• The Senior Data Engineer designs, builds and maintains the data ingestion and transformation pipelines that populate Inchcape’s central data platforms. • This role ingests raw data from diverse systems, curates the bronze and silver layers of the medallion architecture, ensures data quality and performance, and delivers reliable, reusable datasets for modelling, analysis, reporting and BI. • Develop and maintain ETL/ELT pipelines to ingest data from ERP, CRM, operational, financial, and third‑party sources into the Microsoft Fabric Platform - Lakehouse (OneLake) using Delta Lake/Parquet. • Implement data quality standards and controls, incremental loading, CDC and error handling to ensure reliability and correctness. • Create bronze tables, curated Silver and gold tables by transforming, cleansing and conforming raw data, document lineage and transformations. • Optimise performance through partitioning, clustering and tuning of MS Fabric, SQL and Spark workloads, monitor pipeline health and costs. • Collaborate with Data Architects, Modellers and Data BAs to design schemas, naming conventions and integration patterns to ensure business self-service enablement through Gold data. • Build reusable components, templates and automation scripts using Fabric Dataflows Gen2, Spark notebooks or equivalent tools. • Maintain metadata and sensitivity labels via Purview, ensure proper access controls and compliance. • Research and evaluate new features and patterns in Microsoft Fabric and make recommendations for adoption, enabling an AI-driven data strategy. • Ensure NFR requirements like resilience, availability and security standards are applied as per agreed NFR metrics.

• Design, deploy, and scale large-scale ML and data processing pipelines across cloud infrastructure • Build systems to ingest, process, and serve 250,000+ hours of multimodal data (video, audio, metadata) • Architect and optimize GPU-based compute environments (e.g., NVIDIA Tesla clusters) for distributed training and inference • Develop high-throughput backend systems for video ingestion from desktop and mobile platforms • Implement distributed processing workflows, including job scheduling, fault tolerance, and resource allocation • Design and build human-in-the-loop and automated annotation systems to ensure data quality and scalability • Translate ML and multimodal research into scalable, production-grade cloud architectures • Optimize pipelines for performance, reliability, and cost efficiency across compute, storage, and networking layers • Collaborate with ML, data, and engineering teams to deliver end-to-end data workflows.

• Design, develop, and maintain databases supporting IVR and contact center systems • Support databases used by both runtime IVR services and analytics platforms • Design and maintain relational data models for IVR event, routing, and call data • Write, maintain, and optimize SQL for application logic, configuration changes, and investigations • Ensure database availability, integrity, performance, and scalability in production environments • Support storage and availability of IVR event logs, call lifecycle data, and routing outcomes for analytics and reporting • Monitor and troubleshoot production databases and support incident investigations • Collaborate with architects, application developers, DevOps, QA, and Analytics teams on platform changes and improvements

Role Description The Complex Data Exchange Specialist is responsible for managing the overall process, practice, and project implementation of electronic data interfaces with New York Life clients in support of Life, Accident, Disability, Family Medical Leave products, and various service offerings, with a strong focus on National Accounts and highly complex data integrations. This role serves as both a technical and consultative resource, ensuring high-quality data exchange while educating clients on how their data powers downstream services including administration, billing, eligibility, enrollment, and reporting. The Specialist understands how data flows through New York Life systems—from file receipt and validation to internal processing and operational impact—and proactively advises clients and TPAs on how data structure, file dependencies, and transmission timing affect service delivery and administration outcomes. They balance New York Life standards regarding layout, data integrity, and transmission protocols with client requirements to deliver compliant, scalable, and efficient solutions. The Complex Data Exchange Specialist manages multi-file data environments where multiple client files must be validated, sequenced, reconciled, and merged in order to support accurate system ingestion. These integrations often involve complex file structures, dependent file relationships, and conditional data mapping logic, requiring advanced technical expertise in file architecture, merge capabilities, and data validation. This role also drives inventory control of active interfaces and milestone management in partnership with internal and external stakeholders. The Specialist demonstrates strong analytical capabilities to audit incoming files across multiple data sources, identify discrepancies or systemic errors, and implement corrective actions that improve data integrity and client experience. The Complex Data Exchange Specialist partners closely with Implementation IT, Family Medical Leave Operations, Account Management, and external Ben Tech vendors to ensure deadlines are met, key milestones are achieved, and implementation efforts stay aligned with business objectives. Because this role supports large National Accounts and marquee clients, it requires the ability to manage high-volume, complex integrations with multiple vendors, benefit programs, and file dependencies. The Specialist must proactively assess data risk, ensure data governance standards are met, and maintain operational stability across interconnected systems. Additionally, they act as a leader among peers by proactively contributing expertise, mentoring team members, taking on complex work, driving process improvements, and independently leading projects and training initiatives. Qualifications - Bachelor’s Degree strongly preferred or minimum of 3 years relevant work experience required. - Prior experience working with clients, producers, TPAs, or Ben Tech partners preferred. - Strong understanding of complex data structures, file layouts, and electronic transmission methods preferred. - Demonstrated ability to analyze, audit, and interpret complex and high-volume data files, including multi-file data environments. - Experience managing file dependencies, merge logic, and reconciliation across multiple data sources preferred. - Strong planning, project management, and inventory control skills. - Proficient/advanced Microsoft Excel skills required (VLOOKUP, Pivot Tables, Macros). - Proficiency in Access preferred. - Experience with mainframe TSO and JCL scripting preferred. - Excellent organizational skills with ability to manage multiple complex implementations simultaneously and meet tight deadlines. - Excellent written and verbal communication skills with the ability to explain technical concepts to non-technical audiences. - Strong interpersonal and consultative skills. - Demonstrated ability to drive results and meet key milestones. - Ability to work independently while collaborating effectively across internal business partners. - Demonstrated leadership capability in a fast-paced, evolving environment. - Proven adaptability and willingness to embrace change and continuously improve processes. Requirements - Integrate with TPAs and Ben Tech partners in support of eligibility, enrollment, remittance, and billing data for new and inforce business. - Serve as a consultative partner to clients and TPAs by educating them on data structure, file specifications, and the operational impact of their data across downstream administration systems. - Implement complex electronic interfaces based on established timelines while maintaining strict inventory control of active integrations, dependent file streams, and in-flight implementations. - Manage multi-file integration environments, ensuring files are received, validated, and sequenced appropriately for system ingestion and downstream processing. - Review, audit, and validate test data across multiple related files and data sources to ensure quality, completeness, and alignment with business rules prior to production implementation. - Identify root causes of file discrepancies, mapping errors, transmission issues, or data inconsistencies across merged files, and recommend corrective actions. - Understand and articulate end-to-end data flow, including how files are received, validated, transformed, merged across multiple sources, and processed within New York Life systems. - Balance New York Life/LDEX standards regarding layout, data, and transmission protocols with client requirements, delivering compliant and scalable solutions for complex client environments. - Prepare and maintain documentation confirming the method of data exchange between New York Life and client/TPA, including file dependencies, mapping logic, merge requirements, and audit controls. - Partner with Production Support and IT to ensure successful receipt, mapping, merging, and processing of data. - Articulate complex file mapping and merge logic requirements clearly to IT and technical partners. - Drive accountability with internal teams and Ben Tech partners to meet key deliverables and milestone deadlines. - Troubleshoot and diagnose issues related to electronic data exchange, multi-file integrations, and system processing impacts. - Track file status and ensure metrics are reported accurately within Salesforce. - Develop and maintain support documentation, SOPs, and training materials for complex integration processes and data governance practices. - Proactively review and suggest improvements to existing procedures to enhance efficiency, data integrity, and scalability of complex integrations. - Serve as a subject matter expert for complex data exchange implementations and National Account integrations, providing guidance and mentorship to peers. Benefits - We provide a full package of benefits for employees – and have unique offerings for a modern workforce, including leave programs, adoption assistance, and student loan repayment programs. - Based on feedback from our employees, we continue to refine and add benefits to our offering, so that you can flourish both inside and outside of work.