Database Engineer

Enlyte•UNAVAILABLE, UNAVAILABLE

3d•Remote

About The Position

As a Data Engineer in the Casualty Analytics Group, you will build and maintain the data infrastructure that powers Enlyte’s analytics and decision-making capabilities. You’ll join a growing engineering team and be responsible for developing robust data pipelines that integrate data from multiple source systems into our Snowflake data warehouse, ensuring data quality, reliability, and accessibility for downstream analytics. You'll have the opportunity to take on increasing ownership as the team and platform mature.

Requirements

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

Nice To Haves

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

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