Data Migration Lead, Senior Consultant
About the Role
Join our Deloitte AI & Engineering team to transform technology platforms, drive innovation, and help make a significant impact on our clients' success. You'll work alongside talented professionals reimagining and reengineering operations and processes critical to businesses. Your contributions can help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.
Responsibilities
- Deliver Appian-based business process solutions that support mission objectives.
- Lead migration of data from legacy systems 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.
Qualifications
- 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 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 you do and the clients and industries/sectors you serve
- Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future
Preferred Qualifications
- 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
Pay
For individuals assigned and/or hired to work in Virginia, a reasonable estimate of the compensation range for this role is $131,000 to $218,300. This range takes into account factors such as skill sets, experience, training, licensure, certifications, and organizational needs. Compensation decisions are dependent on the facts and circumstances of each case. You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program.
Skills
- Ability to work independently and collaborate 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 lead projects or workstreams
- Ability to manage and prioritize multiple tasks in a fast-paced and dynamic environment
- Strong interpersonal skills and professional demeanor
- Ability to meet deadlines
- Ability to provide clear guidance to others
The Team
Deloitte's Government & Public Services (GPS) practice is designed for impact. Serving federal, state, & local government clients as well as public higher education institutions, our team of professionals brings fresh perspective to help clients anticipate disruption, reimagine the possible, and fulfill their mission promise. Our Engineering as a Service offering provides end-to-end design, implementation, and technology operations, leveraging our core engineering expertise. We help transform engineering teams, modernize technology, & deliver complex programs with a product engineering mindset. Our flexible delivery models—traditional teams, pools, or pods—are tailored for each client's needs, offering engineering-led Advise, Implement, & Operate capabilities to accelerate innovation.