Data Migration Lead, Senior Consultant
About The Position
As a Data Engineer III on Deloitte’s GPS Engineering as a Service team, the Data Migration Lead delivers Appian-based business process solutions that support mission objectives. The role leads the migration of data from a legacy system into the relational database for a new Appian application, owning the migration lifecycle from source-to-target mapping and strategy through ETL coordination, reconciliation, validation, and cutover support. The lead works with architects, Appian developers, analysts, and business subject-matter experts to maintain data quality and completeness and align migration work with the evolving target-state data model. The position also participates in Agile delivery and applies Appian development standards, reusable components, and performance practices to support maintainability and technical quality. The role is part of Deloitte’s Government & Public Services practice and Engineering as a Service offering, which provides end-to-end design, implementation, and technology operations to government and public higher education clients. The position is available in Atlanta, Boston, Philadelphia, Pittsburgh, Rosslyn, Tampa, or Washington, D.C. Travel may average 0–25%, depending on the work and clients served.
Requirements
- Bachelor’s degree.
- Active Public Trust security clearance.
- Must be MarkLogic Certified or able to obtain MarkLogic Certification.
- 5+ years of experience in data migration leadership.
- 3+ years of experience developing detailed source-to-target mappings for data integration and migration initiatives.
- 3+ years of strong hands-on experience with PL/SQL development, including complex queries, stored procedures, functions, and packages.
- 3+ years of experience performing data validation, reconciliation, and defect resolution to ensure data accuracy and completeness.
- 1+ years of experience delivering solutions in Agile/Scrum environments, including sprint planning, stand-ups, reviews, and retrospectives.
- Ability to travel 0–25%, on average, based on the work and the clients and industries/sectors served.
- Legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future.
- Ability to work independently and collaboratively as part of a team.
- Effective written and verbal communication skills.
- Meticulous attention to detail and quality of work product.
- Ability to build and sustain professional relationships.
- Ability to manage and prioritize multiple tasks in a fast-paced, dynamic environment.
- Strong interpersonal skills and professional demeanor.
- Ability to meet deadlines and provide clear guidance to others.
Nice To Haves
- Proficiency designing, developing, testing, and executing ETL processes.
- Experience with Appian or low-code platform migrations.
- Experience with SQL Server, PostgreSQL, or similar relational databases.
- Familiarity with data profiling, cleansing, and cutover planning.
- Strong documentation and stakeholder communication skills.
- Familiarity with Product Lifecycle Management software.
Responsibilities
- Lead migration of data from a legacy system into the relational database supporting a new Appian application.
- Own source-to-target mapping, migration strategy, ETL coordination, reconciliation, validation, and cutover support across the full migration lifecycle.
- Partner with architects, Appian developers, analysts, and business SMEs to ensure data quality, completeness, and alignment to the evolving target-state data model.
- Participate in Agile delivery activities, including sprint planning, daily stand-ups, backlog refinement, and release support.
- Apply Appian development standards, reusable components, and performance practices to support maintainability and technical quality.
- Lead projects or workstreams, provide clear guidance to others, manage multiple tasks, and meet deadlines.
Benefits
- Potential eligibility to participate in a discretionary annual incentive program, subject to program rules and individual and organizational performance.
- Broad range of employee benefits; details are not specified in the posting.
- Opportunities for professional development, including on-the-job learning, formal development programs, leadership opportunities, and mentorship.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
