NPAworldwide · 1 day ago
Senior ETL/Data Migration Consultant
Seattle, WA
Full-time
Onsite
Senior LevelNPAworld is a non-profit organization that focuses on making a difference in people's lives. They are seeking a Senior ETL/Data Migration Consultant to lead a major data migration project, involving data extraction and transformation from JDE to SQL Server, while ensuring data integrity and accuracy throughout the process.
Human ResourcesRecruiting
Responsibilities
Lead the data conversion and cleaning process, converting existing data in JD Edwards Enterprise one into Dayforce format to move data from JDE1 to Dayforce
Work closely with the internal and external colleagues/partners to understand current data structures, formats, and content
Clean and preprocess data by handing errors, duplicate and inconsistencies
Ensure data integrity and accuracy throughout the migration process
Analyze and interpret large datasets to identify patterns, trends, and inconsistencies
Develop understanding of the external partner's data requirements
Ability to load converted data into the targeted system
Develop and maintain Extract, Transform & Load (ETL) processes for continuous data migration
Collaborate with IT Team members, partners & other stakeholders to assist with resolving issues and to ensure successful data migrations
Provide/communicate updates, concerns, and recommendations
Document data conversion processes, mappings, and transformation rules, which is crucial for auditability and future reference
Share knowledge, best practices, and suggest future improvements and knows the best practices in data migration and SQL
Qualification
Required
Should be skilled in T-SQL and SSIS (SQL Server Integration Services)
Lead the data conversion and cleaning process, converting existing data in JD Edwards Enterprise one into Dayforce format to move data from JDE1 to Dayforce. This could be any data conversion experience
Work closely with the internal and external colleagues/partners to understand current data structures, formats, and content
Clean and preprocess data by handing errors, duplicate and inconsistencies
Ensure data integrity and accuracy throughout the migration process
Analyze and interpret large datasets to identify patterns, trends, and inconsistencies
Develop understanding of the external partner's data requirements
Ability to load converted data into the targeted system
Develop and maintain Extract, Transform & Load (ETL) processes for continuous data migration
Collaborate with IT Team members, partners & other stakeholders to assist with resolving issues and to ensure successful data migrations
Provide/communicate updates, concerns, and recommendations
Document data conversion processes, mappings, and transformation rules, which is crucial for auditability and future reference
Share knowledge, best practices, and suggest future improvements and knows the best practices in data migration and SQL
Preferred
HRIS project experience is highly preferred
Company
NPAworldwide
NPAworldwide is a global recruiting network that facilitates placements that result in split fees.
Founded in 1956
2-10 employees
Funding
Current Stage
Early StageRecent News
Company data provided by crunchbase