> Markdown version of [/jobs/ext/145478-senior-data-engineer](https://www.wearedevelopers.com/jobs/ext/145478-senior-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Engineer - **Company:** Smartlight Analytics - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Agile Methodology, JIRA, Code Review, Information Engineering, Data Infrastructure, Data Integrity, Extract Transform Load (ETL), Data Warehousing, Python (Programming Language), Microsoft SQL Server, Power BI, SQL Databases, Data Streaming, Tableau (Software), Azure Data Factory, System Availability, Snowflake, Information Technology, Looker Analytics, Data Pipelines, Legacy Systems - **Published:** May 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=a0f71703a2cf4c17 ## About the Role * 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. ## Description We are seeking a Senior Data Engineer with deep expertise in data warehousing, ETL pipeline development, and Snowflake to lead the modernization of our data infrastructure. In this role, you will build new data pipelines and warehouse models in Snowflake while partnering with our existing SQL Server Data Engineering team to migrate legacy systems to the cloud. You will work with healthcare claims, eligibility, and related data ingested from carrier and TPA partners, as well as data aggregated from internal systems. This is a hands-on technical role requiring strong self-management, a proven ability to mentor peers, and comfort working with sensitive healthcare data under strict security requirements. As a scaling technology organization, we value ownership, collaboration, and continuous improvement - you will have a direct hand in shaping the tools, processes, and architecture that power our data platform. Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States., * 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean) - [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)