Functional Analyst - Bi

JOB INDEX - 1 month ago - Job Mail

1 month ago

Functional Analyst - Bi

Main Purpose of the Job:

To define the customer data requirements for the overall business solution, develop detailed data technical specifications and establish effective metadata management mechanisms.


Job Objectives:

• The development of data requirements and technical data specifications through the design, prototyping, testing, training, defining, and implementation of procedures for support of the required technical solutions to meet business solution requirements.

• Documentation of the detailed data specifications to deliver the required data sources to meet customer data reporting and analytics business requirements.

• Define and document all aspects of customer metadata management.

• Documentation of Data quality metrics and specifications for data validation

• Provide support to the data architect, data engineers, data analysts and the analytics team members in the execution of their responsibilities


Task Information:

• The development of data requirements and technical data specifications through the design, prototyping, testing, training, defining, and implementation of procedures for support of the required technical solutions to meet business solution requirements.

- Assist the Business Analysts with data requirements definition from the functional and non-functional business requirements

- Consolidate the data requirements for the business solution across all functional workstreams from business functional and non-functional requirements

- Identifies the data use cases and transforms them into logical and technical data solutions.

- Ensure that all stakeholders agree and sign-off the suggested proposed data technical solutions

- Ensure that technical data specifications includes required data Integration and Interoperability needs

• Documentation of the detailed data specifications to deliver the required data sources to meet customer data reporting and analytics business requirements.

- Translate all business requirements from the business requirements documentation and business process documents into functional and non-functional data requirements

- Define data specifications (using systems specifications of various systems, business and data requirements as input)

• Define and document all aspects of customer metadata management and assist with data governance documentation.

- Ensure all data and information requirements are met in the system specifications of various w/streams by consolidating all systems data dictionaries to a customer master data dictionary and then mapping all data fields to information requirements

- Define all customer data fields CRUD controls in technical specifications for all systems, interfaces and user Interfaces

- Define of data field security technical specifications for data masking in each interface and UI to meet security and regulatory requirements

- Definition of data master and slave data relationships with associated control and update processes across systems

- Define all derived and transformed data fields with the associated technical specification for derivation and transformation

- Define Meta data design, populate metadata repository and implement metadata administration and update processes

- Integrate all aspects of data governance into the data technical specifications.

• Documentation of Data quality metrics and specifications for data validation

- Support test workstream in development of data quality assurance test strategy

- Define data acceptable quality metrics for all data sources

- Consolidate all customer data capture field validation specifications to ensure consistent data quality

- Assist test workstream with Data quality assurance process

• Provide support to the data architect, data engineers, data analysts and the analytics team members in the execution of their responsibilities.

- Assist the business analysts in defining data requirements and business rules for data manipulation, derivation and transformation, as well as data quality business rules

- Assist data engineers with metadata, data sourcing and data integration documentation

- Assist data architect and data engineers in delivery of data architecture and data management documentation


Report Structure:

Reports to manager for Data Management and Decision Support


Impact of Decision:

• Time Span - Operational

• Problem solving - Complex to Highly Complex

• Risk of decisions - High Internal

• Financial impact - Medium

• Influence of work - Operational

• Work proficiency - Professional

• Demands of change - High


Job Related Experience:

• Retail operations 4+ years desirable

• Developing and maintaining systems functional and technical specifications experience - 4+ years essential

• Data Analysis experience - 3+ years essential

• Business Intelligence and Data warehousing - 4+ years essential

• Agile exposure, Kanban or Scrum - 2+ years desirable


Formal Qualification:

• IT-related: 3 years, essential


Job Related Knowledge:

• Business Intelligence Domain Knowledge - 24 months essential

• Metadata Management - 36 months essential

• Provide technical effort estimates to used project schedules and resource allocation - 36 months essential

• Participate in test efforts: Test Planning, Test Execution, Defect Resolution and conducting root cause analysis to identify corrective actions - 36 months essential

• Participate in Go-live planning activities - 36 months essential

• Translation of Business Reporting and Analytics requirements to data requirements - 36 months essential

• Translation of Business Reporting and Analytics requirements to data requirements - 36 months essential

• Working with interfaces - 36 months essential


Job Related Skills:

• Data modeling techniques and methodologies - 36 months essential

• Database / data repository design - 36 months essential

• System functional analysis - 36 months essential

• Data Analysis - 24 months essential

• Problem solving skills - essential

• Good communication skills (oral & written) - essential

• Organising skills - essential

• Analytical skills - essential


Competencies:

• Planning & Organising (Structuring tasks) - essential

• Evaluating problems - essential

• Executing assignments - essential

• Achieving success - essential

• Analytical thinking - essential

• Communication - essential

• Creative thinking - desirable


Kindly regard your application as unsuccessful if you have not heard from the agency within 2 weeks.