Data analyst with extensive experience in data warehousing, extensive experience with data normalization and modeling required: 3NF, Kimball, data vault.A good candidate will also have extensive experience with Oracle and ODI specifically
Purpose
Analyze user needs and translate them in coordination with the Solution Architect. Taking into account technical capabilities/limitations in order to ensure the quality of the existing architecture and applicable quality requirements in new application deliveries and continuity of existing applications.
Business analysis
Collect, challenge and document end user needs in order to have a standardized, complete and correct representation of the business needs that serves as input for the functional analysis.
Example of activities
Challenging business requirements and translating them into functional requirements.
Manage requirements and keep them up-to-date
Understand the business processes (and thus the use of the applications in the business) so that new requirements can be translated into workable solutions
Translate business requirements to the product teams
Perform the impact analysis with input from the entire team
Work closely with Product Owner to thoroughly understand our customers' challenges
Monitor that the E2E solution provided by different integration points in the application landscape always delivers the desired result for business
Propose solution
Analyze and compare customer-oriented solutions and propose the best possible solution to the users in the business in order to validate or adjust the proposed solution if necessary.
Example of activities
Prepare a solution proposal.
Determine and evaluate the IT benefits and costs (e.g. license cost, effort, ...) of a proposed solution
Document the assumptions of the proposed solution
Organize workshops/ presentations with business
Follow up and apply guidelines with impact on ICT in order to guarantee an application that meets the company standards (including test follow-up)
Functional Analysis
Prepare the functional analysis according to the agreed standard-den in order to give the developer a correct and complete input for the development of the new or the modification to the existing ap-plication according to the needs of the business.
Example of activities
Monitoring the functional architecture of the applications (E.g. data model).
Elaborate the business requirements taking into account the technical constraints and the existing architecture (in consultation with Solution Architect)
Defining and managing the application logical information model
Transform business concepts into ICT concepts and vice versa
Define the authorization matrix for an application in collaboration with dba, security and business
Perform impact analysis with input from the entire team
Define non-functional requirements in consultation with the Solution Architect
Analyzing test defects/problems/...
Functional design
Prepare a functional design in order to define roles and responsibilities within the application landscape and to guarantee a logical structure in the application landscape architecture.
Example of activities
Prepare functional blueprint
Draw up functional interface specification
Documentation
Create and maintain documentation in order to provide a correct and reliable picture of the application landscape at all times.
Example of activities
Draw up documentation about the chosen solution
Maintaining processes
Maintain documentation structure
Knowledge development
Build, maintain and exchange relevant evolutions in own domain in order to contribute to own development and professionalization as well as that of colleagues.
Example of activities
Actively participate in teamwork.
Supporting colleagues
Quality assurance
Facilitate acceptance testing together with the testers and create awareness about quality in order to secure the quality of the E2E process, both in terms of project, operational and business operation.
Example of activities
Review test plan.
Follow up and validate user tests
Respect standards
Taking quality and continuity into account as a decision criterion
Continuous improvement
Identify, propose and implement improvement actions in order to improve the predictability of processes and improve the quality, effectiveness, efficiency and customer friendliness of the product or service provided.
Example of activities
Perform peer reviews for deliverables prepared by direct colleagues
Keep system documentation up-to-date and share with customers
Analyze, execute, follow up and validate improvement initiatives to automation to promote the continuous delivery pipeline (e.g. automate test scenarios)
Experimenting with new tools/frameworks
Continuously improve the team's processes
Implement cost savings, e.g. through process improvement
Self-organizing teams
Apply Lean/agile mindset, principles and skills in order to achieve greater operational excellence, job satisfaction and empowerment of the teams.
Example of activities
Create support for the NDM agile safe way of working
Incorporate tasks within the product team that are not necessarily aligned with the current role but are within the capabilities and contribute to the quality of the product and team performance
Give and receive feedback to become stronger as a team by addressing colleagues about their performance in a correct but professional manner
Actively participate in team and/or program ceremonies such as daily scrums, PI planning, demos, retrospectives ...
Risks
You are aware of the - daily - risks inherent in the products, activities, processes and systems you collaborate on, you will identify and report these risks you come into contact with during the performance of your job.
Example of activities
Incorporating the principles of the company’s security and risk policy in your investigations and developing analyses and solutions
Respect the company’s policy on information security and operational risk and follow training courses imposed by the company on risk awareness and management.
Developing adjustments and solutions as necessary to mitigate risks or to comply with audit recommendations
Actively identifying risks from your own work and coordinating where necessary with your manager or ISRM
Ideal Profile
Master's degree
3 years of experience as a business or functional analyst
Can provide a thought framework for a project
Organizes own work and coaches other analysts
Conducts reasoned discussion with business about functionalities
Has in-depth knowledge of all important elements in the assigned domains and provides a framework for thinking about a project
Formulates and elaborates improvement proposals to optimize working methods and procedures after discussion with management
Does review of analyses of other domain analysts and mentors new employees
