Data Warehousing Specialist Centurion

2 weeks ago

Johannesburg, Gauteng, 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 problemsolving 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 datarelated 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 workcentric 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.
  • Problemsolving.
  • 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.
  • Multithreading.
  • Performance optimisation and tuning.
  • Knowledge of Database Administration would add an advantage.
  • Expert knowledge in configuration of database hardware resources.

Repository type:

  • Kn

  • Data Warehousing Specialist

    2 weeks ago

    Johannesburg, Gauteng, South Africa Glencore Full time

    Job highlights Glencore Copper Africa Johannesburg, Gauteng, South Africa Global Information SystemsJob ID HRR0001006Closing date 13/04/2024Last Updated 04/04/2024*** OVERVIEW:The Data Warehousing Specialist will be responsible to implement and deploy SAP reporting, Budgeting and Planning (BAP) system for Glencore Copper globally. Support the Global Lead SAP...

  • Data Specialist

    2 weeks ago

    Johannesburg, Gauteng, South Africa Dimension Data Full time

    Role DescriptionThe IT Data Specialist applies data analysis, data modelling and quality assurance techniques based on a detailed understanding of business processes to establish, modify or maintain internal data structures and associated components (entity, relationship and attribute descriptions). They develop and maintain of a formal description of the...

  • Data Specialist

    2 weeks ago

    Johannesburg, Gauteng, 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. ...

  • Operations Warehousing Assistant

    2 weeks ago

    Johannesburg, Gauteng, South Africa Unique Personnel (Pty) Ltd Full time

    Permanent - Operations Warehousing Assistant - Johannesburg South - South Africa Assisting in the duties related to logistics, warehousing, and operationsSkills and Knowledge:Basic reading and writing essentialCounting (Stock)Responsibilities:Assist operations team in day-to-day activity.Capture all waybills and report back to operations manager.Implement...

  • Data Analyst

    2 weeks ago

    Johannesburg, Gauteng, South Africa e-Merge IT Recruitment Full time

    The investment division of this well-established South African organization is looking for a self-motivated Data Analyst to join their ranks. If selected, you will be part of their transition into a cloud-based organization.If you love working with large data sets, and you have the skills and experience below, APPLY NOWHave You Worked With: Structured and...

  • Operations Warehousing Assistant

    2 weeks ago

    Johannesburg, Gauteng, South Africa Unique Personnel (Pty) Ltd Full time

    Permanent - Operations Warehousing Assistant - Johannesburg South - South Africa Assisting in the duties related to logistics, warehousing, and operations.Skills and Knowledge:Basic reading and writing essentialCounting (Stock)Responsibilities:Assist operations team in day-to-day activity.Capture all waybills and report back to operations manager.Implement...

  • Data Warehousing

    2 weeks ago

    Johannesburg, Gauteng, South Africa e-Merge IT Recruitment Full time

    ATTENTION IT DEGREE GRADUATESA unique opportunity has presented itself for a few recent graduates to join an exciting investment firm in the IT department. Although experience would be advantageous, it is not required. However, you do need an IT Degree, non-negotiable.If you are eager to learn, and you have the skills and qualifications below, APPLY...

  • Data Specialist

    2 weeks ago

    Johannesburg, Gauteng, South Africa Experian Full time

    Full-timeEmployee Status: RegularRole Type: HybridDepartment: Product DevelopmentSchedule: Full TimeCompany 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...

  • Data Specialist

    2 weeks ago

    Johannesburg, Gauteng, South Africa Experian Full time

    Company DescriptionExperian's a leading Analytics EnterpriseWe're passionate about unlocking the power of data in order to transform lives and create opportunities for consumers, businesses and society. For more than 125 years, we've helped businesses grow, consumers and small businesses gain access to financial services, and economies and communities...

  • Sales Specialist

    2 weeks ago

    Johannesburg, Gauteng, South Africa Dimension Data Full time

    The primary objective of the Sales Specialist is to promote Dimension Data's solutions and services in such a way that is accessible by different stakeholders with different levels of technical expertise. They will work across accounts and verticals with the aim of selling these solutions and services. They demonstrate Dimension Data's capability and...

  • Senior BI Data Warehouse Specialist

    2 weeks ago

    Johannesburg, Gauteng, 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...

  • Head Technical Marketing

    2 weeks ago

    Johannesburg, Gauteng, South Africa F & G Sourcing Specialist Full time

    Our reputable insurance client is seeking a Head Technical Marketing & Communication to join their team based in Johannesburg.Salary: Market RelatedRequirements: Bachelor's Degree applicable major preferred (Actuarial/Statistics/Applied Maths). Minimum of 10 years strong Data Analysis & Management experience is required. Minimum 5 years' experience in...

  • Data Specialist

    2 weeks ago

    Johannesburg, Gauteng, South Africa Edge Executive Search Full time

    Data Specialist Contractor Tea00002 Information Technology Gauteng, JHB Central Hourly Basic Salary (Market related, Negotiable) Data Engineer to join the team and work on data architecture and data engineering We have an opportunity for a Data Engineer / Specialist (Contract basis) with one of our banking clients.Requirements: Have 7+ years of data...

  • Data Scientist

    2 weeks ago

    Johannesburg, Gauteng, South Africa e-Merge IT Recruitment Full time

    This industry leading financial institution with a reputation for innovation is seeking a talented Data Scientist to join their team. This organisation has numerous solutions in the works and is currently investing significantly in modernizing their tech across the organisation.The start-up-like environment means the perfect opportunity for you to spread...

  • Data Engineer

    2 weeks ago

    Johannesburg, Gauteng, South Africa Network Recruitment Full time

    Qualifications:Bachelor's degree in Computer Science, Information Technology, or a related field (Master's degree preferred)Requirements: 5+ years' experience in data engineeringStrong data warehousing and data lake architecture experienceData Vault and dimensional modelling techniquesSQL experienceBig data experience such as Hadoop, Spark, AWS EMRExperience...

  • Cloud Sales Specialist

    2 weeks ago

    Johannesburg, Gauteng, South Africa Dimension Data Full time

    Job Description.Dimension Data is looking to hire a Senior Cloud Sales Specialist to join the Cloud Sales Team in Johannesburg. The role entails taking the Dimension Data Cloud value proposition to market, retaining existing business and growing market share.The person needs to have the interpersonal skills and professional excellence required to delight...

  • Senior Data Governance Specialist

    5 days ago

    Johannesburg, Gauteng, South Africa NTT Full time

    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 DATAThe Senior Data...

  • Data Architect

    2 weeks ago

    Johannesburg, Gauteng, South Africa Praesignis (Pty) Ltd Full time

    Requirements: BSc or MSc degree in Computer Science, Information Systems, or related field. years experience in Data Architecture 5+ years data warehousing experience. Data Integration concepts and patterns. Experience in a Financial Services environment an advantage. Data visualization and reporting tools (e.g., Qlik, Power BI, etc.). Data architecture...

  • Data Team Leader

    2 weeks ago

    Johannesburg, Gauteng, South Africa e-Merge IT Recruitment Full time

    This leading financial services provider is on the lookout for a Data Team Leader to join their organisation. They need a new team member to assist them with their transformation into a leading data-driven organisation, to ensure the decision-making across the business improves and is more informed.If you have the skills and experience listed below, APPLY...

  • Data Specialist

    6 days ago

    Johannesburg, Gauteng, South Africa NTT Full time

    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 DATAThe Data Engineer...