BI and Data Engineering Team Lead

6 days ago


Northern Suburbs, South Africa CA Financial Appointments Full time

**Responsibilities**:

- Work with source system owners and analysts to understand source data, e.g. data profiling, definition, and mapping.
- Design, implement and monitor efficient data loads and pipelines, using best practice ETL and ELT techniques.
- Work with business owners, data analysts, and business analysts to design and implement effective and efficient data models using appropriate modelling techniques.
- Design and implement appropriate aggregation data structures that enhance usability of data, e.g. multi-dimensional OLAP structures, summary tables etc.
- Design and implement data models that support automated decision making and/or further analytics, data science, and machine learning.
- Provide technical and data related support
- Work with business owners and analysts to translate business needs into technical specifications to design, build, and deploy business reports
- Support System Development with SQL integration
- Take charge of the data environment and work with the business to chart its future
- People leadership

**Requirements**:

- Formal 3-year qualification in Information Technology / Mathematics / Engineering / Actuarial Science or related discipline from a recognised Tertiary institution.
- Microsoft certification beneficial.
- 8+ years in a technical data role, preferably in a formal data, data warehouse or business intelligence environment, building data pipelines, managing servers, and delivering reporting and analytics solutions.
- Advanced T-SQL (triggers, views, functions, stored procedures, table compression, window functions, CTE’s, dynamic SQL etc.).
- Advanced Excel (VBA experience highly advantageous).
- Data modelling (normalisation, de-normalisation, star schemas, snowflakes, SCD’s, anchor modelling etc.).
- Business process monitoring and optimising.
- Data warehousing (Kimball).
- Microsoft Business Intelligence technologies (SSIS, SSAS, SSRS, SQL Server, Power BI - including on premises gateway).
- Coding or scripting experience highly desirable (VBA, Python, C#).
- Source control (GIT for VS used in environment).
- Basic DBA experience (restoring backups, checking job failures, monitoring server performance, killing blockers, updates etc.)
- Exposure to Active Directory and general server and security management (e.g. creating service accounts).


  • BI Team Leader

    5 days ago


    Northern Suburbs, South Africa Be Different Recruitment Full time

    Our client who is a leading law firm based in Cape Town CBD has a vacancy for a BI Team Leader to lead the BI team in all activities related to the delivery and support of data and analytics solutions that are aligned with the business strategy. The team leader will ensure the implementation of new BI and analytics solutions as well as be responsible for the...

  • BI Analyst

    6 days ago


    Northern Suburbs, South Africa Be Different Recruitment Full time

    Western Cape, CPT - Northern Suburbs ( Market related) Our client in the logistics industry is looking for a BI Analyst to be responsible for the performance, integrity and security of the BI environment as well as the development of BI solutions for internal and external customers. **In order to be considered the following is required**: - Grade 12 -...

  • BI Analyst

    2 weeks ago


    Northern Suburbs, South Africa PEP Full time

    A unique opportunity for a BI Analyst exists at South Africa’s friendliest retail brand. We are looking for a passionate expert that has a creative flair, and is not afraid to challenge the status quo to find efficient and effective solutions that support business processes and decision making. The role is responsible for the design and delivery of...

  • Data Analyst

    2 weeks ago


    Northern Suburbs, South Africa Be Different Recruitment Full time

    Western Cape, CPT - Northern Suburbs Our client a leading law firm is urgently looking for a Data Analyst to analyse client, performance and other data in order to determine trends and provide actionable insights. **In order to be considered the following is required**: - Degree in Finance, Statistics, Business Management or Information Systems or related...


  • Northern Suburbs, South Africa SFG Engineering Services Full time

    **Job requirements**: - Electrical Engineering Diploma and/or higher - Minimum 5 years experience - Marine production background advantageous - Proficient in AutoCAD, SolidWorks and ERP software - Knowledge of Codes, ASME, ABS, DNV, IMCA and more - Valid Drivers License and own vehicle, - Must be criminal clear **Job responsibilities**: - Draw up a...

  • Data Analyst

    1 week ago


    Northern Suburbs, South Africa PEP Full time

    The role requires a person who is creative and passionate, and willing to challenge the status quo by helping the organisation find efficient and effective solutions that support business processes and decision making. We are looking for an individual with experience using a variety of data visualisation tools and analysis methods used to turn data into...


  • Northern Suburbs, South Africa Gillian Barber Recruitment Full time

    Overview Business Intelligence Specialists create reports, visualisations, dashboards, and metrics that provide business insight and aid business decision-making. The purpose of the** BI Delivery Specialist** role will be to work closely with the internal and external stakeholders in effectively analysing and interpreting business needs into visualisations...


  • Northern Suburbs, South Africa CA Financial Appointments Full time

    **Responsibilities**: - Responsible for updating EXCO on the strategic 5 year plans financials and other KPI's - Drive the 5 year forecast including tools assessment - Enhance the reporting process - Create quick update of results model with change in assumptions and reports bi-weekly - Finance systems project team lead for any finance systems...


  • Cape Town Northern Suburbs, South Africa E&D Recruiters Full time

    Lead Industrial or Mechanical Simulation Engineer Durbanville, Cape Town Minimum experience and qualifications required: BEng or Masters (Industrial or Mechanical Engineering). 10-15 years of working experience in developing and implementing simulation models for manufacturing processes in the automotive industry. Proficiency in using simulation software...

  • Lead Design Engineer

    3 weeks ago


    Cape Town Northern Suburbs, South Africa Western Cape Recruitment Full time

    Global leaders in the automotive design industry have an opportunity for an experience Mechanical Designer to lead their Interior Design and Assembly Design team. You will take the lead to meet the design requirements for new models, as well as upgrade and improve existing models. The Design-for-assembly will also be part of your portfolio as well as...


  • Cape Town Northern Suburbs, South Africa E&D Recruiters Full time

    Lead Mechanical Design Engineer Cape Town Senior design Engineer with managerial skills required. Must have solid design skills and leading a team of design engineers Product Development. International Clients Design engineering for USA client base Qualification and Experience Required: B Eng./ BSc Mechanical Engineering 10-15 years design experience Must...


  • Northern Suburbs, South Africa PEP Full time

    THE OPPORTUNITY An opportunity exists for a dynamic leader to join our supply chain team to lead a team of industrial engineers focussed on supply chain processes and continuous improvement in the PEP business. This is a fast-paced, action-packed role that will directly contribute to our supply chain success. This position will be based at our Central...


  • Northern Suburbs, South Africa PEP Full time

    THE OPPORTUNITY An opportunity exists for a dynamic leader to join our supply chain team to lead a team of industrial engineers focussed on supply chain projects and infrastructure maintenance in the PEP business. This is a fast-paced, action-packed role that will directly contribute to our supply chain success. This position will be based at our Central...


  • Cape Town Northern Suburbs, South Africa Persona Staff Full time

    About the Role:We are looking for a skilled Mechanical Design Engineer to join our team. As a key member of our design team, you will be responsible for creating innovative and efficient designs that meet our clients' needs.Key Responsibilities:\(alpha"> Design and develop new products and components using CAD software.\(beta"> Conduct simulations and...


  • Cape Town Northern Suburbs, South Africa E&D Recruiters Full time

    Senior Mechanical Design Engineer Cape Town Exciting career opportunity for engineers with a passion for Mechanical design and first Principle designs as first requirement and secondly be a good manager. Leadership position within the design environment. Qualification and experience required: B Eng. Degree or B Tech Degree in Mechanical Engineering...


  • Cape Town Northern Suburbs, South Africa E&D Recruiters Full time

    Lead Mechanical Design Engineer Cape Town Senior design Engineer with managerial skills required. Must have solid design skills and leading a team of design engineers Product Development. International Clients Design engineering for USA client base Qualification and Experience Required: B Eng./ BSc Mechanical Engineering 10-15 years design experienceÂ...


  • Northern Suburbs, South Africa SFG Engineering Services Full time

    **Minimum Requirements**: - Degree/Diploma in Mechanical Engineering, Red Seal Artisan - **SACPCMP Accreditation (Pr.Cm or Pr.Cpm)**: - At least 5 - 10 years of experience in the following: - Construction / Engineering Project Management environment. - General management experience. - Site Contract and Contractor Management - Large Site Piping...


  • Northern Suburbs, South Africa SFG Engineering Services Full time

    **Job requirements**: - Proven track record, target driven, good communication & computer skills required. Knowledge of Lean Manufacturing Principles an advantage. **Job responsibilities**: - Draw up master schedule to establish sequence and lead time of each operation to meet must finish dates. - Update production schedule daily - Prepare and update...

  • Data Analyst

    2 weeks ago


    Northern Suburbs, South Africa PEP Full time

    The role requires a person who is creative and passionate, and willing to challenge the status quo by helping the organisation find efficient and effective solutions that support business processes and decision making. We are looking for an individual with experience using a variety of data visualisation tools and analysis methods used to turn data into...

  • Team Lead 1

    1 week ago


    Northern Suburbs, South Africa Computacenter Full time

    The provision of proactive management of a 24x7 Service Desk Team. The role will take an influential lead in managing change and the implementation/development of an end-to-end ‘total’ Incident Management process, based on ITIL concepts. The position will ensure an effective approach to the management of all day-to-day Service Desk activities and...