Back to jobs

Analytics Engineer

Pay
Pay not listedSimilar roles state $123K–$190K
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Build and maintain dbt models across staging, intermediate and mart layers

  • Onboard new sources into Snowflake, profiling data and writing loads and quality checks

  • Keep the nightly dbt run healthy by diagnosing failures and fixing root causes

  • Add freshness, row-count and reconciliation checks with alerting

  • Tune Snowflake cost and performance, including warehouse sizing and clustering

From the employer’s posting
Design, build, and maintain dbt models across our staging, intermediate, and mart layers
Onboard new sources into Snowflake, from agency management systems to SaaS tools and flat-file feeds
Keep the nightly dbt run healthy: diagnose failures, fix root causes
Improve observability with freshness checks, row-count and reconciliation tests, and alerting
Tune Snowflake cost and performance, including warehouse sizing, clustering, query patterns, and task scheduling

What you’ll bring

All qualifications

Core experience

  • 3+ years of professional experience building production data pipelines, with at least 2 years on a cloud data warehouse
  • Demonstrated ability to use AI to accelerate coding, debugging, refactoring, and learning new technologies or codebases.
  • Familiarity with AMS360, Epic, or similar agency management systems is a real plus.
  • Strong SQL skills, including reading query plans, window functions, incremental logic, and slowly changing dimensions; comfortable profiling unfamiliar schemas and performing data quality analysis.
  • Ability to critically review AI-generated code for correctness, security, performance, and long-term maintainability.
  • Proficiency in Python for data work: loading files, calling APIs, writing small services or scheduled jobs, and testing them.

Preferred experience

  • Snowflake strongly preferred
Qualification wording
3+ years of professional experience building production data pipelines, with at least 2 years on a cloud data warehouse (Snowflake strongly preferred).
Demonstrated ability to use AI to accelerate coding, debugging, refactoring, and learning new technologies or codebases.
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.
Strong SQL skills, including reading query plans, window functions, incremental logic, and slowly changing dimensions; comfortable profiling unfamiliar schemas and performing data quality analysis.
Ability to critically review AI-generated code for correctness, security, performance, and long-term maintainability.
Proficiency in Python for data work: loading files, calling APIs, writing small services or scheduled jobs, and testing them.
Apply at Trucordia

Posting record

Report an error

Actively hiringFirst seen by us 5 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 16, 20265 days ago
Recorded sightings
6
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$123K–$190K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 342 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 5

Early. Similar jobs usually come down between day 7 and day 51.

From 1,783 similar postings that came down. Coming down is not always a hire.

Trucordia is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • dbt
  • Power BI
  • Snowflake
  • FastAPI
Where the posting names them
- 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.
- Power BI semantic models, or experience feeding LLM and semantic-layer tools from a warehouse. - FastAPI or another Python web framework. Additional Information
- 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.
- 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. Qualifications
- 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.
Job Description Trucordia is a rapidly growing insurance brokerage that acquires agencies nationwide and brings their business onto shared systems and shared reporting. Every acquired agency arrives with its own systems, its own data, and its own way of counting things. The Data & Analytics team turns that into one answer: a Snowflake warehouse fed from AMS360, Salesforce, HR, and finance systems, etc. modeled in dbt into conformed dimensions and facts (policies, premium, retention, producers, agencies, carriers), and served through Power BI, curated semantic views for AI, and internal web apps we design and build ourselves. Our governance framework (Entra-synced roles, row-level security, network and authentication policies) is code we wrote and maintain. We are hiring an Analytics Engineer to help us build and run that platform. This role sits within the Data and Technology organization on the Data & Analytics team, a small, senior group that owns the full path from source system to decision. You will own dbt models and pipelines end to end, onboard new sources, keep the nightly run healthy, and make the platform faster, more trustworthy, and less dependent on any one engineer’s memory. You will work closely with our Integrations team, which migrates acquired agencies into AMS360, and with analysts and stakeholders in Sales, Operations, and Finance.
Trucordia is a rapidly growing insurance brokerage that acquires agencies nationwide and brings their business onto shared systems and shared reporting. Every acquired agency arrives with its own systems, its own data, and its own way of counting things. The Data & Analytics team turns that into one answer: a Snowflake warehouse fed from AMS360, Salesforce, HR, and finance systems, etc. modeled in dbt into conformed dimensions and facts (policies, premium, retention, producers, agencies, carriers), and served through Power BI, curated semantic views for AI, and internal web apps we design and build ourselves. Our governance framework (Entra-synced roles, row-level security, network and authentication policies) is code we wrote and maintain. We are hiring an Analytics Engineer to help us build and run that platform. This role sits within the Data and Technology organization on the Data & Analytics team, a small, senior group that owns the full path from source system to decision. You will own dbt models and pipelines end to end, onboard new sources, keep the nightly run healthy, and make the platform faster, more trustworthy, and less dependent on any one engineer’s memory. You will work closely with our Integrations team, which migrates acquired agencies into AMS360, and with analysts and stakeholders in Sales, Operations, and Finance. Duties and Responsibilities:
Duties and 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.
- 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.
- 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.
- 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.
- 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.
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.
- 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.

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

Trucordia is a rapidly growing insurance brokerage that acquires agencies nationwide and brings their business onto shared systems and shared reporting. Every acquired agency arrives with its own systems, its own data, and its own way of counting things. The Data & Analytics team turns that into one answer: a Snowflake warehouse fed from AMS360, Salesforce, HR, and finance systems, etc. modeled in dbt into conformed dimensions and facts (policies, premium, retention, producers, agencies, carriers), and served through Power BI, curated semantic views for AI, and internal web apps we design and build ourselves. Our governance framework (Entra-synced roles, row-level security, network and authentication policies) is code we wrote and maintain.

We are hiring an Analytics Engineer to help us build and run that platform. This role sits within the Data and Technology organization on the Data & Analytics team, a small, senior group that owns the full path from source system to decision. You will own dbt models and pipelines end to end, onboard new sources, keep the nightly run healthy, and make the platform faster, more trustworthy, and less dependent on any one engineer’s memory. You will work closely with our Integrations team, which migrates acquired agencies into AMS360, and with analysts and stakeholders in Sales, Operations, and Finance.

 

Duties and 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.

 

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. 

 

AI Assisted Development Requirements:

  • 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. 

 

Nice to have:

  • 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. 

 

Additional Information

Please see our company 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

Trucordia Insurance Services, LLC and its affiliates (collectively, the “Company”)  is aware of scams involving false offers of employment with the Company. The false offers use fake websites, email addresses, group chats and text messages. The Company does not (a) interview prospective candidates via instant message or group chat; (b) request banking or credit card information during the interview process; or (c) require candidates to purchase products or services or process payments on its behalf as a condition of any employment offer.

Trucordia is an equal opportunity employer. We believe that every employee has the right to work in an environment that is free from all forms of discrimination. It is our policy that all decisions involving any aspect of the employment relationship such as hiring, compensation and training, promotions, transfers, discipline, and termination will be based on merit, qualifications, and abilities. Such decisions will be made without regard to age, ancestry, color, race, national origin, disability, protected medical condition, genetic information, military service, veteran status, citizenship status, religion, creed, sex, gender, gender identity, sexual orientation, pregnancy, childbirth, marital status, or any other condition, characteristic or activity protected by law. Discrimination based on any of these factors is contrary to our operating philosophy.  Attention Recruitment Agencies: Trucordia does not accept unsolicited resumes from any agencies that have not signed a mutual service agreement. All unsolicited resumes will be considered property of Trucordia, and we will not be obligated to pay a referral fee. This includes resumes submitted directly to hiring managers without contacting Trucordia's Talent Acquisition Department.

Company Description

 

Extraordinary opportunity. Exceptional experience.

Sometimes in life, you find yourself in the right place, at the right time, looking at an opportunity so extraordinary it cannot be ignored. At Trucordia, our company is built on wildly successful businesses in our communities across the country, and now we’ve come together to create the next great insurance brokerage. We offer an unrivaled combination of people, tools and solutions, and deliver exceptional experiences and opportunities for our employees, clients and stakeholders.

We celebrate both individual successes and collective accomplishments, making sure the industry recognizes the remarkable company we’re building together, as well as the impact we’re having on our clients and communities. Ranked as one of the fastest-growing companies in the U.S. for three consecutive years, we have more than 5,000 team members across 200 offices across the country, who actively, genuinely care about our clients, each other and the quality of our work, and in every interaction, represent a company that people want to work for and do business with.

 

Trucordia Values

  1. We actively, genuinely CARE about our clients, each other and the quality of our work, and in every interaction, represent a company that people want to work for and do business with.
  2. We COLLABORATE continuously because, together, we are more powerful and make amazing things happen for our clients and company.
  3. We LEAD with intelligence, hunger, curiosity, energy and a future-focused attitude of “what’s next”?
  4. We are RESULT-ORIENTED, growth-focused and driven to out-perform expectations of what an insurance brokerage can achieve.
  5. We CELEBRATE both individual successes and collective accomplishments, making sure the industry recognizes the remarkable company we’re building together, as well as the impact we’re having on our clients and communities.

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 21% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 81, the most 168, and the latest week had 91.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Lindon, UT, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

This passage needs a closer read in the full description.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.