Data Migration Lead, Senior Consultant

PowerToFly; Washington (District of Columbia); On-site; USD 131,000 - 218,000; Full time

Job summary

Deloitte's GPS Engineering team seeks a Data Engineer III to drive Appian-based data migration solutions, leading data mapping, ETL coordination, and validation across migration lifecycles. You will collaborate with architects, Appian developers, analysts, and business SMEs to ensure data quality and alignment with the evolving target model.

The role requires a Bachelor’s degree, active Public Trust clearance, and 5+ years in data migration leadership, plus hands-on PL/SQL, SQL Server, and

Qualifications

• Bachelor's degree required
• Active Public Trust security clearance required
• Must be MarkLogic Certified or able to obtain MarkLogic Certification
• 5+ years of experience in data migration leadership
• 3+ years of experience creating detailed source-to-target mappings for data integration and migration
• 3+ years of 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
• Ability to travel 0-25%, based on client engagement
• Must be legally authorized to work in the United States without sponsorship

Responsibilities

• Lead migration of data from 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 and alignment to the 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 quality

Skills

Data migration

PL/SQL

Data validation

Agile/Scrum

Appian

Public Trust

Security clearance

Travel 0-25%

Education

Bachelor's degree

Tools

MarkLogic

SQL Server

PostgreSQL

Appian

Job description

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 that are critical to businesses. Your contributions can help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.

Work you'll do

As a Data Engineer III on the GPS Engineering as a Service team, you will be responsible for delivering Appian-based business process solutions that support mission objectives.

• Lead migration of data from 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.

A successful candidate would possess these 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 workstreamsAbility 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 - our people, ideas, technology and outcomes - 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.

Qualifications

Required:

• Bachelor's degree
• Active Public Trust security clearance
• Must be MarkLogic Certified or able to obtain MarkLogic Certification.
• 5+ years of experience data migration leadership
• 3+ years of experience developing detailed source-to-target mappings for data integration and migration initiatives.
• 3+ years of experience with 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 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:

• 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

For individuals assigned and/or hired to work in Virginia, Deloitte is required by law to include a reasonable estimate of the compensation range for this role. This compensation range is specific to Virginia and takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. At Deloitte, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $131,000 to $218,300.

You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.