Data and Analytics Engineering Lead, Reinsurance

Internationalinsuranceprofessionals; Connecticut; Hybrid; USD 139,000 - 278,000; Full time

Benefits offered by this job

Health benefits

401K

Tuition assistance

Job summary

Marsh is seeking a Data and Analytics Engineering Lead to design, develop, and deploy enterprise-scale analytics solutions across the organization. You will architect scalable BI environments, lead cross-functional collaboration, and ensure governance, security, and performance in data pipelines and dashboards.

You will work with Azure Data Lake, Databricks, DBT, and Power BI, delivering data-driven insights for reinsurance stakeholders.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, Engineering or related field.
• 5+ years of experience in the reinsurance domain and understanding of its data/reporting needs.
• 10+ years of experience in data analytics with proven delivery of enhanced data and analytics capabilities.
• Expertise in designing and implementing enterprise Power BI solutions, including data modeling, DAX, Power Query, and visualization best practices.
• Strong knowledge of cloud data platforms such as Azure Data Lake, Azure Synapse Analytics, Databricks, DBT and integration with Power BI.
• Familiarity with data governance, security, and compliance standards for enterprise reporting.
• Excellent problem-solving skills and ability to troubleshoot complex data issues.
• Strong communication skills and collaboration with cross-functional teams.

Responsibilities

• Lead the design and implementation of enterprise BI architecture, including data models, dashboards, reports, and data gateways.
• Translate business requirements into scalable BI solutions with data modeling, DAX, and visualization best practices.
• Provide subject matter expertise in Reinsurance data analytics.
• Architect and oversee integration of Power BI with Azure Data Lake, Databricks, and other data platforms.
• Define analytic solutions leveraging Databricks, DBT and Power BI.
• Develop and enforce governance and security standards across reports and dashboards.
• Support deployment of Power BI in enterprise environments with data refresh, security roles, and governance.
• Identify and address performance bottlenecks in data pipelines and queries to reduce latency.
• Optimize Power BI performance through modeling, querying, and report design best practices.
• Produce design documentation, deployment plans, and user guides.
• Stay current with Power BI innovations and industry best practices.

Skills

DAX

Power BI

Data modeling

Power Query

Azure Databricks

Education

Bachelor's or Master's in CS/IS/Engineering

Tools

Power BI

Azure Data Lake Storage

Databricks

DBT

Azure Synapse Analytics

Job description

As Data and Analytics Engineering Lead within our Reinsurance Data and Analytics team, you will be instrumental in designing, developing, and deploying enterprise-scale Analytics solutions that enable data-driven decision-making across the organization. You will collaborate with cross-functional teams to architect scalable, secure, and high-performance analytic environments, ensuring alignment with business needs and data governance standards.

We will count on you to:

• Lead the design and implementation of enterprise BI architecture, including data models, dashboards, reports, and data gateways, ensuring optimal performance, usability, and security.
• Collaborate with data engineers, analysts, and stakeholders to translate business requirements into scalable BI solutions, including data modeling, DAX calculations, and visualization best practices. Ensure adherence to data governance and compliance standards in data modeling and architecture
• Provide subject matter expertise in the Reinsurance domain for data analytics.
• Architect and oversee the integration of Power BI with various data sources, including Azure Data Lake Storage, Databricks, and other cloud or on-premise data platforms.
• Define analytic solution leveraging Databricks, DBT and Power BI.
• Develop and enforce development standards, governance policies, and best practices to ensure consistency, security, and maintainability across all reports and dashboards.
• Support the deployment of Power BI in enterprise environments, including managing data refresh schedules, security roles, and workspace governance.
• Identify and address performance bottlenecks in data pipelines and queries. Implement strategies to optimize data processing and reduce latency in data delivery
• Optimize Power BI performance by implementing best practices in data modeling, query optimization, and report design.
• Produce comprehensive design documentation, deployment plans, and user guides.
• Stay current with Power BI innovations and industry best practices, recommending improvements to enhance reporting capabilities.

What you need to have:

• Bachelor's or Master's degree in Computer Science, Information Systems, Engineering or a related field.
• 5+ years of experience working within the reinsurance domain, understanding its data and reporting needs.
• 10+ years of experience in data analytics, with extensive experience delivering enhanced data and analytical capabilities.
• Proven expertise in designing and implementing enterprise Power BI solutions, including data modeling, DAX, Power Query, and visualization best practices.
• Strong knowledge of cloud data platforms such as Azure Data Lake, Azure Synapse Analytics, Databricks, DBT and integration with Power BI.
• Familiarity with data governance, security, and compliance standards related to enterprise reporting.
• Excellent problem-solving skills and the ability to troubleshoot complex data issues.
• Strong communication skills and the ability to collaborate effectively with cross-functional teams.

What makes you stand out:

• Proficiency in DAX, Power BI Service, Power BI Embedded, and Power BI REST APIs.
• Leveraging AI to enabling Ad Hoc and Self Serve BI capabilities
• Knowledge of Python, R, or other scripting languages to enhance Power BI capabilities.
• Understanding of information security, data privacy, and cloud security best practices.
• Strong communication skills to collaborate with technical and non-technical stakeholders.

Why join our team:

• We help you be your best through professional development opportunities, interesting work and supportive leaders.
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being.

Marsh (NYSE: MRSH) is a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information, visit marsh.com, or follow us on LinkedIn and X.

Marsh is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, veteran status (including protected veterans), or any other characteristic protected by applicable law. If you have a need that requires accommodation, please let us know by contacting [e-mail].

Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one "anchor day" per week on which their full team will be together in person.

The applicable base salary range for this role is $139,000 to $277,900.

The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other retirement programs as well as employee assistance programs.