Unlock Health is seeking a hands-on Data Engineer to build, maintain, and optimize our modern cloud data platform. This role develops reliable data pipelines, integrates diverse sources, and delivers high-quality datasets for analytics, reporting, and business decisions.
The ideal candidate brings strong SQL skills, experience with Snowflake and/or Google BigQuery, working Python knowledge, and an interest in automation, troubleshooting, and responsible AI-assisted development.
Applicants must reside in the United States and be legally authorized to work in the United States to be considered for this position.
Key Responsibilities- Develop, maintain, and optimize data pipelines using Snowflake, Google BigQuery, SQL, and Python.
- Ingest and transform data from APIs, databases, cloud storage, marketing platforms, and third-party sources.
- Build reusable data models and transformation workflows using SQL, dbt, and established engineering practices.
- Implement data validation, quality checks, monitoring, and troubleshooting for reliable delivery.
- Automate manual processes and improve pipeline performance, scalability, and maintainability.
- Use tools such as Fivetran, Supermetrics, and cloud services for data integration when appropriate.
- Use ChatGPT, Claude, or similar AI tools for development, debugging, testing, and documentation; validate outputs for accuracy and security.
- Collaborate with data architects, analytics teams, and stakeholders to deliver trusted, analytics-ready datasets.
- 2+ years of hands-on experience in data engineering, analytics engineering, or a related technical role.
- Strong SQL skills and experience developing and supporting production data pipelines.
- Hands-on experience with Snowflake and/or Google BigQuery, with the ability to learn and support both platforms.
- Working knowledge of Python for data processing, automation, and API integrations.
- Familiarity with dbt or similar data transformation frameworks.
- Experience with AWS and/or Google Cloud environments.
- Understanding of data modeling, ETL/ELT, Git, and data quality practices.
- Strong analytical, troubleshooting, communication, and problem-solving skills.
- Bachelor’s degree in a related field or equivalent practical experience.
- Fivetran, Supermetrics, or similar integration tools.
- Tableau or comparable business intelligence platforms.
- ChatGPT, Claude, or other AI-assisted development tools.
- CI/CD, orchestration, automated testing, or data governance.
- Marketing, advertising, CRM, or healthcare data integrations.
- Deliver reliable, automated, and well-documented data pipelines.
- Improve data quality, processing efficiency, and platform reliability.
- Build reusable solutions that reduce manual maintenance.
- Collaborate effectively with technical and business teams.
- Competitive salary; health, dental, and vision benefit packages.
- Company-paid life, short-term disability, and long-term disability insurance; FSA/HSA options.
- 401(k) with company match; flexible paid time off; paid parental leave.
- Hybrid and remote schedules; employee assistance and referral programs.
About Us:
Unlock Health is a full-service marketing communication agency, grounded in technology, built for healthcare - and integrated with a managed care consultancy with deep revenue strategy expertise. We brought together leading healthcare firms to solve a core challenge: aligning brand, marketing, technology, and revenue strategy so healthcare organizations can attract and retain patients, grow brand equity, and protect their margins. We help our clients do everything from patient acquisition and brand building, to simplifying complex martech ecosystems, and creating digital experiences. Our work is rooted in clarity, authenticity, and a deep understanding of what moves healthcare forward.
Equality Opportunity Employer Statement
Unlock, and its affiliate companies, is an equal opportunity employer dedicated to building an inclusive and diverse workforce. We provide equal employment opportunities without regard to an applicant's race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
