Data Architect

1 week ago


Rolling Meadows, United States Gallagher Full time

About Us:
Discover a world of endless possibilities at Gallagher Benefit Services, where you'll have the power to shape the future of workplaces across industries. As a member of our team, you become the driving force behind positive change, helping clients build environments where employees thrive. Embrace the opportunity to impact lives, unlock potential, and create a legacy of remarkable transformation.

Overview:
**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

Please note additional position details below:

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

**Responsibilities**:
**How will I contribute to the business?**

**Key Responsibilities**
- 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.
- 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
- Work with technical leadership to drive innovation and create best practices within the team.
- Present technical ideas and high-level concepts and solutions to internal and external team members.
- Collaborate and contribute to the company’s data mining architectures, modeling standards, reporting, and data analysis methodologies.
- Contribute to a positive culture of continuous improvement and operational excellence by identifying and implementing process improvements where appropriate.
- Collaborates with cross-functional teams to understand the business problem, gather business requirements, supporting data and with/without guidance of leadership, help stakeholders/partners understand the business and scientific principles behind the process in order to gain their buy-in
- Trains/coaches team members or peers and actively shares expertise with peers

Qualifications:
**Job Qualifications**
- Bachelor’s degree in Computer Science or related field, 8+ years of experience.
- In-depth knowledge of database structures/ data warehousing principles, and experience in SQL across different platforms including structured and unstructured data from various enterprise sources.
- Proven technical skills in data architecture, data modeling, data management, and data retention concepts and practices.
- Experience with the Microsoft SQL Server Technology Stack (2016 or later) is required.
- Good knowledge of standard concepts, best practices, coming up with blue prints, future state data marts, and procedures within a data warehousing and Business Intelligence(BI) environment
- Initiative and passion for finding solutions to ambiguous problems and ability to work in difficult situations and across organizational boundaries.
- Strong written and verbal communication skills including the ability to effectively collaborate with multi-disciplinary groups and all organizational levels
- High level organizational and project management skills in order to handle multiple concurrent assignments in a timely manner and to monitor processes throughout a team or department
- Strong decision-making skills

Gallagher offers competitive salaries and benefits, including: medical/dental/vision plans, life and accident insurance, 401(K), employee stock purchase plan, educational expense reimbursement, employee assistance program, flexible work hours (availability varies by office and job



  • Rolling Meadows, Illinois, United States Arthur J. Gallagher & Co. Full time

    Discover a world of endless possibilities at Gallagher Benefit Services, where you'll have the power to shape the future of workplaces across industries. As a member of our team, you become the driving force behind positive change, helping clients build environments where employees thrive. Embrace the opportunity to impact lives, unlock potential, and create...


  • Rolling Meadows, United States Pyramid Technology Solutions Full time

    Collibra Data Governance Delivery Architect/Specialist.Location: Rolling Meadows, IL. (Hybrid)Duration: 6+ Months.Support current data domain mapping exercise outputs in conjunction with Program Manager and others from business and Data Governance teams across Clients Global and GBS to ensure correct hierarchies, architecture and mapping is done to support...


  • Rolling Meadows, United States Gallagher Full time

    Introduction: Discover a world of endless possibilities at Gallagher Benefit Services, where you'll have the power to shape the future of workplaces across industries. As a member of our team, you become the driving force behind positive change, helping clients build environments where employees thrive. Embrace the opportunity to impact lives, unlock...

  • Senior Consultant

    4 weeks ago


    Rolling Meadows, United States BLackbuck Insights LLc Full time

    Rolling Meadows, United States | Posted on 09/04/2023 BBInsights (BBI) is adata-solutions firm specializing in niche technologies andleveraging art and science to enable businesses to transform datainto information. Our solution-centric approach delivers elegantintegration of IoT, Cloud, Data, and Analytics framework with acore focus on architecture,...

  • Senior Consultant

    4 weeks ago


    Rolling Meadows, United States BLackbuck Insights LLc Full time

    Rolling Meadows, United States | Posted on 09/04/2023 BBInsights (BBI) is adata-solutions firm specializing in niche technologies andleveraging art and science to enable businesses to transform datainto information. Our solution-centric approach delivers elegantintegration of IoT, Cloud, Data, and Analytics framework with acore focus on architecture,...

  • HR Advisor

    4 days ago


    Rolling Meadows, United States Gallagher Full time

    Introduction: Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...


  • Rolling Meadows, United States Arthur J. Gallagher & Co. Full time

    Welcome to Gallagher – a global leader in insurance, risk management, and consulting services. With a growing team of more than 45,000 professionals worldwide, we empower businesses, communities, and individuals to thrive. At Gallagher, you can build a career whether it’s with our brokerage division, our benefits and HR consulting division, or our...

  • M&a Project Manager

    3 weeks ago


    Rolling Meadows, United States Gallagher Full time

    About Us: Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...


  • Rolling Meadows, United States Gallagher Full time

    About Us: Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...


  • Rolling Meadows, United States Gallagher Full time

    About Us: Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...

  • HR Advisor

    4 days ago


    Rolling Meadows, United States Gallagher Full time

    Introduction: Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...


  • Rolling Meadows, United States Gallagher Full time

    Introduction: Welcome to Gallagher – a global leader in insurance, risk management, and consulting services. With a growing team of more than 45,000 professionals worldwide, we empower businesses, communities, and individuals to thrive. At Gallagher, you can build a career whether it’s with our brokerage division, our benefits and HR consulting division,...


  • Rolling Meadows, Illinois, United States Gallagher Full time

    About Us: Welcome to Gallagher – a global leader in insurance, risk management, and consulting services. With a growing team of more than 45,000 professionals worldwide, we empower businesses, communities, and individuals to thrive. At Gallagher, you can build a career whether it's with our brokerage division, our benefits and HR consulting division, or...

  • M&A Project Manager

    2 weeks ago


    Rolling Meadows, Illinois, United States Gallagher Full time

    About Us: Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...


  • Rolling Meadows, United States Gallagher Full time

    About Us: Welcome to Gallagher a global leader in insurance, risk management, and consulting services. With a growing team of more than 45,000 professionals worldwide, we empower businesses, communities, and individuals to thrive. At Gallagher, you can build a career whether its with our brokerage division, our benefits and HR consulting division, or our...


  • Rolling Meadows, Illinois, United States Gallagher Full time

    About Us: Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...


  • Rolling Meadows, United States Gallagher Full time

    Introduction: Welcome to Gallagher a global leader in insurance, risk management, and consulting services. With a growing team of more than 45,000 professionals worldwide, we empower businesses, communities, and individuals to thrive. At Gallagher, you can build a career whether its with our brokerage division, our benefits and HR consulting division, or our...


  • Rolling Meadows, United States Gallagher Full time

    Introduction: Welcome to Gallagher – a global leader in insurance, risk management, and consulting services. With a growing team of more than 45,000 professionals worldwide, we empower businesses, communities, and individuals to thrive. At Gallagher, you can build a career whether it’s with our brokerage division, our benefits and HR consulting division,...

  • HR Advisor

    2 weeks ago


    Rolling Meadows, Illinois, United States Gallagher Full time

    About Us:Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a...

  • Sous Chef

    2 weeks ago


    Meadows, United States MCR Hotels Full time

    Sous Chef Luxury Collection Hotel Manhattan Midtown, 151 West 54th Street, New York, New York, United States of America Req #7071 Wednesday, June 12, 2024 Luxury Collection Manhattan Midtown The Sous Chef is responsible for assisting in the overall success of the daily culinary operations. This person will assist in leading the...