Data Migration SME

Kearney & Company • UNAVAILABLE, UNAVAILABLE

3d

About The Position

Kearney & Company is seeking a Data Migration SME to join our growing firm! This individual will collaborate with a team focused on developing and executing data cleansing, data analysis, architecture, and data conversion.

Requirements

• Bachelor’s degree in a related field and 11+ years of relevant experience OR Master’s degree in a related field with a minimum of 3 years of relevant experience
• Experience analyzing financial and procurement data.
• Demonstrated proficiency to write, run, and interpret SQL queries.
• Experience performing ETL processes and data transformation.
• Experience working with data schemas and models
• Experienced with data migration phases and/or data management concepts
• Demonstrated critical thinking ability
• Excellent verbal and written communication skills
• Ability to obtain a U.S. Agency Suitability clearance (requires US Citizenship)

Nice To Haves

• Masters degree in related field and 6+ years of relevant experience
• Experience supporting a federal financial system migration/implementation program.
• Experience with performing multiple ETL processes and data migrations
• Ability to document complex technical processes and data flows clearly and concisely.
• Proficient knowledge of financial systems and their feeder systems, including data flow and integration points.
• Experience in developing data management strategies and plans
• Expertise in testing data mapping, performing data validation, and identifying discrepancies.

Responsibilities

• Use SQL to assess, reconcile, map and extract, transform, and load (ETL) financial and procurement data including master and transactional datasets from legacy systems to the future state solution
• Participate in multiple mock data conversions, testing scripts based on business rules, applying crosswalks, completing data conversion templates, and reconciling records.
• Perform crosswalks and reconciliations of financial data elements between legacy and target systems
• Perform comprehensive business analysis and process and data modeling using both manual and automated tools for financial and procurement functions. This includes analyzing master data, metadata, transactional data, and interface data.
• Provide technical guidance in data management, including data architecture, analytics/reporting, quality, cleansing, and conversion from legacy systems to the new solution.
• Recommend data fixes, promote cleansed data through test cycles, and support the final cutover.
• Acts independently to uncover and resolve issues associated with the data reconciliations and mapping, data cleansing, conversion testing, and/or data migration.
• Develops dashboards to enable further data analysis, reconciliations and data-driven decisions
• Support various data management-related requests and working groups as needed.
• Gather lessons learned from each project phase and actively apply them in future endeavors.

Benefits

• Medical, Dental, Vision, Life, AD&D, and Disability Insurance
• 401(k) Retirement Plan and 529 Education Savings Plan
• Flexible Spending & Health Savings Account
• Accident, Critical Illness, Hospital Indemnity Insurances
• Legal Insurance and Pet Insurance
• Employee Assistance Program, fitness and wellness benefits, and other firm benefits.
• Paid holidays, vacation, and sick time

What This Job Offers

• Job Type: Full-time
• Career Level: Senior