Data Architect

Join us at Gallagher Re, the trailblazers of the reinsurance world, where every day brings new opportunities to shape the future. We empower our clients with cutting-edge analytics and insights, providing them the confidence to make strategic decisions that transform industries. As a team member, you'll be at the forefront of innovation, translating data into impactful solutions and taking the reins of your career like never before.

We believe that every candidate brings something special to the table, including you! So, even if you feel that you're close but not an exact match, we encourage you to apply.

At Gallagher Re, we are seeking an experienced Data Architect to join our global technology team. As our Data Architect, you will contribute to the architecture and implementation of our data strategies using Snowflake and Azure. You will be responsible for developing data solutions that are scalable, efficient, and optimized to meet our business needs as we continue to grow.

• Design and develop data models for large-scale databases on the Azure platform & Snowflake, ensuring scalability, performance, and data integrity.
• Collaborate with stakeholders, including data analysts, developers, and business analysts, to understand data requirements and translate them into effective data models.
• Assess database implementation procedures to ensure they comply with internal and external standards.
• Implement best practices for data modeling, including normalization, denormalization, indexing, and partitioning strategies.
• Prepare accurate database design and architecture reports for management and executive teams.
• Oversee the migration of data from legacy systems to cloud solutions.
• Stay up-to-date with the latest trends and advancements in data modeling techniques, tools, and technologies.
• Document data models, data dictionaries, and related artifacts to facilitate knowledge sharing and maintain data lineage.

• Degree obtained in Computer Science, Information Systems, or a related field.
• Proven experience as a Data Architect.
• Knowledge of data modeling concepts, techniques, and best practices.
• Proficiency in SQL and experience with database management systems (DBMS) such as Azure SQL Database, Azure Synapse Analytics, or Azure Cosmos DB.
• Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks.
• Familiarity with data integration and ETL processes, including data ingestion, transformation, and loading.
• Experience with Snowflake.
• Excellent communication and collaboration skills, with the ability to work effectively in cross-functional teams.

On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits. Below are the minimum core benefits you'll get, depending on your job level these benefits may improve:

• Minimum of 25 days holiday, plus bank holidays, and the option to 'buy' extra days
• Defined contribution pension scheme, which Gallagher will also contribute to
• Life insurance, which will pay 4x your basic annual salary, which you can top-up to 10x
• Income protection, we'll cover up to 50% of your annual income, with options to top up
• Health cash plan or Private medical insurance

Other benefits include:

• Three fully paid volunteering days per year
• Employee Stock Purchase plan, offering company shares at a discount
• Share incentive plan, HMRC approved, tax effective, stock purchase plan
• Critical illness cover
• Discounted gym membership, with over 3,000 gyms nationally
• Season ticket loan
• Access to a discounted voucher portal to save money on your weekly shop or next big purchase
• Emergency back-up family care
• And many more