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.