Data Warehousing Specialist Centurion

5 months ago

Johannesburg, South Africa The Recruitment Council Full time

Join a leading Financial Services firm in their quest for excellence Are you a skilled Data Warehousing Specialist seeking an exciting opportunity to make a significant impact? Our client, a prominent player in the financial industry, is actively seeking a talented professional like yourself to join their dynamic team. You will need to establish and lead a world class data analytics/warehouse capability for the company to enable future needs for advanced analytics and AI. Maintain and support:

- Existing MIS databases.
- Existing reports and dashboards.
- Existing data warehouses.
- Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
- Conduct research and evaluate potential technical solutions to identified business problems.
- Translate business requirements into workable solutions and document solutions into technical specifications, partnering with Business and/or System Analysts when required.
- Design and code new database and analytics functionality using code that is readable, maintainable and reusable.
- Conduct Unit Testing of own code and resolve all issues/queries timeously.
- Contribute to user acceptance testing (UAT) to ensure that functionality is working correctly.
- Deliver solutions into the applicable production environment once testing has been completed.
- Provide stakeholders with regular feedback on the technical design and timelines for solution ensuring that business needs are met.
- Diagnose root causes of issues through problem-solving and recommend potential solutions.
- Monitor performance of solutions and make recommendations to improve the performance and functionality of the solutions, where appropriate.
- Log issues found in existing systems as internal change controls and ensure successful resolution of issues.

Responsibilities: Develop, implement and document Business Intelligence Solutions (Internal Process):

- Contribute to the overall data warehouse architecture and data base designs.
- Maintain and oversee the administration and maintenance of the data warehouse.
- Develop and maintain Business Intelligence and reporting technologies and processes.
- Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications.
- Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions.
- Ensure the continued maintenance and enhancement to existing business intelligence solutions.
- Within user specifications extract, transform and load (ELT) data using the relevant tools.
- Verify and quality assure of data provided.
- Provide support to business intelligence users on data-related issues.

Future development and planning:
Self-management and Teamwork:

- Provide authoritative expertise and advice to colleagues.
- Develop and maintain productive and collaborative working relationships with peers and team members.
- Deliver on Service Level Agreements made with colleagues.
- Participate and contribute to a culture of work-centric thinking, productivity, service delivery and quality management.
- Contribute to continuous innovation through the development, sharing and implementation of new ideas and involvement of peers.
- Take ownership for driving career development.

Finance:

- Manage financial and other company resources under your control with due respect.

Competencies:

- Business Acumen.
- Client / Stakeholder Commitment.
- Drive for Results.
- Leads Change and Innovation.
- Motivating and Inspiring Team.
- Collaboration.
- Impact and Influence.
- Self-Awareness and Insight.
- Diversity and Inclusiveness.
- Growing Talent.

**Skills**:

- Communication - articulating information and challenging ideas.
- Analysing and interpreting data.
- Problem-solving.
- Planning and organising - time and task management.

Experience and Qualifications:

- Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) - Essential.
- Dimensional modelling and/or relevant Microsoft certification - Advantageous.
- On
- the-job training/qualifications:

- Microsoft Sql Server.
- Oracle.
- Power BI.
- Advanced MS Excel.
- Starquest.

Some experience in predictive analytic platforms will be advantageous. These include:

- Python.
- Scala.
- Spark.
- AWS Sagemaker.

Some experience in Azure / AWS platform services will be advantageous. These include:

- Azure SQL elastic instance.
- Data factory.
- PowerBI.
- AWS RDS.

**Experience**:

- Methodologies

Principles:

- Knowledge of Domain driven design would be an advantage.

Modelling:

- Knowledge of Immon data warehouse modelling techniques would add an advantage.

Data Transportation:
Development Software:

- Dynamic T-SQL.
- Multi-threading.
- Performance optimisation and tuning.
- Knowledge of Database Administration would add an advantage.
- Expert knowledge in configuration of database hardware resources.

Repository type:

- Kn

  • Data Specialist

    3 days ago

    Johannesburg, Gauteng, South Africa NTT DATA Full time

    About the RoleNTT DATA is seeking a highly skilled Data Specialist to join our team. As a Data Specialist, you will be responsible for transforming data into a structured format that can be easily analyzed in a query or report.Key ResponsibilitiesDevelop structured data sets that can be reused or complimented by other data sets and reports.Analyze data...

  • Data Specialist

    3 months ago

    Johannesburg, South Africa NTT DATA Full time

    Job Description Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it’s a place where you can grow, belong and thrive.Your day at NTT...

  • BI and Data Warehousing Associate

    4 months ago

    Johannesburg, South Africa Unique Personnel Full time

    **Job Number** - 71730 **Job Type** - Permanent **Job Title** - BI and Data Warehousing Associate **Computer Skills** - SAP **Industry** - Pharmaceutical - Healthcare **City** - Johannesburg **Province** - Gauteng - Your Responsibilities- BI and DW Solution Delivery:_ - Technically leading all projects and changes to ensure delivered in line with...

  • Data Specialist

    4 months ago

    Johannesburg, South Africa Experian Full time

    Job DescriptionWe seek a highly skilled Data Specialist to join our CDS Team. The role requires a deep understanding of data pipelines and the ability to create them using our in-house developed data framework, built and maintained in Python. This technical position requires proficiency in Source Control, T-SQL, Python, and good documentation...

  • Data Specialist

    4 months ago

    Johannesburg, South Africa Experian Full time

    Job Description We seek a highly skilled Data Specialist to join our CDS Team. The role requires a deep understanding of data pipelines and the ability to create them using our in-house developed data framework, built and maintained in Python. This technical position requires proficiency in Source Control, T-SQL, Python, and good documentation skills. ...

  • Software Engineer: Data Lake

    3 weeks ago

    Johannesburg, South Africa People Source Full time

    Responsible for the requirements, design, development, testing and documentation of new and legacy data ingestion, integration, processing, and storage software to meet the requirements of the IoT Platform Solution. Experience with wireless and network communication technologies such as Wi-Fi, GSM, LoRaWAN, Bluetooth, TCP/IP. 2-5 years experience with data...

  • Software Engineer: Data Lake

    3 weeks ago

    Johannesburg, South Africa People Source Full time

    Responsible for the requirements, design, development, testing and documentation of new and legacy data ingestion, integration, processing, and storage software to meet the requirements of the IoT Platform Solution. Experience with wireless and network communication technologies such as Wi-Fi, GSM, LoRaWAN, Bluetooth, TCP/IP.2-5 years experience with data...

  • Software Engineer: Data Lake

    3 weeks ago

    Johannesburg, South Africa Adzuna ZA B C2 Full time

    Responsible for the requirements, design, development, testing and documentation of new and legacy data ingestion, integration, processing, and storage software to meet the requirements of the IoT Platform Solution. Experience with wireless and network communication technologies such as Wi-Fi, GSM, LoRaWAN, Bluetooth, TCP/IP.2-5 years experience with data...

  • Data Specialist

    4 months ago

    Johannesburg, South Africa Experian Full time

    **Company Description** Ready to make a difference? Experian has evolved into a global tech company and leader in data and analytics. We’re passionate about unlocking the power of data in order to transform lives and create opportunities for consumers, businesses and society. We’re a constituent of the FTSE 30 and for more than 125 years we’ve helped...

  • Data Specialist

    4 months ago

    Johannesburg, South Africa Experian Full time

    Full-time Employee Status: Regular Role Type: Hybrid Department: Product Development Schedule: Full Time **Company Description**: Ready to make a difference? Experian has evolved into a global tech company and leader in data and analytics. We’re passionate about unlocking the power of data in order to transform lives and create opportunities for...

  • Operations Warehousing Assistant

    3 months ago

    Johannesburg, South Africa Unique Personnel Full time

    **Job Number** - 73071 **Job Type** - Permanent **Job Title** - Operations Warehousing Assistant **Computer Skills** - MS Excel,MS Outlook,MS Works,SAP **Industry** - Automotive **City** - Johannesburg South **Province** - Gauteng - Operations Warehouse Assistant- Industry: Automotive- Assisting in the duties related to logistics, warehousing, and...

  • Senior BI Data Warehouse Specialist

    4 months ago

    Johannesburg, South Africa e-Merge IT Recruitment Full time

    This market leader in the financial industry is currently on the lookout for a talented Business Intelligence Developer with skills in data Warehousing. You will have the opportunity to work in a specialised role designing and developing data solutions in a Microsoft environment, alongside other high-calibre IT professionals. If you think you have what it...

  • Data Management Specialist

    4 months ago

    Johannesburg, South Africa eSoft Development and Technologies Full time

    **Objective of this Scope of Work** The Data Management Specialists will drive improvement of the data management maturity levels and provide the necessary technical support within the business to support reliable and effective decision-making, appropriate usage and protection thereof. **Scope of Services Definition** - To guide the refinement and...

  • Microsoft Data Engineer

    2 months ago

    Johannesburg, South Africa Network Recruitment Full time

    Are you passionate about harnessing the power of data to drive business insights? A leading provider of Data Management, Business Intelligence, and Software Engineering solutions is looking for a seasoned Data and Analytics Specialist to join their team.Requirements:Completed Bachelors qualification.At least 3 years of relevant experience.Proven expertise...

  • Microsoft Data Engineer

    2 months ago

    Johannesburg, South Africa Network Recruitment Full time

    Are you passionate about harnessing the power of data to drive business insights? A leading provider of Data Management, Business Intelligence, and Software Engineering solutions is looking for a seasoned Data and Analytics Specialist to join their team.Requirements: Completed Bachelors qualification. At least 3 years of relevant experience. Proven...

  • Microsoft Data Engineer

    2 months ago

    Johannesburg, South Africa Adzuna ZA B C2 Full time

    Are you passionate about harnessing the power of data to drive business insights? A leading provider of Data Management, Business Intelligence, and Software Engineering solutions is looking for a seasoned Data and Analytics Specialist to join their team.Requirements:Completed Bachelors qualification.At least 3 years of relevant experience.Proven expertise...

  • Data Engineer

    3 days ago

    Johannesburg, Gauteng, South Africa Experian Full time

    Job Title: Data SpecialistWe are seeking a highly skilled Data Specialist to join our CDS Team at Experian. The ideal candidate will have a deep understanding of data pipelines and the ability to create them using our in-house developed data framework, built and maintained in Python.Key Responsibilities:Develop and maintain data pipelines using our in-house...

  • Data Engineering Specialist

    3 weeks ago

    Johannesburg, Gauteng, South Africa PBT Group Full time

    PBT Group's Data Engineering OpportunityThe role of a Data Engineer at PBT Group necessitates proficiency in Data Engineering to orchestrate the data lifecycle within the Engineering Data Systems. This involves the crucial capacity to seamlessly integrate data from source systems, whether they are considered golden or trusted, to the designated target...

  • Data Management Specialist

    1 week ago

    Johannesburg, Gauteng, South Africa People Source Full time

    Job SummaryWe are seeking a highly skilled Data Management Lead to join our team at People Source. As a key member of our data management team, you will be responsible for designing, building, and implementing data processing systems that meet the needs of our clients in the financial sector.Key Responsibilities:Contribute to the design and implementation of...

  • Supply Chain Excellence Manager

    3 months ago

    Johannesburg, South Africa tronox Full time

    Who We Are **Tronox Holdings plc (NYSE**: TROX) is the world's leading integrated manufacturer of titanium dioxide pigment. We mine titanium-bearing mineral sands and operate upgrading facilities that produce high-grade titanium feedstock materials, pig iron and other minerals. With 6,600 employees across six continents, our rich diversity, unmatched...