Senior Data Architect - Temp - Hybrid

Introduction

At Gallagher Benefit Services, you’re a trusted partner to organizations navigating some of their most important people decisions. We help clients build better workplaces, where people feel supported, empowered, and inspired to thrive. Whether it’s shaping benefit strategies, designing wellbeing programs, or advising on workforce challenges, the work you do here creates meaningful change for businesses and the people who power them.

We’re a community of bold explorers, trusted experts, and compassionate partners; working side by side to solve problems, and shape the future of work. Here, curiosity is encouraged, collaboration is second nature, and your ideas have room to grow. If you’re looking for a place where your contribution matters and where you can help build a better world of work;

think of Gallagher.

Data Architect
Gallagher Benefit Services, Inc. (GBS), a division of Gallagher
, consistently stands out in a competitive marketplace as an employer of knowledgeable, highly skilled and competitive talent. We are a company that touches businesses and their employees on a personal level. At the core, our job is to help protect the health and well-being of employees and their families and provide for their financial security—all while allowing employers to attract and retain the people they need to grow and succeed.

As you consider the value of working for our team, remember our talent, winning attitude and strong performance will be highly valued and will maximize your future potential.
Additional position details:
- This is a Temp-To-Hire, W-2 position. We are not able to do 1099 or C2C.
- It is a fully remote role that will need to be based in the U.S.
- You must meet our U.S. Eligibility requirements for work authorization as noted under "Additional Information" at the bottom of the job description.

How will I contribute to the business?
As a Data Architect you will be a key member of the GBS IT Data and Analytics team. This role creates both enterprise and product/project level data architecture artifacts. Working within the organization with Data & Analytics, Technology and other stakeholders, the Data Architect facilitates the creation and evaluation of data models, data governance data strategy through the review of requirements and use cases to recommend both strategic and execution level artifacts with the standard methodologies for development.

The architect will be responsible for design and delivery of solutions to integrate data from line of business applications into data warehouses and marts and the presentation of this data to end users using data visualization software. You will be able to demonstrate knowledge of traditional and cloud-based architecture approaches, with strong programming skills including SQL.

• Lead the architecture and design of cloud-based data architecture using Azure data platform solutions.
• Determine architecture solutions that meet performance, scalability, reliability, and security needs.
• Lead multiple, large, highly complex efforts simultaneously, making key architecture and technology decisions.
• Support conceptual, logical, and physical data modeling efforts for strategic initiatives.
• Design and develop data warehouse database schemas, extract, transform, and load (ETL) mappings, procedures, and schedules.
• Coordinate activities with data source application owners to ensure integration and data integrity.
• Design and develop reports, dashboards, KPIs, and data extracts.
• Provide proactive technical oversight and mentorship to architecture and development teams fostering re-use, design for scale, stability, and operational efficiency based on strategic business and P&E tenets.
• Research and evaluate emerging data management technologies for applicability and adoption.
• Build prototypes of learning solutions to show proof-of-concepts and develop scalable integrated enterprise services.
• Design, develop, implement, test intelligent application solutions in a PaaS environment.
• Work with technical leadership to drive innovation and create best practices within the team.
• Present technical ideas and high-level…