Senior Data Engineer & Senior Data Engineer (Regulatory and Compliance Reporting Engineer)

Senior Data Engineer (Regulatory and Compliance Reporting Engineer)
Columbia, TN

Job Summary:

We are seeking an experienced Data Engineer to design, develop, and maintain data pipelines that extract transactional insurance data from on-premises Guidewire and legacy systems and deliver to regulatory bodies for compliance. The role requires someone who can work with Guidewire’s complex relational schemas and the external insurance ecosystem, ensuring accurate and timely data delivery to regulatory bodies, risk aggregators, and specialized reinsurers.

Key Responsibilities:

• Design and automate complex downstream extracts like Bordereaux for Hartford Steam Boiler (HSB), CLUE, Current carrier, Verisk and other Insurance services offices.
• Develop and maintain Third Party mandatory industry reports for Verisk, LexisNexis (C.L.U.E) and Current Carrier.
• Develop and maintain Premium/loss and claims datasets, ensuring they reconcile with General ledger (GL).
• Develop and maintain the logic to calculate Written, Earned, and Unearned Premium (UEP) at the transaction level, accounting for mid-term endorsements and cancellations.
• Develop Extracts to match XML/JSON transformation, SFTP automation, and API-based data delivery.
• Develop and maintain data pipelines, ETL/ELT processes, and data integration workflows using Azure Data Factory (ADF), Databricks, and Storage Accounts.
• Provide technical leadership, mentoring, and guidance to team members while contributing as an independent contributor.
• Work in Agile development environments, participating in sprint planning, stand-ups, and retrospectives.
• Ensure data quality, governance, and security standards are maintained across all platforms.

Required Qualifications:

• 10+ years of professional experience in data engineering, data warehouse development, or related roles.
• Knowledge of Datahub/Info Center is highly preferred
• Experienced in developing complex extracts from Guidewire Policy center and billing center to Support Outbound Extracts for industry partners, ensuring compliance with proprietary file formats and transmission protocols
• Insurance industry experience, specifically with policies, quotes, claims, or related domains.
• Strong understanding of P&C insurance lifecycles (submissions, renewals, FNOL, subrogation).
• Strong Hands-on experience with Azure Data Stack:
• ADF (pipelines, orchestration, data flows)
• Storage Accounts
• Key Vaults
• Hands-on experience with Snowflake (SnowSQL, Snowpark, Snow pipe, Streams & Tasks, Dynamic Tables, Cortex AI).
• Experience in Agile development environments.
• Ability to work independently while providing leadership to projects and teams.
• Willingness to relocate or travel as required.