Data Engineer

USI Insurance Services

United States

Remote

USD 110,000 - 125,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

USI is seeking a data engineering professional to design and develop scalable data pipelines. You will work with Azure Data Factory, dbt, and Snowflake to ingest and transform data for multiple teams and products.

You will collaborate with data scientists, analysts, and stakeholders to define schemas, optimize queries, and ensure reliable data delivery while following security standards.

Qualifications

  • 5+ years of SQL programming, data modeling, and data warehousing experience.
  • Bachelor’s degree in a relevant field.
  • Experience building data pipelines using Azure Data Factory and dbt.
  • Familiarity with Snowflake and SQL ETL/ELT patterns.

Responsibilities

  • Participate in the design, development, and maintenance of Azure Data Factory and dbt pipelines.
  • Move data from multiple systems into Snowflake using ELT techniques.
  • Develop SSIS/T-SQL processes and ETL pipelines.
  • Collaborate with stakeholders to define tables, views, and schemas for data products.
  • Design and optimize data models for performance in Snowflake.
  • Monitor pipelines and troubleshoot data movement issues.
  • Ensure data availability, integrity, and security.

Skills

SQL programming
Data architecture concepts
Data warehousing
Scrum agile processes
Azure DevOps
Azure Data Factory
Snowflake
dbt
Git and CI/CD

Education

Bachelor’s degree in computer science, information systems, statistics, or related field

Tools

Azure Data Factory
dbt
SSIS
T-SQL
Snowflake
Git
CI/CD tooling

Job description

General Description

Participate in the design and development of data pipelines. Collaborate with various cross functional teams to understand data requirements and deliver data driven solutions. Includes data scientists, analysts, and business stakeholders. Support the data needs of multiple teams, systems, and products.

Responsibilities
  • Participate in the design, development, and maintenance of Azure Data Factory and dbt data pipelines. Utilize extract, load, and transform (ELT) methodologies to move data from various systems into a Snowflake enterprise data warehouse.
  • Participate in the design, development, and maintenance of SSIS/TSQL processes. Utilize extract, transform, and load (ETL) methodologies to move data from disparate systems into SQL databases.
  • Contribute to the development of best practices for data ingestion, dataset creation, storage and updates, naming conventions, and retention.
  • Collaborate with stakeholders to define tables, views, and schemas to support data products.
  • Participate in the design and implementation of data models in Snowflake. Ensure they are efficient, scalable, and optimized for performance.
  • Monitor the data movement processes and pipelines for overall health and performance.
  • Investigate and troubleshoot issues to ensure data availability and reliability.
  • Fine tune and optimize SQL queries and pipelines for improved efficiency.
Cyber Security Job Responsibilities
  • Operate in accordance with USI Policies for the Information Security Program (PISP) and USI Standards for the Information Security Program (SISP).
  • Keep up to date with security updates and improvements. Implement improvements as appropriate.
  • Protect systems against unauthorized access by appropriately defining access.
  • Upgrade systems by implementing and maintaining security and technical controls.
Knowledge, Skills and Abilities
  • 5 years + SQL programming, SQL database design, and data architecture concepts.
  • Bachelor’s degree in computer science, information systems, statistics, or related field.
  • Experience with data models and data warehousing.
  • Experience working with scrum agile processes.
  • Experience with Microsoft Azure components such as DevOps and Azure Data Factory.
  • Good understanding of Snowflake or similar cloud data warehousing.
  • Good understanding of modern data transformations using dbt or similar tool.
  • Hands-on experience working with Git code repositories and CI/CD tools.
  • Working knowledge of insurance brokerage or sales workflows and systems preferred.

#LI-JM4

#LI-Remote

Why USI?

With approximately $3 billion in revenue and over 10,500 associates across approximately 200 offices nationwide, USI is one of the largest insurance brokerage and consulting firms in the world. At USI, we have created one of the most dynamic personal and professional development cultures in the industry. We invest heavily in our associates, and we take pride in celebrating their growth and success through our one-of-a-kind employee reward and recognition programs.

Unrivaled Resources and Support

What truly distinguishes USI as a premier insurance brokerage and consulting firm is the USI ONE Advantage®, a game-changing value proposition that delivers to clients a robust set of risk management and benefit solutions with bottom-line financial impact. USI ONE® represents Omni, Network, Enterprise—the three key elements that set USI apart from the competition. Through USI ONE, we develop strategic, timely, and effective risk management and benefit programs in terms that are easy to understand, and we demonstrate how the solutions can have a positive economic impact.

Industry-Leading Programs, Rewards, and Recognition

In addition to competitive pay, incentives, and benefits, USI recognizes associates through our Summit Awards program, rewarding excellence in those who build our brand each day. USI offers employee programs that recognize outstanding achievement and help our associates lead healthy, productive lives. We turn care into action with our award-winning wellness program, college scholarships for associates' children, and financial help in times of need.

Deep Community Engagement

We are committed to giving back to our local communities and supporting a culture of environmental sustainability. From sharing our time, talent, and resources to support local non-profit organizations, animal shelters, and environmental beautification and restoration projects – to partnering with eco-conscious vendors and taking steps to reduce our own environmental footprint – we’re working together as ONE to build a better future.

Committed to a Diverse and Inclusive Workplace

Our award-winning I’m With U diversity and inclusion program educates our associates to help them better understand and serve our clients, prospects, fellow team members, and local communities through curated education and training resources, employee support programs, and community outreach initiatives to build a more diverse, equitable, and inclusive culture.

Nationally Recognized as a Top Insurance Employer

Recognized as one of Insurance Business America’s Top Insurance Employers eight consecutive years (2018-2025).

Named to Business Insurance’s annual list of the Best Places to Work in Insurance six years in a row (2020-2025).

Named to Fortune’s Best Workplaces in Financial Services & Insurance list for the last two years (2024-2025).

Certified as a Great Place To Work two years in a row (2024-2025).

Visit our Awards and Accolades page for a complete list of our latest industry awards and recognitions!

USI is committed to providing a full-suite of competitive benefits for our growing population and its diverse needs. We offer a wide range of health, welfare and financial benefits including medical, wellness, dental and vision, 401(k), flexible spending and health savings accounts, short and long-term disability, life insurance and other unique employer-sponsored and voluntary programs. USI also offers a generous paid time off policy, paid family leave benefit as well as paid holiday time.

Salary Range: $110,000- $125,000. This is a bonus eligible position with a target incentive of 8%.

Deadline for applications: 3/27/26

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Scrum Master
Scrum Master

USI Insurance Services • United States

On-site
USD 80,000 - 95,000
Competitive salary
Employee wellness programs
401(k) plan
Employee Benefits Account Manager, Select
Employee Benefits Account Manager, Select

Usi, Inc. • Savannah (GA)

On-site
USD 65,000 - 80,000
Commercial Lines Sr. Casualty Consultant
Commercial Lines Sr. Casualty Consultant

Usi, Inc. • Portland (OR)

On-site
USD 135,000 - 180,000
Paid Time Off – 18 days per year
Bonus eligible with target 10%
Commercial Lines Sr. Casualty Consultant
Commercial Lines Sr. Casualty Consultant

Usi, Inc. • United States

On-site
USD 135,000 - 180,000
Bonus eligible with target 10%
PTO 18 days per year
12 paid holidays
Employee Benefits Sr. Account Manager
Employee Benefits Sr. Account Manager

USI Insurance Services • Florham Park (NJ)

On-site
USD 95,000 - 120,000
EB Producer
EB Producer

Usi, Inc. • Florham Park (NJ)

On-site
USD 120,000 - 200,000
Medical insurance
Dental plan
Vision plan
+5
Senior Employee Benefits Account Manager, Select
Senior Employee Benefits Account Manager, Select

Usi, Inc. • Greenville (SC)

On-site
USD 80,000 - 90,000
Health benefits
Dental insurance
Vision insurance
+5
Senior Employee Benefits Account Manager, Select
Senior Employee Benefits Account Manager, Select

Usi, Inc. • Mount Pleasant (SC)

On-site
USD 80,000 - 90,000
Employee Benefits Analyst IV
Employee Benefits Analyst IV

USI Insurance Services • Georgia

On-site
USD 90,000 - 130,000
Senior Employee Benefits Account Manager, Select
Senior Employee Benefits Account Manager, Select

Usi, Inc. • Raleigh (NC)

On-site
USD 80,000 - 90,000
Medical
Wellness program
Dental insurance
+9