Company: Guy Carpenter

Description:

We are seeking a talented individual to join our Data Engineering team at Guy Carpenter. This role will be based in the New York City office.

As a Re/Insurance Data Engineering and Reporting Lead , you will play a critical role in implementing the target data architecture for the organization, interacting with cross-functional teams to ensure the highest quality, efficiency, reliability, security, and availability of data.

We will count on you to:

1. Lead the data engineering and reporting efforts to migrate our on-premise data assets to the Azure cloud.
2. Oversee technology activities to deliver meaningful, data-driven capabilities aligned with business strategies, optimizing data solutions for scalability, security, and performance.
3. Develop, implement, and deploy data products using Azure Databricks and Power BI to support business intelligence dashboards and reporting needs.
4. Provide subject matter expertise in data processing and exploration leveraging Azure Databricks.
5. Build best-in-class ETL/ELT solutions for effective data ingestion and transformation, implementing and managing DBT workflows to ensure data quality and consistency.
6. Collaborate with stakeholders to design and implement scalable and maintainable data models while ensuring adherence to data governance and compliance standards.
7. Identify and address performance bottlenecks in dashboards, reports, data models and queries. Implement models and strategies to optimize data consumption by business stakeholders.
8. Produce design documentation and be responsible for solution delivery.
9. Define development best practices and standards, enforced through code reviews.

What you need to have:

1. Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
2. 10+ years in the data and analytics space with extensive experience delivering enhanced data and analytics capabilities.
3. 8+ years of hands-on experience designing and implementing data consumption solutions using Azure cloud offerings, including ADLS, Azure Databricks, Azure Synapse, and Power BI.
4. Expertise in modern data architecture patterns and advanced SQL, preferably using DBT or similar tools. Expertise in data modeling for reporting and analytics.
5. 5+ years of experience supporting Power BI reporting as an enterprise platform and working within the reinsurance domain.
6. 5+ years working within the reinsurance domain is necessary for success.
7. Experience migrating on-premises data, reporting, and analytics assets to cloud technologies, along with a solid understanding of DevOps, Git integration, and CI/CD pipelines.

What makes you stand out:

1. Proficiency in Python, Spark, and JSON.
2. Knowledge of information and cloud security.