Data Migration & Power BI Consultant

Saltchuk Marine•Seattle, WA

About The Position

Saltchuk Marine is seeking an experienced Data Migration & BI Consultant for a part-time, temporary contract role, supporting Business Development & Continuous Improvement teams during a critical data infrastructure and systems migration. This is a hands-on position requiring independent work in extracting, cleansing, transforming, and migrating data, as well as building and maintaining reporting and analytics. The role is expected to last approximately six months, with a maximum of 20 hours per week.

Requirements

Demonstrated experience building validation and reconciliation frameworks.
Strong SQL skills, comfortable writing complex queries for extraction, transformation, and validation against large, messy datasets.
Proficiency with Power BI (DAX, Power Query) or equivalent BI tooling (Tableau).
Working knowledge of Python for data processing/automation.
Solid understanding of data modeling and database design principles.
Strong written documentation skills; able to produce clear, detailed records of data lineage, transformation logic, validation methodology, and reconciliation results that a third party could follow.
Attention to detail and personal ownership of data accuracy end to end.
Excellent communication and teamwork skills.

Nice To Haves

2+ years of hands-on experience with data extraction, cleansing, migration, and reconciliation (ERP/CRM migrations a strong plus).
Experience with ERP systems migrations (e.g., SAP to NetSuite or similar).
Experience with API based data integrations.
Familiarity with cloud platforms (AWS, Azure (Fabric, Onelake), Snowflake).
Experience with source system reconciliation (open balances, GL data, master data cleanup).
Comfortable with fundamental accounting concepts (trial balance, income summary) and general financial/business literacy.

Responsibilities

Extract, cleanse, and migrate data across legacy and target systems (ERP, CRM, and other operational data sources), ensuring accuracy and integrity throughout the migration lifecycle.
Write and optimize SQL for data extraction, transformation, and validation against complex datasets. Building in repeatable validation queries/checks.
Reconcile migrated data against source-of-truth records (row counts, control totals, key balances, master data), identify and resolve discrepancies, and formally sign off on data accuracy before go-live milestones.
Document data validation and reconciliation processes thoroughly. Including source-to-target mappings, transformation logic, validation criteria, known exceptions, and sign-off records so the process is auditable and repeatable by others.
Design, build, and maintain ETL/ELT pipelines to move and transform data between source systems, staging environments, and reporting layers.
Build and maintain Power BI dashboards and data visualizations (DAX, Power Query/M) for Financial Analysts, Operations, and other business stakeholders.
Collaborate with cross functional stakeholders to gather requirements and confirm reconciliation results are understood and accepted by business owners.
Identify and implement process improvements within the data pipeline and Shared Services data workflows.
Use Python for scripting, automation, and data processing tasks as needed (pandas, API integrations, etc.).

Benefits

Medical coverage for you and your family.
Dental coverage for you and your family.
Vision coverage for you and your family.
Life insurance equal to two times annual base salary.
Accidental death and dismemberment insurance.
Long term disability insurance.
401k program with a 4% match, vested immediately.
Employee Assistance Program.
Flexible Spending Accounts.
Business travel assistance program.
Other voluntary benefits are available for purchase via payroll deduction at group rates.
Fully paid ORCA transportation card.
Tuition reimbursement.
All other benefits as required by law.