Data Architect /Data Migration Facilitator

Job Description

Job Description Location Milwaukie, Oregon Job Description

Position: Data Migration Facilitator
Location Requirement: Candidate must be within 100 miles of OLCC Headquarters and report onsite at least one day per week.

Overview

The Data Migration Facilitator will play a key role in the Enterprise Modernization Program and DSSC project, ensuring accurate, secure, and efficient migration of legacy data into new enterprise systems. The role requires strong analytical skills, experience with data integrity practices, and the ability to coordinate across agency staff, vendors, and external stakeholders.

Key Responsibilities

• Implement data security approaches and best practices to ensure data consistency, integrity, and business continuity across multiple applications.

• Collaborate with agency staff, licensees, and contracted liquor store agents to identify required reports/queries, prioritize them, and document data fields needed.

• Evaluate proposed queries/reports, optimize or combine for performance and efficiency.

• Maintain and update the data inventory analysis document (unified data matrix), including data mapping, quality measurement, and migration recommendations.

• Facilitate planning and development of field-level data mapping across legacy systems, defining sources of truth and mapping to future-state schema for cleansing, transformation, extraction, and loading.

• Research and assess data quality dimensions—completeness, uniqueness, timeliness, validity, accuracy, and consistency—ensuring conformance to design standards.

• Lead stakeholder meetings to determine which data should be migrated, establish priorities, and design data models accordingly.

• Provide weekly migration status reports, highlighting gaps, risks, and mitigation strategies to prevent project delays.

• Develop and execute a data testing plan, involving stakeholders in pre-migration testing.

• Identify data-related risks that may impact overall system performance and recommend design or process changes.

• Document procedures, standards, and policies for data migration through facilitated workshops with OLCC subject matter experts, vendors, and contracted agents.

• Create and maintain a data dictionary bridging legacy databases and new system schemas.

• Analyze data usage, reporting, integrity, and security to design and establish the data lake/mart, ensuring compatibility across modernization projects.

• Facilitate cross-team meetings to address migration challenges and ensure alignment across ongoing modernization efforts.

Qualifications

• Bachelor’s degree in Mathematics, Statistics, Computer Science, or related field.

• Strong mathematical and analytical skills with the ability to interpret and apply statistical methods to solve industry problems.

• Hands-on experience with data migration, analysis, and reporting.

• Strong computer skills with proficiency in databases, reporting tools, and programming languages for automation or optimization.

• Ability to compile, organize, and present complex statistical/data findings to stakeholders and management.

• Excellent communication skills to train and guide team members in interpreting data and organizing findings.

Required Skills

• Database:

  • Data Analysis – Proficient (4–6 Years)

  • MySQL – Novice (1–3 Years)

• Languages:

  • JSON – Proficient (4–6 Years)

  • SQL – Proficient (4–6 Years)

• Others:

  • Communication skills (verbal & written) – Advanced (7–9 Years)

  • Learning ability – Advanced (7–9 Years)

  • Teamwork – Advanced (7–9 Years)

Desired (Not Required) Skills

• Database:

  • ADO.NET – Novice (1–3 Years)

  • Data Modeling – Proficient (4–6 Years)

  • Data Warehousing – Novice (1–3 Years)

  • DBA – Novice (1–3 Years)

  • Microsoft SQL Server – Proficient (4–6 Years)

  • PostgreSQL – Novice (1–3 Years)

• Operating Systems:

  • Linux – Novice (1–3 Years)

• Others:

  • Integration planning and strategy – Novice (1–3 Years)

  • Presentation skills – Proficient (4–6 Years)

• Tools:

  • Crystal Reports – Novice (1–3 Years)

  • Microsoft Office – Proficient (4–6 Years)

  • Sybase PowerBuilder – Novice (1–3 Years)

InstantServe is Proud to be an EOE and will consider all applications without regard to race, genetic information, sex, age, color, religion, national origin, veteran status, disability, or any other characteristic protected by law. Applicants with disabilities that require accommodation or assistance in a position please call 202-701-1667 or email contact@iserveworld.com. This is a dedicated line designed exclusively to assist job seekers whose disability prevents them from being able to apply online.