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.

Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.

Questions? Call your local office at 1.888.490.4429. All applicants applying for Canadian job openings must be authorized to work in Canada.

Only job postings for jobs located in Quebec appear in French.

© 2025 Robert Half. By clicking “Apply,” you’re agreeing to Robert Half’s Terms of Use and Privacy Notice.