Lead automation-led modernization of legacy data platforms, migrate data pipelines from Informatica to Databricks, and provide hands-on technical leadership.
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 payer, 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 Group.
Top Skills
Azure
Cloudera
Databricks
Informatica
Power BI
Similar Jobs
Cloud • Information Technology • Security • Software • Cybersecurity
The Revenue Enablement Manager will develop programs that enhance enablement offerings, engage stakeholders, and drive field success through strategic collaboration and communication initiatives.
Top Skills:
Ai Tools
Fintech • News + Entertainment • Software • Database • Financial Services
The Product Specialist ensures successful onboarding and implementation of CLO and fund compliance solutions, troubleshooting issues, and driving continuous improvement.
Top Skills:
Excel
.png)
Fintech • Insurance • Machine Learning • Other • Analytics • Financial Services • Automation
The Team Lead will manage a team of Adjusters and Specialists, overseeing claim activities, ensuring optimal outcomes, and handling escalated complaints. They will focus on performance management and development while aligning departmental goals.
Top Skills:
G-Suite ToolsMicrosoft Office Suite
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
