Data Engineer – Automation-Led Modernization

We are looking for a Senior Data Engineer / Data Architect to lead automation-led modernization of legacy data and reporting platforms at scale.   This role drives operational automation, repeatable architecture, and AI-assisted tooling, eliminating manual work and accelerating delivery across multiple environments. A core focus is leading the migration of data pipelines and integrations from Informatica to Databricks, while building scalable, repeatable patterns used across states and teams.   This is a hands-on, senior role with ownership across architecture, design, and execution.

Responsibilities

• Assess legacy data and reporting workloads to identify where automation replaces manual effort.
• Lead the migration of Informatica-based data workloads to Databricks, ensuring performance, reliability, and data integrity
• Design and execute an automation-first modernization strategy for data pipelines, reporting systems, and analytics platforms.
• Apply tool-assisted and AI-assisted techniques to accelerate modernization while maintaining compliance and control.
• Build repeatable frameworks and patterns for: Data ingestion, transformation, and orchestration; Reporting and analytics modernization; Data validation, reconciliation, and quality controls.
• Establish governance to ensure modernization efforts are consistent, auditable, and scalable.
• Partner with distributed data teams to deploy and scale modernization patterns across environments.
• Provide hands-on technical leadership while remaining engaged in execution.

Required Experience

• 10+ years in data engineering and/or data architecture.
• Proven track record of modernizing large-scale, complex, legacy data and reporting environments.
• Hands-on experience migrating or modernizing Informatica-based data pipelines to modern platforms such as Databricks.
• Demonstrated use of automation frameworks, accelerators, or AI-assisted tools to compress delivery timelines.
• Hands-on experience with Azure, Cloudera, and Power BI.
• Strong experience designing and operating ETL/ELT pipelines and analytics layers.
• Deep understanding of data quality, lineage, reconciliation, and validation frameworks.
• Experience working in large-scale or regulated enterprise environments.

Preferred Experience

• Experience in healthcare, or other regulated domains.
• Experience designing solutions that support multi-environment scalability.
• Exposure to GenAI tooling for code generation and automation.
• Experience as a technical thought leader for new platform initiatives.

McLaren Strategic Solutions is a leading-edge global technology consulting firm, addressing critical challenges across industries such as retail, financial services, and healthcare. Integrating a powerful ecosystem of platforms with capital-efficient execution, McLaren specializes in digital transformation to help businesses optimize operations, accelerate revenue, and achieve scalable outcomes. McLaren’s expertise spans the development of customer-centric applications, modernizing systems for cost-effectiveness and security, and leveraging cloud scalability for future-ready architectures. With a deep commitment to operational excellence, McLaren provides comprehensive managed services, including application maintenance, cybersecurity, platform solutions, and AI-optimized operations, ensuring seamless, secure, and efficient performance.
From supply chain automation to compliance and analytics, McLaren drives measurable impact: improving workforce productivity, reducing inventory costs, and cutting technology ownership expenses. With its emphasis on automation and zero business downtime, McLaren facilitates seamless migrations from legacy systems to modern platforms, enabling organizations to harness the full potential of digital transformation. Backed by strategic partnerships and a proven delivery model, McLaren empowers clients to innovate, modernize, and achieve lasting success in today’s digital economy.
McLaren is a certified minority owned business through the NMSDC and has a mission to place more people from non-traditional backgrounds into sustainable technology careers. Through partnerships with non-profit technology programs in underserved communities and Veteran organizations, candidates transition from tech training programs into real IT careers at McLaren. Our unique recruitment policy allows us to create exceptional teams, bringing a broad spectrum of experience to our company and creating anything but a traditional consulting firm.
Visit McLaren Strategic Solutions to learn more!
Doran Jones Inc. is proud to be part of the McLaren Strategic Ventures Gr