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 bring joy to our work. We deliver on our promises. We are committed to diversity, equity, and inclusion throughout our recruiting practices. Everyone is welcome and included. We value our differences and learn from each other. Our team members come in all shapes, colors, and sizes. No matter how you identify your lifestyle, creed, or fandom, we value everyone's unique journey. Oh, and one more thing … a recent study shows that men apply for a job or promotion when they meet only 60% of the qualifications, but women and other marginalized groups apply only if they meet 100% of them. So, if you think you’d be a great fit, but don’t necessarily meet every single requirement on one of our job openings, please still apply. We’d love to consider your application! Come join us and help our patients live their best lives. Learn more at www.interwellhealth.com. It has come to our attention that some individuals or organizations are reaching out to job seekers and posing as potential employers presenting enticing employment offers. We want to emphasize that these offers are not associated with our company and may be fraudulent in nature. Please note that our organization will not extend a job offer without prior communication with our recruiting team, hiring managers and a formal interview process.