Logo of Huzzle

Home

Matches

Explore

Manage

Data Architect

image

Gallagher Re

1mo ago

  • Job
    Full-time
    Senior Level
  • New York

AI generated summary

  • You must have a degree in Computer Science or related field, 5 years of Data Architect experience, strong SQL skills, Azure and Snowflake expertise, and excellent communication abilities.
  • You will design and develop scalable data models, collaborate with stakeholders, ensure compliance, oversee data migration, implement best practices, and document data artifacts for knowledge sharing.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, or a related field.
  • Proven experience (5 years) as a Data Architect
  • Strong 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.

Responsibilities

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

FAQs

What is the primary responsibility of the Data Architect at Gallagher Re?

The primary responsibility of the Data Architect is to design and develop data models for large-scale databases using Snowflake and Azure, ensuring scalability, performance, and data integrity.

What qualifications are required for this role?

Candidates must have a Bachelor's degree in Computer Science, Information Systems, or a related field, along with at least 5 years of proven experience as a Data Architect.

Which technologies should candidates be proficient in?

Candidates should have strong knowledge of data modeling concepts, proficiency in SQL, experience with Azure SQL Database, Azure Synapse Analytics, Azure Cosmos DB, and hands-on experience with Azure services like Azure Data Factory, Azure Data Lake Storage, Azure Databricks, and Snowflake.

Who will the Data Architect collaborate with in this role?

The Data Architect will collaborate with stakeholders including data analysts, developers, and business analysts to understand data requirements and translate them into effective data models.

What benefits does Gallagher Re offer to employees?

Gallagher Re offers a competitive salary along with medical/dental/vision plans, life and accident insurance, 401(K) options, tax-advantaged accounts, educational expense reimbursement, paid parental leave, and additional benefits such as digital mental health services, flexible work hours, and training programs.

Does Gallagher Re value inclusion and diversity?

Yes, inclusion and diversity are core parts of Gallagher Re's business, and they are committed to embracing diverse identities, experiences, and talents to better serve their clients and communities.

What kind of experience is necessary for this position regarding data integration processes?

Candidates should have familiarity with data integration and ETL processes, including data ingestion, transformation, and loading.

Is knowledge of Snowflake essential for this position?

Yes, experience with Snowflake is one of the requirements for this role.

What practices should the Data Architect implement for data modeling?

The Data Architect should implement best practices for data modeling, including normalization, denormalization, indexing, and partitioning strategies.

Does Gallagher Re provide training programs for its employees?

Yes, Gallagher Re offers training programs as part of their benefits.

Gallagher Re

Finance
Industry
10,001+
Employees

Mission & Purpose

The reinsurance landscape is evolving. To compete in a global marketplace, our clients and carriers demand scale and breadth. And we’re rising to meet the challenges ahead. As we welcome Willis Re to the Gallagher Re team, we look forward to driving greater value by combining the knowledge and expertise of our two organisations. The new Gallagher Re is more than just bigger. It’s smarter, faster, and stronger. At Gallagher Re, client advocacy is at the heart of everything we do. We are here to help you face your future with confidence.