Technical Analyst
The Mission
The DWH Technical Analyst is a liaison between the business analysts and the development team. On one side he/she should be able to understand the end-user requirements and identify business needs; on the other hand, he/she should identify the golden source for each business term, create source to target mappings and find implementation options together with developers. At the end the solution will be presented for review & acceptance to both teams (business and developers).
Your Day to Day
- Collaborate with data modelers, architects, developers and source system analysts to define source system output files structure, ensuring the quality of the data and considering non-functional requirements (security, performance, availability or scalability)
- Responsible of creation of source to requirements mappings for the business terms defined by the business analysts and source to target mappings for the logical & physical model defined by the data modelers
- Support Product owner in defining User Stories and backlog for analysis and development teams
- Provide ongoing support to Dev Team during development phase
- Support Dev team in SIT (System Integration Testing)
- Support Product Owner/Business in performing the UAT (User Acceptance Testing)
- Collaborates with programmers, testers, other development teams and business users
- Accurately and concisely articulate issues, questions, recommendations to customers, team members, and management. Proactively identify issues and concerns
- Provides training, documentation and support for business user and other support lines
- Set up and maintain way of working, design principles, standards and guidelines for local and group Data Lake components.
What you bring to the team
Experience
- University degree in Computer Science or other related fields preferred; equivalent experience will be considered
- 3+ years of proven experience in the role of System/Technical Analyst in a Data Warehouse or reporting environment
- 3+ years of proven experience in the role of Business Analyst in a DWH environment and respective business area in gathering, analyzing and documenting requirements
- 3+ years of proven experience as DWH SQL.
Knowledge
- Strong understanding of data warehousing, data modeling, ETL, database design, business intelligence and their processes
- Strong knowledge of SQL
- Understanding of modeling principles (conceptual, logical and physical – relational and dimensional) is a plus
- Working knowledge of banking/financial environment is a plus
- Experience using Agile methodology is a plus
- Good level of English.
Skills
- Good in problem analysis and judgment – you evaluate the impact of architectural decisions, actions, choices, risks and updates and their impact on the organization
- Autonomous in executing tasks, preparation of advice, and decision making about the implementation
- Persistent – you deal with conflicts of interest and obtain a good and acceptable end solution
- Communicative and persuasive – you can document in a comprehensive way to non-IT colleagues the decisions taken.