Back to Jobs
Recently postedTechnology

Data Analyst (Valuation)

AdientOne LLCMontreal, QC🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationMontreal, QC, United States
Stakeholder ManagementSQLMicrosoft ExcelMicrosoft PowerPointConfluenceJiraData Analysis

Job description

DUTIES AND RESPONSIBILITES:
• Responsible for elicitation, analysis, and documentation of business requirements.
• Research and exploration of user requirements, costs, and benefits in support of documentation required for the demand management process.
• Responsible for analyzing the business needs to identify new processes and process improvements that will meet those needs.
• Documents current business processes and models to define requirements and/or gaps.
• Analyze detailed system factors including input/output requirements, information and paper flow, hardware, and software needs.
• Analyze “soft" system factors including roles, responsibilities, policy, culture, etc.
• Evaluate the impact of potential software and process changes on the organization.
• Develop and facilitate groups as necessary in pursuit of eliciting and defining requirements.
• Assist in the creation of the business case documentation.
• Understanding of architectural consistency and usability standards.
• Defines and develops user test cases and validates test results during testing.
• Executes unit and functional test cases.
• May conduct system demonstrations and training sessions, as well as participate in design/review of training content.
• Plays a third level support role by helping to troubleshoot and resolve issues with production systems.
• Participates in associate meetings and communicates any concerns to management.
QUALIFICATIONS AND REQUIREMENTS:
• Bachelor’s degree in computer science, Information Systems, Business, or another related field or equivalent work experience.
• Proven experience leading data migration requirements from legacy systems into a new ERP (Sage X3) environment
• Strong hands-on expertise in requirements elicitation, documentation, and management, with emphasis on data mapping, transformation rules, and validation
• Deep understanding of data structures, data quality, and migration best practices, with the ability to identify gaps and risks early
• Self-driven and accountable professional with strong stakeholder management and communication skills, able to drive outcomes with minimal oversight
• Working knowledge of Confluence and JIRA.
• Experience in any of the following business areas is desired: Sales operations, order entry, accounting, finance, procurement, warehouse operations, order management, and order fulfillment.
• Minimum of 3-5 years’ business analysis or systems analysis experience is preferred.
• Bonus: Sage X3 experience (ERP).
Associate is expected to operate at a proficient level across the following areas of technical knowledge and skill:
• Ability to organize and prioritize work.
• Detail oriented, proactive, creative, and efficient
• Intermediate level abilities in Excel, Outlook, PowerPoint, Visio, and Word
• Familiarity with application integration methods to include understanding of data mapping process.
• Ability to effectively work both independently and collaboratively in a team environment
• Ability to work on simultaneous and complex projects, with domain expertise in at least one business area.
• Expertise in ERP solution selection and implementation is a plus
• Ability to communicate effectively to both technical and non-technical audiences in written and non-written format
• Ability to work with all levels of associates
• Ability to work with minimal supervision in a very dynamic environment
• Ability to learn new systems and tools
• Knowledge of software development life cycle methodologies, processes, and procedures.
• Active listener
• Effective in a variety of formal/informal presentation settings: one-on-one, small, and large groups.

Job Title: Data Valuation Analyst

Location: Montreal, QC

Duration: 12 Months

The data valuation analyst contributes to the exploitation and valuation of data collected through various channels. Their mandate is to bring data to life through extraction, description, analysis, and interpretation, in order to facilitate business decision-making.

The person will be primarily responsible for analyzing data from source systems, understanding its meaning and rules of use, and then defining and documenting the source-target mappings necessary for its ingestion into the EBX data model.

Main responsibilities

  • Analyze the structures and data from the various authoritative sources of collaborators.
  • Understand the target data model in EBX and establish the correspondences with the source models.
  • Produce and maintain source-target mapping documents for ingestion flows.
  • Document the attributes (transformation and normalization rules; applicable business rules; necessary reference values and mappings, etc.)
  • Identify the discrepancies between the source data and the target model and collaborate with the relevant teams to define how to address them.
  • Participate in profiling source data to identify quality issues that may impact integration.
  • Clarify the ingestion rules with source system experts, functional managers, and MDM teams.
  • Supporting developers/integrators in interpreting mappings and transformation rules.
  • Participate in the preparation of functional test cases and data validation after ingestion.
  • Document the rules to ensure data traceability, from the authoritative source to the EBX repository.
  • Contribute to DMR work related to the integration, transformation and reliability of employee data.

Requirements and qualifications

  • Experience in data analysis and integration.
  • Excellent ability to perform source-target mappings.
  • Good understanding of data models, source systems, and integration flows.
  • Experience with MDM solutions, ideally TIBCO EBX.
  • Good command of SQL for analyzing and validating data.
  • Knowledge of the concepts of:
    • master data;
    • authoritative sources;
    • data quality and profiling;
    • transformation rules;
    • reference frameworks and reference values;
    • traceability and lineage.
  • Ability to read and understand exchange formats such as JSON, XML, CSV as well as API specifications.
  • Ability to translate business rules into precise functional specifications that can be used by a technical team.
  • Rigorous documentation and strong analytical skills.

Similar jobs