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

Interwell Health is a kidney care management company that partners with physicians on its mission to reimagine healthcare—with the expertise, scale, compassion, and vision to set the standard for the industry and help patients live their best lives. We are on a mission to help people and we know the work we do changes their lives. If there is a better way, we will create it. So, if our mission speaks to you, join us! 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. Our mission is to reinvent healthcare to help patients live their best lives, and we proudly live our mission-driven values: We care deeply about the people we serve. We are better when we work together. Humility is a source of our strength. We br