Senior Data Analyst

Our client, based in Langley, BC, is seeking a Senior Data Analyst (Data Warehouse & Integration) for an approximately 5-month contract engagement (30 hours/week). Due to the collaborative nature of the project, preference will be given to candidates located in the Lower Mainland who can work closely with internal Finance, Operations, and IT teams, as well as external Sage consultants. This is a highly technical role focused on data mapping, data transformation, integration, cleansing, and warehousing activities across multiple source systems rather than traditional reporting or dashboard development. Responsibilities Analyze and map data from multiple enterprise systems, including financial, operational, HR, fleet management, dispatch, and other business platforms. Work with Finance, Operations, and IT stakeholders to understand source system data structures and business requirements. Perform source-to-target data mapping and define transformation rules for warehouse integration. Cleanse, validate, and reconcile data to ensure accuracy, consistency, and completeness. Support the integration of flat-file, database, and API-based data sources into the enterprise data warehouse. Execute data transformation and validation activities using SQL and related tools. Collaborate with Sage consultants and implementation partners to support data onboarding into Sage Enterprise Intelligence. Identify and resolve data quality, data consistency, and integration issues. Assist with data migration, testing, reconciliation, and user acceptance activities. Document data flows, mapping specifications, transformation logic, and integration requirements. Support the continued onboarding of new data sources into the enterprise analytics environment. Required Qualifications 7+ years of experience in Data Analysis, Data Warehousing, Data Integration, ETL, or related disciplines. Proven experience working with enterprise data warehouse initiatives and large-scale data integration projects. Strong SQL skills with hands-on experience querying, validating, transforming, and reconciling data. Experience integrating data from multiple source systems, including ERP, HRIS, financial, and operational platforms. Strong understanding of data cleansing, data quality, data governance, and data validation principles. Experience performing source-to-target mapping and documenting complex data transformations. Demonstrated ability to work with structured and semi-structured data from databases, flat files, and APIs. Experience collaborating with technical and business stakeholders across Finance, Operations, and IT teams. Strong analytical, troubleshooting, and problem-solving skills.

The role focuses on data mapping, transformation, and integration across multiple enterprise systems into a data warehouse. It involves collaborating with Finance, Operations, and IT teams to ensure data accuracy and support onboarding into Sage Enterprise Intelligence.

Requires over 7 years of experience in data analysis, warehousing, and ETL with strong SQL proficiency. Candidates must have a proven track record of managing large-scale data integration projects and working with structured and semi-structured data.

• SQLPreferred
• Data analysisPreferred

Identified from the job description. Confirm important requirements above.

• Data Analysis
• Data Warehousing
• Data Integration
• ETL
• SQL
• Data Mapping
• Data Transformation
• Data Cleansing
• Data Validation
• Source-to-Target Mapping
• API Integration
• Data Governance
• Data Migration
• Sage Enterprise Intelligence
• Stakeholder Management
• Troubleshooting

• Data & Analytics
• Technology
• Consulting
• Finance & Accounting
• Software

Minimum experience

5+ years

Apply by

Sep 5, 2026

Posting language

English

Working hours

30 hours per week

Seniority

Mid-Senior level

Application method

Direct apply is available