Vacancy expired!
job summary:
Summary- Work with Product Managers/Owners and the Development community to ensure the robust data warehousing solutions are delivered
- Develop Conceptual/Logical/Physical data models in line with business requirements
- Ensure data models developed meet appropriate standards and principles
- Ensure data models are documented, communicated, updated, and centrally managed in an appropriate manner
- Design technical data solutions meeting business requirements and providing guidance to development teams.
- Oracle SQL / PLSQL
- Hadoop
- Data modelling and architecture
- Expertise in Data Modelling, including Conceptual, Logical and Physical modelling for Enterprise-level Data Stores
- Good understanding of different data modelling techniques - 3NF, Dimensional and Data Vault.
- Ability to think strategically about business, product, and technical challenges in an enterprise environment.
- Understanding of database and analytical technologies in the industry including MPP and NoSQL databases, Data Warehouse design, BI reporting, and Dashboard development.
- Knowledge of payments industry data standards is highly desirable, including ISO 20022, as well as regulatory experience within Payments.
- Excellent problem solving and communication skills; experience in interacting with technical and non-technical stakeholders at all levels.
- Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience
- Experience in reverse-engineering of data models.
- Ability to troubleshoot complex SQL queries implemented as part of ETL code
- Ability to utilize Business Intelligence tools (Power BI, Tableau, etc.) to represent insights
- Excellent problem solving and communication skills; experience in interacting with technical and non-technical stakeholders at all levels.
- Data Architecture - Data Warehouse, Data Mart, ODS, ETL, reporting, analytics
- Understanding of Apache Hadoop and the Hadoop ecosystem.
- Significant exposure to relational and NoSQL design methodologies.
- Understand common integration services: REST API exposure.
- Data analysis and modelling tools (e.g., Power Designer, Erwin, etc.)
- SQL and/or PL/SQL hands-on experience
- RDBMS platforms (e.g., SQL Server, Oracle, Netezza, Teradata, DB2 / UDB)
- NoSQL databases (MongoDB, Elasticsearch, etc)
- BI Tools (MSTR/Tableau/Kibana)
- Microsoft Excel, Word, Power Point and Visio
- Specialist skillsets: Oracle, Agile, Hadoop, Java
- inter-personal skills and ability to work as part of a team
- Work with Product Managers/Owners and the Development community to ensure the robust data warehousing solutions are delivered
- Develop Conceptual/Logical/Physical data models in line with business requirements
- Ensure data models developed meet appropriate standards and principles
- Ensure data models are documented, communicated, updated, and centrally managed in an appropriate manner
- Design technical data solutions meeting business requirements and providing guidance to development teams.
- Experience level: Experienced
- Minimum 3 years of experience
- Education: Bachelors
Vacancy expired!