Health Intelligence Programmer

Role Description

This position is responsible for developing, enhancing, and maintaining the core data processing platforms of the company, driving business solutions by querying existing databases to create data models for actionable reporting, and creating and maintaining reporting applications that result in efficient data extraction.

• Responsible for designing, developing reports, analyzing raw data and identifying data and report discrepancies and deploying Enterprise and External Client grade critical Reports.
• Responsible for administering, configuring, managing and monitoring reporting platforms, security, processes, identifying and troubleshooting issues, managing upgrades.
• Responsible for managing report security, access, archival, retention, assistance in audits.
• Collaborate with various function teams such as operations, marketing, research, and IT to achieve business results.
• Prepare accurate and relevant reports that provide insight regarding key points for leadership and clients.
• Able to independently profile data and test output and produce support documentation.
• Research data discrepancies, performance and troubleshoots SQL Code, underlying transformations, SSIS Packages, views, stored procedures.
• Utilize reporting methodology to communicate needs to Data Analysts for report programming.
• Communicate the results of data analysis in written and verbal form to managers and changes in financial and business trends for leadership decision making.
• Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules.
• Mentor Juniors, Train peers and adopt and share Best Practices with the team.
• Able to communicate with stakeholders, manage expectations and prioritize deliverables.

Qualifications

• Requires a bachelor's degree and X-X years of relative experience, or an equivalent combination of education and experience.
• Requires High proficiency in SQL, well-developed analytical skills especially in Database.
• Requires High proficiency in Cognos Reporting Tool, Framework Manager and Cognos Server Administration. Additional tools preferred - SSRS, Power BI, Tableau.
• Requires experience in data architecture, data modeling and performance tuning.
• Requires High Proficiency with tools - Toad, DBeaver, Workbench, SSMS, SSAS, SSIS.
• Requires Proficiency in Story Telling via Data Visualization and User Experience Design.
• Requires strong organizational and multitasking skills, and the ability to meet time-sensitive deadlines.
• Experience in working on Data Warehouse or similar data repository environments.
• Intermediate to advanced knowledge of Excel is required.

Preferred Qualifications

• Master's degree preferred.
• General knowledge of business operations, programs, outcomes, system inputs and outputs to support accurate reports to clients.
• Prior experience working with healthcare claims, utilization / case management data.
• Knowledge or Experience in Healthcare domain or industry.
• Familiarity with Visual Studio and TFS/Azure DevOps source control.
• Familiarity with agile methodology.
• Experience supporting ETL development.
• Experience in scripting languages - Unix/Shell, Python, etc.
• Experience with development methodology - Agile, SDLC in regulated industry.