Data Engineer

We are seeking a skilled, hands-on Data Engineer to join our team. In this role, you will build, test, and maintain data pipelines and data warehouse components that support our broader data platform. You will help enable data-driven decision-making by ensuring business teams have access to clean, reliable, and well-modeled data.

As a Data Engineer, you will transform raw data into actionable insights by developing scalable pipelines, creating robust data models, and supporting reporting and analytics tools in partnership with the broader team., * Data Platform Development: Build and maintain data pipelines and data warehouse/lakehouse components (data warehouses, lakes, and marts) while following established data governance, security, and privacy controls.

• Pipeline Engineering: Develop reliable data ingestion pipelines using scheduled and event-driven patterns. Optimize performance and ensure resilience.
• Data Quality & Monitoring: Implement data quality frameworks, validation checks, and safeguards to minimize pipeline failures and data integrity issues.
• Architecture & Optimization: Contribute to improving legacy ingestion methods, address technical debt, and support impact assessment for proposed changes in partnership with the team.
• Reporting & Visualization: Build custom reports and dashboards using tools like Power BI, Snowflake, etc.
• Collaboration & Agile Delivery: Work closely with product owners and cross-functional teams to understand business needs, clarify requirements, and deliver solutions using agile methodologies.
• Automation & Efficiency: Identify inefficiencies, automate processes, and recommend improvements to optimize data flows.
• Documentation & Standards: Document pipelines, datasets, and data models; follow team standards; and participate in code reviews to improve maintainability and consistency.
• Production Support: Provide technical support for production incidents, ensuring system stability and continuous improvement.

Do you have experience in Snowflake?, Do you have a Bachelor's degree?, Experience: 2-4 years in data engineering with experience in Snowflake, SQL, ELT/ETL, dimensional data modeling, data warehousing, and pipeline development.

Technical Skills:

• Strong SQL skills with experience in query optimization and basic performance tuning.
• Solid understanding of dimensional modeling and core data architecture principles.
• Familiarity with Azure cloud services.
• Experience with BI tools (Power BI & Snowflake).
• Knowledge of Agile/Scrum practices.
• Experience building dimensional (Kimball-style) data models.

Soft Skills:

• Excellent communication (written and verbal).
• Strong problem-solving and incident management capabilities.
• High attention to detail and commitment to data accuracy., * Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
• Proficiency in programming languages such as Python or Java.
• Experience with orchestration tools and CI/CD pipelines (e.g., ADO YAML Pipelines or GitHub Actions).
• Familiarity with cloud platforms (Azure) and modern data tools (Snowflake).
• Exposure to machine learning/AI concepts.
• Experience working with APIs and integrating external data sources.
• Background in the insurance industry (including carrier experience) is a plus.

Technical Competencies

• Data Engineering: Experience building and supporting data warehouses/lakes, especially on Snowflake and Azure.
• Data Integration: Experience developing ELT/ETL pipelines using modern tools and scripting languages.
• Data Modeling: Proficient in logical and physical data modeling using relational and dimensional approaches.
• Performance Optimization: Experience tuning pipelines and database objects for optimal performance.
• Version Control & CI/CD: Familiarity with ADO YAML Pipelines or GitHub Actions and automated deployment practices.
• API Integration: Experience implementing and leveraging APIs for data exchange.

Pulled from the full job description

• Referral program
• Military leave
• Parental leave
• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance, * Commensurate with experience
• Performance-based incentives

Benefits Package

• 401(k) company match up to 6% eligible upon hire
• Medical, dental & vision, including company paid Life insurance and long-term disability
• Health care flexible spending accounts
• Paid time off
• Parental & family leave; military leave & pay
• Employee Referral Incentive
• Career Development & Continuing Education Assistance