Senior Data Engineer — Snowflake, dbt & Power BI

Trucordia Insurance Services, LLC; Lindon (CO); On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical

Dental

Vision

Life Insurance

FSA/HSA

401K

Job summary

Trucordia Insurance Services, LLC is hiring a Data Engineer to build and operate a Snowflake-based data platform. You will own dbt models end-to-end, onboard new sources, and collaborate across Analytics, Sales, Operations and Finance to turn data into actionable insights.

You will partner with the Integrations team to migrate agencies into AMS360 and design robust data pipelines with governance and security in mind.

Qualifications

• 3+ years of professional experience building production data pipelines.
• Strong SQL skills including window functions and data quality analysis.
• Hands-on dbt experience in production projects (models, tests, macros, sources, exposures).
• Proficiency in Python for data work (loading files, API calls, small services).
• Experience with Git-based workflows, pull-request review, and CI/CD pipelines.
• Sound data modeling judgment and ability to explain grain of a fact table.
• Strong written communicator who collaborates with technical and non-technical stakeholders.

Responsibilities

• Design, build, and maintain dbt models across staging, intermediate, and mart layers.
• Onboard new sources into Snowflake and perform data profiling and quality checks.
• Keep the nightly dbt run healthy by diagnosing failures and fixing root causes.
• Improve observability with freshness checks and reconciliation tests.
• Tune Snowflake cost and performance (warehouse sizing, clustering, scheduling).
• Contribute to governance with role grants and Entra ID policies.
• Build the backend data layer for internal web apps and support CI pipelines.
• Translate business questions into reproducible models and document results.

Skills

SQL

Data modeling

Communication

Python

Tools

Snowflake

dbt

Power BI

AMS360

Salesforce

Git

Azure DevOps

Job description

Trucordia Insurance Services, LLC is hiring a Data Engineer to build and operate a Snowflake-based data platform. You will own dbt models end-to-end, onboard new sources, and collaborate across Analytics, Sales, Operations and Finance to turn data into actionable insights.

You will partner with the Integrations team to migrate agencies into AMS360 and design robust data pipelines with governance and security in mind.