Note: The job is a remote job and is open to candidates in USA. SpringbokIT's client is a growing technology company in the healthcare data space seeking a Senior Data Engineer. The role owns the Snowflake data warehouse, leads modernization of the data infrastructure, builds pipelines and warehouse models, and migrates legacy SQL Server workloads to the cloud while supporting analytics and reporting needs.
Responsibilities
- Own the Snowflake data warehouse end-to-end, including architecture, data modeling, performance optimization, cost management, and high availability
- Design, build, and maintain ETL and reverse-ETL pipelines between Snowflake, Azure Data Factory, and legacy SQL Server systems
- Implement and maintain row-level and column-level security policies and broader access controls 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
- 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
- Partner with analytics and reporting stakeholders to ensure the warehouse supports downstream BI needs
Skills
- • 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 owning a Snowflake environment, including architecture, performance optimization, cost governance, and security
- • Strong proficiency in SQL and Python
- • Experience with dbt and Azure Data Factory
- • Experience with at least one major BI/visualization platform (e.g., Power BI, Tableau, Looker, Sigma)
- • Prior experience working with healthcare data, including familiarity with HIPAA, data sensitivity, 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 data
- • Experience migrating data infrastructure from SQL Server to Snowflake or other cloud platforms
- • Experience working in Agile environments with tools such as Jira
- • Prior experience in a startup or fast-growing technology company
Benefits
- Fully remote work environment
Company Overview