Requirements
Data Modeling:
Design and implement robust scalable and efficient data models for operational data and subjectoriented data marts.
Develop conceptual logical and physical data models to support data integration business intelligence and analytics initiatives.
Collaborate with business stakeholders to understand data requirements and translate them into effective data models.
ETL Development:
Create and maintain ETL processes to extract transform and load data from various sources into the data platform.
Ensure ETL processes are optimized for performance accuracy and maintainability.
Troubleshoot and resolve issues related to ETL processes and data integration.
Data Integration:
Manage data ingestion processes from multiple applications ensuring data consistency and reliability.
Develop and maintain data integration frameworks to support realtime and batch data processing.
Coordinate with application owners to ensure seamless data ingestion and integration.
IndustrySpecific Data Models:
Apply deep knowledge of retail industry data models particularly in areas such as sales inventory loss prevention supply chain and warehouse management.
Utilize industry best practices to design data models that support the unique needs of a pharmaceutical retail business.
Documentation and Governance:
Maintain comprehensive documentation of data models ETL processes and data integration workflows.
Implement data governance practices to ensure data quality security and compliance with industry standards.
Establish and enforce data modeling and documentation standards.
Collaboration and Leadership:
Work closely with data architects data engineers and business analysts to align data modelling efforts with business objectives.
Mentor junior team members and provide guidance on best practices in data modelling and data management.
Lead data modelling sessions and design reviews with crossfunctional teams.
The person must be comfortable with:
Building lasting relationships that can be relied on to help bolster our reputation
Working and liaising with people from a diverse range of multicultural backgrounds
TEAMWORK AND RELATIONSHIPS
Work closely with other departments functions to deliver exceptional services across the business
Demonstrate teamwork and foster good communication with departmental/ functional colleagues as well as other staff and management
Promote and demonstrate a can do attitude
GENERAL RESPONSIBILITIES
Provide quality information to the MANAGERDATA & ANALYTICS IT in all areas of responsibilities
Assist and support other members of the team in the performance of their roles and responsibilities
Act in accordance with all policies procedures practices and guidelines in the performance of accountabilities
Take all reasonable care for their own and others safety and wellbeing while at work.