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

<div class="content-intro"><p>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!</p></div><p><u>InterWell Health Partners, Inc., Senior Analyst - Data Infrastructure, (Waltham, MA - Remote)</u></p> <p>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:</p> <ul> <li>Design and implement scalable data systems and workflows to support organizational analytical needs.</li> <li>Collaborate with IT and analytics teams to ensure seamless integration of data sources into centralized infrastructure.</li> <li>Maintain and enhance data pipelines to ensure real time access to reliable information.</li> <li>Develop analytical reports and dashboards to uncover trends and actionable insights in healthcare data.</li> <li>Create advanced data visualizations that enable stakeholders to understand complex data quickly and effectively.</li> <li>Leverage domain knowledge in value-based healthcare to identify key metrics and areas for analysis.</li> <li>Validate and reconcile general reporting data across the organization.</li> <li>Create and maintain reporting in compliance with CMS and FHP policies, including ad-hoc reports and automation of manual reporting processes to enhance efficiency.</li> <li>Identify discrepancies and risks in data, conducting root cause analyses to recommend and implement remediation steps.</li> <li>Prepare files and materials for internal and external regulatory audits.</li> <li>Ensure data integrity throughout the reporting lifecycle.</li> <li>Collaborate with departments to prepare required materials and ensure clear communication of findings and recommendations.</li> <li>Provide guidance to junior staff and escalate higher-level issues to senior management as needed.</li> <li>Assist with various cross-departmental projects as assigned, contributing to the overall success of organizational initiatives.</li> </ul> <p><strong><u>Minimum Requirements:</u></strong></p> <p>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.</p> <p> </p> <p>Qualified candidates must also possess two (2) years of experience in (may be gained concurrently with above):</p> <p> </p> <ul> <li>Performing data analytics and visualization using: PowerBI, MSSQL, and speak and understand Excel (including Power Query, Pivot Tables, Advanced Formulas).</li> <li>Utilizing InContact reporting data and Salesforce Healthcloud.</li> <li>Automating data workflows and implementing efficiencies.</li> <li>Working with database management systems and ETL Processes.</li> <li>Performing collaboration and project management using Jira, Git, SharePoint, and Confluence.</li> <li>Database and query optimization with MSSQL (including CTEs, Windows Functions, Stored Procedures, and Cube/Rollup).</li> <li>Presenting to clients and cross functional teams.</li> <li>Working with healthcare regulations and compliance standards, including HIPAA.</li> </ul> <p>Applicants are subject to testing during the interview process to demonstrate aptitude/capabilities in SQL coding and PowerBI.</p> <p>This position is remote and can be performed from any location within the United States.</p> <p>Salary range of $137,946 - $150,000/year offered. </p> <p> </p><div class="content-conclusion"><p>Our mission is to reinvent healthcare to help patients live their best lives, and we proudly live our mission-driven values: </p> <ul> <li>We care deeply about the people we serve.</li> <li>We are better when we work together.</li> <li>Humility is a source of our strength.  </li> <li>We bring joy to our work.</li> <li>We deliver on our promises. </li> </ul> <p>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.</p> <p>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!   </p> <p>Come join us and help our patients live their best lives. Learn more at www.interwellhealth.com.</p> <p><em>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.</em></p></div>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...