IT Enterprise Data Warehouse Architect

2 weeks ago

Cape Town, Western Cape, 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 highperformance 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 userfriendly 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: Indepth knowledge of database management systems, both traditional (e.g. SQL Server) and cloudbased 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

  • Senior Data Enterprise Architect

    2 weeks ago

    Cape Town, Western Cape, 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 goals and the...

  • Data Architect

    2 weeks ago

    Cape Town, Western Cape, 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

    2 weeks ago

    Cape Town, Western Cape, South Africa Dlk Group Full time

    Cape Town, South Africa | Posted on 09/05/2024 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: ...

  • Data Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa Open Box Software Full time

    Open Box Software is an internationally focused consulting company that specialises in business and software consulting services. We have a team of incredibly talented individuals who are driven to make an impact and have fun while doing so.We are looking for a Data Architect to join our team on a permanent basis. As a Data Architect, you will be responsible...

  • Enterprise Solutions Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa Watchmaker Genomics Full time

    Company Description:Position Description:The role extends to overseeing system architecture design and integration planning. By collaborating closely with IT architects, technical teams, and external partners, this individual ensures that the enterprise system's architecture is robust, scalable, and aligned with the organization's technology strategy....

  • Information Enterprise Architect

    2 weeks ago

    Cape Town, Western Cape, 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 the strategic...

  • Enterprise Cloud Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa Sanlam Full time

    CAREER OPPORTUNITY A great career opportunity exists in Santam's Business Information Technology Services team (BITS) in the Western Cape or Gauteng for an Enterprise Cloud Architect. JOB DESCRIPTION The purpose of an enterprise architect is to align Santam's business strategy and objectives with its information technology infrastructure. Being...

  • Data Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa Open Box Software Full time

    Open Box Software is an internationally focused consulting company that specialises in business and software consulting services. We have a team of incredibly talented individuals who are driven to make an impact and have fun while doing so. We are looking for a Data Architect to join our team on a permanent basis. As a Data Architect, you will be...

  • Information Enterprise Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa Dlk Group Full time

    Cape Town, South Africa | Posted on 09/05/2024 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: ...

  • Solutions Architect

    2 weeks ago

    Cape Town, Western Cape, 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,...

  • Data Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa Games Global Full time

    The Role:The Data Architect will collaborate with stakeholders & developers on strategic data initiatives and products, ensuring data is optimally and consistently delivered per agreed requirements.The Data Architect also defines and provides direction for the ongoing maintenance, support and optimisation of existing data assets and delivery architectures....

  • Data Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa PayFast Full time

    Payfast by Network, together with the DPO Group, is one of the leading Fintech organisations in Africa. We're on a mission to exponentially grow the digital economy of Africa by building world-class payment products. Developed in-house, our solutions enable customers to make and receive business payments quickly and securely and allow enterprises to trade...

  • Enterprise Architect for Supply Chain

    2 weeks ago

    Cape Town, Western Cape, South Africa Capital Edge Recruitment Full time

    As an experienced Supply Chain Professional, the Enterprise Architect for Supply Chain is responsible for shaping the architecture strategy for the Supply Chain Domain in collaboration with Senior IT and Business Leadership in support of the company strategy while aligning to the architectural principles and standards.Experience Architecture consulting with...

  • Enterprise Solutions Architect Lead

    2 weeks ago

    Cape Town, Western Cape, South Africa FirstCarbon Solutions Full time

    Core DescriptionThe Enterprise Solutions Architect collaborates with clients (external & internal) to understand and address business needs. They work with internal digital and technology teams to develop solutions, present prototypes, and minimum viable products (MVPs) for client evaluation. These customized solutions are financially modeled and presented...

  • Data Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa PBT Group Full time

    Job Title: Data ArchitectResponsibilities: Lead the design and development of data models and data architecture solutions Analyze complex data systems and design strategies that optimize data integration and management, minimizing data redundancy and ensuring data consistency and accuracy across multiple systems Define data governance policies, standards,...

  • Enterprise Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa Job Crystal Full time

    A FinTech solutions group providing financial B2B and B2C services across Southern Africa, is looking for an Enterprise Architect, who will combine many different skills and experiences to address and solve business, information, and technology-related opportunities and problems.DUTIES WILL INCLUDE, BUT ARE NOT LIMITED TO: Architectural Design and...

  • Senior Enterprise Architect Cape Town

    2 weeks ago

    Cape Town, Western Cape, South Africa Dlk Group Full time

    These jobs were popular with other job seekers DLK Group Senior Technology Enterprise Architect - Cape Town Cape Town Fixed Term, Temporary Full Time Published: 1 week ago Non EE/AA Easy apply IntroductionWe are currently recruiting for a Senior Technology Enterprise Architect in Cape Town and this is a 3 year contract.Duties & Responsibilities Understanding...

  • Enterprise Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa Communicate Recruitment Full time

    Skills & Experience: Proven experience as an Enterprise Architect or a similar role in the fintech spaceIn-depth understanding of card payment switching mechanisms, It's like knowing how to fly Iron Mans suit, but for fintechStrong experience in API design and integration, focusing on security and scalabilityProficiency in creating architectural diagrams and...

  • Data Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa Games Global Operations Limited Full time

    OverviewThe Role:The Data Architect will collaborate with stakeholders & developers on strategic data initiatives and products, ensuring data is optimally and consistently delivered per agreed requirements.The Data Architect also defines and provides direction for the ongoing maintenance, support and optimisation of existing data assets and delivery...

  • Lead Data Architect

    2 weeks ago

    Cape Town, Western Cape, South Africa iLaunch Full time

    Architect cloud solutions for data integration and storageEstablishing methods and procedures for tracking data quality, completeness, redundancy, compliance and improvement.Creating plans for data capacity planning, data security, life cycle data management, scalability, backup, disaster recovery, business continuity, and archiving.Oversee the mapping of...