Senior Data Engineer

SmartLight Analytics

Senior Data Engineer leading data infrastructure modernization at SmartLight Analytics. Building data pipelines and optimizing Snowflake warehouse models for healthcare data management.

Posted 5/14/2026full-timeRemote • 🇺🇸 United StatesSeniorWebsite

Tech Stack

Tools & technologies

AzureCloudETLPythonSQLTableau

About the role

Key responsibilities & impact

Design, build, and maintain ETL and reverse-ETL pipelines between Snowflake, Azure Data Factory, and legacy SQL Server systems.
Develop and optimize Snowflake data warehouse models, ensuring performance, reliability, and high availability.
Implement and maintain row-level and column-level security policies to protect sensitive healthcare data.
Partner with the existing SQL Server Data Engineering team to plan and execute the migration of legacy ETL processes and warehouse models to Snowflake and the cloud.
Build and maintain data transformations using dbt.
Monitor pipeline health, troubleshoot failures, and ensure uptime and data integrity across all data flows.
Mentor peers and contribute to engineering best practices, code reviews, and documentation.
Learn and adopt Sigma as the organization’s BI and reporting tool.

Requirements

What you’ll need

Bachelor’s degree in Computer Science, Data Engineering, or related field, or equivalent experience.
10+ years of experience in data engineering, ETL development, and data warehouse modeling.
Proven hands-on experience with Snowflake, including architecture, optimization, and security.
Strong proficiency in SQL and Python.
Experience with at least one major BI/visualization platform (e.g., Power BI, Tableau, Looker, Sigma).
Experience with dbt and Azure Data Factory.
Prior experience working with healthcare data, including familiarity with data sensitivity, HIPAA, and security best practices.
Experience implementing row-level and/or column-level security in a data warehouse environment.
Strong self-management skills with the ability to work independently in a fully remote environment.

Benefits

Comp & perks

Health care claim data management
Ownership and collaboration
Mentorship opportunities
Hands-on technical role

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETL developmentdata warehouse modelingSnowflakeSQLPythondbtAzure Data Factorydata transformationsdata integritydata migration

Soft Skills

mentoringself-managementindependent workcollaborationtroubleshootingcommunicationengineering best practicescode reviewsdocumentation