Note: The job is a remote job and is open to candidates in USA. Enlyte combines innovative technology, clinical expertise, and human compassion to help people recover after workplace injuries or auto accidents. The Database Engineer will build and maintain production data pipelines and data models that integrate multiple source systems into a Snowflake data warehouse, while ensuring data quality, reliability, and accessibility for analytics. The role also involves collaborating with stakeholders and engineers, documenting processes, supporting governance practices, and contributing to code reviews and proof-of-concepts.
Responsibilities
- Build and maintain production data pipelines using Snowflake and dbt to integrate and transform data from various sources (e.g. SQL Server, Oracle, PostgreSQL, Salesforce)
- Implement data models and transformations following established architectural patterns and team standards
- Collaborate with business stakeholders and senior engineers to understand data requirements and deliver high-value integrations
- Write and maintain documentation for pipelines, data models, and engineering processes
- Contribute to data governance and quality practices, including testing, monitoring, and alerting
- Participate in code reviews, both giving and receiving feedback to maintain pipeline quality
- Build proof-of-concepts and MVPs that demonstrate value for larger data initiatives
Skills
- 3-5 years of hands-on experience building data pipelines in production cloud environments
- Strong proficiency in SQL, including performance tuning and window functions
- Working knowledge of Python for data pipeline development and automation
- Experience with modern data stack technologies including Snowflake, dbt, data ingestion tools (e.g. Snowflake Openflow, Fivetran), orchestration tools (e.g. Dagster, Airflow), AI-assisted development (e.g. Snowflake CoCo, GitHub CoPilot)
- Familiarity with OLTP databases (e.g. PostgreSQL, Oracle, SQL Server), with understanding of the differences between OLTP and OLAP systems
- Experience working with AWS cloud services for data workloads (S3 or similar)
- Familiarity with CI/CD concepts and version control workflows (e.g. Git, pull requests, automated testing)
- Strong communication skills with the ability to explain technical work to non-technical stakeholders
- Proactive and self-motivated, comfortable working in a fast-paced environment with evolving priorities
- Bachelor's degree in Computer Science, Data Engineering, or a related technical field
- Experience with Medallion Architecture
- Experience with using containerization technologies such as Docker and Kubernetes to deploy and manage data applications
- Experience with analytics platforms like Hex and/or BI tools such as Power BI or Tableau
- Understanding of the insurance industry, particularly workers' compensation or P&C insurance
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- Health Savings Accounts / Flexible Spending Accounts
- Life and AD&D Insurance
- 401(k)
- Tuition Reimbursement
- An array of resources that encourage a lifetime of healthier living
Company Overview