Jobs and Careers

Enterprise Data Migration Lead

United Statesfull_timeVerifiedPosted 30 Sept 2025

About the role

Role: Enterprise Data Migration Lead
Duration: 7 Months (Contract) W2
Location: Milwaukie, OR (Hybrid)

Key Skills:

Data Migration & ETL Expertise – mapping, cleansing, transforming, and loading data from legacy systems to modern platforms.
Data Governance & Quality Management – ensuring data completeness, accuracy, timeliness, consistency, and conformance to standards.
SQL & Reporting Development – writing, optimizing, and validating queries/reports; experience with reporting tools.
Data Modeling & Schema Mapping – designing data dictionaries, field-level mapping, source-of-truth identification, and schema alignment.
Risk & Compliance Awareness – applying security best practices, disaster recovery, and business continuity planning.
Project Management & Documentation – maintaining unified data inventory, producing weekly migration reports, and developing procedural documentation.
Stakeholder Facilitation – working with agency staff, vendors, contractors, and external partners to prioritize, validate, and deliver data solutions.
Testing & Validation – building and executing data testing plans, involving stakeholders, and validating migrated datasets.

Description
Research and properly evaluate sources of information to determine possible limitations in reliability or usability, Apply sampling techniques to effectively determine and define ideal categories to be questioned, Compare and analyze provided statistical information to identify patterns, relationships and problems. Define and utilize statistical methods to solve industry-specific problems in varying fields, such as economics and engineering.
Prepare detailed reports for management and other departments by analyzing and interpreting data. Train assistants and other members of the team how to properly organize findings and read data collected, Design computer code using various languages to improve and update software and applications Bachelor's degree in mathematics, statistics, computer science or related field, Strong math and analytical skills are essential to complete job requirements successfully, Able to compile and organize statistical information retrieved and present findings to management, Strong computer skills and ability to use necessary databases and software

The Data Migration Facilitator will be responsible for the following tasks:

Implementing security approaches and apply best practices for data consistency across multiple applications within the Enterprise Modernization Program addressing disaster recover and business continuity.
Lead efforts with the Agency staff, licensees, and contracted liquor store agents to identify reports and/or queries needed from the DSSC project and the data lake/mart. Develop a finalized document containing the list of reports, what data fields are needed and prioritization of each report (must, could, nice to have). Prioritization will be used to determine the urgency and schedule to roll out reports.
Evaluate for adoption the effectiveness of proposed queries/reports and make decisions using best practices to modify or combine reports or queries for solution optimization and performance.
Maintain and update the unified data matrix also known as data inventory analysis document on an iterative basis to support DSSC project implementation. The data inventory analysis document must include a data map of the existing data sets associated with the DSSC, measurement of the quality/integrity of the data sets, as well as recommendations for data migration from various legacy sources.
For the Enterprise Modernization Program and DSSC project, facilitates the planning and development of field level mapping efforts with Agency staff, solution vendor, professional services vendor, Enterprise Information Services staff, and contracted liquor store agents to identify field level detail information for each data field. To include identifying the source of truth for