The Sr. Data Analyst will design and maintain ETL processes, analyze healthcare data, define requirements, and collaborate with teams to enhance operational efficiency.
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. Data Analyst, ETL 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 OPPORTUNITY:
The Sr. 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.
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.
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.
Top Skills
Bi Reporting Tools
Emr
ETL
Excel
Python
T-Sql
Similar Jobs
.png)
Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
The role involves developing competitive intelligence, analyzing data trends, presenting insights to leadership, and managing data models and pipelines.
Top Skills:
PythonSQL
Artificial Intelligence • Machine Learning • Natural Language Processing • Software
Lead the evaluation of voice AI models by developing benchmarking pipelines, metrics, and collaborating across teams to ensure model integrity and performance.
Top Skills:
Data Analysis LibrariesLlmsMl PipelinesPython
Healthtech • Information Technology • Mobile • Productivity • Software • Analytics • Telehealth
As a Data Analyst, you will analyze healthcare data, collaborate with cross-functional teams, and provide insights to improve healthcare services.
Top Skills:
GitNumpyPandasPythonSparkSQLUnix
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
