Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Analytics Engineer

Full-time

Trucordia

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.
Vacancy posted 22 hours ago
Similar jobs that could be interesting for youBased on the Analytics Engineer in Lindon, UT vacancy
  • $100k - $140k

     ...We're building a modern analytics platform from the ground up: a layered, well-tested data model in Snowflake that becomes the single...  ...ask questions and get trustworthy answers. As an Analytics Engineer, you own the transformation layer. You'll turn messy source data... 
    Suggested

    Havenpark Communities

    Orem, UT
    2 days ago
  •  ...As the Lead Data Engineer, you will lead the development of Kenect’s data ecosystem, including architecting and implementing a customer data platform. This platform will unify batch and real-time data from sources such as DMS, CRMs, social networks, and web traffic to... 
    Suggested

    Kenect

    Pleasant Grove, UT
    2 days ago
  •  ...schedule open to remote candidates. The Opportunity: The Senior Data Engineer will be responsible for designing and building infrastructure...  ..., researching latest industry trends in areas like data analytics, LLMs, and AI Collaborate and strategize with internal partners... 
    Suggested
    Contract work
    Remote work
    Flexible hours

    Varite

    Lehi, UT
    1 day ago
  •  ...collaborative team that builds with sane, high-trust execution, you'll thrive at MX. Introduction to the Position The Security Engineering team is responsible for designing and implementing the security measures that protect MX's digital assets and infrastructure. The... 
    Suggested

    mxtechnologiesinc

    Lehi, UT
    4 days ago
  • $105k

     ...Job Description Job Description The Data Engineer works with a multidisciplinary Agile team to build and maintain high-quality data...  ...and will be key in supporting current and future reporting and analytic solutions. What You’ll Do Build and optimize secure, reusable... 
    Suggested
    Work at office
    Remote work
    Flexible hours
    Shift work

    KLAS Research

    Pleasant Grove, UT
    18 days ago
  • $47.89 - $59.86 per hour

     ...intelligence solutions that enable data-driven decisions across the organization. You will partner with business stakeholders, analytics, and engineering teams to define KPIs, scope BI projects, and translate requirements into reliable reporting. This role supports... 
    Hourly pay
    Permanent employment
    Full time
    Contract work

    NextDeavor

    Lehi, UT
    3 days ago
  •  ...experience and expertise in providing comprehensive scientific, engineering, technical, and non-technical staff augmentation and talent...  ...Collaborate with cross-functional teams including business, analytics, and engineering teams Document processes, data models, and... 
    Contract work

    Varite, Inc

    Lehi, UT
    21 days ago
  •  ...job-related knowledge, skills, and experienceThe Data/DataOps Engineer II is a junior-to-mid level position that will provide data pipeline...  ...companyFor over 50 years, Verisk has been the leading data analytics and technology partner to the global insurance industry by... 
    Work at office

    Verisk Analytics

    Lehi, UT
    12 hours ago
  • $100k - $115k

     ...development and ongoing improvement of our enterprise reporting and analytics capabilities. We're looking for a hands-on Power BI...  ...and deliver actionable reporting solutions. Work with data engineering to leverage centralized data within Microsoft Fabric. Support... 
    Full time

    Dentive, LLC

    Provo, UT
    22 days ago
  •  ..., consistency, and performance across reporting solutions Collaborate with cross-functional teams including business, analytics, and engineering teams Document processes, data models, and reporting standards Required Skills: Power BI Tableau SQL Server... 
    Contract work

    SGA Inc.

    Lehi, UT
    21 days ago
  • $109k - $200.7k

     ...reports ADI is known for, and stepping in wherever the team needs analytical horsepower, from analysis of US dollar inflation to...  ...downstream users depend on. Along the way you will collaborate with engineering, analysts, architects, product managers, and leadership,... 
    Full time
    Temporary work
    Local area
    Worldwide
    Flexible hours
    Shift work

    Adobe Systems

    Lehi, UT
    3 days ago
  • $165k - $195k

     ...As a Lead Data Analyst, you will report directly to the VP of Analytics & Operations Supply and act as the team's senior individual contributor...  ...effective communication. Partner cross-functionally with Engineering, Product, Data Science, and Finance teams to drive initiatives... 
    Full time
    Remote work

    Liftoff Inc

    Provo, UT
    3 days ago
  • $74.1k - $148.3k

     ...supports new region builds and expansion activities, both onsite and remotely.-Acts as a liaison with project teams and data center engineering, supporting timelines and capacity needs are proactively managed for expansion projects and site builds.-Collaborates closely... 
    Temporary work
    Remote work
    Flexible hours
    Shift work

    Oracle Corporation

    Lehi, UT
    4 days ago
  • $80k - $110k

     ...touch. Position Summary: Reef is looking for an AI-forward analytics professional who turns business questions into answers people...  ...and testing it before it ships. Work with the Data Engineer to resolve data discrepancies and fix problems at the source.... 
    Worldwide
    Relocation

    Reef Capital Partners

    Lehi, UT
    14 days ago
  •  ...have a current understanding of sales strategies, best practices, and associated resources. GPA is 3.7 or higher. Outstanding analytical and data management skills including experience with SQL. Teachable and fast learner. Self-motivated and proactive. High... 
    Full time
    Internship
    Local area

    Pattern

    Lehi, UT
    22 days ago
  • Job Description Job Description Senior Reporting and Analytics Business Analyst Job Sumary: Senior Reporting and Analytic… Shift: [] Start: []
    Shift work

    Axelon Services Corporation

    Lehi, UT
    19 days ago
  • $75k - $95k

     ...CSAT signals. Producing monthly CX reports with actionable insights fit for executive-level audiences grounded in a consistent analytical framework (trend, driver, and root cause analysis). Analyzing root causes of escalations, refunds, and low-CSAT moments using... 

    Fashionfile

    Lehi, UT
    2 days ago
  • $100k - $120k

     ...Industrial Engineer – Solar Operations & Data Analytics Job Level: Individual Contributor Location: Orem, Utah Shift: Full-Time Compensation: $100,000–$120,000 About SunPower SunPower’s mission is to provide industry leading, innovative, end-to-end... 
    Full time
    Work at office
    Immediate start
    Shift work
    1 day per week

    Sunpower

    Orem, UT
    5 days ago
  • $126.2k - $264.1k

     ...response to increased concurrent projects for the delivery of our data centers, Oracle is recruiting a Lead Principle Commissioning Engineer. The role is a senior multi-disciplinary data center commissioning lead with a focus all levels of commissioning activities up to... 
    Contract work
    Temporary work
    Live in
    Flexible hours

    Oracle Corporation

    Lehi, UT
    1 day ago
  •  ...Description Job Description Job Description: The Senior Data Engineer will be responsible for designing and building infrastructure...  ..., researching latest industry trends in areas like data analytics, LLMs, and AI o Collaborate and strategize with internal... 
    Contract work

    Mindlance

    Lehi, UT
    21 days ago
  •  ...Guidance & Assistance, Inc., (SGA), is searching for a Senior Data Engineer for a contract assignment with one of our premier SaaS...  ..., researching latest industry trends in areas like data analytics, LLMs, and AI Collaborate and strategize with internal partners... 
    Contract work

    SGA Inc.

    Lehi, UT
    21 days ago
  •  ...Analyst acts as a consultant to both sales and company leadership. You are responsible for providing a wide range of strategic, analytical, and operational support across multiple global regions and sales teams. In this role you will be responsible for solving complex... 
    Work at office
    3 days per week

    Qualtrics

    Provo, UT
    12 hours ago
  • $150k

     ...KLAS, our mission is to improve healthcare by amplifying truth through collaboration, insights, and transparency. The Software Engineering Team Lead guides a small team building software for data science and AI products. This is a hands-on role combining team... 
    Work at office
    Remote work
    Flexible hours

    KLAS Research

    Pleasant Grove, UT
    5 days ago
  •  ...Compliance Team is looking for an experienced compliance data analytics professional to join the team. In this role, you will be responsible...  ...Compliance, Technology, Model Risk Management, and Data Engineering to support deliverablesPerform ongoing User-Acceptance Testing... 
    Full time
    Work at office
    Local area
    Remote work
    Relocation
    Flexible hours

    Lending Club

    Lehi, UT
    1 day ago
  •  ...Description At E Tech Group, joining our team means joining a group of passionate and forward-thinking experts. We're one of the largest engineering and system integration firms in the United States providing value for our clients through IT automation and control solutions for... 
    Local area
    Remote work
    Flexible hours

    E Tech Group

    Provo, UT
    14 days ago
  • Are you obsessed with data, partner success, taking action, and changing the game? If you have a whole lot of hustle and a touch of nerd, come work with Pattern! We want you to use your skills to push one of the fastest-growing companies in the US to the top of the list...
    Internship

    pattern

    Lehi, UT
    4 days ago
  •  ...understand the relationship of the data from the various sources for integration. This level will also perform ad hoc deep dive analytical analysis and interpretation. Qualifications Education: BS/BA Degree in mathematics statistics computer science or a related... 
    Full time
    Work experience placement

    The Church of Jesus Christ of Latter-day Saints

    Lehi, UT
    2 days ago
  • $122.4k - $144k

    Job Description Job Description Who We Are: SmithRx is a rapidly growing, venture-backed Health-Tech company.  Our mission is to disrupt the expensive and inefficient Pharmacy Benefit Management (PBM) sector by building a next-generation drug acquisition platform...
    Temporary work
    Work at office
    Flexible hours
    Shift work

    SmithRx

    Lehi, UT
    26 days ago
  • $66.21k - $105.96k

     ...is changing in higher education, why it matters, and what we should pay attention to next. As part of the Marketing Insights and Analytics team, you will explore internal and external data, secondary research, competitive intelligence, and market signals to uncover meaningful... 
    Full time
    Remote work
    Worldwide

    Southern New Hampshire University

    Provo, UT
    12 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Analytics Engineer. Be the first to apply!