Data Cleanup and Conversion Specialist, Hxm

3 weeks ago


Cambridge, Canada Waterloo Regional Police Service Full time

The Waterloo Regional Police Service (WRPS) and Region of Waterloo (ROW), the “Organizations”, are embarking on a partnership to implement a shared Human Experience Management (HXM) solution. As the Organizations endeavor to deliver the best service possible to their communities, this new HXM solution will provide enhanced strategic value by introducing modern business practices, replacing outdated systems, and enabling a world-class user experience.

The Organizations have partnered with PricewaterhouseCoopers (PwC) for implementation and the contracted solution is the SAP SuccessFactors HXM Suite (cloud-based).

With more than 1000 sworn and civilian members, the Waterloo Regional Police Service (WRPS) requires a temporary full-time **Data Cleanup and Conversion Specialist **to support the HXM Project**. **The WRPS delivers exceptional police services to more than 575,000 residents. The Waterloo Region is a vital and prosperous community in Southern Ontario that offers the unique combination of a growing urban centre surrounded by four rural communities. You will work in a community proud of its diversity, and within an organization focused on its people.

As the **Data Cleanup and Conversion Specialist**

**You Will**:

- Develop an understanding of the current model data layout, completes data cleansing, data validation, extraction and transformation processes across multiple systems in preparation for the HXM implementation;
- Analyze current data sets and aggregates data from multiple data files and sources;
- Collaborate with a variety of stakeholders and project team members to understand how data is used within particular systems;
- Develop data migration guidance and pre-configured templates to collect data. Perform data validation, quality assurance, user interface and verification activities related to data migration;
- Prepare and update documentation to support data migrations activities. Provide suggestions to streamline the cleansing and conversion of data and data migration processes;
- Identify and fix data errors and other data-related problems. Understand and support data standards and processes to support master data migration;
- Define test scenarios based on data requirements. Create test scripts to prove each scenario through system and user acceptance testing supports;
- Execute extraction, transformation and loading of legacy data into the new HXM environment;
- Prepare status reports and modifies schedules/work plans, as required; ensure all stakeholders are kept up-to-date and well-informed.
- Identify challenges and provide recommendations and resolutions to the Supervisor; and
- Perform other duties as required.

**You Have**:

- Successful completion of a three-year community college diploma in Computer Science, Management Information Systems, Information Management or a related field. A combination of education and experience may be considered;
- Three (3) years of demonstrated experience with designing, implementing and maintaining data integration for complex systems is required;
- Expert knowledge and understanding of data cleansing and conversion; ability to extract and convert data from multiple sources consistently in accordance with mandated guidelines;
- Experience working with a variety of data platforms to retrieve, combine, interact with, explore and visualize data is required;
- Previous experience working with Human Resource Information systems, payroll, time and attendance tracking systems, or other related systems is required. Previous experience working with data in an Human experience Management (HXM) environment is preferred;
- Experience with database design is considered an asset;
- Previous experience working in municipal or public sector workplaces, with union and non-union team members is preferred;
- Previous experience with data mapping, data movement, data quality and cleansing, using ETL tools, such as SSIS, FME, etc;
- Analytical skills troubleshooting and problem-solving skills required to resolve issues as it pertains to data cleansing and data mapping;
- Comprehension, focus and attention to detail are required when entering information into systems or analyzing information from multiple sources;
- Demonstrated professionalism and conflict resolutions skills required to interact with a variety of stakeholders;
- Concise and clear written abilities with the ability to communicate pertinent and time sensitive information to stakeholders;
- A valid Class “G” Driver’s License with no more than six (6) demerit points required to travel within and outside the Region.

**You Are**:

- Self-motivated and organized with a well-developed sense of time, projects, and priority management; ensures adherence to deadlines through prioritizing, communicating status updates, monitoring and mitigating changes;
- Able to clearly and concisely provide explanations and direction to technical and non-technical customers;
- A good communicator, with the abil



  • Cambridge, Ontario, Canada Waterloo Regional Police Service Full time

    The Waterloo Regional Police Service (WRPS) and Region of Waterloo (ROW), the "Organizations", are embarking on a partnership to implement a shared Human Experience Management (HXM) solution. As the Organizations endeavor to deliver the best service possible to their communities, this new HXM solution will provide enhanced strategic value by introducing...


  • Cambridge, Ontario, Canada Waterloo Regional Police Service Full time

    The Waterloo Regional Police Service (WRPS) and Region of Waterloo (ROW), the "Organizations", are embarking on a partnership to implement a shared Human Experience Management (HXM) solution. As the Organizations endeavor to deliver the best service possible to their communities, this new HXM solution will provide enhanced strategic value by introducing...


  • Cambridge, Canada Waterloo Regional Police Service Full time

    The Waterloo Regional Police Service (WRPS) and Region of Waterloo (ROW), the “Organizations”, are embarking on a partnership to implement a shared Human Experience Management (HXM) solution. As the Organizations endeavor to deliver the best service possible to their communities, this new HXM solution will provide enhanced strategic value by introducing...


  • Cambridge, Canada Waterloo Regional Police Service Full time

    The Waterloo Regional Police Service (WRPS) and Region of Waterloo (ROW), the “Organizations”, are embarking on a partnership to implement a shared Human Experience Management (HXM) solution. As the Organizations endeavor to deliver the best service possible to their communities, this new HXM solution will provide enhanced strategic value by introducing...


  • Cambridge, Canada Parrish & Heimbecker, Limited Full time

    **Performance Data Specialist** **New-Life Mills** **Ontario** Join our team that shares your Passion & Heart for Canadian agriculture! Parrish & Heimbecker, Limited (P&H) has an opportunity for a motivated, forward-thinking, and dedicated individual as a Performance Data Specialist based in Cambridge, Ontario. **Work and grow with a family-owned...


  • Cambridge, Canada Parrish & Heimbecker Full time

    New-Life Mills Ontario Join our team that shares your Passion & Heart for Canadian agriculture! Parrish & Heimbecker, Limited (P&H) has an opportunity for a motivated, forward-thinking, and dedicated individual as a Performance Data Specialist based in Cambridge, Ontario. Work and grow with a family-owned company. Join our team with Purpose & History!...


  • Cambridge, Ontario, Canada Parrish & Heimbecker Full time

    New-Life MillsOntarioJoin our team that shares your Passion & Heart for Canadian agriculture Parrish & Heimbecker, Limited (P&H) has an opportunity for a motivated, forward-thinking, and dedicated individual as a Performance Data Specialist based in Cambridge, Ontario.Work and grow with a family-owned company.Join our team with Purpose & History P&H's roots...


  • Cambridge, Canada Lebada Motors Superstore Full time

    We are seeking a highly skilled and experienced SEO Specialist to join our team. As an SEO Specialist, you will be responsible for optimizing our website and driving organic traffic to increase visibility and rankings on search engine results pages. This is a full-time position. **Duties**: - Conduct keyword research to identify target keywords and...


  • Cambridge, Canada AGDATA Full time

    Data Quality Specialist Do you want to work for an organization whose products truly matter and that can make a real difference? The reality is that as the world’s population continues to grow, the agricultural industry needs to scale to meet these growing demands. At AGDATA, we’re focused on delivering a greater return for stakeholders throughout the...


  • Cambridge, Canada Bimeda Full time

    **Validation Specialist**: Cambridge, ON, Canada | Full-time regular Posting Date : 2024-06-17 Job Identification : 189 Department : Validation **Purpose of the Position/Role Summary** Reporting to the Validation Manager, the Validation Specialist initiates and executes validation studies throughout the facility. **Role Specific Requirements**: -...


  • Cambridge, Canada Intact Public Entities Inc. Full time

    We’re entering an exciting time here at Intact Public Entities. If you’re ready to roll up your sleeves and make a difference, we want to hear from you! **Opportunity: Data and Innovation Specialist, Risk Management** - Monitor, identify and analyze trends, explaining outliers and providing influential feedback related to results and productivity. -...


  • Cambridge, Canada 401 Auto Full time

    At the 401 Group of Companies, we want to focus on not who you are, but who you CAN be! We strive to hire exceptional employees who see themselves as _trailblazers, trendsetters, creators, do-ers, catalysts, go-getters, and influential leade_rs in all aspects of who they aspire to be daily. **Location: 2200 Eagle Street North, Cambridge, ON** - **_No...

  • Google Ad Specialist

    2 months ago


    Cambridge, Canada 401 Auto Full time

    At the 401 Group of Companies, we want to focus on not who you are, but who you CAN be! We strive to hire exceptional employees who see themselves as _trailblazers, trendsetters, creators, do-ers, catalysts, go-getters, and influential leade_rs in all aspects of who they aspire to be daily. **Location: 2200 Eagle Street North, Cambridge, ON** - **_No...


  • Cambridge, Canada 401 Auto Full time

    At the 401 Group of Companies, we want to focus on not who you are, but who you CAN be! We strive to hire exceptional employees who see themselves as _trailblazers, trendsetters, creators, do-ers, catalysts, go-getters, and influential leade_rs in all aspects of who they aspire to be daily. **Location: 2200 Eagle Street North, Cambridge, ON** - **_No...

  • Google Ad Specialist

    2 weeks ago


    Cambridge, Canada 401 Auto Full time

    At the 401 Group of Companies, we want to focus on not who you are, but who you CAN be! We strive to hire exceptional employees who see themselves as _trailblazers, trendsetters, creators, do-ers, catalysts, go-getters, and influential leade_rs in all aspects of who they aspire to be daily. **Location: 2200 Eagle Street North, Cambridge, ON** - **_No...


  • Cambridge, Canada Randstad Digital Full time

    MDM Developer - Data Engineering (Contract Position)Number of Positions: 1 Filled: 0 Duration: 3 months initial contractLocation: Cambridge, ON, CAMust be eligible to work in CanadaHybrid position 2 days/week onsite in Cambridge3-month initial contract, project slated to run for 9-12 months. Strong chance of extensionRoles and responsibilities:Accountability...


  • Cambridge, Canada Randstad Digital Full time

    MDM Developer - Data Engineering (Contract Position) Number of Positions: 1 Filled: 0 Duration: 3 months initial contract Location: Cambridge, ON, CA Must be eligible to work in Canada Hybrid position 2 days/week onsite in Cambridge 3-month initial contract, project slated to run for 9-12 months. Strong chance of extension Roles and responsibilities: ...


  • Cambridge, Canada Randstad Digital Full time

    MDM Developer - Data Engineering (Contract Position)Number of Positions: 1 Filled: 0 Duration: 3 months initial contractLocation: Cambridge, ON, CAMust be eligible to work in CanadaHybrid position 2 days/week onsite in Cambridge3-month initial contract, project slated to run for 9-12 months. Strong chance of extensionRoles and responsibilities:Accountability...


  • Cambridge, Canada Bimeda Full time

    **Purpose of the Position/Role Summary** Reporting to the Validation Manager, the Validation Specialist initiates and executes validation studies throughout the facility. **Role Specific Requirements**: - Interact with all levels of management and staff to manage and facilitate the validation process from inception to completion by enlisting cooperation,...


  • Cambridge, Canada Cambridge Memorial Hospital Full time

    Overview: Join a hospital where everyone makes a difference! Cambridge Memorial Hospital (CMH) is a thriving community hospital that proudly provides acute care services including: Emergency, Surgery, Medicine, Women’s and Children’s Health, Intensive Care, Mental Health, and Inpatient Rehabilitation. Our vision is to **_creating healthier communities...