Key skills
PythonSQLETLData EngineeringAnalyticsLookerBITableauPower BISnowflakedbtAzureSQL ServerJiraAgile
About this role
SmartLight Analytics is a company focused on reducing healthcare costs through data analysis. They are seeking a Senior Data Engineer to lead the modernization of their data infrastructure by building new data pipelines and migrating legacy systems to the cloud.
Responsibilities:
- 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:
- 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
- Experience with healthcare claims, eligibility, or related payer/TPA data
- Experience migrating data infrastructure from SQL Server to Snowflake or other cloud platforms
- Familiarity with Sigma
- Experience working in Agile development environments with tools such as Jira
- Prior experience in a startup or fast-growing technology company