Senior Manager – Business Cards & Payments
Capital One
PMP
Manager – Payment Services
EXL
full-time
Posted on:
Location Type: Hybrid
Location: New York City • New York • 🇺🇸 United States
Visit company websiteSalary
💰 $171,000 - $173,000 per year
Job Level
Mid-LevelSenior
Tech Stack
ETLHadoop.NETOraclePySparkPythonShell ScriptingSQLSSISTableau
About the role
- Develop healthcare analytic software applications.
- Develop and test complex queries/programs using SQL Server, PL/SQL developer tool, SSIS and MS Access tools.
- Recognize areas for automation in payment service and create report automation using SSIS/SSRS/SAS for weekly/monthly deliverables.
- Develop business/analytical reports on Ad hoc basis that will be delivered on the same day using data tools.
- Extract, transform, and load data utilizing SSDT tools.
- Analyze the new data feeds expected from the clients as part of the TPL implementations, review the new data layouts, importing test data, and comparing identification engine percentages.
- Analyze healthcare data and produce, verify, and interpret client reports.
- Perform analyses of health care data, including medical and pharmacy claims, membership files and health advisory/coaching interaction, to understand the quality and level of care delivered and measure the effectiveness of the organization's services.
- Write high complex SQL queries in Enterprise Data warehouse.
- Build and edit SAS programs/models based on client requirements.
- Load client raw data files into production tables through ETL tools, such as SSIS.
- Work with the concept generation team, gather and analyze requirements and present/translate the client requirements to offshore development team and ensure active communication.
- Analyze, map, transform, and write complex procedures in SQL, to migrate large volumes of transactional data.
- Build Tableau dashboard reports for business analytics team.
- Develop report automation processes using SSRS servers to improve turnaround time and reporting capabilities.
- Work with large and complex databases (SQL, Hadoop) for data extraction, manipulation and validation.
- Optimize long running MSSQL queries.
- Perform high-level checks on the research completed by the team on new logic and obtain approval from client to work on the same.
- Monitor team productivity and quality, organize KSS sessions, plan training schedule for new hires, and coordinate with on-site resources.
- Conduct scrum meetings for tracking progress in agile environment including report generation and presentations.
- Establish Standard Operating Procedures and ensure quality standards based on query performance and output.
- Ensure compliance of entire team for HIPAA/OIG at both process and data management level.
Requirements
- Requires Master’s degree, or foreign equivalent, in Computer Science, Computer Engineering, or a directly related field plus three (3) years of experience in healthcare analytics software development including a familiarity with medical coding systems (CPT, ICD-10, DRG).
- Must have at least five (5) years of experience with MSSQL, TSQL, SQL Server, PL/SQL developer tools and Oracle database; SSIS, SSAS, and SSRS; MS Visual Studio (.NET (ASP), C#, VB.net); Tableau and Shell scripting; Python and Hadoop technologies -Hive, PySpark and Zeppelin.
- Employer will also accept a Bachelor’s degree or foreign equivalent, in Computer Science, Computer Engineering, or a directly related field plus five (5) years of experience required in healthcare analytics software development including a familiarity with medical coding systems (CPT, ICD-10, DRG).
Benefits
- Telecommuting permitted.
- Must cite job title and code EXL23A in response.
- Subject to ExlService.com, LLC's employee referral program. EEO/Minorities/Females/Vets/Disabilities.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLPL/SQLSSISSSRSSASETLTableauPythonHadoopMSSQL
Soft skills
communicationteam productivity monitoringtraining coordinationagile methodologyrequirements gatheringpresentation skillsquality assuranceclient interactionproblem-solvingleadership
Certifications
Master’s degree in Computer ScienceMaster’s degree in Computer EngineeringBachelor’s degree in Computer ScienceBachelor’s degree in Computer Engineering
