Remote Senior Data Engineer, Platform & Pipelines

Lyric; City of Albany (NY); Remote; USD 125.000 - 188.000; Vollzeit

Zusammenfassung

Lyric is seeking a Senior Data Engineer to build the data foundation for its healthcare decision intelligence platform. You will design and deliver data pipelines, implement a canonical data model, and ensure data quality and observability across a multi-tenant environment.

The role emphasizes hands-on development with Snowflake, Airflow, dbt, and Python, with collaboration across analytics and reporting teams.

Qualifikationen

• Bachelor's degree in Software Engineering, Computer Science, or a related field.
• 5+ years of experience in data engineering, building and owning production data pipelines.
• Strong Snowflake experience, including streams and tasks, warehouse sizing and performance tuning, SQL optimization, and RBAC.
• Production experience with dbt and Airflow, including how to structure models and DAGs for maintainability.
• Strong programming expertise in Python and deep SQL proficiency.
• Solid data modeling skills, with experience designing schemas serving multiple consumers and shared vs consumer-specific extensions.
• Experience building testing and data quality validation into pipelines rather than validating after load.
• Disciplined engineering practices: version control, code review, automated testing, and CI/CD.
• Ability to work with non-engineering data consumers and communicate constraints clearly.

Aufgaben

• Design, build, and own data pipelines in our unified framework using Airflow, dbt, and Snowflake.
• Implement the canonical data model in production, working within the architecture set by the Principal Data Engineer and contributing to it.
• Build automated validation and data quality checks into pipelines at defined stages to catch defects before they reach consumers.
• Instrument pipelines for observability, including freshness, lineage, and failure alerting.
• Contribute to self-service capability that lets consuming teams declare needed data and receive governed output.
• Partner with consuming teams across invoicing, analytics, and reporting to translate requirements into reliable data.
• Migrate and consolidate existing data workloads onto the unified framework without disrupting consumers.
• Participate in on-call rotation for pipeline and data quality incidents and incident reviews.
• Maintain high engineering bar: version control, testing, code review, CI/CD, and up-to-date documentation.
• Mentor engineers and raise the technical level of the team.

Kenntnisse

Python

SQL

Snowflake

dbt

Airflow

Data modeling

RBAC

CI/CD

Mentoring

Ausbildung

Bachelor's degree in Software Engineering

Bachelor's degree in Computer Science

Tools

Snowflake

Airflow

dbt

Python

Jobbeschreibung

Lyric is seeking a Senior Data Engineer to build the data foundation for its healthcare decision intelligence platform. You will design and deliver data pipelines, implement a canonical data model, and ensure data quality and observability across a multi-tenant environment.

The role emphasizes hands-on development with Snowflake, Airflow, dbt, and Python, with collaboration across analytics and reporting teams.