IT Enterprise Data Warehouse Architect

2 weeks ago

Cape Town, South Africa Watchmaker Genomics Full time

**Company Description**:
**Position Description**:
The role extends to supporting system implementations and integration planning. By collaborating closely with IT software architects, technical teams, and external partners, the individual ensures that the enterprise software implementations are aligned with the organization's data warehousing strategy and architecture. Their expertise will guarantee seamless data extracts, transformations and loads from internal and external systems into the data warehousing solution.

**Responsibilities**:

- **Data Architecture**_
- Develop and maintain data models, including dimensional and normalized models, to represent data accurately and efficiently;
- Design and implement data schemas and data dictionaries to ensure consistency and clarity of data definitions;
- Select, configure, and manage data warehousing platforms and technologies based on organizational needs.
- **Data Integration and ETL Processes**_
- Design, implement, and optimize ETL processes to extract, transform, and load data from source systems into the data warehouse;
- Monitor ETL workflows for performance, reliability, and data quality;
- Implement data validation, cleansing, and error handling in ETL processes.
- **Performance Optimization**_
- Tune database configurations to ensure high-performance data retrieval;
- Monitor system performance, identify and address bottlenecks, and optimize data storage and retrieval.
- **Data Governance, Security and Compliance**_
- Define and enforce data security measures, access controls, encryption, and authentication to protect sensitive data;
- Ensure compliance with data privacy regulations and industry standards;
- Develop, enforce, and maintain data governance policies and procedures;
- Assign data stewards and establish data ownership responsibilities.
- **Business Intelligence (BI) and Reporting Integration**_
- Integrate the data warehouse with BI tools to provide data for reporting and analytics;
- Collaborate with BI teams to design user-friendly dashboards and reports.
- **Scalability and Future-Proofing**_
- Plan for scalability by selecting technologies that can grow with the organization's data requirements.

**Required Experience**:

- _Data warehouse and/or data lake Design, Implementation and Support Experience:_ Previous experience in designing, implementing and supporting enterprise data warehousing systems.
- _Business Process Understanding: _Strong familiarity with various business processes across different departments, such as finance, supply chain and manufacturing is crucial.
- _Data Mapping and Transformation:_ Experience in defining data mapping, transformation, and conversion processes to ensure seamless data load;
- _Data Transformation:_ Experience with data manipulation tools and techniques is essential;
- _Business intelligence tools:_ Experience in BI tools like Power BI for data visualization and reporting;
- _Data Governance:_ Prior experience in establishing and enforcing data governance practices, data quality standards, data lineage, and data ownership is essential.
- _Project Management:_ Proven track record in managing projects, especially those related to ERP implementation, upgrades, or integration initiatives. Skills in defining project scopes, timelines, resource allocation, and risk management are important.
- _Change Management and Training:_ Experience in change management strategies, including user training and adoption planning, to ensure smooth transitions during implementations;
- _Vendor and Partner Collaboration:_ Experience in working collaboratively with external partners, third-party vendors, and consultants to facilitate successful system integrations.
- Data Modeling: Proficiency in creating and managing data models, including dimensional and normalized models, to represent data structures effectively;
- Database Expertise: In-depth knowledge of database management systems, both traditional (e.g. SQL Server) and cloud-based platforms (e.g. Azure SQL Data Warehouse);
- ETL (Extract, Transform, Load) Skills: Experience in designing and implementing ETL processes to extract, transform, and load data from source systems into the data warehouse;
- Data Integration: Ability to ensure seamless data integration across various data sources, including structured and unstructured data;
- SQL and Scripting Languages: Strong proficiency in SQL for querying and managing databases.
- Analytical and problem solving skills;
- Effective written, verbal and presentation and listening communications skills;
- Strong teamwork and collaboration skills;
- Stress and Time management.
- Resilience: The ability to bounce back from challenges and setbacks is important in a role where complex issues may arise;
- Business Acumen: Understanding the business context and how data supports the organization's goals is important for aligning data solutions with the company's strategic objectives;
- Attention to Detail: Being meticulous

  • Data Architect

    4 weeks ago

    Cape Town, South Africa PBT Group Full time

    PBT Group has an opportunity for a Data Architect to define and set architecture principles, which are aligned to the overall bank Data Strategy, and to be adopted by the business and data warehouses to create, deploy and manage the relevant BU’s data. The Data Architect will define how data will be stored, consumed, integrated and managed to meet the...

  • Senior Data Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group (PTY) Ltd Full time

    The Ce-I continues to provide Enterprise Architect strategic planning, innovation, and good governance support services to the province.Ce-I follows the approach below in order to achieve its strategic goal enablement (top down), this approach should be followed by the successful bidder in delivery the services:•                 ...

  • Solutions Architect

    4 weeks ago

    Cape Town, South Africa Dimension Data Full time

    The Solutions Architect will be responsible for architecting solutions that take advantage of our technologies and enabling the team to deploy new software in a quick, reliable and scalable way. Your primary responsibility will be to drive innovation within the company by developing cutting-edge technology solutions. You'll work closely with other...

  • Enterprise Architect

    4 weeks ago

    Cape Town, South Africa iCore Full time

    Looking for _**Enterprise architecture**_ at one of our client location in western cape. **Requirements**: Must have and IT architecture certification. _**TOGAF certification**_ is advantageous. Minimum of 5 years of experience as an _**Enterprise Architect**_ or equivalent role: Minimum of 2 years of experience as an _**Solution Architect**_ or equivalent...

  • Senior Data Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group Full time

    Job Description The Ce-I continues to provide Enterprise Architectstrategic planning, innovation, and good governance support services to theprovince. Ce-I follows the approach below in order toachieve its strategic goal enablement (top down), this approach should befollowed by the successful bidder in delivery the services: •Understanding the...

  • Senior Data Enterprise Architect

    7 days ago

    Cape Town, South Africa DLK Group (PTY) Ltd Full time

    Job DescriptionThe Ce-I continues to provide Enterprise Architect strategic planning, innovation, and good governance support services to the province.Ce-I follows the approach below in order to achieve its strategic goal enablement (top down), this approach should be followed by the successful bidder in delivery the...

  • Information Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group (PTY) Ltd Full time

    The Ce-I continues to provide Enterprise Architect strategic planning, innovation, and good governance support services to the province.Ce-I follows the approach below in order to achieve its strategic goal enablement (top down), this approach should be followed by the successful bidder in delivery the services:•                 ...

  • Enterprise Solutions Architect Lead

    4 weeks ago

    Cape Town, South Africa ADEC Innovations Full time

    Core Description  The Enterprise Solutions Architect requires client (external & internal) engagement to identify and understand business requirements. The Enterprise Solutions Architect together with internal digital and technology functions of the business crafts solution/s and presents a minimum viable product (MVP) or prototypes for client...

  • Senior Business Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group (PTY) Ltd Full time

    The Ce-I continues to provide Enterprise Architect strategic planning, innovation, and good governance support services to the province.Ce-I follows the approach below in order to achieve its strategic goal enablement (top down), this approach should be followed by the successful bidder in delivery the services:·        Understanding the strategic...

  • Solutions Architect

    4 weeks ago

    Cape Town, South Africa Dimension Data Full time

    FunctieomschrijvingThe primary responsibility of the Solutions Architect is to consult with the client and work with internal teams to create strategies, transformational designs and the architectural vision for complex solutions that address the clients’ needs. They provide multi-technology consulting services on all aspects of application software,...

  • Information Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group Full time

    Job Description The Ce-I continues to provide Enterprise Architectstrategic planning, innovation, and good governance support services to theprovince. Ce-I follows the approach below in order toachieve its strategic goal enablement (top down), this approach should befollowed by the successful bidder in delivery the services: •Understanding the...

  • Senior Business Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group (PTY) Ltd Full time

    Job DescriptionThe Ce-I continues to provide Enterprise Architect strategic planning, innovation, and good governance support services to the province.Ce-I follows the approach below in order to achieve its strategic goal enablement (top down), this approach should be followed by the successful bidder in delivery the services:·        Understanding...

  • Information Enterprise Architect

    6 days ago

    Cape Town, South Africa DLK Group (PTY) Ltd Full time

    Job DescriptionThe Ce-I continues to provide Enterprise Architect strategic planning, innovation, and good governance support services to the province.Ce-I follows the approach below in order to achieve its strategic goal enablement (top down), this approach should be followed by the successful bidder in delivery the...

  • Warehouse Solutions Architect- Contract Position

    6 days ago

    Cape Town, South Africa Lineker Solutions Full time

    PLEASE NOTE THIS IS A CONTRACT POSITION Degree in Computer Science, Industrial Engineering, Logistics Management, or related field. Advanced degree preferred. - Proven experience as a Warehouse Solutions Architect or similar role, with a focus on warehouse management and logistics. - Strong understanding of warehouse operations, logistics processes, and...

  • Senior Solutions Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group (PTY) Ltd Full time

    ·        Understanding the strategic goals and the supporting business architecture.·        Obtaining and understanding of how our information and date assets will be leveraged.·        Determine the application landscape and roadmap required.·        Identify the in place and required technology components.·       ...

  • Data Warehouse Business Analyst

    4 weeks ago

    Cape Town, South Africa Status Staffing Full time

    A recent professional profile photo is to accompany your applicationEMPLOYMENT TYPE : PermanentSECTOR : AdminBASIC SALARY : R45 000START DATE : A.S.A.P / ImmediateREQUIREMENTS:3+ Years experience in a business analyst role, preferably in a formal data, data...

  • Senior Solutions Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group Full time

    Job Description ·Understanding the strategic goals and the supporting businessarchitecture. ·Obtaining and understanding of how our information and date assets willbe leveraged. ·Determine the application landscape and roadmap required. ·Identify the in place and required technology components. ·Opportunity identification (bottom-up)...

  • Senior Technology Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group (PTY) Ltd Full time

    ·        Understanding the strategic goals and the supporting business architecture.·        Obtaining and understanding of how our information and date assets will be leveraged.·        Determine the application landscape and roadmap required.·        Identify the in place and required technology components.·       ...

  • Data Warehouse Business Analyst

    4 weeks ago

    Cape Town, South Africa Status Staffing Full time

    Our client based in Durbanville is looking for a Data Warehouse Business Analyst with proven experience as a business analyst in data warehousing projects to join their team. A recent professional profile photo is to accompany your applicationEMPLOYMENT TYPE    :           PermanentSECTOR                         ...

  • Senior Technology Enterprise Architect

    4 weeks ago

    Cape Town, South Africa DLK Group Full time

    Job Description ·Understanding the strategic goals and the supporting businessarchitecture. ·Obtaining and understanding of how our information and date assets willbe leveraged. ·Determine the application landscape and roadmap required. ·Identify the in place and required technology components. ·Opportunity identification (bottom-up)...