[Remote] Senior Data Engineer

Note: The job is a remote job and is open to candidates in USA. 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, build new data pipelines, and migrate legacy systems to the cloud, particularly using Snowflake.ResponsibilitiesDesign, build, and maintain ETL and reverse-ETL pipelines between Snowflake, Azure Data Factory, and legacy SQL Server systemsDevelop and optimize Snowflake data warehouse models, ensuring performance, reliability, and high availabilityImplement and maintain row-level and column-level security policies to protect sensitive healthcare dataPartner 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 cloudBuild and maintain data transformations using dbtMonitor pipeline health, troubleshoot failures, and ensure uptime and data integrity across all data flowsMentor peers and contribute to engineering best practices, code reviews, and documentationLearn and adopt Sigma as the organization’s BI and reporting toolSkillsBachelor's degree in Computer Science, Data Engineering, or related field, or equivalent experience10+ years of experience in data engineering, ETL development, and data warehouse modelingProven hands-on experience with Snowflake, including architecture, optimization, and securityStrong proficiency in SQL and PythonExperience with at least one major BI/visualization platform (e.g., Power BI, Tableau, Looker, Sigma)Experience with dbt and Azure Data FactoryPrior experience working with healthcare data, including familiarity with data sensitivity, HIPAA, and security best practicesExperience implementing row-level and/or column-level security in a data warehouse environmentStrong self-management skills with the ability to work independently in a fully remote environmentExperience with healthcare claims, eligibility, or related payer/TPA dataExperience migrating data infrastructure from SQL Server to Snowflake or other cloud platformsFamiliarity with SigmaExperience working in Agile development environments with tools such as JiraPrior experience in a startup or fast-growing technology companyCompany OverviewSmartLight Analytics reduces health care costs for self-funded employers with analytics and results-oriented solutions. It was founded in 2016, and is headquartered in Plano, Texas, USA, with a workforce of 2-10 employees. Its website is https://smartlightanalytics.com.