Role description
Position Summary
The Senior Data Engineer will design, build, and maintain data pipelines and integration frameworks that power analytics, reporting, and underwriting operations for our MGA commercial insurance portfolio. The ideal candidate has at least 5 years of experience working with P&C insurance data, including policy, rating, and bordereaux/mid‑office data flows for MGAs, and is comfortable leading complex data‑mapping and integration initiatives. Preference will be given to candidates with strong experience on Databricks and modern lakehouse architectures.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines and ETL/ELT processes to integrate data from policy admin systems, rating engines, billing, claims, and third‑party data providers.
- Lead end‑to‑end data mapping for MGA commercial lines programs (e.g., GL, Property, Auto, Package, Excess/Umbrella), including source‑to‑target mapping, transformation rules, and data lineage documentation.
- Build and optimize data models and lakehouse structures to support reporting, analytics, and downstream applications (e.g., underwriting workbenches, dashboards, actuarial models).
- Implement best practices for data quality, including validation rules, reconciliation checks, and exception handling for policy, premium, exposure, and claims datasets.
- Collaborate with product, underwriting, and operations teams to translate business requirements into robust data solutions supporting bordereaux, regulatory reporting, and carrier reporting obligations.
- Develop reusable data assets, reference data, and canonical models for MGA programs to enable faster onboarding of new products, carriers, and distribution partners.
- Monitor and troubleshoot production data pipelines; ensure performance, reliability, and adherence to SLAs.
- Contribute to data governance efforts, including metadata management, data cataloging, access controls, and compliance with security/privacy standards.
- Mentor junior data engineers and contribute to coding standards, best practices, and technical design reviews.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or related field (or equivalent experience).
- 5+ years of professional experience in data engineering, with a minimum of 3+ years focused on P&C commercial insurance data.
- Demonstrated experience working with MGAs or delegated authority environments (e.g., carrier, program administrator, or insurtech supporting MGAs).
- Strong expertise in data mapping and integration for policy, billing, and claims systems, including complex source‑to‑target mappings and transformation logic.
- Proficiency in SQL and at least one programming language commonly used for data engineering (e.g., Python, Scala).
- Hands‑on experience with modern data platforms (warehouses or lakehouses), ETL/ELT tools, and workflow orchestration.
- Solid understanding of data modeling (relational and dimensional), performance optimization, and handling large‑scale structured and semi‑structured data.
- Experience working in Agile environments and collaborating with cross‑functional teams (product, engineering, underwriting, analytics).
Skills
Preferred Qualifications
- Strong hands‑on experience with Databricks (Delta Lake, Spark, notebooks, jobs) and related cloud services (e.g., Azure, AWS, or GCP).
- Experience designing and operating a lakehouse architecture to support self‑service analytics and advanced analytics/data science.
- Familiarity with common commercial insurance and MGA data standards (e.g., ACORD, bordereaux structures, carrier reporting schemas).
- Experience integrating with policy administration systems, rating engines, and other insurance core systems.
- Background working with BI tools (e.g., Power BI, Tableau, Looker) and supporting analytics/actuarial teams.
- Exposure to data governance frameworks, data catalog tools, and privacy/security best practices in regulated environments.
Personal Attributes
- Strong analytical and problem‑solving skills with a high attention to detail.
- Ability to work independently while collaborating effectively with distributed teams.
- Clear communicator who can explain complex technical concepts to non‑technical stakeholders.
- Continuous learner who stays current with modern data engineering and cloud technologies.
About RCG Global Services
At Myridius, we transform the way businesses operate. Formerly known as RCG Global Services, our more than 50 years of expertise now drive a new vision—propelling organizations through the rapidly evolving landscapes of technology and business. We offer tailored solutions in AI, data analytics, digital engineering, and cloud innovation, addressing the unique challenges each industry faces. Our integration of cutting-edge technology with deep domain knowledge enables businesses to seize new opportunities, drive significant growth, and maintain a competitive edge in the global market. Our commitment is not just to meet expectations but to exceed them, ensuring measurable impact and fostering sustainable innovation. The success of Myridius is directly tied to the breakthroughs achieved by our clients. Together, we co-create solutions that not only solve today’s challenges but also anticipate future trends. At Myridius, we go beyond typical service delivery. We craft transformative outcomes that help businesses not just adapt, but thrive in a world of continuous change. Discover how Myridius can elevate your business to new heights of innovation. Visit us at www.myridius.com and start leading the change.
