IntroductionJoin 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.
How you'll make an impact- Gathering data from various sources, such as databases, APIs, and external systems, and integrating it into a centralized data warehouse or data lake.
- Cleaning, validating, and transforming raw data into a structured format that can be easily analyzed and used for business intelligence purposes.
- Designing and implementing data models and database schemas that support efficient data storage, retrieval, and analysis.
- Building and maintaining data pipelines that automate the extraction, transformation, and loading (ETL) processes, ensuring the smooth flow of data from source systems to the data warehouse.
- Implementing data quality checks and ensuring data integrity and consistency throughout the data lifecycle. Establishing data governance policies and procedures to ensure compliance with regulations and best practices.
- Monitoring and optimizing the performance of data systems, including database queries, ETL processes, and data pipelines, to ensure efficient data processing and analysis.
- Implementing security measures to protect sensitive data and ensuring compliance with data privacy regulations, such as GDPR or CCPA.
- Working closely with data scientists, analysts, and other stakeholders to understand their data requirements and provide them with the necessary data infrastructure and tools.
- Identifying and resolving issues related to data pipelines, database performance, or data quality, and providing technical support to resolve data-related problems.
- Staying updated with the latest technologies, tools, and best practices in data engineering, and continuously improving data engineering processes and infrastructure to enhance efficiency and scalability.
About You- Bachelor's or equivalent degree in computer science, information systems, or a related field.
- Proven experience in data engineering or a related role, with a strong understanding of data architecture and data integration principles.
- Key Skills, roughly in order of importance
- Microsoft Azure environment
- Snowflake
- SSIS
- T-SQL
- ETL principals such as SCD types, SQL CDC, etc.
- Azure Data Factory
- Synapse Analytics
- Azure DevOps (particularly collaborating using Git)
- Microsoft SQL Database
- Azure Storage/ Data Lake
- SSRS/PowerBI development
- Python
- Previous experience in a data engineering or related role, working with large-scale data systems and handling complex data pipelines, is highly desirable.
Compensation and benefitsOn 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…
We value inclusion and diversity
Inclusion and diversity (I&D) is a core part of our business, and it’s embedded into the fabric of our organisation. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work.
Gallagher embraces our employees’ diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest.
Gallagher is Disability Confident Committed. We have pledged to make sure our recruitment process is inclusive and accessible, in addition to supporting our existing employees with any long-term health conditions or disabilities.
We understand that applicants may have disabilities, if you do, you may find some parts of the recruitment process more challenging than others. Don’t worry, we’re here to help, however, we can only do this if you let us know.
Should you require reasonable adjustments to your application, please get in touch with TAGlobalSupport@ajg.com . If you’d prefer to speak on the phone, please request a call back, leaving details, so we get in touch.
Our employing entity, Arthur J. Gallagher Services (UK) Limited, is proud to be accredited as a Living Wage employer with the Living Wage Foundation. We are committed to diversity and opportunity for all and are opposed to any form of less favourable treatment on the grounds of gender or gender identity, marital status, civil partnership status, parental status, race, ethnicity, colour, nationality, disability, sexual orientation, religion/ belief, age and those with caring responsibilities.
Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as “protected characteristics”) by applicable federal, state, or local laws.
Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.
