Data Warehouse Architect

Description and Requirements

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. Includes 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+ 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.

#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: $150,000- $175,000. This is a bonus eligible position with a target incentive of 15%.

Deadline for application: 6/29/26