Job Title: Lead Databricks Migration ArchitectPosition Overview Play a critical role in a large-scale data warehouse modernization initiative migrating legacy DB2 and Amazon Redshift environments, supported by Informatica and Unix shell scripting, onto Databricks.
This position combines hands-on migration expertise, technical architecture leadership, and strategic influence. You will establish migration approaches, review and approve technical designs, validate deliverables, and drive execution while helping define reusable architectural patterns for future migration waves.
What You'll Do / Key Responsibilities - Establish and document an agreed-upon migration approach and reusable architectural patterns to support subsequent migration waves.
- Review and approve application architectures and data flows before build execution.
- Define technical direction and provide hands-on guidance for large-scale data warehouse modernization and migration.
- Review designs, validate migration deliverables, and ensure alignment with technical strategy and best practices.
- Lead granular technical discussions and communicate clear recommendations on migration strategy and architecture.
- Influence cross-functional partners and drive execution without direct team management authority.
- Take ownership of deliverables and proactively drive migration outcomes.
Required Qualifications - Recent hands-on experience delivering large-scale data warehouse modernization and migrations, with deep technical execution experience.
- Hands-on Databricks experience within the past 1-2 years, including:
- Unity Catalog
- Lakeflow Jobs
- Delta Lake
- SQL Warehouses
- Experience with legacy ETL and orchestration environments, including Informatica, Unix shell scripting, and job schedulers.
- Experience with cross-platform SQL conversion and data reconciliation.
- Strong technical leadership and architecture review capabilities.
- Ability to lead detailed technical conversations, establish client trust, and advocate for technical best practices.
- Proactive ownership, accountability, and ability to drive execution without direct team management authority.
Preferred Qualifications - Direct experience with IBM DB2, Amazon Redshift, or broader AWS data services.
- Domain knowledge in Insurance or Financial Services.
- Hands-on experience with migration accelerators or AI-assisted code conversion tools.