Data Migration & Power BI Consultant

Saltchuk Marine is looking for an experienced Data Migration & BI Consultant to support our Business Development & Continuous Improvement teams through a critical data infrastructure and systems migration effort. This is a hands-on contract role for someone who can independently extract cleanse transform and migrate data across multiple source systems while also building and maintaining reporting and analytics.

What youll do:

• 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.)

Qualifications:

• Demonstrated experience building validation and reconciliation frameworks a
• 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

Preferred:

• 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

Compensation:Pay for this position will be between $45 and $55 hourly.

Benefits:

• The benefit program includes medical dental and 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

How to Apply:Ready to set sail with Saltchuk Marine Submit your application via our careers page. If you need any assistance please reach out to We look forward to welcoming you aboard.

Drug Free Workplace:Saltchuk Marine is a Drug Free Workplace where post offer applicants and employees are subject to testing for cocaine opioids amphetamines PCP and alcohol when criteria is met as outlined in our policies.

Equal Opportunity Employer:Saltchuk Marine is an Equal Opportunity Employer. Employment decisions are made without regard to race color religion national origin gender sexual orientation gender identity age physical or mental disability genetic factors military/veteran status or other characteristics protected by law.