Data Engineer

Trucordia is an insurance brokerage that brings acquired agencies onto shared systems and reporting. The Data Engineer will build and operate the Snowflake and dbt data platform, onboard data sources, maintain reliable pipelines, and support analytics and internal applications.

Responsibilities

• Design, build, and maintain dbt models across our staging, intermediate, and mart layers, owning model performance, incremental strategies, tests, and documentation for the areas you take on
• Onboard new sources into Snowflake, from agency management systems to SaaS tools and flat-file feeds, including profiling the data, agreeing on grain and keys with analysts, and writing the loads and quality checks
• Keep the nightly dbt run healthy: diagnose failures, fix root causes, and reduce the blast radius when an upstream source breaks
• Improve observability with freshness checks, row-count and reconciliation tests, and alerting when a source or model drifts from expectations
• Tune Snowflake cost and performance, including warehouse sizing, clustering, query patterns, and task scheduling
• Contribute to our governance framework: role grants, Entra group sync, row-level security policies, and the access-config tables that gate our internal apps
• Build the backend data layer for the internal web apps we ship to the business and support deploys through our CI pipelines
• Partner with analysts and stakeholders to translate a business question into a model that answers it consistently, and document the result in model docs, runbooks, and decision notes in our Azure DevOps wiki

Preferred

• Snowflake strongly preferred
• Insurance brokerage or agency data experience: policies, premium, commissions, carriers, producers, retention. Familiarity with AMS360, Epic, or similar agency management systems is a real plus
• Salesforce data model and replication into a warehouse
• Snowflake governance features: row access policies, masking, network policies, or SCIM
• Azure ecosystem: Azure DevOps pipelines, Azure Functions, Entra ID
• Power BI semantic models, or experience feeding LLM and semantic-layer tools from a warehouse
• FastAPI or another Python web framework
• Insurance brokerage data
• Insurance agency data
• Policy data
• Premium data
• Commission data
• Carrier data
• Producer data
• Retention data
• AMS360
• Epic
• Agency management systems
• Salesforce data modeling
• Data replication
• Data warehousing
• Snowflake governance
• Row access policies
• Data masking
• Network policies
• SCIM
• Azure DevOps pipelines
• Azure Functions
• Entra ID
• Power BI semantic models
• LLM data integration
• Semantic-layer tools
• Python web frameworks
• FastAPI

Benefits

• Medical, Dental, Vision
• Life Insurance and AD&D
• FSA / HSA
• Accident
• Critical Illness
• Hospital Indemnity
• Supplemental Health Insurance
• Employee Assistance Program (EAP)
• Pet Insurance
• 11 Paid Holidays
• Flexible PTO
• 401K

Company

• Insurance brokerage for commercial, personal, life, health, and workers' compensation
• Lindon, Utah, USA
• https://trucordia.com/
• Founded in 1987
• 1001-5000 employees

Qualifications

• 3+ years of professional experience building production data pipelines, with at least 2 years on a cloud data warehouse (Snowflake strongly preferred)
• Strong SQL skills, including reading query plans, window functions, incremental logic, and slowly changing dimensions; comfortable profiling unfamiliar schemas and performing data quality analysis
• Hands-on dbt experience in a production project: models, tests, macros, sources, exposures, and a CI workflow
• Proficiency in Python for data work: loading files, calling APIs, writing small services or scheduled jobs, and testing them
• Experience with Git-based workflows, pull-request review, and CI/CD pipelines
• Sound data modeling judgment: you can explain why a fact table has the grain it does and push back when a request would break it
• Strong written communicator who documents solutions and collaborates effectively with technical and non-technical stakeholders
• Proven, ongoing use of AI-assisted development tools (e.g., ChatGPT, Copilot, Claude, Cursor, or similar) as part of daily development workflows
• Demonstrated ability to use AI to accelerate coding, debugging, refactoring, and learning new technologies or codebases
• Ability to critically review AI-generated code for correctness, security, performance, and long-term maintainability
• Hands-on, habitual experience using AI in professional work, side projects, or personal experimentation; this role assumes AI is a core productivity multiplier
• Snowflake strongly preferred
• Insurance brokerage or agency data experience: policies, premium, commissions, carriers, producers, retention. Familiarity with AMS360, Epic, or similar agency management systems is a real plus
• Salesforce data model and replication into a warehouse
• Snowflake governance features: row access policies, masking, network policies, or SCIM
• Azure ecosystem: Azure DevOps pipelines, Azure Functions, Entra ID
• Power BI semantic models, or experience feeding LLM and semantic-layer tools from a warehouse
• FastAPI or another Python web framework

Required skills

• AI-Assisted Development ChatGPT, AI-Assisted Development Claude, AI-Assisted Development Cursor, AI-Assisted Development GitHub Copilot, CI/CD, Data Modeling, Git, Insurance Brokerage Data, Power BI, Python, SQL, Salesforce, Snowflake, Snowflake Governance, Stakeholder Collaboration, dbt

Preferred skills

• FastAPI or another Python web framework, Salesforce data model and replication into a warehouse, Snowflake strongly preferred

Experience

• 3+ years