Data Warehouse Architect
USI Insurance Services · United States
- Hybrid
- Full-time
- $175,000 / year
- United States
Job highlights
- Design scalable data pipelines and products.
- Transform data using ELT and dbt.
- Build ingestion pipelines with Azure Data Factory.
- Architect Kimball-style dimensional data models.
- Collaborate with data scientists and stakeholders.
About the role
Data Warehouse Architect - USI Insurance Services
General Description: Participate in the design and development of scalable data pipelines, transforming data and creating data products to empower business decision making. Collaborate with cross-functional teams to understand data requirements and deliver data-driven solutions. Includes data scientists, analysts, and business stakeholders. Support data needs of multiple teams, systems, and products.
Responsibilities
- Utilize extract, load, and transform (ELT) methodologies to move data from various systems into a Snowflake enterprise data warehouse.
- Design, implement, and maintain scalable data ingestion pipelines using Azure Data Factory (ADF).
- Leverage dbt and Jinga to build, test, and document data transformation within the Snowflake platform, including scalable, modular, and reusable data transformation workflows.
- Develop best practices for data ingestion, dataset creation, storage and updates, naming conventions, and retention.
- Architect, design, and implement Kimball-style dimensional data models (e.g., star and snowflake schemas) to support business intelligence and reporting needs.
- Collaborate with stakeholders to define tables, views, and schemas to support data products.
- 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
- 8+ years of SQL programming, SQL database design, and data architecture concepts.
- Bachelor’s degree in computer science, information systems, statistics, or related field.
- 2+ years of experience architecting data models and data warehousing techniques.
- Experience working with agile scrum methodology.
- Experience with Microsoft Azure DevOps and Azure Data Factory.
- Advanced knowledge of Snowflake or similar cloud data warehousing.
- Solid understanding of modern data transformations using dbt or similar tools.
- Hands-on experience working with Git code repositories and CI/CD tools.
- Working knowledge of insurance brokerage or sales workflows and systems preferred.
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 USI sets 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!
Benefits
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.
Key skills/competency
- Data Warehouse Architecture
- Snowflake
- Azure Data Factory
- dbt
- SQL
- Data Modeling
- ELT
- ETL
- Data Pipelines
- Agile
Skills & topics
- Data Warehouse Architect
- Data Architecture
- Snowflake
- Azure Data Factory
- dbt
- SQL
- Data Modeling
- ELT
- ETL
- Data Pipelines
- Cloud Data Warehousing
- Agile
- Business Intelligence
- Reporting
How to get hired
- Customize your resume: Highlight your 8+ years of SQL, data architecture, and 2+ years of data modeling experience. Emphasize Snowflake, Azure Data Factory, and dbt expertise.
- Tailor your application: Align your cover letter with USI's values, focusing on collaboration and data-driven solutions. Mention your experience with Agile and CI/CD tools.
- Prepare for interviews: Be ready to discuss your experience designing Kimball-style data models and optimizing SQL queries. Showcase your understanding of ELT methodologies and data security best practices.
- Demonstrate business acumen: If applicable, highlight any experience with insurance brokerage or sales workflows, showing you understand USI's industry.
Technical preparation
Behavioral questions
Frequently asked questions
- What is the salary range for the Data Warehouse Architect position at USI Insurance Services?
- The Data Warehouse Architect position at USI Insurance Services offers a salary range of $150,000 to $175,000 annually. This role is bonus eligible with a target incentive of 15%.
- What are the key technical skills required for the Data Warehouse Architect role at USI Insurance Services?
- Key technical skills include 8+ years of SQL programming and database design, 2+ years of data architecture and warehousing techniques. Proficiency with Snowflake, Azure Data Factory, dbt, Agile methodologies, and Git is essential. Experience with ELT is also crucial.
- Does USI Insurance Services offer remote work options for the Data Warehouse Architect position?
- The job description does not explicitly state the work arrangement. However, given the typical nature of these roles and the company's nationwide presence, it could be hybrid or on-site depending on the specific team and location. It's best to clarify this during the application process.
- What is the application deadline for the Data Warehouse Architect job at USI Insurance Services?
- The application deadline for the Data Warehouse Architect position at USI Insurance Services is June 29, 2026.
- What kind of data modeling expertise is USI Insurance Services looking for in a Data Warehouse Architect?
- USI Insurance Services is looking for expertise in architecting, designing, and implementing Kimball-style dimensional data models, such as star and snowflake schemas, to support business intelligence and reporting needs.
- How does USI Insurance Services foster professional development for its associates, particularly for a Data Warehouse Architect?
- USI Insurance Services emphasizes a dynamic personal and professional development culture, investing heavily in associates and celebrating growth through unique reward and recognition programs. They offer robust training and career advancement opportunities.
- What is the company culture like at USI Insurance Services for a Data Warehouse Architect?
- USI fosters a culture of collaboration, innovation, and community engagement. They are committed to diversity and inclusion, providing a supportive environment with industry-leading programs, rewards, and recognition. They are also recognized as a top insurance employer.
- What are the benefits of working as a Data Warehouse Architect at USI Insurance Services?
- USI offers a competitive suite of benefits including medical, dental, vision, 401(k), life insurance, disability, generous paid time off, paid family leave, and paid holidays. They also have award-winning wellness programs and employee recognition initiatives.