Senior Analyst-Data infrastructure

InterWell Health Partners, Inc., Senior Analyst - Data Infrastructure, (Waltham, MA - Remote): Responsible for leading development of a robust data infrastructure to support value-based healthcare insights generation and report development. Designs systems that ensure data integrity, enable self-service analytics and foster informed decision making. Duties include:

• Design and implement scalable data systems and workflows to support organizational analytical needs.
• Collaborate with IT and analytics teams to ensure seamless integration of data sources into centralized infrastructure.
• Maintain and enhance data pipelines to ensure real time access to reliable information.
• Develop analytical reports and dashboards to uncover trends and actionable insights in healthcare data.
• Create advanced data visualizations that enable stakeholders to understand complex data quickly and effectively.
• Leverage domain knowledge in value-based healthcare to identify key metrics and areas for analysis.
• Validate and reconcile general reporting data across the organization.
• Create and maintain reporting in compliance with CMS and FHP policies, including ad-hoc reports and automation of manual reporting processes to enhance efficiency.
• Identify discrepancies and risks in data, conducting root cause analyses to recommend and implement remediation steps.
• Prepare files and materials for internal and external regulatory audits.
• Ensure data integrity throughout the reporting lifecycle.
• Collaborate with departments to prepare required materials and ensure clear communication of findings and recommendations.
• Provide guidance to junior staff and escalate higher-level issues to senior management as needed.
• Assist with various cross-departmental projects as assigned, contributing to the overall success of organizational initiatives.

Minimum Requirements:

Master's degree in Information Systems, Bioinformatics or closely related field and two (2) years of professional business analyst experience within the value-based healthcare industry with a focus on care management processes or, in the alternative, a Bachelor's degree in the same and four (4) years of professional business analyst experience within the value based healthcare industry with a focus on care management processes.

Qualified candidates must also possess two (2) years of experience in (may be gained concurrently with above):

• Performing data analytics and visualization using: PowerBI, MSSQL, and speak and understand Excel (including Power Query, Pivot Tables, Advanced Formulas).
• Utilizing InContact reporting data and Salesforce Healthcloud.
• Automating data workflows and implementing efficiencies.
• Working with database management systems and ETL Processes.
• Performing collaboration and project management using Jira, Git, SharePoint, and Confluence.
• Database and query optimization with MSSQL (including CTEs, Windows Functions, Stored Procedures, and Cube/Rollup).
• Presenting to clients and cross functional teams.
• Working with healthcare regulations and compliance standards, including HIPAA.

Applicants are subject to testing during the interview process to demonstrate aptitude/capabilities in SQL coding and PowerBI.

This position is remote and can be performed from any location within the United States.

Salary range of $137,946 - $150,000/year offered.