Data Engineering and Reporting Lead

Re/Insurance Data Engineering and Reporting Lead

JOB 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, NY OR Norwalk, CT OR Princeton, NJ 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.

RESPONSIBILITIES:

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

QUALIFICATIONS:

• Bachelor\'s or Master\'s degree in Computer Science, Engineering, or a related field.
• 10 years in the data and analytics space with extensive experience delivering enhanced data and analytics capabilities.
• 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.
• Expertise in modern data architecture patterns and advanced SQL, preferably using DBT or similar tools. Expertise in data modeling for reporting and analytics.
• 5 years of experience supporting Power BI reporting as an enterprise platform and working within the reinsurance domain.
• 5 years working within the reinsurance domain is necessary for success.
• 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: ADDITIONAL QUALIFICATIONS:

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

EOE:

Our client is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind: We are committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at our client are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. We will not tolerate discrimination or harassment based on any of these characteristics