USI Insurance Services · 9 hours ago
Data Engineer
United States
Full-time
Remote
Mid, Senior Level
$110K/yr - $125K/yr
5+ years expUSI Insurance Services is one of the largest insurance brokerage and consulting firms in the world. They are seeking a Data Engineer to participate in the design and development of data pipelines, collaborating with cross-functional teams to support data needs across various systems and products.
Commercial InsuranceConsultingEmployee BenefitsFinancial ServicesHealth InsuranceInsuranceRisk Management
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
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
Qualification
Required
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
Preferred
Working knowledge of insurance brokerage or sales workflows and systems
Benefits
Medical
Wellness
Dental
Vision
401(k)
Flexible spending and health savings accounts
Short and long-term disability
Life insurance
Other unique employer-sponsored and voluntary programs
Generous paid time off policy
Paid family leave benefit
Paid holiday time
Company
USI Insurance Services
USI Insurance Services is an insurance brokerage and consulting firm that delivers diversified insurance and financial services.
10001+ employees
H1B Sponsorship
USI Insurance Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2023 (3)
Funding
Current Stage
Late StageTotal Funding
$1BKey Investors
Kohlberg Kravis Roberts
2023-09-11Private Equity· $1B
2017-03-17Secondary Market
2017-03-17Acquired
Leadership Team
Stew Gibson
Senior Vice President and Chief Information Officer
Dave Petno
Vice President, Employee Benefits Consultant
Recent News
USI Insurance Services
2025-10-25
2025-10-21
Company data provided by crunchbase