The Role
The IT Data Engineer will design and implement ETL pipelines, modernize data workflows, support analytics, and collaborate with teams on data needs.
Summary Generated by Built In
COMPANY OVERVIEW:
Founded in 1989, United Automobile Insurance Company is an innovative and established organization looking for an IT Data Engineer to join our team. Family-owned, UAIC, is one of the largest privately held property and casualty insurance companies in the United States. The key to our growth and success is a commitment to providing quality service to our agents and customers, by providing disciplined underwriting, and strategic claims handling. Our ongoing efforts to invest substantial resources in personnel and technology are the foundation of our promise of assuring maximum efficiency and specialized operations in the industry. We are proud that our independent agents and customers have recognized our dedication by making UAIC the market leader in every state where we conduct business.
SCOPE:
As an IT Data Engineer at UAIC, you will help design and build modern, efficient, and scalable data integration processes across multiple systems. You’ll work on consolidating ETL pipelines into a unified technology stack and support downstream data analysis, reporting, and machine learning initiatives across departments.
RESPONSIBILITIES:
- Design and implement ETL/ELT pipelines to ingest data from various sources such as SQL Server, CSV files, AS400/DB2 systems.
- Consolidate and modernize data workflows using Azure Data Factory and/or other cloud-native tools.
- Support the creation of a centralized data lake environment for enterprise-wide analytics.
- Automate and optimize data extraction, transformation, and loading processes to improve scalability, reliability, and transparency.
- Work with cross-functional teams to support data requirements for reporting and dashboard development using Tableau/Power BI
- Perform validation checks, exception handling, and monitoring for data integrity and process health.
- Maintain technical documentation for data flows, integration specs, and design patterns.
- Collaborate with IT and business stakeholders to understand data needs and support a broader analytics strategy.
QUALIFICATIONS:
- Bachelor’s degree in Computer Science, Information Systems, or a related field; Master's is a plus.
- 3+ years of hands-on experience building and maintaining ETL pipelines and data workflows.
- Proficiency with SQL Server and advanced SQL development.
- Experience with Azure Data Factory or similar cloud data integration tools.
- Familiarity with cloud-based data platforms such as Azure Synapse, Redshift, or Snowflake.
- Knowledge of reporting tools (e.g., Tableau, SSRS) and BI integration best practices.
- Strong problem-solving and debugging skills with a collaborative mindset.
- Familiarity with P&C insurance data is a plus but not required.
BENEFITS:
- 401(k) Retirement Savings Plan with employer match.
- Comprehensive Medical, Prescription Drug, Vision, and Dental Insurance
- Paid Time Off, Holidays, and Leave programs.
- Flexible spending accounts
- Basic Life Insurance and Voluntary Life/ADD
- Short Term and Long-Term Disability
UAIC participates in the E-Verify program to confirm the employment eligibility of all newly hired employees. For more information about E-Verify, please visit https://www.e-verify.gov/.
Top Skills
Azure Data Factory
Azure Synapse
Power BI
Redshift
Snowflake
SQL Server
Tableau
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
United Automobile Insurance Company was incorporated on March 2, 1989 in Miami Gardens, FL to provide a high quality and low cost insurance product to the non-standard automobile insurance market. The company is family owned and it is one of the largest privately held property and casualty insurance companies in the United States
