About the role
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.
About Robert Half
Robert Half, the world’s first and largest specialized talent solutions firm, connects opportunities at great companies with highly skilled job seekers. We offer contract, temporary and permanent placement solutions for roles in finance and accounting, technology, marketing and creative, legal, and administrative and customer support. Named to Fortune’s World’s Most Admired Companies and 100 Best Companies to Work For® lists and a Forbes Best Employer for Diversity, Robert Half is the parent company of Protiviti®. Robert Half is traded on the New York Stock Exchange (symbol: RHI) and is a member of the S&P 500 index.
Similar Jobs
About the role
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.
About Robert Half
Robert Half, the world’s first and largest specialized talent solutions firm, connects opportunities at great companies with highly skilled job seekers. We offer contract, temporary and permanent placement solutions for roles in finance and accounting, technology, marketing and creative, legal, and administrative and customer support. Named to Fortune’s World’s Most Admired Companies and 100 Best Companies to Work For® lists and a Forbes Best Employer for Diversity, Robert Half is the parent company of Protiviti®. Robert Half is traded on the New York Stock Exchange (symbol: RHI) and is a member of the S&P 500 index.