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 Data Engineer, 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.

THE OPPORTUNITY:

Reporting to the Associate Vice President, Health Information Technology the Data Engineer will assist in our data modernization and optimization efforts. The Data Engineer is responsible for delivering data warehouse, business intelligence, and operational data solutions by developing data integration and ETL processes, data quality and master data management solutions, and administration of SQL Server, and Azure SQL. This individual works closely with end users and IT development staff to ensure that new and existing data models and databases are consistent with approved MHN data architecture standards and HIPAA security requirements.

WHAT YOU CAN LOOK FORWARD TO:

Develop software/data solutions using SQL and Python.
Perform development, modification, and implementation of software and data applications in both our existing stack (SQL Server on Azure VM, Python on Azure Linux VM) and coding for our planned future state (Azure SQL, Azure Linux VM, Master Data Management, etc.)
Development initiatives including data analysis, source-target mapping, data profiling, data quality, master data management, and performance tuning
Monitor system performance trends and identify opportunities for improvement
Document all programming changes and design, system modifications and their associated maintenance to all required applications
Design and support production job schedules, including alerting, monitoring, break fixes, and performance tuning

WHAT YOU’LL NEED TO SUCCEED:

Bachelor’s degree in Computer Science, or a related discipline or equivalent work experience.
Strong knowledge of T-SQL (DML & DDL), Stored Procedures, Indexes, user defined functions, etc.
Bachelor degree in computer science or related field or 5+ years equivalent experience
Python programming experience
Experience building/operating highly available, distributed systems of extraction, ingestion, and processing of large data sets both in near real time and batch processing.
Deep understanding of enterprise data hubs and data warehouses with deep experience in both types of environments
Working knowledge of Linux and Windows VMs
Working knowledge of Git, Bitbucket, or similar source code management software
Experience with a workload automation software package such as Active Batch
Working knowledge of Azure, Azure SQL and serverless compute environments
Experience developing Restful APIs
Experience with NoSQL databases such as MongoDB
Experience developing data warehouses or data integration in a healthcare environment
Experience developing data warehouses and data marts (Kimball, Inmon design models)
Support of self-service BI and reporting
Experience creating patient or provider web portals
Experience with HL7 data feeds
Use of JIRA, Confluence and Bitbucket
Creation of database solutions and projects in Visual Studio with automated builds

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.

Job Type: Full-time

Pay: $87,000.00 - $115,000.00 per year

Benefits:

401(k)
Dental insurance
Employee assistance program
Flexible spending account
Health insurance
Life insurance
Paid time off
Tuition reimbursement
Vision insurance

Compensation Package:

Bonus opportunities
Yearly bonus

Schedule:

8 hour shift

Application Question(s):

Have you worked in the Healthcare Industry?

Experience:

Microsoft SQL Server: 4 years (Required)

Ability to Commute:

Chicago, IL 60601 (Required)

Work Location: Hybrid remote in Chicago, IL 60601

Medical Home Network

Latest Jobs

Database Developer