Sr. ETL Data Analyst

Description

Are you ready to join a passionate community of people who are changing how health care is delivered?  A place where you will find a career you love while truly making a difference building healthier communities.  If this sounds like you, we would love to have you apply as Sr. ETL Data Analyst, with Medical Home Network!

Founded in 2009 by the Comer Family Foundation, Medical Home Network unites health systems and providers around a vision to improve the health of patients and communities in Chicago. Today, as a Public Benefit Corporation (PBC), MHN has expanded its mission and impact to new markets and is a nationally recognized leader in transforming care within the safety net and building healthier communities across the country. Our whole person model of care, powered by proprietary technology, enhances collaboration across primary care and community-based organizations, leading to better outcomes, lower costs, and reduced health disparities.

THE PERKS

• Fun, challenging, and collaborative work environment with passionate colleagues that care deeply about healthcare delivery.
• Recognized as One of the Best Places to Work in Healthcare by Modern Healthcare.
• Competitive benefits programs including Medical, Vision, Dental, HSA, FSA, and 401k.
• Fitness reimbursement, commuter benefits, and tuition assistance.
• Great work life benefits- Paid time off, sick time, and 12 paid holidays.
• Hybrid schedule, 2 days on site 3 days remote in Chicago, Open to fully remote in AK, AL, CA, FL, IL, IN, MI, MO, NC, NM, NV, NY, OK, TX, WI, or DC.

Qualifications

THE OPPORTUNITY:

The Sr. ETL Data Analyst is responsible for developing and executing Extract, Transform, Load (ETL) processes to manage clinical data from Electronic Medical Records (EMRs). This role involves writing complex queries, analyzing healthcare data, defining requirements, and collaborating with technical teams to support reporting and healthcare operations. The analyst will validate and map data, ensuring its accuracy and consistency, before handing it off to the engineering team for integration into the Operational Data Store & Data Warehouse infrastructure. By driving data standards and ensuring seamless data delivery across the organization, the analyst plays a crucial role in enhancing data-driven decision-making and operational efficiency.

WHAT YOU CAN LOOK FORWARD TO:

• Design, develop, and maintain ETL processes to efficiently manage clinical data from EMR systems.
• Write complex queries to extract and analyze healthcare data, ensuring data integrity and accuracy.
• Collaborate with the technical, data and clinical teams to define data requirements and support reporting initiatives.
• Develop and maintain reports to measure, track, and manage data.
• Analyze inbound healthcare clinical data, including claims, ADT HL7 messages, and eligibility information, assessing quality and consistency.
• Assist in designing, programming, testing, and standardizing processes and reports for data auditing and verification.
• Create detailed business requirements to support new clients and product implementations.
• Present analytical findings to diverse audiences, translating complex data insights into actionable information.
• Research and advocate for the adoption of emerging technologies in data analysis to enhance current processes.
• Implement analytical directives from senior staff, ensuring alignment with organizational goals.

WHAT YOU’LL NEED TO SUCCEED:

• Bachelor's degree in Computer Science, Data Science, Information Systems, Health Informatics, or a related field with a quantitative emphasis.
• 5 years of relevant industry experience in data analysis, with a focus on ETL processes and clinical EMR data.
• Proficiency in data manipulation, analysis, and report presentation.
• In-depth knowledge of clinical EMR data, including medical claims, pharmacy claims, and eligibility information.
• Experience with population or public health data analysis.
• Professional experience using statistical software and programming languages such as T-SQL and Python.
• Strong analytical skills, attention to detail, and problem-solving abilities.
• Commitment to continuous learning and expanding technical and industry skill sets.
• Excellent proficiency in Excel and database management.
• Experience with BI reporting tools is a plus.
• Ability to work collaboratively within and across teams.

PREFERRED:

• Experience with population health platforms and EMR vendor integrations.
• Knowledge of regulatory compliance standards and security protocols for healthcare data exchange.
• Familiarity with payer-provider collaborations, value-based care initiatives, and Accountable Care Organization (ACO) models.
• Experience in healthcare IT, including system implementation and support.
• Understanding of clinical workflows and the ability to align information systems and data with these processes.

Medical Home Network is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.