Vacancy title:
Specialist; Data Architecture and Modelling
Jobs at:
CRDBDeadline of this Job:
Wednesday, October 18 2023
Summary
Date Posted: Friday, October 06 2023, Base Salary: Not Disclosed
JOB DETAILS:
Job Summary
Design, implement, and document data architecture and data modelling solutions, which include the use of relational, dimensional, and NoSQL databases to support enterprise data management, business intelligence, machine learning, data science, and other data-related initiatives.
Key responsibilities:
• Create data conceptual models and logical data models for each data asset.
• Establish data mapping to all the source systems tables and fields that store data assets.
• Analyze structural data requirements for new software and applications.
• Develop migration plans of data from legacy systems to new solutions.
• Design conceptual and logical data models and flowcharts.
• Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
• Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models.
• Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• Work proactively and independently to address data-related project requirements and articulate design/modelling issues/challenges to reduce delivery risks.
• Be responsible for the development of the conceptual, logical, and physical data models, OLTP RDBMS, operational data stores (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
• Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices.
• Engage with users during development and testing activities
• Conceptualize, execute, and refine design specifications in the form of process flows, information architecture, wireframes, prototypes, and functional design specs.
• Understand complex customer data, business goals, and requirements, and translate them into functional and technical designs.
• Create customer-centric designs that meet organizational and user requirements.
• Work closely with Data Architects in the development of stored procedures as well as data integrations and aggregation.
Experience, Knowledge and Skills Requirements
• Bachelor’s degree in data science, Information Systems/ Computer Science or related discipline from a recognized university.
• Minimum of 3 years of experience in data design and modelling.
• Proven work experience as a Data Architect, Data Modeler or similar role.
• In-depth understanding of database structure principles.
• Experience gathering and analyzing system requirements.
• Experience in data mining and modelling techniques.
• Experience in SQL and Oracle.
• Knowledge in data architecture, data warehousing, master data management, enterprise information integration and ETL using a cross-section of technologies and programming languages.
• Hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols.
Work Hours: 8
Experience in Months: 36
Level of Education: Bachelor Degree
Job application procedure
Interested and Qualified Click here to Apply
All Jobs
Join a Focused Community on job search to uncover both advertised and non-advertised jobs that you may not be aware of. A jobs WhatsApp Group Community can ensure that you know the opportunities happening around you and a jobs Facebook Group Community provides an opportunity to discuss with employers who need to fill urgent position. Click the links to join. You can view previously sent Email Alerts here incase you missed them and Subscribe so that you never miss out.