Sql data analyst • burnaby bc
Reporting to the ERP Data Lead, the Technical Business Analyst - ERP Data Migration will play a meaningful role in data readiness and data migration activities during the ERP implementation program... Voir plus
Entity: WELL Health Technologies.Position Title: Financial Analyst.Salary Range: $80,000 - $90,000.WELL Health Technologies is an innovative technology-enabled healthcare company whose overarching ... Voir plus
Validate data sources, transformations, and analysis against reference data to ensure quality, accuracy, and completeness of derived reports.Complete data discovery and mapping of shipyard enterpri... Voir plus
Designs, develops, and maintains highly complex Power BI reports and dashboards, incorporating advanced data modeling techniques to integrate data from disparate shipbuilding systems.Works extensiv... Voir plus
Our public sector client is looking for a Data Analyst to assess and implement changes across the enterprise data ecosystem.Initially 6-month contract with chances of extension.Hybrid 2 days/week o... Voir plus
Business Analysis: Translate business requirements into clear, detailed technical specifications and technical roadmaps.System Configuration: Customize and configure SuccessFactors to meet specific... Voir plus
Vancouver is consistently ranked as one of the world’s most liveable and environmentally sustainable cities.Recognized among BC’s Top Employers and Canada’s Greenest Employers, the City of Vancouve... Voir plus
Technical Lead - SQL DBA, SQL Server & Database Administration.The person will be responsible for leading Microsoft SQL Server database administration, production support, operational governanc... Voir plus
LGM is a national leader in providing warranty, finance and insurance services to the Canadian automotive industry.Since 1998, LGM has partnered with leading automotive manufacturers and dealership... Voir plus
Located in the heart of downtown Vancouver, between the Pacific Ocean and the Coast Mountains, Teck’s Corporate Office sits in one of Canada’s most culturally diverse cities.Surrounded by world-ren... Voir plus
Vancouver, BC • ID: 886-028 • Full-Time/Regular.LGM is a national leader in providing warranty, finance and insurance services to the Canadian automotive industry.Since 1998, LGM has partnered with... Voir plus
Our consumer business client is seeking a.Oracle Cloud Application Developer (10+ years) to enhance and integrate Oracle Fusion Cloud ERP applications using Oracle Integration Cloud, SQL, and PL/SQ... Voir plus
Job Title: Accounts Payable AnalystPrimary Location: Vancouver, BC Job Status: Full-Time, PermanentEmail to applyPrimex Investments Ltd.Primex) is a BC-owned and operated real estate investment, d... Voir plus
Our client is seeking a junior data analyst to assist with customer compliance and documentation within their data domain.This is a junior position and is open to new or recent graduates.A Bachelor... Voir plus
The global functions technology group supports Finance and Risk Business partners by using our extraordinarily rich data set that spans multiple versions and geographies globally and captures detai... Voir plus
Our Ideal QA AnalystOur ideal QA Analyst is excited by the opportunity to be part of a collaborative development team building and improving products from the ground up.You enjoy working on greenfi... Voir plus
With over $45 billion in assets under administration, our "booming" business means you gain high-level exposure and real opportunities for career advancement.We are professional yet enjoyable.We pr... Voir plus
Putting people first, every day.BDO is a firm built on a foundation of positive relationships with our people and our clients.Each day, our professionals provide exceptional service, helping client... Voir plus
At Deloitte, our Purpose is to make an impact that matters.We exist to inspire and help our people, organizations, communities, and countries to thrive by building a better future.Our work underpin... Voir plus
Xplor is building a high-impact Transformation team to drive strategic change across the business.As Analyst / Senior Analyst, Transformation, you will play a role owning the analysis and executing... Voir plus
Reporting to the ERP Data Lead, the Technical Business Analyst - ERP Data Migration will play a meaningful role in data readiness and data migration activities during the ERP implementation program. This position focuses on supporting cross-functional teams throughout the data extraction, transformation, migration, and validation process, ensuring that data from legacy systems is accurately transitioned to our new ERP platform.
The ideal candidate will have a solid technical background in data management and migration tools, hands-on experience with ERP systems, and a collaborative approach to leading partners and ensuring data integrity throughout the ERP migration journey.
The Technical Business Analyst will be responsible for working closely with data stewards, product owners, business partners, and technical teams to ensure that data migration activities are accurately planned, implemented, and monitored. The goal is to ensure that data is accurately and fully migrated, with a key focus on data profiling, mapping, cleansing, and validation throughout the migration process.
**Responsibilities**
- Be a courageous safety leader, adhere to and sponsor safety and environmental rules and procedures
- Adhere to and promote safety and environmental rules and procedures throughout the data migration process to ensure that all activities align with safety standards
- Actively support data extraction, transformation, and loading (ETL) activities from legacy ERP systems to the data readiness tool
- Act as a liaison between business users and technical teams to ensure smooth data migration across all business domains
- Provide hands-on support in the Syniti migration tool, including configuration, data load execution, and validation
- Collaborate with key partners to assess current data readiness levels, ensuring that all data required for migration is clean, accurate, and complete
- Work with data stewards to prepare data for migration, ensuring that any gaps or issues are identified and resolved in advance
- Ensure that all data processes are carefully gathered and validated as part of the migration strategy
- Work alongside data stewards to identify, cleanse, and correct any discrepancies or data quality issues in the existing systems prior to migration
- Participate in the profiling of existing data to identify data quality issues or gaps. Work with technical teams to develop and implement the transformation processes to ensure that the data aligns with the new system's requirements
- Collaborate with data developers, technical teams, and third-party software providers to ensure that the data migration process runs smoothly and that data integrity is maintained
- Ensure all partners are aligned on migration schedules, timelines, and dependencies
- Support and coordinate the advancement of data readiness and migration activities, tracking key achievements to ensure all business areas are progressing within the broader ERP implementation timeline
- Support UAT activities by ensuring the migrated data is tested against business requirements
- Facilitate UAT sessions to ensure that the data meets business expectations and address any data-related issues raised by end-users during testing
- Support the development/ delivery of training materials, user guides, and system documentation related to data migration changes
- Ensure end-users are adequately educated on new data processes to facilitate the smooth adoption of the new ERP system
- Assist with handling change associated with data migration, ensuring compliance with corporate change management and release management processes
- Ensure that all data migration activities are well-documented, tested, and communicated to relevant partners
**Qualifications**
- Applied University Degree with emphasis on information systems, computer science, business systems, or a related technical discipline
- 7+ years of experience in a similar role, specifically focused on data readiness and data migration within ERP systems, including hands-on experience supporting data migration across multiple business domains.
- Strong analytical and problem-solving skills, with the ability to quickly understand and resolve data-related issues
- Ability to handle large volumes of data and ensure high-quality data throughout the migration process
- Ability to work optimally in a team environment, managing multiple tasks related to data readiness and migration, and adhering to tight deadlines in a fast paced ERP implementation context
- Familiarity with ERP systems and business processes, particularly in industries such as mining, manufacturing, or any industry requiring complex data migrations
- Proficiency in Microsoft Office tools, especially Excel and SharePoint (O365 preferred)
- Experience with ERP systems such as SAP, Oracle, or Microsoft Dynamics
- Hands-on experience with Syniti ADMM or other ETL tools is highly desirable
- Experience with change management processes and methodologies, specifically in the context of ERP implementations and data migration
- Fluency in Spanish is an asset
