Senior Analyst, Data Infrastructure (Waltham, MA- Remote)

Interwell Health

9h•$137,946 - $150,000•Remote

About The Position

Interwell Health is a kidney care management company dedicated to partnering with physicians to reimagine healthcare. Our mission is to set the industry standard for helping patients live their best lives through expertise, scale, compassion, and vision. We are seeking a Senior Analyst, Data Infrastructure to lead the development of a robust data infrastructure that supports value-based healthcare insights generation and report development. This role involves designing systems that ensure data integrity, enable self-service analytics, and foster informed decision-making. The position is remote and can be performed from any location within the United States.

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 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.
Two (2) years of experience in performing data analytics and visualization using: PowerBI, MSSQL, and speak and understand Excel (including Power Query, Pivot Tables, Advanced Formulas).
Two (2) years of experience utilizing InContact reporting data and Salesforce Healthcloud.
Two (2) years of experience automating data workflows and implementing efficiencies.
Two (2) years of experience working with database management systems and ETL Processes.
Two (2) years of experience performing collaboration and project management using Jira, Git, SharePoint, and Confluence.
Two (2) years of experience in database and query optimization with MSSQL (including CTEs, Windows Functions, Stored Procedures, and Cube/Rollup).
Two (2) years of experience presenting to clients and cross functional teams.
Two (2) years of experience 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.

Responsibilities

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.