Doran Jones Inc.Remote
Data Engineer – Automation-Led Modernization
United States of America
Full Time
2 weeks ago
H1B Sponsor Likely
Key skills
Data EngineeringData ArchitectureInformatica to Databricks migrationAutomation frameworksAzureClouderaPower BIETL/ELT pipelinesData quality frameworksAI-assisted toolsMulti-environment scalabilityGenAI toolingHealthcare domain experienceAIGenAIETLELTAnalyticsBIDatabricksLeadership
About this role
Doran Jones Inc. is part of the McLaren Strategic Ventures Group, focusing on modernizing legacy data and reporting platforms. The Senior Data Engineer / Data Architect will lead automation-led modernization efforts, driving operational automation and overseeing the migration of data pipelines from Informatica to Databricks.
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
Requirements:
- 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
- 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