Specialist; Data Integrations and Modelling

Reporting Line: Manager, Data Management Operations

Location: HQ

Job Summary.

This role involves designing, developing, optimizing, and maintaining conceptual and logical database models of all source systems and targeted repositories. Successful candidate is expected to design, implement, and document data architecture and data modeling 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 modeling 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.
ajira
• 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, 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 development of stored procedures as well as data integrations and aggregation.

Experience, Knowledge, and Skills Requirements

• Bachelor’s Degree in Information Technology, Computer Science, Computer Engineering or any other equivalent and relevant qualification from an accredited institution.
• Minimum 3 years of hands-on experience in data designs and modelling, relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
• Experience with enterprise data platforms.
• Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others).
• Experience with data management and relational database design and familiarity with data formats, table joins, and ETL.
• Knowledge in data architecture, data warehousing, master data management, enterprise information integration and ETL using a cross section of technologies and programming languages
• Clear understanding of common data requirements as they relate to the finance, sales, marketing and contact center organizations. Understands the impact of the data models on complex business issues across many functions and departments.
• In-depth understanding of database structure principles.
• Experience gathering and analyzing system requirements.
• Experience in data mining and modelling techniques.

Deadline: 16th April 2024