QUANTALEAP ยท 1 month ago
Data Migration Specialist
Richmond, VA, VA
Full-time, Contract
Hybrid
Mid LevelQUANTALEAP is seeking a Data Migration Specialist who will be responsible for transforming and loading data into the data warehouse for a modernization initiative. The role involves troubleshooting data migration issues, collaborating with stakeholders, and ensuring data consistency and compliance throughout the migration process.
Information Technology & Services
Responsibilities
Transform and load data into the respective data warehouse for a modernization initiative
Transform data to meet target system requirements
Translate functional requirements into technical specifications for ETL development
Troubleshoot and resolve data migration issues
Validate and analyze data sets to ensure data consistency and internal requirements are met
Analyze DBDHS Legacy data, data quality rules, business rules, data dictionaries
Analyze, prepare and execute data cleansing services
Analyze, specify and document data migration requirements with clients and internal teams
Articulate how Legacy data will be cleansed and adapted to fit into the new Future solution
Assist others with the selection of approaches, methods and / or services as required
Attend Project stand-ups and Stakeholder meetings
Champion standards and implementation process that you define with the team
Collaborate with data architects to design data migration solutions
Collaborate with the IMS Business customers and the DBHDS EDW Team, ensuring quicker and more accurate data management
Complete assigned tasks in an organized manner to ensure project deadlines
Develop and execute data migration process and procedures (from analysis to post implementation) including scripts and programs
Develop and execute test plans to ensure client requirements are fulfilled
Contribute to the release and cutover strategy
Coordinate with stakeholders to gather requirements and system assessments as it related to data
Create and maintain utilities, SQL scripts as needed to accelerate the process
Ensure adherence to compliance needs for the agency
Implement new Mapping and ETL scripts
Lead data cleaning and dedupe program to drive accurate and complete data
Maintain appropriate levels of data security and privacy relating to customer data
Ensure documentation are created an maintained to enable migration process and post implementation support
Create and Monitor data migration progress and build dashboards to support audit , reconciliation and verification
Perform regular backups to ensure data preservation
Propose a data migration and reconciliation strategy
Represent DBHDS IT and the Data cleansing/migration initiative at meetups with DBHDS internal and external partners
Retrieve data from the database or electronic files as requested
Validate post-migration results and communicate outcome with Key DBHDS Central Office Leadership and Business Stakeholders, Key External DBHDS Reporting Stakeholders, CO Security, VITA, and DBHDS IT
Verify data by comparing it to source documents
Write validation scripts to run over the Staging tables to report any invalid data
Qualification
Required
Experience in transforming and loading data into data warehouses
Ability to transform data to meet target system requirements
Experience in translating functional requirements into technical specifications for ETL development
Proven troubleshooting skills to resolve data migration issues
Experience in validating and analyzing data sets for consistency and compliance
Ability to analyze legacy data, data quality rules, business rules, and data dictionaries
Experience in data cleansing services
Ability to specify and document data migration requirements
Experience in articulating data cleansing and adaptation strategies
Ability to assist in selecting approaches and methods for data migration
Experience attending project stand-ups and stakeholder meetings
Ability to champion standards and implementation processes
Experience collaborating with data architects on migration solutions
Ability to collaborate with business customers and data teams for data management
Strong organizational skills to complete tasks and meet project deadlines
Experience developing and executing data migration processes and procedures
Ability to develop and execute test plans for client requirements
Experience contributing to release and cutover strategies
Ability to coordinate with stakeholders for requirements and assessments
Experience creating and maintaining SQL scripts and utilities
Knowledge of compliance needs for data management
Experience implementing new mapping and ETL scripts
Ability to lead data cleaning and deduplication programs
Experience maintaining data security and privacy
Ability to create and maintain documentation for migration processes
Experience monitoring data migration progress and building dashboards
Ability to perform regular backups for data preservation
Experience proposing data migration and reconciliation strategies
Ability to represent IT and data initiatives at meetups
Experience retrieving data from databases or electronic files
Ability to validate post-migration results and communicate outcomes
Experience verifying data by comparing it to source documents
Ability to write validation scripts for staging tables
Company
QUANTALEAP
Quantaleap empowers Enterprises with cutting-edge AI solutions that drive measurable impact and long-term value.
Founded in 2023
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase