Job description

The Role 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. Required Qualifications 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. Preferred Qualifications 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. What Success Looks Like 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. Perks and Benefits 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.

Requirements

Must-haves

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.
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.

Nice-to-haves

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.
What Success Looks Like
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.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonaiapiawsci/cd

Platform: greenhouse
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off

Parental Leave