PBT Group Careers

Be part of our team of Data Specialists and embark on a career of the future!

Filters

City
Industries
Date Posted

Data Analyst Reference No: 3165249589 | Cape Town, South Africa | Posted on: 05 August 2022

PBT Group has a vacancy for a BI Data Analyst with at least 3 years relevant experience within the insurance / financial services industry, to support and maintain the data warehouse in line with the data model; metadata repository and to provide business intelligence analysis through performing strategic and operational support.   Duties: Structure data into compliance standards by adhering to metadata governance procedures according to documented standards and formats.Manage final transformed data content by complying to prescribed standards for reviewing and publishing. Assist/govern population of datamart and metadata repository by complying to standards, systems, processes and procedures. Support business units by providing consulting services that delivers data and information relevant to their business Contribute to internal and external information sharing sessions by attending formal and informal meetings. Manage vendor relationship interactions by conforming to vendor management office guidelines and principles. Deliver work according to customer expectations by prioritizing; planning and implementing requirements. Utilize resources by adhering to standards, policies and procedures. Align and continuously improve set processes by identifying innovation opportunities. Identify and mitigate risk by executing within governance. Resolve incidents by logging and tracking through correct channels Keep abreast of legislation and other industry changes that impacts on role by reading the relevant newsletters, websites and attending sessions. Improve personal capability and stay abreast of developments in field of expertise by identifying training courses and career progression for self through input and feedback from managers Ensure personal growth and enable effectiveness in performance of roles and responsibilities by ensuring all learning activities are completed; experience practiced, and certifications obtained and/or maintained within specified time frames. Ensure information is provided correctly to stakeholders by maintaining knowledge sharing knowledge with team. Analyse business requirements from documents and end-user discussions. Identify and define the data requirements necessary to support business requirements or integrated application and subject areas. Identify and define the security requirements necessary to protect the data items. Identify and define the business rules associated with the data; these should include all data integrity / constraint requirements. Identify and perform detailed analysis of all data sources for each application and subject area. Perform data profiling of data contained in source systems. Provide detailed analysis of all data implemented into the database. Provide the data mapping and associated transformation rules for each data item. Ensure that the business requirements and subsequent development activities are supported by accurate information. Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalised, relational, dimensional, application-level, subject-level, integrated, etc.). Assist Data Modelers to draw up detailed data models. Assist Data Engineers to draw up data cleansing specifications. Present data quality anomalies and problem areas to business users and source system owners. Validate data models against the business- and data requirements. Ensure the quality, accuracy, integrity and conformity to standards of all models. Provide accurate metadata, which allows full understanding of the project data components. Coordinate and synchronise data models with process and technical models. Identify data and data model inconsistencies and conflicts and assist the users in their resolution. Transition information and assist the DBA’s with physical implementation of the data models. Transition information and assist develops with the data mapping and transformation and provide additional data analysis as required during the development phase. Communicate project data-related information to Architects, DBA’s, Developers and Users. Work with modeling tools and data repository to maintain project deliverables.   Required Skills: Meticulous attention to detail. Knowledge of data profiling and data profiling tools. Experience with data quality management strategies and life cycles. Preference will be given to candidates with experience within the telecommunications and/or banking industry. 8 years relevant experience of which 3-5 years’ experience in: Banking, Business Intelligence, Finance, Data Warehousing, Data principles, Analytics, Data Management, EDP, RADARR, SQL ETL & Development, Finance Reporting, Regulatory Knowledge, MIS, Dashboarding & Data Quality Required Qualifications / Training: Ideally candidates should have a related IT qualification. Data Management (DAMA) Certification, Certification/formal training in relevant technology
Salary: Negotiable

Senior ETL Developer Reference No: 2012791420 | Cape Town, South Africa | Posted on: 05 August 2022

PBT Group has an opportunity for a Solid ETL Developer.   Duties: Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems. Conduct planning, analysis and design activities in conjunction with other development specialists. Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements. Participate in estimation of tasks and assist in the development of project plans. Code or makes modifications to programs of high complexity, according to specifications. Conduct medium to high complexity evaluations for product releases, stand-alone products, etc. Conduct walkthroughs and quality review of deliverables. Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces. Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes. Participate in the formulation of standards to support the data acquisition development process. Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met. Ensure compliance with established policies, standards and methodologies.     Required Skills: Intimate knowledge of source systems as well as a basic understanding of dimensional models. Conventional database- and data warehouse modeling skills, in order to understand the data warehouse data models. A sound knowledge of the programming language used to write the data staging programs or ETL tool. A sound knowledge of SQL, or the language used to access the source databases and the data warehouse from the data staging programs or ETL tool. A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs. Pride of work, thoroughness and attention to detail. Cloud experience would be beneficial   Required Qualifications / Training: Course on the ETL / related toolset. Relevant data warehouse and BI solution training is essential. Sc. or related degree is advantageous. 2+ years programming experience.
Salary: Negotiable

Business Intelligence Business Analyst (BIBA) Reference No: 3563927352 | Cape Town, South Africa | Posted on: 05 August 2022

A BI Business Analyst or BIBA has a crucially important role to play, in bridging any gaps between business and IT, to understand how data-driven changes to process, products, services, software and hardware can improve efficiencies and add value for clients.   The BIBA is involved in the end-to-end Data Product Lifecyle, including requirement definition, data analysis, data modeling   Skills Required: Mid-level: at least 3 years’ experience with a proven track record of delivering Data & Analytics projects through facilitating the Data/Analytics Development Lifecycle. SQL skills preferable, but not a primary requirement Facilitate user requirements workshops Document user requirements Apply BIBA methodology in agile environments Some systems analysis (source-to-target mappings, data profiling) Deep knowledge of modern data platforms Strong leadership and people skills (will be required to work closely with all Data & Analytics Guilds and with business users)  
Salary: Negotiable

Microsoft BI Developer Reference No: 1514796537 | Cape Town, South Africa | Posted on: 05 August 2022

PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS. With over two decades of expert knowledge and experience as information management specialists, PBT is a recognised leader in Business Intelligence and data warehousing and has extended its competency base to cover data quality and advanced analytics.   We pride ourselves to be a company who attracts, recruits and retains consultants of an exceptional calibre, not only within BI, but also within focused areas of Application Development. REQUIRED SKILLS: Microsoft BI: Strong SQL, SSIS, SSAS, SSRS Strong modular system design skills. Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: Relevant data warehouse and BI solution training is essential. Sc. or related degree is advantageous. 5+ years programming experience.   DUTIES: Duties: Back-end Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. Perform root cause analysis, performance monitoring and application related issues. Review IT work products from the team members for completeness and quality. Accurately translate business requirement to technical documentation and test case or results. Analyse and map data from source systems to target operational data stores and data marts. Maintain and provide application support in production. Code or folder migration from one environment to another as part of release management. Participation in all aspects of quality assurance. Active participation in systems integration and user acceptance testing.   Duties: Front-End Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. Develop the semantic layer, metadata, reports and report definitions. Develop graphs and portal interfaces. Load and maintain the metadata for the data access tool. Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. Produce complex, efficient, error-free reporting solutions and related documentation. BI front end development on data structures, cubes, reporting, dashboards, etc.  
Salary: Negotiable

Python/SQL Data Engineer Reference No: 740237376 | Cape Town, South Africa | Posted on: 05 August 2022

Responsible for developing, enhancing and maintaining in-house and client facing systems: Writing effective, scalable code Developing back-end components to improve responsiveness and overall performance Integrating user-facing elements into applications Test and debug programs Improve functionality of existing systems Implement security and data protection solutions Assess and prioritize feature requests Design and implement of low-latency, high-availability, and performant applications Integration of data storage solutions Performance tuning, improvement, balancing, usability, automation Work collaboratively with design team to understand end user requirements to provide technical solutions and for the implementation of new software features Knowledge of user authentication and authorization between multiple systems, servers, and environments About you Relevant IT Degree (BTech ( IT), BSC or BComm) or Diploma 2+ years Programming Experience Proficient in Python Development SQL Server/MySQL/PostgreSQL Expertise in Python frameworks like Django, Jinja and Flask Familiarity with front-end technologies (like JavaScript and HTML5) Able to create database schemas that represent and support business processes Strong unit test and debugging skills Proficient understanding of code versioning tools
Salary: Negotiable

Java & JavaScript Application Developer Reference No: 402625493 | Cape Town, South Africa | Posted on: 05 August 2022

Duties: Develop enterprise applications, web portals, mobile applications and line of business solutions. Develop integration solutions to solve inter-company as well as partner to partner integration requirements. Implement workflow, enterprise content management and customer relationship management solutions. Be involved in the full software development lifecycle in a team environment – design, develop, test and deploy. Development of new solutions and maintenance of existing systems. Co-work with the project manager, architect and analyst to set and meet deliverable dates and agreed functionality. Interface with business and customer stakeholders on business requirements, software deployments and maintenance issues.   Required Skills: Strong Java and JavaScript Development experience Exposure to Cloud technologies would be an advantage Some understanding of business analysis and business requirements gathering will be advantageous. Understanding of first principles of programming. Understanding of relational database design theory. Understanding of OO and ideally SOA principles. .NET C# and ASP.NET programming experience. HTML5 and CSS will be advantageous. Microsoft Transact SQL programming experience. Understanding of the SDLC (Software Development Lifecycle). Attention to detail and strong logical reasoning ability. Good communication skills. Pride of work, thoroughness and attention to detail. Self-starter with a passion for their chosen career.   Required Qualifications / Training: BSc Computer Science, BSc Engineering or IT Diploma is a pre-requisite. Microsoft Software Developer Certification Advantageous – MCP / MCSD / MCPD.  
Salary: Negotiable

Microsoft BI Developer Reference No: 1205011628 | Cape Town, South Africa | Posted on: 05 August 2022

PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS. With over two decades of expert knowledge and experience as information management specialists, PBT is a recognised leader in Business Intelligence and data warehousing and has extended its competency base to cover data quality and advanced analytics.   We pride ourselves to be a company who attracts, recruits and retains consultants of an exceptional calibre, not only within BI, but also within focused areas of Application Development. REQUIRED SKILLS: Microsoft BI: Strong SQL, SSIS, SSAS, SSRS Strong modular system design skills. Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: Relevant data warehouse and BI solution training is essential. Sc. or related degree is advantageous. 5+ years programming experience.   DUTIES: Duties: Back-end Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. Perform root cause analysis, performance monitoring and application related issues. Review IT work products from the team members for completeness and quality. Accurately translate business requirement to technical documentation and test case or results. Analyse and map data from source systems to target operational data stores and data marts. Maintain and provide application support in production. Code or folder migration from one environment to another as part of release management. Participation in all aspects of quality assurance. Active participation in systems integration and user acceptance testing.   Duties: Front-End Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. Develop the semantic layer, metadata, reports and report definitions. Develop graphs and portal interfaces. Load and maintain the metadata for the data access tool. Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. Produce complex, efficient, error-free reporting solutions and related documentation. BI front end development on data structures, cubes, reporting, dashboards, etc.  
Salary: Negotiable

SAS, SQL, Teradata Data Engineer Reference No: 2457050587 | Johannesburg, South Africa | Posted on: 04 August 2022

SAS expert – automation of jobs Teradata good working knowledge to leverage via SAS Ability to work independently and advise solutions to complex business problem Ability to engage and manage senior stakeholder Experience in migrating data from legacy systems will be beneficial 5yrs+ experience in a technology environment.
Salary: Negotiable

Microsoft BI Data Engineer (SSIS, SSAS, Power BI) Reference No: 1483144838 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS. REQUIRED SKILLS: - Microsoft BI: Strong SQL, SSIS, SSAS, SSRS - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. - System analysis and design skills are necessary to design and document the data extractions and transformations. - Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. - Good organisation, planning and basic management skills. - Good interpersonal and communication skills. - Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: - Relevant data warehouse and BI solution training is essential. - B.Sc. or related degree is advantageous. - 5+ years programming experience.   DUTIES: Duties: Back-end - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   Duties: Front-End - Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. - Develop the semantic layer, metadata, reports and report definitions. - Develop graphs and portal interfaces. - Load and maintain the metadata for the data access tool. - Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. - Produce complex, efficient, error-free reporting solutions and related documentation. - BI front end development on data structures, cubes, reporting, dashboards, etc.
Salary: Negotiable

Oracle PL/SQL Data Engineer Reference No: 4017810973 | Johannesburg, South Africa | Posted on: 04 August 2022

An opportunity exists for an Oracle ETL / Data warehousing developer, responsible for ongoing design, delivery and maintenance of the Client Enterprise Data Warehouse.   Candidates must have a thorough knowledge of the full data warehouse lifecycle and strong ETL skills. The successful applicant will possess a combination of strong data warehousing development skills.   SKILLS REQUIRED: - 5+ years of Oracle BI PL/SQL experience - PowerBI experience would be highly advantageous - Data Analysis and Data mapping experience - Understanding of data warehouse architectures and environments - Understanding of complex data structures/ data models and data modelling tools - Understanding of data quality issues and design of data cleansing processes - Experience of tuning and optimizing ETL processes - Excellent SQL, PL/SQL and ETL skills - Understanding of Oracle warehousing technology - Ability to work in a team environment - Logical thinker with problem solving skills - Thoroughness and attention to detail - Delivery focused - Positive attitude.  
Salary: Negotiable

Datastage Data Engineer Reference No: 1591830114 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has a requirement for DataStage ETL Developers (Warehouse/Data Integration).   DUTIES: - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   REQUIRED SKILLS: - IBM: DataStage Tool - Telco / Banking experience would be an advantage - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. - System analysis and design skills are necessary to design and document the data extractions and transformations. - Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. - Good organisation, planning and basic management skills. - Good interpersonal and communication skills. - Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: - Relevant data warehouse and BI solution training is essential. - B.Sc. or related degree is advantageous. - 5+ years programming experience.  
Salary: Negotiable

SAS Data Engineer Reference No: 511642718 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group is looking for a SAS Developer. A minimum of 3+ years of experience is required, and strong Base SAS experience is compulsory. Financial Industry experience would be an advantage.   The resource needs to have strong data manipulation skills, specifically using the SAS environment. Must be able to convert SAS reports to SQL.   SKILLS REQUIRED: Strong SAS Base experience Strong SQL skills SAS Macros experience would be an advantage SAS DI Studio experience would be an advantage Strong data manipulation skills Financial Industry experience would be a huge advantage.   QUALIFICATIONS REQUIRED: Matric and relevant degree/diploma   PERSONAL SKILLS REQUIRED: Acting with Integrity. Able to Build Relationships. Communicating with Impact. SDLC Knowledge. Working in Teams. Service oriented.
Salary: Negotiable

Senior SAS Data Engineer / Analyst Developer Reference No: 2735391047 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group is looking for an experienced SAS Data Engineer to work with an existing team.   Duties: Focus is on ‘rebuilding and optimising’ ETL as part of an organisational and system change. Besides technical expertise, it will be required to assist and guide younger team members.   Experience: Main technologies – SAS (using the Base SAS application, Enterprise Guide & SAS Scripting) 5+ Years’ Experience in complex SAS Programming and Strong Data Integration experience handling disparate Data Sources using SAS ACCESS engines and the related Pass-through. AWS experience is a plus.   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent SAS Certification would be an advantage
Salary: Negotiable

Data Engineer Reference No: 1278232504 | Johannesburg, South Africa | Posted on: 04 August 2022

We currently have numerous vacancies for Data Engineers skilled in tools such as the Microsoft Stack (SSIS, SSRS, SSAS), Power BI, AWS, Azure, DataStage, SAS etc.   Duties: Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. Perform root cause analysis, performance monitoring and application related issues. Review IT work products from the team members for completeness and quality. Accurately translate business requirement to technical documentation and test case or results. Analyse and map data from source systems to target operational data stores and data marts. Maintain and provide application support in production. Code or folder migration from one environment to another as part of release management. Participation in all aspects of quality assurance. Active participation in systems integration and user acceptance testing.   Required Skills: Strong modular system design skills. Conventional and data warehouse modeling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   Required Qualifications / Training: Relevant data warehouse and BI solution training is essential. B.Sc. or related degree is advantageous. 5+ years programming experience.
Salary: Negotiable

Data Architect Reference No: 2601762380 | Johannesburg, South Africa | Posted on: 04 August 2022

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 strategic business requirements. Responsibilities include data modelling, database architecture, metadata definition, repository creation, data growth and integration management as well as governance and risk management   Duties:   Develops and implements a data architecture and management plan Develops and implements a Data Architecture and management plan for the business unit – ensuring alignment to and executed in accordance with Data Strategies Applies IT Risk and Governance standards for the data environment (SDLC, Change management, Incident management, Release management, etc) Motivates for new requirements for the data environment and the coordination of projects in conjunction with the Project Office in terms of scoping, planning, prioritising Manages all aspects of the data sourcing, migration, modelling and implementation and identifies new initiatives and/or recommendations for database growth and integration Establishes and coordinates a data Task Force with regular feedback / communication to senior management on profess and future pipeline work Maintains accountability for supporting the Data Architecture vision and championing efforts to reach that vision. Provides Data framework, governance and roadmap to attain the enterprise data vision Collaborates with business units and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution Contributes in developing transparent and well understood data governance processes, rules and technologies to support them.   Data architecture analysis and practice Identify interconnected problems, determine impact, patterns, trends and identify best fit alternatives to design and implement best practice solutions Facilitates and documents the agreements on appropriate corporate data and its usage (including master data management). Holds overall, responsibility for management, planning, design and implementation of the enterprise Data Architecture domain to ensure alignment of the Banks’s Architecture Develops tools, guidelines, principles, policies and governance for Data across the bank Serves as the in-house expert and authority by defining, implementing and enforcing all data integration standards and documentation. Provides deep expertise in enterprise data and information management methods and standards. Promotes data sharing, consistency and reuse across the organization. Manages reviews of data quality deliverables of all phases and enhancements. Identifies and promotes best practices for data modelling within information areas across the organization, providing oversight for all activities related to data cleansing, data quality and data consolidation using industry standard data modelling methods and processes. Displays demonstrated ability in communicating the overall data architecture to both technical and business constituencies. Develops guidelines and best practices to ensure data standardization and consistency.   Experience:   In depth knowledge of: Demonstrable experience creating and presenting executive and technical level documentation related to business data requirements. Demonstrable experience facilitating business specific workshops to document business data requirements Demonstrable experience with BI and ETL solutions. Experience creating data model POCs using documented test cases and actual data samples. Demonstrable experience leading data governance teams/efforts. Advanced knowledge of standard data modelling tools including Erwin, Enterprise Architect and MS Visio. Advanced knowledge of database concepts, including SQL databases and database querying languages, Hadoop (MapReduce, Hive and Pig) and NoSQL databases Experience: Extensive experience in Cloud / Hybrid platforms with a key focus on Azure – Must have Experience in modelling (Conceptual , logical, and physical) - Must Have A good grasp of the SDLC process with an understanding of CI/CD (Continuous Integration / Deployment) would be an advantage. – Nice to Have Experience in translating business problem statements / requirements into technical solutions (on prem / cloud / hybrid) - Must have Data Engineering Experience – Nice to have System Engineering Experience – Nice to have. 8 years’ experience (including at least 2 enterprise level data solutions or architecture projects). 5 - 8 years’ leading data integration efforts in large scale programs. 8 years of experience working with Data Warehouse Application development 5+ years of experience in ETL design and development 3+ years SDLC and agile methodology with emphasis on requirements gathering/interpretation and data modeling The candidate must be able to translate requirements and data mapping documents to a technical design. Develop, enhance and maintain code following best practices and standards. Create and execute unit test plans. Support regression and system testing efforts Support continuous improvement by identifying and solving opportunities. Experience working with Business Intelligence tools such as Microsoft Business Intelligence, Business Objects etc. Very experienced in working with Data Visualization tools such as Microsoft PowerBI Experience with Cloud-based environments such as Microsoft Azure and Amazon AWS. Data warehouse / business intelligence experience in Finance highly desirable Excellent communication, interpersonal and problem-solving skills, including the ability to translate complex technical concepts into understandable lay terms Strong database development skills, including sound SQL skills and fundamentals Excellent organizational and analytical abilities   Competencies: Judgement and decision-making – the ability to make firm (sometimes difficult) decisions fairly and compassionately based on relevant facts, criteria and disciplined, logical thinking Strategic Thinking - ability to apply long-term, systemic thinking, utilising factual analysis, intuition and creativity to imaging new and different futures for the business area/organisation Process and Technological Competence - utilizes, identifies, enhances and leverages processes and technologies to meet business needs Drive and Results Orientation - self-starter and originator who maintains high levels of activity and produces a consistently high-quality output within agreed deadlines. Prompt and proactive in driving for results and sets demanding goals for self and others Problem Solving – cuts to the core of issues and applies effective analysis, logic and creativity to identify and implement solutions Customer Service Orientation - anticipates, recognises and meets the needs of internal and external clients or customers (however these are defined in the role), taking responsibility for maintaining the highest service standards and developing and sustaining productive client relationships Building Relationships - capacity to put people at ease and build sound relationships based on mutual trust and openness   Qualifications/ Certification: Bachelor’s Degree – Data, Computer Engineering, Solutions Architecture
Salary: Negotiable

Data Test Analyst Reference No: 1952935575 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has an immediate requirement for a Test Analyst to provide testing services.   The main purpose of this position is the end-to-end testing. The testing will cover both the backend (ETL, Database layers, Star Schemas, Cubes) and front-end reports (BI Analysis and Reporting) aspects of the solution. This testing includes functional testing, performance testing, and regression testing as well as coordinating and reporting on User Acceptance testing (UAT) execution and sign off.   Duties: The responsibilities of the successful candidate will include the following: Participating in the project throughout the remaining life cycle of a project. The Test Analyst will be responsible to planning, execution and obtaining sign-off of all testing deliverables. Defining the test approach for the project and highlighting and mitigating risks. Preparing test data to align to the testing scenarios in each technical environment. Assisting with enforcing the Testing Centre of Excellence (TCoE) standards within the project. Maintenance of testing defects and testing results. Reporting and obtaining sign off for each test cycle. Functional, Regression, Performance, Stress testing and User Acceptance Testing: Test Approach; Test Plans; Test Scripts; Test Execution Results; Defects Management Reports; Test Deliverable Sign-off Certificates; Test Closure Reports; Knowledge Transfer Document per Project; and Test Completion Sign Off.   Must have experience: Three to six years’ experience in Test execution and Test Lead Three to six years experienced in conducting functional testing, performance testing, and regression testing as well as coordinating and reporting on User Acceptance testing preparation, execution and sign off. Must have testing experience in a BI environment Experience in working on data warehousing projects A strong understanding of ETLs, Logical Data Models, Star Schemas and Cubes Experience in working in an Agile environment.   The following will be an added advantage: Creating SQL queries for validating the testing back-end data. Strong understanding of the BI environment and terminology. Formal training on HPQC and QTP Creating scripts for Automation testing. Experience in working on an OBIEE project that used Kimball as a foundation   Competencies: Conceptual Thinking; Attention to detail; Effective Communication; Managing complexity and ambiguity. Ability to learning quickly; Agility; Analysis and problem solving; Judgement and decision making; Team oriented; Management Reporting; Resilience; and Self-starter.     Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent ISTQB TA or similar certification is a must.  
Salary: Negotiable

BI Analyst Reference No: 792674637 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has an opportunity for a BI Analyst.   Duties: As Senior Business Intelligence Analyst you are responsible for gathering and documenting requirements, understanding clients’ business models and processes, assisting in solutions design, supporting the development efforts in the whole process of software development lifecycle and providing documentation and trainings to end users. The position is also expected to build good relationship to senior level stakeholders. As Senior Business Analyst you will be leading the client presentations, running demonstrations and demonstrating product proficiency that meets the clients’ business needs.   Experience: Minimum of 7 years relevant experience as a business analyst, functional consultant or other client facing role within the fintech/ financial services/banking industry. Must have solid SQL & Power BI experience Has working knowledge of implementing Management Information solutions, financial compliance solutions. Excellent communicator, confident in delivering presentations and product demonstrations, running workshops and trainings Highly skilled in stakeholder management, efficient in coordinating and managing client's expectations. Above average knowledge of BCBS239 regulations with practical experience within the analysis phase of a similar program Knowledge of debt management processes an advantage   Qualifications/ Certification: Relevant IT or business tertiary qualifications Recognised industry certifications
Salary: Negotiable

Data Solutions Architect Reference No: 635346785 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has an opportunity for a Data Solutions 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 strategic business requirements. Responsibilities include data modelling, database architecture, metadata definition, repository creation, data growth and integration management as well as governance and risk management   Duties:   Develops and implements a data architecture and management plan Develops and implements a Data Architecture and management plan for the business unit – ensuring alignment to and executed in accordance with Data Strategies Applies IT Risk and Governance standards for the data environment (SDLC, Change management, Incident management, Release management, etc) Motivates for new requirements for the data environment and the coordination of projects in conjunction with the Project Office in terms of scoping, planning, prioritising Manages all aspects of the data sourcing, migration, modelling and implementation and identifies new initiatives and/or recommendations for database growth and integration Establishes and coordinates a data Task Force with regular feedback / communication to senior management on profess and future pipeline work Maintains accountability for supporting the Data Architecture vision and championing efforts to reach that vision. Provides Data framework, governance and roadmap to attain the enterprise data vision Collaborates with business units and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution Contributes in developing transparent and well understood data governance processes, rules and technologies to support them.   Data architecture analysis and practice Identify interconnected problems, determine impact, patterns, trends and identify best fit alternatives to design and implement best practice solutions Facilitates and documents the agreements on appropriate corporate data and its usage (including master data management). Holds overall, responsibility for management, planning, design and implementation of the enterprise Data Architecture domain to ensure alignment of the Banks’s Architecture Develops tools, guidelines, principles, policies and governance for Data across the bank Serves as the in-house expert and authority by defining, implementing and enforcing all data integration standards and documentation. Provides deep expertise in enterprise data and information management methods and standards. Promotes data sharing, consistency and reuse across the organization. Manages reviews of data quality deliverables of all phases and enhancements. Identifies and promotes best practices for data modelling within information areas across the organization, providing oversight for all activities related to data cleansing, data quality and data consolidation using industry standard data modelling methods and processes. Displays demonstrated ability in communicating the overall data architecture to both technical and business constituencies. Develops guidelines and best practices to ensure data standardization and consistency.   Experience:   In depth knowledge of: Demonstrable experience creating and presenting executive and technical level documentation related to business data requirements. Demonstrable experience facilitating business specific workshops to document business data requirements Demonstrable experience with BI and ETL solutions. Experience creating data model POCs using documented test cases and actual data samples. Demonstrable experience leading data governance teams/efforts. Advanced knowledge of standard data modelling tools including Erwin, Enterprise Architect and MS Visio. Advanced knowledge of database concepts, including SQL databases and database querying languages, Hadoop (MapReduce, Hive and Pig) and NoSQL databases Experience: Extensive experience in Cloud / Hybrid platforms with a key focus on Azure – Must have Experience in modelling (Conceptual , logical, and physical) - Must Have A good grasp of the SDLC process with an understanding of CI/CD (Continuous Integration / Deployment) would be an advantage. – Nice to Have Experience in translating business problem statements / requirements into technical solutions (on prem / cloud / hybrid) - Must have Data Engineering Experience – Nice to have System Engineering Experience – Nice to have. 8 years’ experience (including at least 2 enterprise level data solutions or architecture projects). 5 - 8 years’ leading data integration efforts in large scale programs. 8 years of experience working with Data Warehouse Application development 5+ years of experience in ETL design and development 3+ years SDLC and agile methodology with emphasis on requirements gathering/interpretation and data modeling The candidate must be able to translate requirements and data mapping documents to a technical design. Develop, enhance and maintain code following best practices and standards. Create and execute unit test plans. Support regression and system testing efforts Support continuous improvement by identifying and solving opportunities. Experience working with Business Intelligence tools such as Microsoft Business Intelligence, Business Objects etc. Very experienced in working with Data Visualization tools such as Microsoft PowerBI Experience with Cloud-based environments such as Microsoft Azure and Amazon AWS. Data warehouse / business intelligence experience in Finance highly desirable Excellent communication, interpersonal and problem-solving skills, including the ability to translate complex technical concepts into understandable lay terms Strong database development skills, including sound SQL skills and fundamentals Excellent organizational and analytical abilities   Competencies: Judgement and decision-making – the ability to make firm (sometimes difficult) decisions fairly and compassionately based on relevant facts, criteria and disciplined, logical thinking Strategic Thinking - ability to apply long-term, systemic thinking, utilising factual analysis, intuition and creativity to imaging new and different futures for the business area/organisation Process and Technological Competence - utilizes, identifies, enhances and leverages processes and technologies to meet business needs Drive and Results Orientation - self-starter and originator who maintains high levels of activity and produces a consistently high-quality output within agreed deadlines. Prompt and proactive in driving for results and sets demanding goals for self and others Problem Solving – cuts to the core of issues and applies effective analysis, logic and creativity to identify and implement solutions Customer Service Orientation - anticipates, recognises and meets the needs of internal and external clients or customers (however these are defined in the role), taking responsibility for maintaining the highest service standards and developing and sustaining productive client relationships Building Relationships - capacity to put people at ease and build sound relationships based on mutual trust and openness   Qualifications/ Certification: Bachelor’s Degree – Data, Computer Engineering, Solutions Architecture
Salary: Negotiable

Data Architect Reference No: 1067677015 | Johannesburg, South Africa | Posted on: 04 August 2022

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 strategic business requirements. Responsibilities include data modelling, database architecture, metadata definition, repository creation, data growth and integration management as well as governance and risk management   Duties:   Develops and implements a data architecture and management plan Develops and implements a Data Architecture and management plan for the business unit – ensuring alignment to and executed in accordance with Data Strategies Applies IT Risk and Governance standards for the data environment (SDLC, Change management, Incident management, Release management, etc) Motivates for new requirements for the data environment and the coordination of projects in conjunction with the Project Office in terms of scoping, planning, prioritising Manages all aspects of the data sourcing, migration, modelling and implementation and identifies new initiatives and/or recommendations for database growth and integration Establishes and coordinates a data Task Force with regular feedback / communication to senior management on profess and future pipeline work Maintains accountability for supporting the Data Architecture vision and championing efforts to reach that vision. Provides Data framework, governance and roadmap to attain the enterprise data vision Collaborates with business units and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution Contributes in developing transparent and well understood data governance processes, rules and technologies to support them.   Data architecture analysis and practice Identify interconnected problems, determine impact, patterns, trends and identify best fit alternatives to design and implement best practice solutions Facilitates and documents the agreements on appropriate corporate data and its usage (including master data management). Holds overall, responsibility for management, planning, design and implementation of the enterprise Data Architecture domain to ensure alignment of the Banks’s Architecture Develops tools, guidelines, principles, policies and governance for Data across the bank Serves as the in-house expert and authority by defining, implementing and enforcing all data integration standards and documentation. Provides deep expertise in enterprise data and information management methods and standards. Promotes data sharing, consistency and reuse across the organization. Manages reviews of data quality deliverables of all phases and enhancements. Identifies and promotes best practices for data modelling within information areas across the organization, providing oversight for all activities related to data cleansing, data quality and data consolidation using industry standard data modelling methods and processes. Displays demonstrated ability in communicating the overall data architecture to both technical and business constituencies. Develops guidelines and best practices to ensure data standardization and consistency.   Experience:   In depth knowledge of: Demonstrable experience creating and presenting executive and technical level documentation related to business data requirements. Demonstrable experience facilitating business specific workshops to document business data requirements Demonstrable experience with BI and ETL solutions. Experience creating data model POCs using documented test cases and actual data samples. Demonstrable experience leading data governance teams/efforts. Advanced knowledge of standard data modelling tools including Erwin, Enterprise Architect and MS Visio. Advanced knowledge of database concepts, including SQL databases and database querying languages, Hadoop (MapReduce, Hive and Pig) and NoSQL databases Experience: Extensive experience in Cloud / Hybrid platforms with a key focus on Azure – Must have Experience in modelling (Conceptual , logical, and physical) - Must Have A good grasp of the SDLC process with an understanding of CI/CD (Continuous Integration / Deployment) would be an advantage. – Nice to Have Experience in translating business problem statements / requirements into technical solutions (on prem / cloud / hybrid) - Must have Data Engineering Experience – Nice to have System Engineering Experience – Nice to have. 8 years’ experience (including at least 2 enterprise level data solutions or architecture projects). 5 - 8 years’ leading data integration efforts in large scale programs. 8 years of experience working with Data Warehouse Application development 5+ years of experience in ETL design and development 3+ years SDLC and agile methodology with emphasis on requirements gathering/interpretation and data modeling The candidate must be able to translate requirements and data mapping documents to a technical design. Develop, enhance and maintain code following best practices and standards. Create and execute unit test plans. Support regression and system testing efforts Support continuous improvement by identifying and solving opportunities. Experience working with Business Intelligence tools such as Microsoft Business Intelligence, Business Objects etc. Very experienced in working with Data Visualization tools such as Microsoft PowerBI Experience with Cloud-based environments such as Microsoft Azure and Amazon AWS. Data warehouse / business intelligence experience in Finance highly desirable Excellent communication, interpersonal and problem-solving skills, including the ability to translate complex technical concepts into understandable lay terms Strong database development skills, including sound SQL skills and fundamentals Excellent organizational and analytical abilities   Competencies: Judgement and decision-making – the ability to make firm (sometimes difficult) decisions fairly and compassionately based on relevant facts, criteria and disciplined, logical thinking Strategic Thinking - ability to apply long-term, systemic thinking, utilising factual analysis, intuition and creativity to imaging new and different futures for the business area/organisation Process and Technological Competence - utilizes, identifies, enhances and leverages processes and technologies to meet business needs Drive and Results Orientation - self-starter and originator who maintains high levels of activity and produces a consistently high-quality output within agreed deadlines. Prompt and proactive in driving for results and sets demanding goals for self and others Problem Solving – cuts to the core of issues and applies effective analysis, logic and creativity to identify and implement solutions Customer Service Orientation - anticipates, recognises and meets the needs of internal and external clients or customers (however these are defined in the role), taking responsibility for maintaining the highest service standards and developing and sustaining productive client relationships Building Relationships - capacity to put people at ease and build sound relationships based on mutual trust and openness   Qualifications/ Certification: Bachelor’s Degree – Data, Computer Engineering, Solutions Architecture
Salary: Negotiable

Microsoft BI Developer Reference No: 2465985293 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS. REQUIRED SKILLS: Microsoft BI: Strong SQL, SSIS, SSAS, SSRS Dimensional Modelling Strong modular system design skills. Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: Relevant data warehouse and BI solution training is essential. B.Sc. or related degree is advantageous. 5+ years programming experience.   DUTIES: Duties: Back-end - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   Duties: Front-End - Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. - Develop the semantic layer, metadata, reports and report definitions. - Develop graphs and portal interfaces. - Load and maintain the metadata for the data access tool. - Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. - Produce complex, efficient, error-free reporting solutions and related documentation. - BI front end development on data structures, cubes, reporting, dashboards, etc.
Salary: Negotiable

Data Scientist Reference No: 2872638149 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has an opportunity for a Data Scientist to build and implement (ML) models to improve business processes resulting in efficiencies and cost savings. Develop data driven insights to help identify trends and opportunities and provide solutions based on these insights. Provide in depth analysis of data using data mining and profiling techniques to understand current business challenges and predict future needs. Effective communication of results to stakeholders.   Duties: Develop information driven insights to identify trends and opportunities and provide solutions based on these insights. Manage data analysis and interpretation including modelling and simulation. Drive the advanced analytics capability within the team and company. Devise and promote creative data visualization to derive actionable intelligence. Forecast the performance of data relative to business needs. Develop recommendations based on data interpretation and analysis to transform behaviours. Develop automated tools and dashboards with IT team to provide real-time insights to business data. Design data integration from multiple systems into manageable data warehouses and analytic data models. Utilize strong research or technical skills to conduct business or industry-wide analysis of current and emerging best practices that support analytics engagement. Proactively improve analytic approaches, methodologies, data and reporting capabilities. Translate data analytics findings into actionable business insights. Critically evaluate information gathered from multiple sources and reconcile conflicts. Develop and deliver compelling presentation using data and graphics to communicate insights and implications for decision making. Provide subject matter expertise for all data related processes and analysis. Actively participate and influence continuous improvement to the organisations data warehousing and Business intelligence solutions with a motive for eliminating redundant and manual data extraction and processing. Extract meaning from complex data relationship and develop reports to enable effective use of the resulting knowledge.   Develop information driven insights to identify trends and opportunities and provide solutions based on these insights. Manage data analysis and interpretation including modelling and simulation. Drive the advanced analytics capability within the team and company. Devise and promote creative data visualization to derive actionable intelligence. Forecast the performance of data relative to business needs. Develop recommendations based on data interpretation and analysis to transform behaviours. Develop automated tools and dashboards with IT team to provide real-time insights to business data. Design data integration from multiple systems into manageable data warehouses and analytic data models. Utilize strong research or technical skills to conduct business or industry-wide analysis of current and emerging best practices that support analytics engagement. Proactively improve analytic approaches, methodologies, data and reporting capabilities. Translate data analytics findings into actionable business insights.   Drive change methodology and ensure implementation across all projects Work with business to develop and implement change management strategies and plans that maximize user adoption and proficiency and minimize resistance by increasing benefit realization, value creation, ROI and the achievement of business results and outcomes.   Continuous improvement to ensure effective service Ensure statutory and legislative knowledge is always current in order to resolve customer complaints, to advise the business on corrective solutions to mitigate risks and to improve the customer experience whilst complying with governance requirements. Ensure adherence to organisational policies, practices and procedures. Identify solutions to enhance cost effectiveness and increase operational efficiency.   Service delivery to ensure customer satisfaction Maintain service, quality and desired outputs across the business process by ensuring compliance to tactical policies, procedures and standards. Establish productive operational relationships with key stakeholders in the various channels and administrative teams. Develop work routines in line with operational plans / schedules in order to manage achievement of service delivery goals. Share knowledge on, and participate in the creation of new standards, control systems and procedures to maintain service delivery.   Ensure cost efficiency through financial and corporate governance Contribute to the development and implementation of fit for purpose budgets. Manage supplier relationships, and budgets associated with projects.   Manage quality people practices Align own behaviour with the organisation culture and values. Share and transfer product, process and systems knowledge to colleagues. Collaborate and work with the HR and IT teams to deliver required service levels. Actively share information with other team members regarding successes, issues, trends and ideas.   Experience: Data science experience 5 – 8 years’ experience applying analytical methods to business problems, including build and implementation of models (machine learning, GLM, etc.) Experience working in the general insurance industry will be advantageous Knowledge of SAS, SQL, PYTHON and HADOOP Strategic: Is able to understand, identify and acts on broader opportunities in order to drive longer term, value-adding change. Applies judgement effectively. Identifies and acts on market and/or competitor trends/opportunities Customer: Putting the customer at the heart of business decisions and driving to improve value for customers. Collaboration: Creates trust, respect and builds meaningful relationships. Able to handle a wide range of relational challenges to ensure collaboration across boundaries. Leading with Influence: Influences and rallies people behind common goals; actively supports growth and inspires others to exceed expectations. Communicates clear strategies and objectives for own function. Innovation: Generates creative/out of the box solutions. Challenges the status quo and/or demonstrates ability to relate to challenges from a range of diverse but relevant perspectives. Willing to take calculated risks when introducing novel ideas. Personal Mastery: Learns and actively works to build self-awareness; develop through experience and feedback from others. Copes effectively with stress and has the resilience to take on stretching and challenging assignments. Adjusts effectively to work within new work structures; processes; requirements and cultures. Executing: Displays consistent energy, drive and perseverance in order to deliver results. Demonstrates a willingness to take calculated risks to achieve stretch performance goals.   Qualifications/ Certification: Bachelor’s/honours degree in either Mathematics/Statistics, Actuarial Science, Computer Science, or Information systems.  
Salary: Negotiable

Scrum Master Reference No: 1249602412 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has an opportunity for an experienced Scrum Master. The Scrum Master will act as a mentor to the development team in data architecture, data modeling and data analysis.   Duties: - Providing all support to the team using a servant leadership style and leading by example. This person should personify Scrum and Agile. Must be able to garner respect from his/her team and be willing to get their hands dirty to get the job done. - Facilitative; must be able to lead and demonstrate value-add principles to a team, guiding and Coaching the Scrum Team and organization on how to use Agile/Scrum practices and values. - Guiding and Coaching both the Scrum Team and the Development team on how to get the most out of self-organisation - Attitude of empowerment; must be able to lead a team to self-organization, guiding and coaching both the Scrum Team and the Development team on self-organising to fill in the intentional gaps left in the Agile/Scrum frameworks. - Assessing the Scrum Maturity of the team and organisation and coaching the team to higher levels of maturity, at a pace that is sustainable and comfortable for the team and organisation - Removing impediments or guiding the team to remove impediments by finding the right personnel to remove the impediment. - Building a trusting and safe environment where problems can be raised without fear of blame, retribution, or being judged, with an emphasis of healing and problem solving. - Assertive; must be able to ensure Agile/Scrum concepts and principles are adhered to, must be able to be a voice of reason and authority, make the tough calls. Facilitating getting the work done without coercion, assigning, or dictating the work. - Conflict resolution; must be able to facilitate discussion and facilitate alternatives or different approaches - Communicative and social; must be able to communicate well with teams, assisting with internal and external communication. - Attitude of transparency; must desire to bring disclosure and transparency to the business about development and grow business trust - Supporting and educating the Product Owner, especially with respect to refining and managing the product backlog. - Enthusiastic and Energetic - Continual improvement; must continually be growing one’s craft learning new tools and techniques to manage oneself and a team - Situationally Aware; must be the first to notice differences and issues as they arise and elevate them to management   Skills / Experience Required: - Scrum Master certification - Experience playing the Scrum Master role for at least one year for a development team- Understand fundamentals of iterative development - Understand other processes and methodologies and can speak intelligently about them and leverage other techniques to provide value to a team/enterprise - Understand fundamentals of development processes and procedures - Understand the value of commitments to delivery made by a development team - Understand incremental delivery and the value of metrics - Understand backlog tracking, burndown metrics, velocity, and task definition - Familiarity with common Agile practices, service-oriented environments, and better development practices - Good skills and knowledge of servant leadership, facilitation, situational awareness, conflict resolution, continual improvement, empowerment, and increasing transparency- Knowledge of numerous well documented patterns and techniques for filling in the intentional gaps left in the Scrum approach - The ability to distinguish between what "is Scrum" what is "not Scrum" - Knowledge of other approaches discussed in the Agile space: XP, Kanban, Crystal, FDD, etc - Knowledge and/or experience with widely successful Agile techniques: User Stories, ATDD, TDD, Continuous Integration, Continuous Testing, Pairing, Automated Testing, Agile Games - Applicable knowledge of the technologies used by the team - Experience applying a wide variety of well documented patterns and techniques for filling in the intentional gaps left in the Scrum approach (example: numerous Burndown techniques, numerous Retrospective formats, handling bugs, etc)
Salary: Negotiable

AWS DevOps Engineer Reference No: 3142846011 | Johannesburg, South Africa | Posted on: 04 August 2022

The AWS DevOps Engineer will be responsible for implementing and managing continuous delivery systems and methodologies on AWS. Implement and automate security controls, governance processes, and compliance validation. Implement systems that are highly available, scalable, and self-healing on the AWS platform.   JOB OBJECTIVES Work closely with the Development and Operations teams to guide the design and deployment of cloud infrastructure code and applications ensuring that best practices are followed. Work with Development and Operations teams to automate solutions and integrate with other services/products/solutions. To develop state of the art solutions which are technically sound. Assists others on own team, or other teams where applicable, DevOps code deployment projects or operational tasks on development projects. Define development frameworks for complex deployments in the Amazon Cloud. To provide a high-quality service to the Enterprise Cloud Services clients i.t.o. consultancy, solutions and delivery. Commitment to team success and positive team dynamics including mentoring of other team members. Passion for growing and applying technical skills in service to customers. Be a trusted DevOps advisor by providing objective, practical and relevant ideas, insights and advice. Work collaboratively with consulting partners and technology teams to ensure high quality of solution delivery. Encourage best practice and knowledge sharing with partners and cross-functional groups Ability to make recommendations as they pertain to improvements in support/development initiatives and facilitate implementation with partners and cross-functional groups within the Business. Participate in high level technical solution definition and design during the implementation phase with the goal of providing reliable, stable and operationally sound applications that meet the Business requirements. Ability to understand and translate business requirements into technical specifications Provide 3rd Tier escalation support to other developers and assess technology and code periodically. Proven experience in performing a mentorship function to junior engineers.   REQUIREMENTS AWS DevOps Professional Certification required. Successful candidates should have a minimum of 6+ years of industry related experience of which 3 years must be within a complex hosting environment. Certifications in DevOps, system architecture or cloud technologies. Experience with Terraform Should be able to write and execute cloud formation templates and integrate that with CI/CD pipelines. Fluent in AWS CLI. Strong scripting (e.g. Python) and automation skills. Extensive experience with configuration tools like Puppet, Chef, or Ansible. Knowledge of cloud networking architecture, cloud operations, security, automation and orchestration. Excellent teamwork, time-management and organizational skills. Perform other duties as deemed necessary and assigned by the customer and management Strong interpersonal skills and problem-solving abilities. Excellent documentation, communication and interpersonal skills. Excellent analytical and problem-solving abilities. Production experience developing, configuring and supporting monitoring systems, alerting and analytics. Define and deploy monitoring, metrics, and logging systems on AWS. Should be able to understand how to use EC2 and Container services like ECS and EKS. Experience in working on more than one repository hosting service including ECR. Experience with Agile software development, project management methodologies.
Salary: Negotiable

Senior Big Data / Hadoop / AWS Data Engineer and Information Team Lead Reference No: 1079874713 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has a requirement for a Hadoop Developer to interpret requirements provided by business and produce effective Big Data solutions.   The Hadoop Data and Information specialist will be responsible to design, develop and support application solutions with focus primarily on Hadoop for a Financial Services Environment. This role will play a vital role in building new data pipelines from various structured and unstructured sources into Hadoop. Must be eager to wear multiple hats and be capable of picking up new technologies at a fast pace.   Programming exposure for code transformations and integrating the big data solution with existing systems. Develop information solutions from a variety of sources for both structured and unstructured data. Technical ownership of Big Data solutions for structured and unstructured data.   DUTIES: Develop and implement big data models and solutions Design and implement ETL methodologies and technologies and the integration with big data Conduct root cause analysis on production issues Technical leadership of entire information management process of both structured and unstructured data Provide ongoing support and enhancement to ETL system Optimization and the information solutions Implementing machine learning algorithms Configuration of the Hadoop infrastructure and environment for optimal performance Integrate with statistical and actuarial analysts to build models Producing relevant technical documentation and specifications Estimate time and resource requirements for business requirement Integration of big data solutions with existing reporting and analytical solutions Develop data processing functions (DPF’s) using Java and Python   SKILLS REQUIRED: Big Data Developer Hadoop based architecture with Hortonworks Data Flow & Data Platform clusters HDF, HBase, Hive, Spark, Storm AWS experience would be a major advantage.  
Salary: Negotiable

BI Data Visualisation Engineers (with strong Business Analyst skills) Reference No: 2435670117 | Johannesburg, South Africa | Posted on: 04 August 2022

PBT Group has a requirement for a Data Visualisation Engineer for the technical development of Dashboards, Reports & Insights. Consultant will be working with the BI team (Data Scientists etc.) and Banking business users.    Duties: Initial Business Requirements Documented (supported by client workshops) Initial Prioritization Complete (supported by client workshops) The role is more than just technical development Developing data models for our global data warehouses and big data initiatives. You will work closely with data engineers, architects, data scientists and business SMEs to create data models that can fulfill the Management Information / analytical requirements from the business. Develop Collections MI Dashboards and Reports meeting stakeholder requirements   Non-Negotiable Skills: BI: Front-end development (PowerBI), Business requirements gathering Industry: Banking or Financial Services   Qualifications/ Certification: A Bachelor’s or Master’s degree in a subject with a clear analytical component and 5 years of relevant work experience. Strong MI & visualization tools knowledge with more than 5 years’ experience leading the implementation of MI solutions
Salary: Negotiable

Systems Analyst Reference No: 1245745574 | Cape Town, South Africa | Posted on: 28 July 2022

The Senior System Analyst is responsible for bridging the gap between business requirements and the development team. The System Analyst must understand the business requirements as well as the technical environment and marry the two up. This entails interaction with business, business analyst and technical stakeholders and compilation of Functional Requirements Specifications against which the development and architecture team is able to deliver the solution. In addition the System Analyst must be able to investigate and understand the existing technology, constraints and solutions in place, down to the ability to interrogate and model databases, and top level system architecture. The ideal System Analyst has a combination of a strong technical background, software testing skills as well as business understanding, elicitation and communication skills.   The System Analyst will work on multiple projects in the Financial Services environment and will be required to manage his/her time effectively. The environment is based on Microsoft technology including MS SQL server, a .NET development toolset as well as other technology suites depending on the system in question.   DUTIES:   Functional and Testing Understand and Analyse systems in the environment, including database and top level architecture understanding Produce Functional Requirements Specifications Produce accurate mapping of “As is” and “To be” processes Identify project risks and issues and ensure that they are documented Produce User Acceptance Test Cases and Scenarios and assist with SIT and QA testing Provide regular, continuous and accurate feedback to project management team Participation in and sign-off of user acceptance testing, pilot and production testing   General Adhere to set process standards Co-work with the Business Analysts and technical team to define and design solutions that meet customer requirements Co-work with the project manager to drive delivery on time, within budget, scope and quality Perform efficient and effective JAD facilitation with relevant project stakeholders   Teamwork Build and maintain meaningful relationships with stakeholders   Experience Required: Must be able to operate independently and have a solid Microsoft tools background. Financial Services background Experience across data-, integration services- Front-end- development Process analysis 5 or more years Technical Business Analysis experience 3 or more years within a mature PMO environment Experience in Retail industry preferred A hands on technical background such as software development or database development will be a strong advantage Business analysis methods, practices and techniques Business process modelling and mapping Formal methodology such as UML and BPMN will be a strong advantage Proven track record of successfully implementing technology projects General understanding in the areas of application programming, database design and project management is highly desirable SQL Query and basic Relational Database design skills Understanding of modern enterprise application building blocks   QUALIFICATIONS REQUIRED: Matric Minimum 5 to 6 years relevant Business Analysis experience B-degree or similar an advantage Business Analysis qualification an advantage Project Management qualification an advantage  
Salary: Negotiable

Java Developer Reference No: 388049336 | Johannesburg, South Africa | Posted on: 28 July 2022

PBT Group has an opportunity for a Java Developer to develop and codify application and software solutions that are bespoke, innovative and sustainable.   Duties: Macro environment Engage with the macro-environment to look for new opportunities, capabilities and trends that would add value to the required development work Suggest changes in executing work processes to better drive value and benefits for the business Prepare and share recommendations for process and systems improvements in relevant area of accountability Actively participate in team, cross-discipline and vendor-driven collaboration sessions or forums to increase understanding of the working environment (current and planned)   Business alignment Partner with BT and Business stakeholders to create integrated roadmaps to enable business requirements delivery   Solution design and build Consolidate and prepare solution design documentation Apply standards and governance in such a way as to develop the best fit solution for business Coordinate and apply various coding efforts Collate data on coding progress achieved Address and develop solutions to problems and risks arising from coding efforts   Test Design relevant test scripts/ test cases to best determine system readiness and usability   Service handover Provide second tier support as required   Experience: 8+ years Java experience. Familiar with agile methodology Strong back end and front end development skills Strong SQL skills, especially on MSSQL Solid experience in the following technologies: SOA Microservices Docker Java Angular NodeJS Bootstrap Spring boot Hibernate Tomcat Jboss Nexus Teamcity Maven Kafka Experience with workflow tools like TIBCO AMX an advantage Experience with rules engines like Drools and advantage In depth knowledge of: Relevant system/application development language Relevant development frameworks Coding for security best practice Agile/DevOps principles and applications Bespoke BU/FA knowledge Corporate and investment banking domain (preferred) Relevant banking regulations (preferred) Worked in an Agile/DevOps environment (preferred)   Competencies: Analysis and Attention to Detail - ability to be systematic and rule orientated in gathering, reviewing and evaluating data from a variety of perspectives; includes the ability to work with precision and highlight inconsistencies and inaccuracies in detailed information. Big Picture Thinking - ability to integrate information from a variety of sources, discern complex underlying relationships and predict patterns for future growth. Drive and Results Orientation - self-starter and originator who maintains high levels of activity and produces a consistently high-quality output within agreed deadlines. Prompt and proactive in driving for results and sets demanding goals for self and others. Problem Solving – cuts to the core of issues and applies effective analysis, logic and creativity to identify and implement solutions. Customer Service Orientation - anticipates, recognises and meets the needs of internal and external clients or customers (however these are defined in the role), taking responsibility for maintaining the highest service standards and developing and sustaining productive client relationships. Building Relationships - capacity to put people at ease and build sound relationships based on mutual trust and openness.   Qualifications/ Certification: Degree in relevant Technology OR Science OR Engineering field of study
Salary: Negotiable

Senior AWS Data Engineer Reference No: 2803928717 | Johannesburg, South Africa | Posted on: 28 July 2022

PBT Group has an opportunity for a Senior AWS Data Engineer.   Duties: Design, build and operationalize large scale enterprise data solutions and applications using one or more of AWS data and analytics services in combination with 3rd parties - Spark, EMR, DynamoDB, RedShift, Kinesis, Lambda, Glue, Snowflake. Analyze, re-architect and re-platform on-premise data warehouses to data platforms on AWS cloud using AWS or 3rd party services. Design and build production data pipelines from ingestion to consumption within a big data architecture, using Java, Python, Scala. Design and implement data engineering, ingestion and curation functions on AWS cloud using AWS native or custom programming. Perform detail assessments of current state data platforms and create an appropriate transition path to AWS cloud. Design, implement and support an analytical data infrastructure providing ad-hoc access to large datasets and computing power. Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies. Creation and support of real-time data pipelines built on AWS technologies including Glue, Redshift/Spectrum, Kinesis, EMR and Athena Continual research of the latest big data and visualization technologies to provide new capabilities and increase efficiency Working closely with team members to drive real-time model implementations for monitoring and alerting of risk systems. Collaborate with other tech teams to implement advanced analytics algorithms that exploit our rich datasets for statistical analysis, prediction, clustering and machine learning Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers   Experience: Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets Experience working with distributed systems as it pertains to data storage and computing Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with unstructured datasets. Build processes supporting data transformation, data structures, meta data, dependency and workload management. A successful history of manipulating, processing and extracting value from large disconnected data sets. Working knowledge of message queuing, stream processing, and highly scalable Big Data, data stores. Strong project management and organizational skills. Experience supporting and working with cross-functional teams in a dynamic environment. Experience in a Data Engineer or similar roles Experience with big data tools is a must: Hadoop, Spark, Kafka, etc. Experience with relational SQL and NoSQL databases, including Postgres and Cassandra. Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc. Experience with AWS cloud services: EC2, EMR, RDS, Redshift Experience with stream-processing systems: Storm, Spark-Streaming, etc. Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc   Qualifications/ Certification: Bachelor's Degree in Computer Science, Information Technology or other relevant fields Has experience in any of the following AWS Athena and Glue Pyspark, EMR, DynamoDB, Redshift, Kinesis, Lambda, Snowflake Proficient in AWS Redshift, S3, Glue, Athena, DynamoDB, EMR Knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations  
Salary: Negotiable

Senior Analyst (Data Insights) with SAS, SQL, Python Reference No: 1998876229 | Johannesburg, South Africa | Posted on: 28 July 2022

Collects, interprets and analyses data to determine specific business insights, and isseminates insights into relevant OMEs / functions.   Collection, interpretation and analysis of data to determine specific business insights Dissemination of business insights analytics into OMEs / functions   Duties: Problem formulation and solution development in collaboration with business Analysis conducted to determine trends or patterns, leading to business insights Data preparation for insights and visualisation Visualisation of business insights   Skills: SAS SQL Python Ability to problem solve Strong communication skills and ability to work with people within business and the data organisation Ability to use statistical and other analytics techniques
Salary: Negotiable

BI Fullstack Developer Reference No: 2292654372 | Cape Town, South Africa | Posted on: 18 July 2022

PBT Group currently has an opportunity role for a who will establish new technology components and reusable solution patterns. You be responsible for developing warehousing blueprints, evaluating hardware and software platforms and integrating systems as well as translating needs into long-term architecture solutions.  About the role: Create design standards, patterns and principles. management, development and modelling. Engage with a wide range of technical stakeholders including scientists, analysts, engineers, database administrators and solutions architects. About you: Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering or another quantitative field or, National Diploma in an Information Technology related discipline preferred 3 - 8 years related experience Application and data engineering background with a solid background in is required architecture design and delivery experience preferred Experience in 3 or more of the following areas is required: Database technologies (e.g. SAP Hana, Teradata or similar) and database development (Views, Functions and Stored Procedure development) components including HDFS, Hive, Spark, Oozie and Impala Object-oriented/object functional scripting languages: , , Scala or related ETL tools (e.g. SAP Services) Event/Streaming based pipelines (e.g. Kafka or Nifi) warehousing (Kimball and Vault patterns are preferred) and dimensional modelling (OLAP and MDX experience)
Salary: Negotiable

Business Intelligence Analyst (BIBA) Reference No: 1153646190 | Cape Town, South Africa | Posted on: 14 July 2022

PBT Group has a requirement for a Senior Business Intelligence Analyst with solid understanding and experience in the BI industry, banking experience would be preferable.   DUTIES: Responsible for the support and analysis of current and new business requirements with the focus on meeting the relevant business objectives. The individual will be responsible to operate within both support and project environments. Analyse the business environment related to the past, present and future. Work with Project Manager to assist with the estimation and planning of activities. Document requirements, including KPI’s, measures, reporting and business dimensions, business processes, data modeling requirements, interface layouts, data flows, screen and report layouts, etc. Investigate and define requirements for business processes and the documentation thereof. Formulate strategies and guidelines to improve the business environment. Analyse existing business processes to determine problems, risks and opportunities for improvement. Facilitate the implementation of new / enhanced processes. Review processes on an ongoing basis and conduct process audits. Render support to and facilitate sessions with end-users. Work closely with the Solution Architects and Data Modellers to design and implement the best possible solution within the limits of the tools available. System and user acceptance testing. Provide input to Quality Assurance. Business assistance during implementation. Provide input for user training.   REQUIRED SKILLS: Substantial Business Analyst & Requirement Analysis experience in a BI environment. Elicitation, documentation, testing and project management. Experience with SQL Server (ability of profile data and perform testing, which would require the person to write SQL code). Must have some technical foundation and SQL scripting experience A good understanding of business processes. Ability to assimilate and apply relevant business principles. Work independently. Must be a team player. Work on more than one project at a time. Be able to work within the framework of project methodologies and work independently on support and maintenance tasks. Strong communication skills. Good writing skills. Must be able to pay attention to detail. Good general understanding of the relevant industry.   REQUIRED QUALIFICATIONS / TRAINING: Ideally candidates should have an IT or business-related qualification. FTI or similar BA qualification will be advantageous.  
Salary: Negotiable

Data Analyst Reference No: 3355054566 | Johannesburg, South Africa | Posted on: 13 July 2022

PBT Group has a vacancy for a BI Data Analyst with at least 3 years relevant experience within the insurance / financial services industry, to support and maintain the data warehouse in line with the data model; metadata repository and to provide business intelligence analysis through performing strategic and operational support.     Required Skills: We are looking for candidates/profiles with strong data analysis and metadata management skills The division/team work with SSIS and PowerBI. Meticulous attention to detail. Knowledge of data profiling and data profiling tools. Experience with data quality management strategies and life cycles. Preference will be given to candidates with experience within the telecommunications and/or banking industry. 8 years relevant experience of which 3-5 years’ experience in: Banking, Business Intelligence, Finance, Data Warehousing, Data principles, Analytics, Data Management, EDP, RADARR, SQL ETL & Development, Finance Reporting, Regulatory Knowledge, MIS, Dash-boarding & Data Quality Required Qualifications / Training: Ideally candidates should have a related IT qualification. Data Management (DAMA) Certification, Certification/formal training in relevant technology   Duties: Assist in the identification, standards, procedures, definition and population of the correct and required business metadata and maintain business glossary Ensure data quality and manage specific issues by Identifying opportunities to mitigate risk and structurally address root causes of problems Create, maintain, resolve and report data related activities such as definitions, rules, data quality issues Create and maintain data models Participate in data governance and carry out decisions to the Information management activities for critical data assets Understand and adhere to the Information Governance Framework and associated policies and guidelines Participate on the Information Management Working Communities Build working relationships across teams and functional lines in order to enhance work delivery, collaboration and innovation Serve as a data champion for data-related issues Understand and adhere to the Information Governance Framework and associated policies and guidelines  
Salary: Negotiable

Azure Data Engineer Reference No: 2874656511 | Johannesburg, South Africa | Posted on: 13 July 2022

PBT Group has an opportunity for Azure Developers who are well versed in the Azure Stack.   Duties: Data Engineering Collecting, centralizing and consolidating large amounts of data from multiple sources by applying data extraction, transforming and load techniques which allow organizations to derive valuable business insights from their data to improve decision-making and enables reporting and analysis. Collaborate with business in defining necessary architecture, design and build data engineering solutions for business enablement. Identify, source and make available key data required for day to day operational reporting and analytics in the Analytics Ecosystem platform. Implement an automated data orchestration and quality solution to ensure reliable and readily available data. Create and publish data products to enable strategic business initiatives in the Analytics Ecosystem platform. Build reporting and analytics solutions to enable and improve decision-making Assist in the creation of ADF data replication and transformation pipelines. Help upskill the team with the use of ADF. Assist with performance tuning of the target databases and with the creation of database maintenance jobs where necessary. Manage the BI Development life cycle, ensuring adherence to best practice coding standards. Maintain and develop the BI systems. Create and build dashboards and reports. Development within an Azure based platform helping in the deployment. Ensure that the design of BI solutions is scalable and aligned to the architecture principals of the Data Warehouse.   Experience: Azure Data Engineering (Azure Data Factory, Azure Synapse, PowerBI) Strong SQL, Fuel and retail industry experience would be a huge advantage. Experience in using Data Factory in conjunction with Azure DevOps for source control and deployment across dev/test/prod environments would be ideal. This would include experience in templatizing ADF flows for use across different environments. Strong SQL Server experience Azure SQL Managed Instances experience preferred. Experience with Columnar Indexes in SQL Server will be an advantage. Solidly skilled within the Azure environment with hands-on experience in setting up and developing ETL and Storage components within Azure Data Factory, Azure Data Lake and Azure SQL DB. Ability to optimize the azure environment to not only manage performance but also cost effectiveness. Ability to provide technical input to current technical teams/ process analysts and project leads in order to provide technical guidance with regards to technology component fit and functional requirement vetting. Should have sufficient experience to operate autonomously and proactively provide technical direction. Excellent verbal and written communication skills coupled with analytical problem-solving skills. Ability to write quality unit and end–to–end tests; debug and optimize existing and new code.   Qualifications/ Certification: Azure Data Engineer Certified A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent
Salary: Negotiable

Senior Azure Data Engineer / Data Architect Reference No: 4185263752 | Johannesburg, South Africa | Posted on: 13 July 2022

PBT Group has an opportunity for Azure Developers who are well versed in the Azure Stack Build out the Blueprint for the golden source in Azure and ensure data quality, monitoring, data types, controls, column names etc Implement required forums and processes Blueprint must include the process for migrating from on-prem to cloud.   Duties: Assist in the creation of ADF data replication and transformation pipelines. Help upskill the team with the use of ADF. Assist with performance tuning of the target databases and with the creation of database maintenance jobs where necessary. Manage the BI Development life cycle, ensuring adherence to best practice coding standards. Maintain and develop the BI systems. Create and build dashboards and reports. Development within an Azure based platform helping in the deployment. Ensure that the design of BI solutions is scalable and aligned to the architecture principals of the Data Warehouse.   Experience: Experience in using Data Factory in conjunction with Azure DevOps for source control and deployment across dev/test/prod environments would be ideal. This would include experience in templatizing ADF flows for use across different environments. Strong SQL Server experience Azure SQL Managed Instances experience preferred. Experience with Columnar Indexes in SQL Server will be an advantage. Solidly skilled within the Azure environment with hands-on experience in setting up and developing ETL and Storage components within Azure Data Factory, Azure Data Lake and Azure SQL DB. Ability to optimize the azure environment to not only manage performance but also cost effectiveness. Ability to provide technical input to current technical teams/ process analysts and project leads in order to provide technical guidance with regards to technology component fit and functional requirement vetting. Should have sufficient experience to operate autonomously and proactively provide technical direction. Excellent verbal and written communication skills coupled with analytical problem-solving skills. Ability to write quality unit and end–to–end tests; debug and optimize existing and new code.   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent
Salary: Negotiable

Senior Data Engineer Reference No: 2767064957 | Johannesburg, South Africa | Posted on: 13 July 2022

We currently have numerous vacancies for Data Engineers skilled in tools such as the Microsoft Stack (SSIS, SSRS, SSAS), Power BI, AWS, Azure, DataStage, SAS etc.   Duties: Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. Perform root cause analysis, performance monitoring and application related issues. Review IT work products from the team members for completeness and quality. Accurately translate business requirement to technical documentation and test case or results. Analyse and map data from source systems to target operational data stores and data marts. Maintain and provide application support in production. Code or folder migration from one environment to another as part of release management. Participation in all aspects of quality assurance. Active participation in systems integration and user acceptance testing.   Required Skills: Mandatory: strong SQL Preferably: MS Azure Strong modular system design skills. Conventional and data warehouse modeling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   Required Qualifications / Training: Relevant data warehouse and BI solution training is essential. B.Sc. or related degree is advantageous. 5+ years programming experience.
Salary: Negotiable

Senior Data Scientist Reference No: 1877184814 | Johannesburg, South Africa | Posted on: 13 July 2022

PBT Group has an opportunity for a Senior Data Scientist to build and implement (ML) models to improve business processes resulting in efficiencies and cost savings. Develop data driven insights to help identify trends and opportunities and provide solutions based on these insights. Provide in depth analysis of data using data mining and profiling techniques to understand current business challenges and predict future needs. Effective communication of results to stakeholders.   Experience: Data science experience 5 – 8 years’ experience applying analytical methods to business problems, including build and implementation of models (machine learning, GLM, etc.) Experience working in the general insurance industry will be advantageous Mandatory skills: PYTHON, Azure, Machine Learning Solutions Strategic: Is able to understand, identify and acts on broader opportunities in order to drive longer term, value-adding change. Applies judgement effectively. Identifies and acts on market and/or competitor trends/opportunities Customer: Putting the customer at the heart of business decisions and driving to improve value for customers. Collaboration: Creates trust, respect and builds meaningful relationships. Able to handle a wide range of relational challenges to ensure collaboration across boundaries. Leading with Influence: Influences and rallies people behind common goals; actively supports growth and inspires others to exceed expectations. Communicates clear strategies and objectives for own function. Innovation: Generates creative/out of the box solutions. Challenges the status quo and/or demonstrates ability to relate to challenges from a range of diverse but relevant perspectives. Willing to take calculated risks when introducing novel ideas. Personal Mastery: Learns and actively works to build self-awareness; develop through experience and feedback from others. Copes effectively with stress and has the resilience to take on stretching and challenging assignments. Adjusts effectively to work within new work structures; processes; requirements and cultures. Executing: Displays consistent energy, drive and perseverance in order to deliver results. Demonstrates a willingness to take calculated risks to achieve stretch performance goals.   Duties: Develop information driven insights to identify trends and opportunities and provide solutions based on these insights. Manage data analysis and interpretation including modelling and simulation. Drive the advanced analytics capability within the team and company. Devise and promote creative data visualization to derive actionable intelligence. Forecast the performance of data relative to business needs. Develop recommendations based on data interpretation and analysis to transform behaviours. Develop automated tools and dashboards with IT team to provide real-time insights to business data. Design data integration from multiple systems into manageable data warehouses and analytic data models. Utilize strong research or technical skills to conduct business or industry-wide analysis of current and emerging best practices that support analytics engagement. Proactively improve analytic approaches, methodologies, data and reporting capabilities. Translate data analytics findings into actionable business insights. Critically evaluate information gathered from multiple sources and reconcile conflicts. Develop and deliver compelling presentation using data and graphics to communicate insights and implications for decision making. Provide subject matter expertise for all data related processes and analysis. Actively participate and influence continuous improvement to the organisations data warehousing and Business intelligence solutions with a motive for eliminating redundant and manual data extraction and processing. Extract meaning from complex data relationship and develop reports to enable effective use of the resulting knowledge.   Develop information driven insights to identify trends and opportunities and provide solutions based on these insights. Manage data analysis and interpretation including modelling and simulation. Drive the advanced analytics capability within the team and company. Devise and promote creative data visualization to derive actionable intelligence. Forecast the performance of data relative to business needs. Develop recommendations based on data interpretation and analysis to transform behaviours. Develop automated tools and dashboards with IT team to provide real-time insights to business data. Design data integration from multiple systems into manageable data warehouses and analytic data models. Utilize strong research or technical skills to conduct business or industry-wide analysis of current and emerging best practices that support analytics engagement. Proactively improve analytic approaches, methodologies, data and reporting capabilities. Translate data analytics findings into actionable business insights.   Drive change methodology and ensure implementation across all projects Work with business to develop and implement change management strategies and plans that maximize user adoption and proficiency and minimize resistance by increasing benefit realization, value creation, ROI and the achievement of business results and outcomes.   Continuous improvement to ensure effective service Ensure statutory and legislative knowledge is always current in order to resolve customer complaints, to advise the business on corrective solutions to mitigate risks and to improve the customer experience whilst complying with governance requirements. Ensure adherence to organisational policies, practices and procedures. Identify solutions to enhance cost effectiveness and increase operational efficiency.   Service delivery to ensure customer satisfaction Maintain service, quality and desired outputs across the business process by ensuring compliance to tactical policies, procedures and standards. Establish productive operational relationships with key stakeholders in the various channels and administrative teams. Develop work routines in line with operational plans / schedules in order to manage achievement of service delivery goals. Share knowledge on, and participate in the creation of new standards, control systems and procedures to maintain service delivery.   Ensure cost efficiency through financial and corporate governance Contribute to the development and implementation of fit for purpose budgets. Manage supplier relationships, and budgets associated with projects.   Manage quality people practices Align own behaviour with the organisation culture and values. Share and transfer product, process and systems knowledge to colleagues. Collaborate and work with the HR and IT teams to deliver required service levels. Actively share information with other team members regarding successes, issues, trends and ideas.   Qualifications/ Certification: Bachelor’s/honours degree in either Mathematics/Statistics, Actuarial Science, Computer Science, or Information systems.  
Salary: Negotiable

MI Analyst Reference No: 810599706 | Cape Town, South Africa | Posted on: 13 July 2022

PBT Group has an opportunity for a MI Analyst. Strong SQL crucial.   Duties: As Senior MI Analyst you are responsible for gathering and documenting requirements, understanding clients’ business models and processes, assisting in solutions design, supporting the development efforts in the whole process of software development lifecycle and providing documentation and trainings to end users. The position is also expected to build good relationship to senior level stakeholders. As Senior Business Analyst you will be leading the client presentations, running demonstrations and demonstrating product proficiency that meets the clients’ business needs. Data Validation & Cleaning Gathering data from Several Databases Data Prep Maintenance of reporting Extract and interrogate data to support business decision making Provide interpretation and guidance for users of information to add value to decision making   Experience: SQL, SAS, EXCEL Data Visualization Critical Thinking Database Querying Data Cleaning Data Validation AWS Database knowledge (Ideal, not required) Data warehousing Domain Knowledge Analytical/Numerical Thinking Minimum of 7 years relevant experience as a MI / BI  analyst, functional consultant or other client facing role within the fintech/ financial services/banking industry. Must have solid SQL & Power BI experience Has working knowledge of implementing Management Information solutions, financial compliance solutions. Excellent communicator, confident in delivering presentations and product demonstrations, running workshops and trainings Highly skilled in stakeholder management, efficient in coordinating and managing client's expectations. Above average knowledge of BCBS239 regulations with practical experience within the analysis phase of a similar program Knowledge of debt management processes an advantage   Qualifications/ Certification: Relevant IT or business tertiary qualifications Recognised industry certifications
Salary: Negotiable

Senior QlikSense Front End Developer Reference No: 2181853843 | Cape Town, South Africa | Posted on: 13 July 2022

PBT Group has a vacancy for strong QlikSense Developer.   DUTIES: Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. Develop the semantic layer, metadata, reports and report definitions. Develop graphs and portal interfaces. Load and maintain the metadata for the data access tool. Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. Produce complex, efficient, error-free reporting solutions and related documentation. BI front end development on data structures, cubes, reporting, dashboards, etc.   SKILLS REQUIRED: Strong QlikSense experience SQL Financial services experience Design & Build QlikSense models Analyse user requirements to produce technical requirements Advising users and making technical proposals Writing SQL code to retrieve data from Data Warehouse (MySQL, MS SQL, Sybase, Oracle) QlikSense Model and SQL query optimisation Design data model layout and flow Front end design and development Thorough data testing before production according to quality standards Writing technical documentation Data warehouse modelling skills is advantageous, in order to understand the data warehouse data models. A sound knowledge of SQL, or the language used to access the data warehouse from the access- or end-user reporting tools. A sound knowledge of the capabilities of the data access- and reporting tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the end user programs or reports. Keep abreast of new releases of these tools and work-arounds to overcome problem areas using these tools. Exposure to various BI front end applications, with working knowledge in at least one of them. Strong ability to analyse user requirements and build front-end BI applications according to specifications. Knowledge of scripting languages. Experience with one or more of the industry standard databases desired. Attention to detail and strong logical reasoning ability. Good communication skills. Pride of work, thoroughness and attention to detail.   REQUIRED QUALIFICATIONS / TRAINING: Relevant data warehouse and BI solution training is essential. Sc. or related degree is advantageous.
Salary: Negotiable

Business Analyst (Finance / Asset Management) Reference No: 2764156693 | Johannesburg, South Africa | Posted on: 13 July 2022

Role Purpose The role of the BA is to provide business analysis support to business units, functional areas and enterprise projects across Corporate and Investment Bank.   The Business Analyst will be responsible for gathering and understanding the business needs within specific projects and generally in relation to the banking strategies. The BA will then ensure together with key project stakeholders and sponsors, that the requirements are accurately translated and delivered/enabled across the key dimensions of people, process, technology and information. The BA will be working across a range of projects and work-streams which are complex and simple, often simultaneously. The BA will have a solid understanding of Asset Classes for example Fixed Income, Equities, Futures, FX and Exchange Traded Derivatives (ETDs) and how these products are traded in local and international markets. In addition, the BA will be tasked with analyzing business processes, and issues and recommending projects to improve the effectiveness of those processes. This role may require certain levels of best practice research.   The BA will be engaging with senior Asset Management business stakeholders in the full trade lifecycle process of Asset Classes. The BA will be working across business and technology teams to gather requirements for complex trade lifecycle processes and scenarios. While the role is based in Sandton, certain projects may require travel and/or spending a percentage of time at the various branches (e.g. Johannesburg CBD or any other offices).   Responsibilities Elicit requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis. Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs. Proactively communicate and collaborate with external and internal customers to analyze information needs and functional requirements and deliver the following artifacts as needed: Business Requirements Specifications, Use Cases, Screen, Interface designs, project reports and presentations, operating models, process map, etc. Successfully engage in multiple initiatives simultaneously. Work independently with users, sponsors, and other stakeholders to define concepts and under direction of project managers. Drive and challenge business units on their assumptions of how they will successfully execute their plans. Strong analytical skills and conceptual level thinking required, including a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements. Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts and end users. Collaborate with developers and subject matter experts to establish the business and technical vision and analyse trade-offs between usability and performance needs. Take accountability for all business analysis responsibilities across the product/software development lifecycle. Create business and test cases for all Asset Classes. Documenting of as-is and designing to-be processes.   Systems and Technologies The BA will be familiar with the following vendor systems and technologies: Bloomberg Port Bloomberg AIM Maitland – NX Manager Omgeo AMX Workflow Visio Microsoft Suite of Products (Excel, Visio, Word, PowerPoint, etc) Murex Axiom Miro   Qualifications and Experience Min B.Com Degree or appropriate related degree 3-5yrs solid business analysis experience with proven experience Financial or banking experience is preferable, Business Analyst certification/qualification advantageous Six Sigma & Lean certifications advantageous Project Management/coordination experience advantageous Experience in continuous improvement initiatives would be an advantage Proven track record across the SDLC Processes Engineering Skills Ability to identify root causes and illicit business requirements Understanding business architecture Analytical and Technical understanding Power Point Skills (ability to develop and prepare presentation packs) Solid experience in Agile Methodologies Solid experience in SQL Code analysis Solid experience in Data analytics and Data management principles Solid experience compiling a RACI Matrix (Responsible, Accountable, Consulted, Informed)
Salary: Negotiable

AWS Data Engineer (Senior/Tech Lead) Reference No: 4286881452 | Cape Town, South Africa | Posted on: 13 July 2022

PBT Group has an opportunity for a Senior/Tech Lead AWS Data Engineer, must have Glue, EMR, S3, EC2 experience.   Duties: Design, build and operationalize large scale enterprise data solutions and applications using one or more of AWS data and analytics services in combination with 3rd parties - Spark, EMR, DynamoDB, RedShift, Kinesis, Lambda, Glue, Snowflake. Analyze, re-architect and re-platform on-premise data warehouses to data platforms on AWS cloud using AWS or 3rd party services. Design and build production data pipelines from ingestion to consumption within a big data architecture, using Java, Python, Scala. Design and implement data engineering, ingestion and curation functions on AWS cloud using AWS native or custom programming. Perform detail assessments of current state data platforms and create an appropriate transition path to AWS cloud. Design, implement and support an analytical data infrastructure providing ad-hoc access to large datasets and computing power. Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies. Creation and support of real-time data pipelines built on AWS technologies including Glue, Redshift/Spectrum, Kinesis, EMR and Athena Continual research of the latest big data and visualization technologies to provide new capabilities and increase efficiency Working closely with team members to drive real-time model implementations for monitoring and alerting of risk systems. Collaborate with other tech teams to implement advanced analytics algorithms that exploit our rich datasets for statistical analysis, prediction, clustering and machine learning Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers   Experience: Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets Experience working with distributed systems as it pertains to data storage and computing Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with unstructured datasets. Build processes supporting data transformation, data structures, meta data, dependency and workload management. A successful history of manipulating, processing and extracting value from large disconnected data sets. Working knowledge of message queuing, stream processing, and highly scalable Big Data, data stores. Strong project management and organizational skills. Experience supporting and working with cross-functional teams in a dynamic environment. Experience in a Data Engineer or similar roles Experience with big data tools is a must: Hadoop, Spark, Kafka, etc. Experience with relational SQL and NoSQL databases, including Postgres and Cassandra. Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc. Experience with AWS cloud services: EC2, EMR, RDS, Redshift Experience with stream-processing systems: Storm, Spark-Streaming, etc. Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc   Qualifications/ Certification: Bachelor's Degree in Computer Science, Information Technology or other relevant fields Has experience in any of the following AWS Athena and Glue Pyspark, EMR, DynamoDB, Redshift, Kinesis, Lambda, Snowflake Proficient in AWS Redshift, S3, Glue, Athena, DynamoDB, EMR Knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations  
Salary: Negotiable

AWS Data Engineer Reference No: 3922083749 | Cape Town, South Africa | Posted on: 13 July 2022

PBT Group has an opportunity for an AWS Data Engineer, must have Glue, EMR, S3, EC2 experience.   Duties: Design, build and operationalize large scale enterprise data solutions and applications using one or more of AWS data and analytics services in combination with 3rd parties - Spark, EMR, DynamoDB, RedShift, Kinesis, Lambda, Glue, Snowflake. Analyze, re-architect and re-platform on-premise data warehouses to data platforms on AWS cloud using AWS or 3rd party services. Design and build production data pipelines from ingestion to consumption within a big data architecture, using Java, Python, Scala. Design and implement data engineering, ingestion and curation functions on AWS cloud using AWS native or custom programming. Perform detail assessments of current state data platforms and create an appropriate transition path to AWS cloud. Design, implement and support an analytical data infrastructure providing ad-hoc access to large datasets and computing power. Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies. Creation and support of real-time data pipelines built on AWS technologies including Glue, Redshift/Spectrum, Kinesis, EMR and Athena Continual research of the latest big data and visualization technologies to provide new capabilities and increase efficiency Working closely with team members to drive real-time model implementations for monitoring and alerting of risk systems. Collaborate with other tech teams to implement advanced analytics algorithms that exploit our rich datasets for statistical analysis, prediction, clustering and machine learning Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers   Experience: Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets Experience working with distributed systems as it pertains to data storage and computing Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with unstructured datasets. Build processes supporting data transformation, data structures, meta data, dependency and workload management. A successful history of manipulating, processing and extracting value from large disconnected data sets. Working knowledge of message queuing, stream processing, and highly scalable Big Data, data stores. Strong project management and organizational skills. Experience supporting and working with cross-functional teams in a dynamic environment. Experience in a Data Engineer or similar roles Experience with big data tools is a must: Hadoop, Spark, Kafka, etc. Experience with relational SQL and NoSQL databases, including Postgres and Cassandra. Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc. Experience with AWS cloud services: EC2, EMR, RDS, Redshift Experience with stream-processing systems: Storm, Spark-Streaming, etc. Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc   Qualifications/ Certification: Bachelor's Degree in Computer Science, Information Technology or other relevant fields Has experience in any of the following AWS Athena and Glue Pyspark, EMR, DynamoDB, Redshift, Kinesis, Lambda, Snowflake Proficient in AWS Redshift, S3, Glue, Athena, DynamoDB, EMR Knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations  
Salary: Negotiable

Data Analyst Reference No: 2206774048 | Cape Town, South Africa | Posted on: 13 July 2022

PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights.   We are looking for an individual with experience in using a variety of data tools, analysis methods and data visualization to turn data into actionable insights with demonstrable business impact. About the role: Data Preparation Analysis and Visualisation Stakeholder Engagement Data Integration About you: Functional experience in analytics, data visualisation or reporting 2-5 years of experience performing data analysis in a BI environment. Experience with reporting packages Demonstrated experience in handling large data sets and relational databases with proven SQL skills. Ability to comply with and manage data assets under a strict governance framework. Experience in agile development desired Ability to work with data profiling, data quality and reference data toolsets. Knowledge of the following BI processes and methodologies: SQL, application, information architecture and ETL procedures Data integration  
Salary: Negotiable

Machine Learning Engineer Reference No: 1513690019 | Cape Town, South Africa | Posted on: 13 July 2022

We have an exciting opportunity available for a Machine Learning Engineer, to design and build new Science/Machine Learning (“ML”) software solutions while participating in all phases of the software development lifecycle. The ultimate goal is to create high-quality software solutions that meet clients’ needs. About the Role: Assist in designing and implementing functional application requirements for client-facing and internal ML solutions Ownership of the delivery of functional aspects of an application design in line with functional specification as part of a larger multi-disciplinary team Collaborate with Engineers to ensure and structures cater to solution needs Collaborate with UX/UI designers to specify UI requirements for application designs Collaborate with Front-End to ensure accurate delivery of UI application specifications Build of efficient back-end application features Manage application testing and bug fixes Prepare technical documentation Implement software enhancements and suggest improvements Review code from other and team members About you: BSc, BEng, or BIT degree, preferably with Postgraduate degrees, strong foundational Computer Science knowledge required Experience in the design, development and deployment of Machine Learning solutions Minimum 4 years total working experience with 2+ years of experience in developing Machine Learning solutions development experience Database design patterns & object-relational mapping in Experience with Git & collaborative software development
Salary: Negotiable

Java Developer Reference No: 160946520 | Cape Town, South Africa | Posted on: 13 July 2022

PBT Group has an opportunity for a Java Developer to develop and codify application and software solutions that are bespoke, innovative and sustainable.   Duties: Macro environment Engage with the macro-environment to look for new opportunities, capabilities and trends that would add value to the required development work Suggest changes in executing work processes to better drive value and benefits for the business Prepare and share recommendations for process and systems improvements in relevant area of accountability Actively participate in team, cross-discipline and vendor-driven collaboration sessions or forums to increase understanding of the working environment (current and planned)   Business alignment Partner with BT and Business stakeholders to create integrated roadmaps to enable business requirements delivery   Solution design and build Consolidate and prepare solution design documentation Apply standards and governance in such a way as to develop the best fit solution for business Coordinate and apply various coding efforts Collate data on coding progress achieved Address and develop solutions to problems and risks arising from coding efforts   Test Design relevant test scripts/ test cases to best determine system readiness and usability   Service handover Provide second tier support as required   Experience: 8+ years Java experience. Familiar with agile methodology Strong back end and front end development skills Strong SQL skills, especially on MSSQL Solid experience in the following technologies: SOA Microservices Docker Java Angular NodeJS Bootstrap Spring boot Hibernate Tomcat Jboss Nexus Teamcity Maven Kafka Experience with workflow tools like TIBCO AMX an advantage Experience with rules engines like Drools and advantage In depth knowledge of: Relevant system/application development language Relevant development frameworks Coding for security best practice Agile/DevOps principles and applications Bespoke BU/FA knowledge Corporate and investment banking domain (preferred) Relevant banking regulations (preferred) Worked in an Agile/DevOps environment (preferred)   Competencies: Analysis and Attention to Detail - ability to be systematic and rule orientated in gathering, reviewing and evaluating data from a variety of perspectives; includes the ability to work with precision and highlight inconsistencies and inaccuracies in detailed information. Big Picture Thinking - ability to integrate information from a variety of sources, discern complex underlying relationships and predict patterns for future growth. Drive and Results Orientation - self-starter and originator who maintains high levels of activity and produces a consistently high-quality output within agreed deadlines. Prompt and proactive in driving for results and sets demanding goals for self and others. Problem Solving – cuts to the core of issues and applies effective analysis, logic and creativity to identify and implement solutions. Customer Service Orientation - anticipates, recognises and meets the needs of internal and external clients or customers (however these are defined in the role), taking responsibility for maintaining the highest service standards and developing and sustaining productive client relationships. Building Relationships - capacity to put people at ease and build sound relationships based on mutual trust and openness.   Qualifications/ Certification: Degree in relevant Technology OR Science OR Engineering field of study
Salary: Negotiable

Data Engineer Reference No: 2841535276 | Cape Town, South Africa | Posted on: 13 July 2022

We currently have numerous vacancies for Data Engineers skilled in tools such as the Microsoft Stack (SSIS, SSRS, SSAS), Power BI, AWS, Azure, DataStage, SAS etc.   Duties: Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. Perform root cause analysis, performance monitoring and application related issues. Review IT work products from the team members for completeness and quality. Accurately translate business requirement to technical documentation and test case or results. Analyse and map data from source systems to target operational data stores and data marts. Maintain and provide application support in production. Code or folder migration from one environment to another as part of release management. Participation in all aspects of quality assurance. Active participation in systems integration and user acceptance testing.   Required Skills: Strong modular system design skills. Conventional and data warehouse modeling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   Required Qualifications / Training: Relevant data warehouse and BI solution training is essential. B.Sc. or related degree is advantageous. 5+ years programming experience.
Salary: Negotiable

Data Analyst Reference No: 2794269104 | Cape Town, South Africa | Posted on: 13 July 2022

PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights.   We are looking for an individual with experience in using a variety of data tools, analysis methods and data visualization to turn data into actionable insights with demonstrable business impact. About the role: Data Preparation Analysis and Visualisation Stakeholder Engagement Data Integration About you: Functional experience in analytics, data visualisation or reporting 2-5 years of experience performing data analysis in a BI environment. Experience with reporting packages Demonstrated experience in handling large data sets and relational databases with proven SQL skills. Ability to comply with and manage data assets under a strict governance framework. Experience in agile development desired Ability to work with data profiling, data quality and reference data toolsets. Knowledge of the following BI processes and methodologies: SQL, application, information architecture and ETL procedures Data integration  
Salary: Negotiable

Solutions / Integration Architect Reference No: 1775738539 | Cape Town, South Africa | Posted on: 06 July 2022

PBT Group has an opportunity for an innovative Solutions/Integration Architect to develop and implement systems architecture that will meet business needs. The Solution Architect’s responsibilities include gathering requirements and functional specifications, assessing the current software systems in place in order to identify areas in need of improvement, and overseeing development teams. You should also be able to regularly update the company on any developments in systems architecture projects. The Architect should be able to integrate any updated specifications and requirements into the systems architecture. An outstanding Solution Architect should be able to explain complex problems to management in layman’s terms.   Duties: Building and integrating information systems to meet the company’s needs. Assessing the systems architecture currently in place and working with technical staff to recommend solutions to improve it. Resolving technical problems as they arise. Providing supervision and guidance to development teams. Continually researching current and emerging technologies and proposing changes where needed. Informing various stakeholders about any problems with the current technical solutions being implemented. Assessing the business impact that certain technical choices have. Providing updates to stakeholders on product development processes, costs, and budgets. Assists Solution Architects, and Project Managers in matching technology services to specific business service and application development projects to ensure consistent use throughout the enterprise. Identifies and leverages opportunities across IT departments to ensure a consistent and efficient infrastructure framework.   Skills and Experience Required: 5 – 8 years relevant experience Proven experience in engineering and software architecture design. In-depth understanding of coding languages (.Net Core, Java, JavaScript). Containerized platforms (OpenShift, Kubernetes) Experience in Integration Platforms (RabbitMQ, Kafka) DevOps Tooling and Process AWS/Azure knowledge advantageous Sound knowledge of various operating systems and databases (SQL) Understanding of Security patterns and network routing Strong organizational and leadership skills. Self-Starter   Knowledge and Skills Business Requirements New Technology Research Project Management IT Architecture Standards and Procedures Profile source data and determine all source data and metadata characteristics   Personal Attributes Interpersonal savvy - Contributing through others Decision quality - Contributing through others Optimises work processes - Contributing through others Plans and aligns - Contributing through others   Core Competencies Being resilient - Contributing through others Collaborates - Contributing through others Cultivates innovation - Contributing through others Customer focus - Contributing through others Drives results - Contributing through others   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent  
Salary: Negotiable

Azure Data Engineer Reference No: 447158994 | Johannesburg, South Africa | Posted on: 05 July 2022

PBT Group has an opportunity for an Azure Data Engineer.  The specification for the scope of work deliverables includes: Data Engineering Collecting, centralizing and consolidating large amounts of data from multiple sources by applying data extraction, transforming and load techniques which allow organizations to derive valuable business insights from their data to improve decision-making and enables reporting and analysis. Collaborate with business in defining necessary architecture, design and build data engineering solutions for business enablement. Identify, source and make available key data required for day to day operational reporting and analytics in the Analytics Ecosystem platform. Implement an automated data orchestration and quality solution to ensure reliable and readily available data. Create and publish data products to enable strategic business initiatives in the Analytics Ecosystem platform. Build reporting and analytics solutions to enable and improve decision-making   Skillsets Required Azure Data Engineering (Azure Data Factory, Azure Synapse, PowerBI)
Salary: Negotiable

Senior Microsoft BI Developer Reference No: 4191766773 | Cape Town, South Africa | Posted on: 04 July 2022

PBT Group has a requirement for a Senior Microsoft BI Developer who knows SSIS, SSAS and SSRS. Must have strong ETL   REQUIRED SKILLS: - Microsoft BI: Strong SQL, SSIS, SSAS, SSRS - Ab Initio experience would be an advantage.  - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. - System analysis and design skills are necessary to design and document the data extractions and transformations. - Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. - Good organisation, planning and basic management skills. - Good interpersonal and communication skills. - Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: - Relevant data warehouse and BI solution training is essential. - B.Sc. or related degree is advantageous. - 5+ years programming experience.   DUTIES: Duties: Back-end - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   Duties: Front-End - Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. - Develop the semantic layer, metadata, reports and report definitions. - Develop graphs and portal interfaces. - Load and maintain the metadata for the data access tool. - Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. - Produce complex, efficient, error-free reporting solutions and related documentation. - BI front end development on data structures, cubes, reporting, dashboards, etc.
Salary: Negotiable

Data Quality Analyst Reference No: 1164924112 | Johannesburg, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for a Data Quality Analyst with experience in the financial services industry.   The Data Quality Analyst will reporting directly to the Data Quality Lead, and be focused on driving and supporting Data & Integration to implement Data Quality Management. This includes data quality measurement & monitoring and data quality issue management & remediation. They will be a delivery-oriented Data Quality Management professional who is able to work with stakeholders to effectively identify, remediate and manage data quality issues and incidents. This will include inputs into the effective use of our enterprise metadata repository as it relates to, and influences, data quality management. Their key focus will be the expansion of the data quality scoring scope to include all data assets for both On & Off-Platform data. The DQ Analyst will be working very closely with the Data Governance team, who will be setting out and embedding the Data Management Principles, Data Governance Framework and Data Standards, that will lay a foundation for the Data Quality Management stream.   In this role, the Analyst will be required to work across multiple business units in building and maintaining strong relationships. They will use their ability to influence and support a diverse set of stakeholder groups to effectively manage their Data Quality issues and incidents, contribute to the identification and remediation of enterprise level issues, and guide on what they need to do to establish good data quality management practices within their business. This includes measuring and monitoring data quality effectively. Improve profitability by supporting the IT Strategy through necessary interventions.   Duties: Assist the Data Quality Lead in chairing Data Quality Working Group Drive the establishment of data quality measurement and monitoring Lead preparation of business groups to effectively implement data quality measurement practices Lead the business support of the Data Quality platform Drive Data Quality Issue Management involving: leveraging and, where necessary, uplifting the artefacts in place today to set clear “how to” guidance on good data quality management practices highlight the impact of poor quality data, from a regulatory, compliance, finance and reputation perspective supporting the teams to implement the necessary structure within their businesses to implement effective data quality issue management ensuring data quality rules are captured within the enterprise repository Manage data quality issues Ensure accurate, monthly, Data Quality reporting is produced to give visibility to Data Governance Council and Data Stewards Forum on data quality issues Analyse data quality issues, facilitating the determination of issue impact, root cause and solution options Assist the DQ Lead in implementing the Data Quality Program and Data Remediation Strategy Oversee the design and delivery of data integrity specific reports and insights that analyzes and provides a view of the quality of data Support all data streams within Data & Integration, by identifying anomalies across data landscape Provide quality assurance of imported data Organize and drive successful completion of data insight initiatives through effective management and collaboration with key stakeholders Communicate results and business impacts of insight initiatives to stakeholders Locate and define new process improvement opportunities relating to data analytics   Experience: Strong financial services industry exp 5+ years’ experience working in Data Management Practices, particularly in Data Quality Experience working with business and technical project stakeholders to translate business requirements into data requirements Experience in data management and a passion for driving value through data Experience defining data quality rules / business rules / validation/ data controls An analytical mind and inclination for problem-solving Ability to work on multiple projects in parallel Ability to work in an agile methodology Analytical Skills: Work with large amounts of data: facts, figures, and number crunching Communication Skills: Present findings or translate the data into an understandable document. Write and speak clearly, easily communicating complex ideas Critical Thinking: Must look at the numbers, trends, and data and come to new conclusions based on the findings. Attention to Detail: Data is precise. Vigilant in analysis to come to correct conclusions Solid Short-term insurance business knowledge Knowledge of Cloud services Ability to produce solutions using Microsoft Azure packages Exposure to the Cloud environment Microsoft Excel (Power Pivot, Power Query) Microsoft SQL Integration Services Microsoft SQL Analysis Services Microsoft SQL Reporting Services Microsoft Data Quality Services (or any data quality tool) Microsoft PowerBI QlikView MS Office MS Visio SSRS SSIS   Qualifications/ Certification: BSc Computer Science - Informatics/ Data Analytics/ Statistics/Mathematics degree Microsoft Business Intelligence certification – advantageous Certified Data Management Professional (CDMP) Certified
Salary: Negotiable

Ab Initio Data Engineers ETL Developers Reference No: 756721999 | Johannesburg, South Africa | Posted on: 30 June 2022

PBT Group, leading Data Specialists, has an opening for 2 x experienced Ab Initio ETL Developers in Johannesburg, ideally with ExpressIT experience.   DUTIES: - Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems. - Conduct planning, analysis and design activities in conjunction with other development specialists. - Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements. - Participate in estimation of tasks and assist in the development of project plans. - Code or makes modifications to programs of high complexity, according to specifications. - Conduct medium to high complexity evaluations for product releases, stand-alone products, etc. - Conduct walkthroughs and quality review of deliverables. - Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces. - Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes. - Participate in the formulation of standards to support the data acquisition development process. - Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met. - Ensure compliance with established policies, standards and methodologies.   SKILLS REQUIRED: - A sound knowledge of Ab Initio (2+ years’ experience). - ExpressIT experience would be highly beneficial - Strong ETL experience - Strong SQL experience - Banking Industry experience - Intimate knowledge of source systems as well as a basic understanding of dimensional models. - Conventional database- and data warehouse modelling skills, in order to understand the data warehouse data models. - A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs. - Pride of work, thoroughness and attention to detail. - Relevant data warehouse and BI solution training is preferred. - B.Sc. or related degree is advantageous.   Qualifications/ Certification: - A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent  
Salary: Negotiable

Senior AWS Cloud Data Engineer Reference No: 2633540188 | Johannesburg, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for an AWS Cloud Data Engineer to implement and maintain the private and hybrid cloud environments in line with the Cloud Strategy to optimise IT expenditure and deliver efficiencies through automation.   Duties: Engage and collaborate with Infrastructure Designers and Platform Owners to review and approve cloud template and patterns Conduct logical deployments of cloud configuration/s Automate cloud services Collaborate with Public Cloud Providers specifically around the integration and consumption of services Maintain and enhance cloud service offerings including portal and catalogue items Ensure all service offerings integrate into ITSM processes (includes infrastructure recoveries, management and delivery according to SLA) Responsible for capacity planning to ensure capacity exists at the right time with the right infrastructure Ensure that enterprise standards and IT governance standards are applied to the cloud infrastructure Report on the performance of the cloud infrastructure and recommend actions where required Act as a third level support to the cloud infrastructure operations team Advise and consult to project workgroups on all cloud related matters Ensure and maintain the stability and reliably of the cloud services Right-size the infrastructure as and when required Execute deliverables in line with cloud strategy within agreed timeframes Keep certifications valid and up to date Keep up to date with current industry trends   Experience: AWS Cloud Specialist IaC (Terraform, CloudFormation) Kubernetes / Containers Development (Java / Python) Full Stack Development 10 Years IT Infrastructure and Operations experience Practical IT operational experience General understanding of end-end IT infrastructure Exposure to Containerisation Exposure to Open-Source Technologies (familiarisation with multiple design, construction, version control and testing tools) Experience working with teams across geographic boundaries and organisational levels Project Methodology (Agile, Kanban, Waterfall etc) (Advantageous) Microsoft Azure, AWS, Google Cloud Exposure (Advantageous) Exposure to XML scripting (Advantageous) Advanced Knowledge of: Virtualisation ITIL Storage, Networking Operating Systems SDDC (Software Defined Data Centre) Intermediate Knowledge of: DevOps Tools and Integration IT Security Private/Hybrid Cloud Integration Scripting Technical/Professional Knowledge & Skills Managing Work Innovation Initiating Action Influencing Collaborating Customer Orientation Leveraging Feedback Continuous Improvement Emotional Intelligence Essentials   Qualifications/ Certification: Essential: Matric Preferred: Relevant IT related Degree or Diploma Microsoft AZURE / AWS Certification Certifications: Public Cloud Certification and Virtualisation certification (VMware preferable)
Salary: Negotiable

SAS Solutions Architect (AWS an advantage) Reference No: 3023109132 | Johannesburg, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for a hands-on Solutions Architect with the ability to also explore any new technologies & techniques for the ever-changing landscape of requirements wrt Data. Progressive involvement will require significant focus on AWS (Solution Architecture and transition from on-prem to Cloud).   Duties: Advise & Implement on any technical Data methods, systems or Architecture for the Data Office. I serve as the Data Engineering Tech Lead and have to analyse and solve any new requirements that may arise in an agile fashion. Developing & implementing bespoke applications that utilise the Data Lake repository of diverse data (e.g. multiple Claims Payments systems, Fraud Alerting, Data Lake Scheduling Monitoring) – mainly using SAS as the Data Integration tool and logical mechanism for the build. Supporting the Data Lake (and Data Office as whole) technical environment (SAS, Linux, Oracle, Hadoop). Take the Lead on all Data Office Data Ingestion Patterns (external & internal), advise, explore and implement. Mentor and train developers in using the Data Lake effectively and bringing the juniors up to speed Assist the PBT Cloud Journey Project team with information gathering from the current Data lanscape.   Experience: Technical skills: The Skillset requires a very deep SAS knowledge, with good Linux, Oracle, Hadoop, SQL practical experience. With the onset of the AWS Cloud Migration, AWS Solution Architecture work will become much more necessary in the near future.   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent
Salary: Negotiable

Data Scientist Reference No: 47775611 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for a Data Scientist to build and implement (ML) models to improve business processes resulting in efficiencies and cost savings. Develop data driven insights to help identify trends and opportunities and provide solutions based on these insights. Provide in depth analysis of data using data mining and profiling techniques to understand current business challenges and predict future needs. Effective communication of results to stakeholders.   Duties: Develop information driven insights to identify trends and opportunities and provide solutions based on these insights. Manage data analysis and interpretation including modelling and simulation. Drive the advanced analytics capability within the team and company. Devise and promote creative data visualization to derive actionable intelligence. Forecast the performance of data relative to business needs. Develop recommendations based on data interpretation and analysis to transform behaviours. Develop automated tools and dashboards with IT team to provide real-time insights to business data. Design data integration from multiple systems into manageable data warehouses and analytic data models. Utilize strong research or technical skills to conduct business or industry-wide analysis of current and emerging best practices that support analytics engagement. Proactively improve analytic approaches, methodologies, data and reporting capabilities. Translate data analytics findings into actionable business insights. Critically evaluate information gathered from multiple sources and reconcile conflicts. Develop and deliver compelling presentation using data and graphics to communicate insights and implications for decision making. Provide subject matter expertise for all data related processes and analysis. Actively participate and influence continuous improvement to the organisations data warehousing and Business intelligence solutions with a motive for eliminating redundant and manual data extraction and processing. Extract meaning from complex data relationship and develop reports to enable effective use of the resulting knowledge. Develop information driven insights to identify trends and opportunities and provide solutions based on these insights. Manage data analysis and interpretation including modelling and simulation. Drive the advanced analytics capability within the team and company. Devise and promote creative data visualization to derive actionable intelligence. Forecast the performance of data relative to business needs. Develop recommendations based on data interpretation and analysis to transform behaviours. Develop automated tools and dashboards with IT team to provide real-time insights to business data. Design data integration from multiple systems into manageable data warehouses and analytic data models. Utilize strong research or technical skills to conduct business or industry-wide analysis of current and emerging best practices that support analytics engagement. Proactively improve analytic approaches, methodologies, data and reporting capabilities. Translate data analytics findings into actionable business insights. Drive change methodology and ensure implementation across all projects Work with business to develop and implement change management strategies and plans that maximize user adoption and proficiency and minimize resistance by increasing benefit realization, value creation, ROI and the achievement of business results and outcomes. Continuous improvement to ensure effective service Ensure statutory and legislative knowledge is always current in order to resolve customer complaints, to advise the business on corrective solutions to mitigate risks and to improve the customer experience whilst complying with governance requirements. Ensure adherence to organisational policies, practices and procedures. Identify solutions to enhance cost effectiveness and increase operational efficiency. Service delivery to ensure customer satisfaction Maintain service, quality and desired outputs across the business process by ensuring compliance to tactical policies, procedures and standards. Establish productive operational relationships with key stakeholders in the various channels and administrative teams. Develop work routines in line with operational plans / schedules in order to manage achievement of service delivery goals. Share knowledge on, and participate in the creation of new standards, control systems and procedures to maintain service delivery. Ensure cost efficiency through financial and corporate governance Contribute to the development and implementation of fit for purpose budgets. Manage supplier relationships, and budgets associated with projects. Manage quality people practices Align own behaviour with the organisation culture and values. Share and transfer product, process and systems knowledge to colleagues. Collaborate and work with the HR and IT teams to deliver required service levels. Actively share information with other team members regarding successes, issues, trends and ideas.   Experience: Data science experience 5 – 8 years’ experience applying analytical methods to business problems, including build and implementation of models (machine learning, GLM, etc.) Experience working in the general insurance industry will be advantageous MUST have Risk, Reg and Reporting background/experience Knowledge of SAS, SQL, PYTHON and HADOOP Strategic: Is able to understand, identify and acts on broader opportunities in order to drive longer term, value-adding change. Applies judgement effectively. Identifies and acts on market and/or competitor trends/opportunities Customer: Putting the customer at the heart of business decisions and driving to improve value for customers. Collaboration: Creates trust, respect and builds meaningful relationships. Able to handle a wide range of relational challenges to ensure collaboration across boundaries. Leading with Influence: Influences and rallies people behind common goals; actively supports growth and inspires others to exceed expectations. Communicates clear strategies and objectives for own function. Innovation: Generates creative/out of the box solutions. Challenges the status quo and/or demonstrates ability to relate to challenges from a range of diverse but relevant perspectives. Willing to take calculated risks when introducing novel ideas. Personal Mastery: Learns and actively works to build self-awareness; develop through experience and feedback from others. Copes effectively with stress and has the resilience to take on stretching and challenging assignments. Adjusts effectively to work within new work structures; processes; requirements and cultures. Executing: Displays consistent energy, drive and perseverance in order to deliver results. Demonstrates a willingness to take calculated risks to achieve stretch performance goals.     Qualifications/ Certification: Bachelor’s/honours degree in either Mathematics/Statistics, Actuarial Science, Computer Science, or Information systems.
Salary: Negotiable

Microsoft BI Developer Reference No: 1599000255 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS.   REQUIRED SKILLS: - Microsoft BI: Strong SQL, SSIS, SSAS, SSRS - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. - System analysis and design skills are necessary to design and document the data extractions and transformations. - Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. - Good organisation, planning and basic management skills. - Good interpersonal and communication skills. - Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: - Relevant data warehouse and BI solution training is essential. - B.Sc. or related degree is advantageous. - 5+ years programming experience.   DUTIES: Duties: Back-end - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   Duties: Front-End - Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. - Develop the semantic layer, metadata, reports and report definitions. - Develop graphs and portal interfaces. - Load and maintain the metadata for the data access tool. - Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. - Produce complex, efficient, error-free reporting solutions and related documentation. - BI front end development on data structures, cubes, reporting, dashboards, etc.
Salary: Negotiable

ETL Developer Reference No: 3080793644 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for a Solid ETL Developer.   Duties: Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems. Conduct planning, analysis and design activities in conjunction with other development specialists. Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements. Participate in estimation of tasks and assist in the development of project plans. Code or makes modifications to programs of high complexity, according to specifications. Conduct medium to high complexity evaluations for product releases, stand-alone products, etc. Conduct walkthroughs and quality review of deliverables. Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces. Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes. Participate in the formulation of standards to support the data acquisition development process. Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met. Ensure compliance with established policies, standards and methodologies.     Required Skills: Intimate knowledge of source systems as well as a basic understanding of dimensional models. Conventional database- and data warehouse modeling skills, in order to understand the data warehouse data models. A sound knowledge of the programming language used to write the data staging programs or ETL tool. A sound knowledge of SQL, or the language used to access the source databases and the data warehouse from the data staging programs or ETL tool. A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs. Pride of work, thoroughness and attention to detail. Cloud experience would be beneficial   Required Qualifications / Training: Course on the ETL / related toolset. Relevant data warehouse and BI solution training is essential. Sc. or related degree is advantageous. 2+ years programming experience.
Salary: Negotiable

Microsoft BI Developer Reference No: 1861936357 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS. REQUIRED SKILLS: - Microsoft BI: Strong SQL, SSIS, SSAS, SSRS - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. - System analysis and design skills are necessary to design and document the data extractions and transformations. - Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. - Good organisation, planning and basic management skills. - Good interpersonal and communication skills. - Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: - Relevant data warehouse and BI solution training is essential. - B.Sc. or related degree is advantageous. - 5+ years programming experience.   DUTIES: Duties: Back-end - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   Duties: Front-End - Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. - Develop the semantic layer, metadata, reports and report definitions. - Develop graphs and portal interfaces. - Load and maintain the metadata for the data access tool. - Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. - Produce complex, efficient, error-free reporting solutions and related documentation. - BI front end development on data structures, cubes, reporting, dashboards, etc.
Salary: Negotiable

System Analyst Reference No: 3516112714 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for a Systems Analyst at an Investment customer based in Cape Town.   Duties: Do technical design of applications based on business processes and requirements documentation, aligned with architectural guidelines. Do the Logical system design (independent of technology) and create Use Case Realisation Documentation and a Logical Data Model Create System Integration Specifications Design and document web services Analyse existing landscape for services that can be reused Identify and analyse Non-Functional Requirements and include in technical documentation. Provide input to Functional specifications as required Provide input into Quality Management Plan Assist with quality reviews Provide input to software development plans Provide input to the scoping and estimation process.   Experience: 5 years relevant experience in systems analysis and design Sound Understanding of Object-Orientation Sound UML experience Sound understanding of service design Solid expertise in MS SQL Experience using service integration testing tools e.g. SoapUI, Postman etc. Documenting technical/system processes At least 8 years IT experience Exposure to Information Governance, BI (Business Intelligence) and Enterprise Data Programs, preferably recently Understanding of data management frameworks Experience working with cross business data domains Exposure to the asset management industry Understanding of the SDLC Methodology Relevant programming languages Problem Analysis and Problem-Solving Techniques Impact Analysis Techniques Documentation Frameworks, Tools and Standards Understanding of Project Management Principles High level understanding of Enterprise Test Methodology Understanding of BPMN or similar business process language would be advantageous Exposure to the asset management industry   Qualifications/ Certification: Computer Science degree, IT Diploma or equivalent in experience Any secondary qualifications with emphasis on technical related courses such as systems design, OO A&D methodology and SO methodology will be a strong advantage   Competencies Strong analytical, data & numerical ability Attention to detail Problem solving skills Conceptual thinker (big picture), logical (process) thinker and implementation level thinking Good communication skills Action and results orientation Quality orientation Ability to work both independently and within a team Knowledge seeking and learning orientation Ability to perform impact analysis, at all levels, i.e. conceptual, logical and implementation Ability to translate business requirements, business processes and architecture requirements into technical designs Able to guide and provide input into testing requirements   Behavioural Competencies: Planning and organising to deliver results and meet expectations Problem solving and prioritising skills Good communication/interpersonal skills Relationship development and networking Client service orientated Action / results orientated Detailed orientated Numerical skills Ownership of tasks High energy Self-starter Sound decision-making skills Ability to avoid “analysis paralysis” Resilience Perseverance
Salary: Negotiable

BI Solutions Architect Reference No: 1998764282 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for a Solutions Architect for a position at an Investment client.   Duties: Data and Information Asset Management Develop, implement and manage the processes and mechanisms for classifying data and information assets in terms of its purpose, sensitivity and quality as well as the level of access control and protection applicable to it. Data Profiling and Data Quality Management Develop, implement and manage the processes to assess data quality and diagnose and report issues for correction. Using data profiling and data quality monitoring & reporting tools, measure completeness, timeliness, accuracy, consistency, relevance and integrity, ensuring data is fit for its intended uses on the BI platform. Reference Data Management Develop, implement and manage the processes for reference data on the BI platform as a special subset of master data that's used for classification throughout the organisation. This includes reference data that is externally mandated or internally authored. Metadata Management Develop, implement and manage the processes for metadata (i.e. data about data) associated with the data on the BI platform. Develop and implement the end-to-end governance framework and model for creating, controlling and enhancing metadata on the BI platform. Data Lineage Management Develop, implement and manage the processes that track the life-cycle of data on the BI platform from ingestion through to consumption as well as how it changes over time (Data lineage tracking is required for master data, reference data, transactional data and metadata on the BI platform.)   Develop physical data management architectures, policies, and practices and oversee the execution of procedures to manage data across its lifecycle on the BI platform from acquisition to consumption.   Requirements & Experience 8 to 10 years’ experience Relevant Data system experience in warehousing, ETL, Reporting, Management Reporting, Business Intelligence implementations, migrations and technology selection Relevant experience delivering business solutions using applicable technology Understanding of data flow from a technical and business perspective from source to output though Information management systems such as Data Warehouses and Data transformation hubs Understanding of Information Architecture domain (e,g DAMA / DMBOK) Define data management policies for governance purposes Ability to balance agility with risk in policy setting Understanding of enterprise implications of data policy as it relates to other policy domains: Security, Regulatory, Legal, Tax and Channel conflict Experience in warehousing, ETL, Reporting, Management Reporting, Business Intelligence implementations, migrations and technology selection Experience with Cloudera, HANA, Teradata would be preferential Demonstrated competence in business domain analysis, data warehousing (design and operations), and database design Demonstrated competence with benefits, design and management of structured and unstructured content and databases / repositories (SQL, NoSQL, HDFS/Hadoop distributions, etc.) and hands-on experience with specific products Demonstrated competence with Microsoft SQL Server, Oracle DBMS, SAP Business Objects, and related tools is valued Working knowledge and understanding of benefits and positioning of data virtualization Working knowledge of data science, data mining, OLAP programming, database management and programming, business process modelling and analysis Working knowledge of statistical computing and graphics programming languages (R, Python, etc.) Working knowledge of open source or commercial data visualization tools (Power BI, BOBJ, Tableau, QlikView) Working knowledge of cloud-based offerings and vendor differentiation related to analytics and information processing capabilities (AWS, Azure)   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent   Behavioural Competencies Planning, prioritising and organising own work to deliver results and meet expectations Relationship development and networking Client service orientated Action / results orientated Detailed orientated, yet ability to avoid “analysis paralysis” Ownership of tasks and self-starter Sound decision-making skills Resilience and perseverance Knowledge seeking and learning orientation Ability to work both independently and within a team  
Salary: Negotiable

Full-Stack Technical Lead Reference No: 1506357716 | Cape Town, South Africa | Posted on: 30 June 2022

Guided by Architecture and a Technical Team Lead you will be responsible for establishing new technology components and reusable solution patterns that can be leveraged by business facing development teams in their day-to-day solutions. You will constantly be developing and setting new principles, standards, processes, procedures and guidelines for the wider BI community. You should be able to communicate technical information to technical teams, as well as be competent in communicating challenges and solutions to project and operational leadership. An understanding of data management solutions and a keen sense of the strategic value of information to an organisation will be of importance. You will also be responsible for developing data warehousing blueprints, evaluating hardware and software platforms and integrating systems; translating business needs into long-term architecture solutions.    The successful technical lead will have the following traits: Ability to define a structured approach to problem solving and delivery against it. Ability to create design standards, patterns and principles. Ability to define a structured approach to problem solving and delivery against it. Creation of role specific design standards, patterns and principles. Data management, development and modelling. Engage with a wide range of technical stakeholders including data scientists, business analysts, data engineers, database administrators and solutions architects. Mentor Junior Full Stack Developers.   Experience 3 - 8 years related experience Application and data engineering background with a solid background in SQL is required Data architecture design and delivery experience preferred Experience in 3 or more of the following areas are required: Database technologies (e.g. SAP Hana, Teradata or similar) and database development (Views, Functions and Stored Procedure development) Hadoop components including HDFS, Hive, Spark, Oozie and Impala Object-oriented/object functional scripting languages: Python, Java, Scala or related ETL tools (e.g. SAP Data Services) Event/Streaming based data pipelines (e.g. Kafka or Nifi) Data warehousing (Kimball and Data Vault patterns are preferred) and dimensional data modelling (OLAP and MDX experience)   Qualification Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering or another quantitative field or, National Diploma in an Information Technology related discipline preferred   Knowledge and Skills IT Data Analysis Project Oversight Reporting and Administration Quality, Compliance and Accreditation Business Requirements Definition Technologies   Personal Attributes Manages complexity - Contributing independently Optimises work processes - Contributing independently Organisational savvy - Contributing independently Plans and aligns - Contributing independently   Core Competencies Being resilient - Contributing independently Collaborates - Contributing independently Cultivates innovation - Contributing independently Customer focus - Contributing independently Drives results - Contributing independently
Salary: Negotiable

AWS Data Engineer Reference No: 1235265271 | Cape Town, South Africa | Posted on: 30 June 2022

AWS Data EngineerVincent Replacment   PBT Cape Town is currently recruiting for a Data Engineer to build the infrastructure required for optimal extraction, transformation and loading of data from a wide variety of data sources using AWS technologies. The role will require the analysing of raw data, as well as developing and maintaining datasets. About you Appropriate degree/ diploma in Computer Science/Information Technology/Math Appropriate certification in cloud data engineering Minimum of 2 years’ experience in cloud data engineering and design Strong experience in working with AWS cloud services: EC2, EMR, RDS, Redshift, S3 working on Terraform and object-oriented/object function scripting languages: SQL and Python Experience building and optimizing ‘big data’ data pipelines, architectures and data sets. Strong analytic skills related to preparing both structured & unstructured datasets from streaming and batch processes. Build processes supporting data transformation, data structures, metadata, dependency and workload management. A successful history of manipulating, processing and extracting value from large disconnected datasets.  
Salary: Negotiable

Datastage ETL Developer Reference No: 2827322466 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has a requirement for DataStage ETL Developers (Warehouse/Data Integration).   DUTIES: - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   REQUIRED SKILLS: - IBM: DataStage Tool - Telco / Banking experience would be an advantage - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. - System analysis and design skills are necessary to design and document the data extractions and transformations. - Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. - Good organisation, planning and basic management skills. - Good interpersonal and communication skills. - Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: - Relevant data warehouse and BI solution training is essential. - B.Sc. or related degree is advantageous. - 5+ years programming experience.    
Salary: Negotiable

Python Backend Engineer Reference No: 1354570438 | Cape Town, South Africa | Posted on: 30 June 2022

  PBT Group has an opportunity for a Python Backend Engineer. The Python Backend Engineer is responsible for understanding requirements and building solutions under a serverless architecture model. The Python Backend Engineer reports directly to the Product Owner and the Team Leader.   Duties: Build solutions from requirements received from product owner. Be able to work in agile environment. Able to build POC solutions and demonstrate/present. Able to elaborate and present his work efforts twice a month in open meeting company sessions. Be able to brainstorm solutions with team member. Good communication skills. Be available to work in an office when it’s necessary. Be able to report on his work using agile tools such as JIRA. Be able to elaborate and document his work in confluence. Communicative and proactive.   Experience: AWS components such as Lambda, SQS, Dynamo DB AWS API Gateway Terraform Python 3.9 Pytest Knowledge of Rest API integrations Openapi, swagger GitHub actions for CI CD Docker and Docker compose Makefile Apache velocity language   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent  
Salary: Negotiable

Data Engineer Reference No: 1160435330 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for an Intermediate Data Engineer. The Data Engineer must have experience in migrating legacy to AWS Lambda.   Duties: Assist in designing and implementing scalable and robust processes for ingesting and transforming datasets. Design, implement and support the creation and maintenance of data pipelines from a multitude of sources. Ingest large, complex data sets that meet functional and non-functional requirements. Enable the business to solve the problem of working with large volumes of data in diverse formats, and in doing so, enable innovative solutions. Design and build bulk and delta data lift patterns for optimal extraction, transformation, and loading of data. Supports the organisation’s cloud strategy and aligns to the data architecture and governance including the implementation of these data governance practices. Engineer data in the appropriate formats for downstream customers, risk and product analytics or enterprise applications. Development of API’s for returning data to Enterprise Applications. Assist in identifying, designing and implementing robust process improvement activities to drive efficiency and automation for greater scalability. This includes looking at new solutions and new ways of working and being on the forefront of emerging technologies. Work with various stakeholders across the organisation to understand data requirements and apply technical knowledge of data management to solve key business problems. Provide support in the operational environment with all relevant support teams for data services. Create and maintain functional requirements and system specifications in support of data architecture and detailed design specifications for current and future designs. Support, test and deployment of new services and features. Design and Implement actionable Alerts, Monitoring and Observability using various toolsets that support our resilience including DR activities Design and build Data validation and reconciliation alerts from source   Required Skills: Strong modular system design skills. Conventional and data warehouse modeling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   Required Qualifications / Training: Relevant data warehouse and BI solution training is essential. B.Sc. or related degree is advantageous.  
Salary: Negotiable

Senior Data Engineer/ Technical Lead Reference No: 133437317 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for a Senior Data Engineer / Technical Lead. The Senior Data Engineer should be comfortable with solution design & data architecture. Must have experience in migrating legacy to AWS Lambda.   Duties: Assist in designing and implementing scalable and robust processes for ingesting and transforming datasets. Design, implement and support the creation and maintenance of data pipelines from a multitude of sources. Ingest large, complex data sets that meet functional and non-functional requirements. Enable the business to solve the problem of working with large volumes of data in diverse formats, and in doing so, enable innovative solutions. Design and build bulk and delta data lift patterns for optimal extraction, transformation, and loading of data. Supports the organisation’s cloud strategy and aligns to the data architecture and governance including the implementation of these data governance practices. Engineer data in the appropriate formats for downstream customers, risk and product analytics or enterprise applications. Development of API’s for returning data to Enterprise Applications. Assist in identifying, designing and implementing robust process improvement activities to drive efficiency and automation for greater scalability. This includes looking at new solutions and new ways of working and being on the forefront of emerging technologies. Work with various stakeholders across the organisation to understand data requirements and apply technical knowledge of data management to solve key business problems. Provide support in the operational environment with all relevant support teams for data services. Create and maintain functional requirements and system specifications in support of data architecture and detailed design specifications for current and future designs. Support, test and deployment of new services and features. Design and Implement actionable Alerts, Monitoring and Observability using various toolsets that support our resilience including DR activities Design and build Data validation and reconciliation alerts from source   Required Skills: Strong modular system design skills. Conventional and data warehouse modeling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   Required Qualifications / Training: Relevant data warehouse and BI solution training is essential. B.Sc. or related degree is advantageous.  
Salary: Negotiable

Cloud Data Engineer Reference No: 907181837 | Cape Town, South Africa | Posted on: 30 June 2022

A cloud data engineer, also known as a cloud engineer or cloud developer, is someone responsible for the management of corporate apps and data in the cloud and all the technical tasks involved in planning, architecting, migrating, monitoring, and managing a company’s cloud systems. A cloud data engineer is expected to be well versed on the best practices for deploying and managing cloud systems and applications on the cloud and needs to implement and ensure adherence to these best practices across the corporation.   Duties: Migrating on-premises corporate applications and related data to the cloud Designing and deploying new applications directly in the cloud Identifying best practices for cloud services monitoring and management and promoting these best practices across the corporation Researching and implementing cloud services to support cloud apps and maintain cloud services Monitoring cloud app performance for potential bottlenecks and resolving performance issues Identifying and implementing cost-saving strategies to reduce ongoing cloud expenses Automating key services and tasks across cloud systems to increase efficiency and further reduce cloud costs Formulating a recovery plan and executing the plan in the event of cloud downtime or failure   Skills Required: SQL, SSIS, AWS, Azure  
Salary: Negotiable

Data Scientist Reference No: 3571891918 | Cape Town, South Africa | Posted on: 30 June 2022

business processes resulting in efficiencies and cost savings. Develop data driven insights to help identify trends and opportunities and provide solutions based on these insights. Provide in depth analysis of data using data mining and profiling techniques to understand current business challenges and predict future needs. Effective communication of results to stakeholders.   Duties: Develop information driven insights to identify trends and opportunities and provide solutions based on these insights. Manage data analysis and interpretation including modelling and simulation. Drive the advanced analytics capability within the team and company. Devise and promote creative data visualization to derive actionable intelligence. Forecast the performance of data relative to business needs. Develop recommendations based on data interpretation and analysis to transform behaviours. Develop automated tools and dashboards with IT team to provide real-time insights to business data. Design data integration from multiple systems into manageable data warehouses and analytic data models. Utilize strong research or technical skills to conduct business or industry-wide analysis of current and emerging best practices that support analytics engagement. Proactively improve analytic approaches, methodologies, data and reporting capabilities. Translate data analytics findings into actionable business insights. Critically evaluate information gathered from multiple sources and reconcile conflicts. Develop and deliver compelling presentation using data and graphics to communicate insights and implications for decision making. Provide subject matter expertise for all data related processes and analysis. Actively participate and influence continuous improvement to the organisations data warehousing and Business intelligence solutions with a motive for eliminating redundant and manual data extraction and processing. Extract meaning from complex data relationship and develop reports to enable effective use of the resulting knowledge.   Develop information driven insights to identify trends and opportunities and provide solutions based on these insights. Manage data analysis and interpretation including modelling and simulation. Drive the advanced analytics capability within the team and company. Devise and promote creative data visualization to derive actionable intelligence. Forecast the performance of data relative to business needs. Develop recommendations based on data interpretation and analysis to transform behaviours. Develop automated tools and dashboards with IT team to provide real-time insights to business data. Design data integration from multiple systems into manageable data warehouses and analytic data models. Utilize strong research or technical skills to conduct business or industry-wide analysis of current and emerging best practices that support analytics engagement. Proactively improve analytic approaches, methodologies, data and reporting capabilities. Translate data analytics findings into actionable business insights.   Drive change methodology and ensure implementation across all projects Work with business to develop and implement change management strategies and plans that maximize user adoption and proficiency and minimize resistance by increasing benefit realization, value creation, ROI and the achievement of business results and outcomes.   Continuous improvement to ensure effective service Ensure statutory and legislative knowledge is always current in order to resolve customer complaints, to advise the business on corrective solutions to mitigate risks and to improve the customer experience whilst complying with governance requirements. Ensure adherence to organisational policies, practices and procedures. Identify solutions to enhance cost effectiveness and increase operational efficiency.   Service delivery to ensure customer satisfaction Maintain service, quality and desired outputs across the business process by ensuring compliance to tactical policies, procedures and standards. Establish productive operational relationships with key stakeholders in the various channels and administrative teams. Develop work routines in line with operational plans / schedules in order to manage achievement of service delivery goals. Share knowledge on, and participate in the creation of new standards, control systems and procedures to maintain service delivery.   Ensure cost efficiency through financial and corporate governance Contribute to the development and implementation of fit for purpose budgets. Manage supplier relationships, and budgets associated with projects.   Manage quality people practices Align own behaviour with the organisation culture and values. Share and transfer product, process and systems knowledge to colleagues. Collaborate and work with the HR and IT teams to deliver required service levels. Actively share information with other team members regarding successes, issues, trends and ideas.   Experience: Data science experience 5 – 8 years’ experience applying analytical methods to business problems, including build and implementation of models (machine learning, GLM, etc.) Experience working in the general insurance industry will be advantageous Knowledge of SAS, SQL, PYTHON and HADOOP Strategic: Is able to understand, identify and acts on broader opportunities in order to drive longer term, value-adding change. Applies judgement effectively. Identifies and acts on market and/or competitor trends/opportunities Customer: Putting the customer at the heart of business decisions and driving to improve value for customers. Collaboration: Creates trust, respect and builds meaningful relationships. Able to handle a wide range of relational challenges to ensure collaboration across boundaries. Leading with Influence: Influences and rallies people behind common goals; actively supports growth and inspires others to exceed expectations. Communicates clear strategies and objectives for own function. Innovation: Generates creative/out of the box solutions. Challenges the status quo and/or demonstrates ability to relate to challenges from a range of diverse but relevant perspectives. Willing to take calculated risks when introducing novel ideas. Personal Mastery: Learns and actively works to build self-awareness; develop through experience and feedback from others. Copes effectively with stress and has the resilience to take on stretching and challenging assignments. Adjusts effectively to work within new work structures; processes; requirements and cultures. Executing: Displays consistent energy, drive and perseverance in order to deliver results. Demonstrates a willingness to take calculated risks to achieve stretch performance goals.     Qualifications/ Certification: Bachelor’s/honours degree in either Mathematics/Statistics, Actuarial Science, Computer Science, or Information systems.    
Salary: Negotiable

Senior Qlikview/Qliksense Developer Reference No: 262662911 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has a vacancy for strong QlikView / QlikSense Developer.   DUTIES: Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. Develop the semantic layer, metadata, reports and report definitions. Develop graphs and portal interfaces. Load and maintain the metadata for the data access tool. Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. Produce complex, efficient, error-free reporting solutions and related documentation. BI front end development on data structures, cubes, reporting, dashboards, etc.   SKILLS REQUIRED: Strong QlikView & QlikSense experience Data warehouse modelling skills is advantageous, in order to understand the data warehouse data models. A sound knowledge of SQL, or the language used to access the data warehouse from the access- or end-user reporting tools. A sound knowledge of the capabilities of the data access- and reporting tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the end user programs or reports. Keep abreast of new releases of these tools and work-arounds to overcome problem areas using these tools. Exposure to various BI front end applications, with working knowledge in at least one of them. Strong ability to analyse user requirements and build front-end BI applications according to specifications. Knowledge of scripting languages. Experience with one or more of the industry standard databases desired. Attention to detail and strong logical reasoning ability. Good communication skills. Pride of work, thoroughness and attention to detail.   REQUIRED QUALIFICATIONS / TRAINING: Relevant data warehouse and BI solution training is essential. Sc. or related degree is advantageous.
Salary: Negotiable

Senior Software Developers Reference No: 2202659839 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has a requirement for a Senior Software Developer, responsible for development and maintenance of applications.    Key Skills: Software developer with a minimum of 4-5 years development experience in the following technologies: React HTML CSS Web based CMS C# .Net Employment experience in the Banking or Financial Services Industries preferred Ability to work under pressure, time management and to be able to multi-task multiple projects. Self-confident/assertive/good communication skills Attention to detail and ability to learn new concepts quickly. Good time management and ability to meet deadlines Hard worker, disciplined and self-motivated. Team player able to collaborate with development team members.  
Salary: Negotiable

Business Analyst Reference No: 1682974193 | Cape Town, South Africa | Posted on: 30 June 2022

Open requirements for a Business Analyst with the ability to translate user and business requirements into specifications for the development of new applications.   Duties: Analyse and document business processes. Collecting, understanding, and analyzing the business requirements for a project, and translating these into business and / or functional specifications. Maintain business documentation with required updates Participate in the report development cycle by assisting the project team in their understanding of the business requirement and objectives and ensuring the correct interpretation of the business requirement Assist in the preparation of test strategies Participate in user acceptance testing Co-ordinate access requirements Ability to function independently and effectively in a self-directed environment.   Business Analysts Skills Required: Ability to investigate, analyse and document business processes. Facilitate requirements gathering workshops and interviews. Gain an understanding of the principles and concepts that drive the business and be able to bring them down to a business/practical level. Ability to make balanced and sound recommendations by understanding business processes, determining problems, risks and opportunities for improvement. Ability to write detailed specification of functional requirements for information systems. End to end experience of the report development lifecycle including system and user and user acceptance testing High Client Focus interacting directly with end users and managers or executives. Results orientated and the ability to initiate action Excellent written and verbal communication skills and an entrepreneurial, self-motivated attitude. More than two years of business analysis specific experience.    Team Orientation: Highly organized, detail-oriented and a strong work ethic Willingness to work with others towards team goals, participating in decision making, co-operating with others and offering assistance when needed. Ability to perform under pressure.   Listening and Communications: Entirely approachable. Actively listens, translates and reacts objectively, even in stressful interchanges. Communicates with clarity and appropriately for the audience.   Education:  An undergraduate degree, preferably in Information Systems or related. A post graduate diploma in business analysis.   Personal Characteristics: Professionalism. High energy. Good track record of working collaboratively with others to produce results. Excellent written and oral communication skills. Strong business acumen. Loyalty and integrity.  
Salary: Negotiable

Web Developer Reference No: 2687992222 | Cape Town, South Africa | Posted on: 30 June 2022

PBT currently has a role for a Web who will be responsible for programming websites, web applications and mobile development. The Web will communicate with clients to determine their needs and design preferences, creating code for the front and back-end of a website.   Required Skills: 3 years’+ experience hands-on development experience. Computer Science related degree, diploma or similar qualification. Experience working in an Agile environment Creative Thinker Ability to work alongside the backend team on integration projects Software: UI, JavaScript, JQuery/Typescript, ASP.NET, MVC and C#, JavaScript Frameworks, i.e. Angular, Front-End Frameworks, HTML5, CSS3, SASS / LESS, Visual Studio, TFS / Git, MongoDB
Salary: Negotiable

Java & JavaScript Application Developer Reference No: 274652873 | Cape Town, South Africa | Posted on: 30 June 2022

Duties: Develop enterprise applications, web portals, mobile applications and line of business solutions. Develop integration solutions to solve inter-company as well as partner to partner integration requirements. Implement workflow, enterprise content management and customer relationship management solutions. Be involved in the full software development lifecycle in a team environment – design, develop, test and deploy. Development of new solutions and maintenance of existing systems. Co-work with the project manager, architect and analyst to set and meet deliverable dates and agreed functionality. Interface with business and customer stakeholders on business requirements, software deployments and maintenance issues.   Required Skills: Strong Java and JavaScript Development experience Exposure to Cloud technologies would be an advantage Some understanding of business analysis and business requirements gathering will be advantageous. Understanding of first principles of programming. Understanding of relational database design theory. Understanding of OO and ideally SOA principles. .NET C# and ASP.NET programming experience. HTML5 and CSS will be advantageous. Microsoft Transact SQL programming experience. Understanding of the SDLC (Software Development Lifecycle). Attention to detail and strong logical reasoning ability. Good communication skills. Pride of work, thoroughness and attention to detail. Self-starter with a passion for their chosen career.   Required Qualifications / Training: BSc Computer Science, BSc Engineering or IT Diploma is a pre-requisite. Microsoft Software Developer Certification Advantageous – MCP / MCSD / MCPD.  
Salary: Negotiable

SQL BI Support Developer Reference No: 1264051954 | Cape Town, South Africa | Posted on: 30 June 2022

Main Purpose: Responsible for the support, enhancement and optimization of the current BI Data Warehouse by managing service requests from users and the support of internal data management tasks. To be successful in this role you will need to have experience working with the Microsoft BI Stack and be well versed in the Ralph Kimball methodology.   Key Responsibilities: Offer support to information delivery production environment: Understand the current production environment and relevant processes Support the BI Team in maintaining the production environment, ensuring delivery of current information to the business on time, effectively collected, correctly transformed, audited, accurately published Develop, maintain and improve ETL jobs and related data warehouse models/objects/systems using ETL tools and coding primarily in Transact-SQL Work closely with the BI Architect and BI Administrator to streamline data flows between internal/external systems and the BIDW Testing and reconciliation of warehouse data to source data to ensure data integrity Efficient and effective resolution of production issues, and users requests for information Monitor the environment to proactively engage in prevention activities and to maintain an environment that is easy to understand and troubleshoot Recurring standby to support and resolve operational issues encountered in the day to day operations of the BIWH production environment   User support Provide a support service to users on data and information to satisfy user needs Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements Adapt ETL processes to accommodate changes in source systems and new business user requirements   Key Competencies: Strong analytical, problem solving and conceptual thinking skills essential Ability to take ownership of problems assigned and find innovative solutions Attention to detail and commitment to delivery is important Must be a team player with a positive attitude Must be able to work to and manage deadlines Flexible, able to change focus when required Excellent communication skills   Qualifications and Experience: Relevant tertiary qualification in Information Technology or similar At least 5 years’ commercial Business Intelligence (Microsoft Stacks) development Intermediate to Advanced skill level in using MS-SQL/T-SQL and SSIS Exposure to Self-Service BI using Power-BI will be an advantage SSRS, SSAS (multi-dimensional and tabular), MDX Working Understanding of Ralph Kimball methodology including good grasp of dimensional modeling and efficient ETL techniques with focus on MS SQL Server Experience in Business Intelligence environment in Financial Services or Retail industry – desirable Exposure in working within an agile project environment will be an added advantage Experience in a SQL Database Administrator or BI Administrator role will be an advantage Experience using a meta-data repository to manage ETL processes and data lineage will be an advantage Experience using Team Foundation (or a similar product) as version control system will be an advantage   Other technologies in use: ActiveBatch Visio / Erwin modelling tools Visual Studio Cognos / Tableau Python
Salary: Negotiable

Business Intelligence Business Analyst (BIBA) Reference No: 1728076158 | Johannesburg, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for a Business Intelligence Business Analyst (BIBA). A BI Business Analyst or BIBA has a crucially important role to play, in bridging any gaps between business and IT, to understand how data-driven changes to process, products, services, software and hardware can improve efficiencies and add value for clients.   The Business Intelligence Business Analyst (BIBA) primarily serves as liaison between the end users and BI project team and gathers business requirements. The BIBA is an expert in understanding business objectives, questions, and problems, and at obtaining and presenting data to address the issues. The analyst understands the tools and techniques used to create data results that range from basic queries through multidimensional analyses and data mining, forming new relations and derivations as necessary, and extracting the maximum amount of valid information content from the data. Extensive insight into the business and the data are essential.   The BIBA participates in design of data marts to provide the optimal balance of data availability, format, flexibility, and performance. The BIBA is involved in the end-to-end Data Product Lifecyle, including requirement definition, data analysis, data modelling.   Duties:   Requirement’s definition phase: Interview end users to determine requirements for data, reports, analyses, metadata, training, service levels, data quality, and performance Help identify and assess potential data sources Validate that BI meets requirements and service level agreements Coordinate prototype reviews Gather prototype feedback Document requirements in relevant formats: Data Warehouse content requirements Data Mart requirements Information output requirements Information exploitation tool – functional requirements Data Profiling, Feasibility and Scope Definition Phase: Analyse business information requirements Recommend appropriate scope of requirements and priorities Work with production data to validate business requirements Map business needs/requirements to subject area model and to logical enterprise model Discover dimension hierarchies Validate hierarchies with production data Define business rules for state detection Design Phase: Work with architects to translate requirements into technical specifications Discover business transformation rules Work with production data to design access structures Classify business users by type Develop security rules/standards Create state transformation models Development Phase: On-hand support to development team to accurately interpret requirements and translate into a quality solution. Testing Phase: Plan acceptance test (functional and data integrity) Execute acceptance test plan internally Facilitate user acceptance testing Change Management and Deployment: Educate users on warehousing capabilities Design training infrastructure Define and get agreement with business users on service-level agreements Develop training materials Write users' guide Train BI users Assist with definition of support plan Interface with process teams regarding business process reengineering Assist users in finding the right information   Skills and Experience Required: At least 3 / 5 years’ experience with a proven track record of delivering Data & Analytics projects through facilitating the Data/Analytics Development Lifecycle.   General BA competencies Business analysis planning and monitoring Requirement’s elicitation Requirements management and communication Business architecture analysis Requirement’s analysis Solution assessment and validation BA tools and techniques Acceptance and Evaluation Criteria Definition Benchmarking Brainstorming Business Rules Analysis Data Dictionary and Glossary Data Flow Diagrams Data Modeling Decision Analysis Document Analysis Focus Groups Interviews Metrics and Key Performance Indicators Non-functional Requirements Analysis Observation Organization Modeling Problem Tracking Process Modeling Prototyping Requirements Workshops Risk Analysis Scenarios and Use Cases Structured Walkthrough Personal skills: Strong communication skills. Good writing skills. Must be able to pay attention to detail. Work independently. Must be a team player. Work on more than one project at a time. Strong leadership and people skills (will be required to work closely with all Data & Analytics Guilds and with business users) BI Project related skills: Apply BIBA methodology in agile environments Strong SQL skills Some systems analysis (source-to-target mappings, data profiling) Deep knowledge of modern data platforms Good general understanding of the relevant industry. Substantial business analysis experience in a BI environment. A good understanding of business processes. Ability to assimilate and apply relevant business principles. Be able to work within the framework of project methodologies and work independently on support and maintenance tasks.   Required Qualifications/ Certification: Ideally candidates should have an IT or business-related qualification. FTI or similar BA qualification will be advantageous.  
Salary: Negotiable

Systems Analyst Reference No: 929461050 | Johannesburg, South Africa | Posted on: 30 June 2022

The Senior System Analyst is responsible for bridging the gap between business requirements and the development team. The System Analyst must understand the business requirements as well as the technical environment and marry the two up. This entails interaction with business, business analyst and technical stakeholders and compilation of Functional Requirements Specifications against which the development and architecture team is able to deliver the solution. In addition the System Analyst must be able to investigate and understand the existing technology, constraints and solutions in place, down to the ability to interrogate and model databases, and top level system architecture. The ideal System Analyst has a combination of a strong technical background, software testing skills as well as business understanding, elicitation and communication skills.   The System Analyst will work on multiple projects in the banking environment and will be required to manage his/her time effectively. The environment is based on Microsoft technology including MS SQL server, a .NET development toolset as well as other technology suites depending on the system in question.   DUTIES:   Functional and Testing Understand and Analyse systems in the environment, including database and top level architecture understanding Produce Functional Requirements Specifications Produce accurate mapping of “As is” and “To be” processes Identify project risks and issues and ensure that they are documented Produce User Acceptance Test Cases and Scenarios and assist with SIT and QA testing Provide regular, continuous and accurate feedback to project management team Participation in and sign-off of user acceptance testing, pilot and production testing   General Adhere to set process standards Co-work with the Business Analysts and technical team to define and design solutions that meet customer requirements Co-work with the project manager to drive delivery on time, within budget, scope and quality Perform efficient and effective JAD facilitation with relevant project stakeholders   Teamwork Build and maintain meaningful relationships with stakeholders   Experience Required: Must be able to operate independently and have a solid Microsoft tools background. Financial Services background Experience across data-, integration services- Front-end- development Process analysis 5 or more years Technical Business Analysis experience 3 or more years within a mature PMO environment Experience in Retail industry preferred A hands on technical background such as software development or database development will be a strong advantage Business analysis methods, practices and techniques Business process modelling and mapping Formal methodology such as UML and BPMN will be a strong advantage Proven track record of successfully implementing technology projects General understanding in the areas of application programming, database design and project management is highly desirable SQL Query and basic Relational Database design skills Understanding of modern enterprise application building blocks   QUALIFICATIONS REQUIRED: Matric Minimum 5 to 6 years relevant Business Analysis experience B-degree or similar an advantage Business Analysis qualification an advantage Project Management qualification an advantage
Salary: Negotiable

Data Engineer Reference No: 3232927723 | Johannesburg, South Africa | Posted on: 30 June 2022

We currently have numerous vacancies for Data Engineers skilled in tools such as the Microsoft Stack (SSIS, SSRS, SSAS), Power BI, AWS, Azure, DataStage, SAS etc.   Duties: Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. Perform root cause analysis, performance monitoring and application related issues. Review IT work products from the team members for completeness and quality. Accurately translate business requirement to technical documentation and test case or results. Analyse and map data from source systems to target operational data stores and data marts. Maintain and provide application support in production. Code or folder migration from one environment to another as part of release management. Participation in all aspects of quality assurance. Active participation in systems integration and user acceptance testing.   Required Skills: Strong modular system design skills. Conventional and data warehouse modeling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   Required Qualifications / Training: Relevant data warehouse and BI solution training is essential. B.Sc. or related degree is advantageous. 5+ years programming experience.
Salary: Negotiable

Data Modeler Reference No: 357815238 | Cape Town, South Africa | Posted on: 30 June 2022

Data Modeler required for a vacancy at PBT Group.   Duties: Create and implement comprehensive logical and physical data models. Perform detailed data analysis in order to develop the data warehouse’s / BI solution’s data model. Involved in the requirements definition process. Assist the ETL Analysts / Business Analysts with the specification of the source to target mappings. Participate in the business requirements definition activities in a secondary role, for which a good understanding of business rules is essential. Work closely with Business Analysts, ETL Analysts, Solution Architects and Database Administrators to perform all tasks. Review models designed by other DBA’s and relate the activities of other modeling efforts to the model under review.   Required Skills: Knowledge about existing corporate data models, as well as knowledge of the business, is extremely important. Strong conventional (normalised) data modeling skills are beneficial, as the Data Modeler often has to be able to read and understand existing data models. However, the Data Modeler should be able to break away from traditional OLTP and E/R design practices and embrace the new data warehouse design techniques such as Dimensional models or multi-dimensional models. Experience working on other data warehousing projects is essential (full life cycle). Understanding of data warehousing and data mart architectures. An exposure to end-user reporting tools and their capabilities is useful. Have a quick grasp and understanding of data models, be able to see things abstractly, for example to derive the common model and represent related business concepts generically. Be very meticulous, as the data warehouse data model should be exact and complete – attention to detail is a very important characteristic. Well versed in conceptual and logical data modeling. Understand advanced analytical data requirements. Understand the data requirements of front-end (reporting, dashboarding and analysis tools.)     Required Qualifications / Training: Data warehouse design methodology training. Normalised and dimensional data modeling training. Must have worked with industry standard data modeling tools. Strong experience working with a range of DBMS’s. Strong experience with SQL query and DBMS tuning. B.Sc. or related degree is advantageous.  
Salary: Negotiable

Systems Analyst Reference No: 3585825880 | Cape Town, South Africa | Posted on: 30 June 2022

The Senior System Analyst is responsible for bridging the gap between business requirements and the development team. The System Analyst must understand the business requirements as well as the technical environment and marry the two up. This entails interaction with business, business analyst and technical stakeholders and compilation of Functional Requirements Specifications against which the development and architecture team is able to deliver the solution. In addition the System Analyst must be able to investigate and understand the existing technology, constraints and solutions in place, down to the ability to interrogate and model databases, and top level system architecture. The ideal System Analyst has a combination of a strong technical background, software testing skills as well as business understanding, elicitation and communication skills.   The System Analyst will work on multiple projects in the banking environment and will be required to manage his/her time effectively. The environment is based on Microsoft technology including MS SQL server, a .NET development toolset as well as other technology suites depending on the system in question.   DUTIES:   Functional and Testing Understand and Analyse systems in the environment, including database and top level architecture understanding Produce Functional Requirements Specifications Produce accurate mapping of “As is” and “To be” processes Identify project risks and issues and ensure that they are documented Produce User Acceptance Test Cases and Scenarios and assist with SIT and QA testing Provide regular, continuous and accurate feedback to project management team Participation in and sign-off of user acceptance testing, pilot and production testing   General Adhere to set process standards Co-work with the Business Analysts and technical team to define and design solutions that meet customer requirements Co-work with the project manager to drive delivery on time, within budget, scope and quality Perform efficient and effective JAD facilitation with relevant project stakeholders   Teamwork Build and maintain meaningful relationships with stakeholders   Experience Required: Must be able to operate independently and have a solid Microsoft tools background. Financial Services background Experience across data-, integration services- Front-end- development Process analysis 5 or more years Technical Business Analysis experience 3 or more years within a mature PMO environment Experience in Retail industry preferred A hands on technical background such as software development or database development will be a strong advantage Business analysis methods, practices and techniques Business process modelling and mapping Formal methodology such as UML and BPMN will be a strong advantage Proven track record of successfully implementing technology projects General understanding in the areas of application programming, database design and project management is highly desirable SQL Query and basic Relational Database design skills Understanding of modern enterprise application building blocks   QUALIFICATIONS REQUIRED: Matric Minimum 5 to 6 years relevant Business Analysis experience B-degree or similar an advantage Business Analysis qualification an advantage Project Management qualification an advantage
Salary: Negotiable

BI Business Analyst Reference No: 2171091613 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has an opportunity for or Business Intelligence Analyst: To gather, analyse and understand business users’ data and analytics requirements and translate these requirements into analytics best practice technical solutions that meet the relevant business objectives. To ensure alignment between business, Product Managers, data and analytics teams and produce a comprehensive functional specification from business requirements by maintaining a high level of in-depth knowledge with regards to analytics and other relevant data concepts.   Skills, Experience & Knowledge Required: Process and organisational thinking skills Project Management skills MS Office suite (advanced) SQL or SAS Data Warehousing At least 5 years’ proven experience within business intelligence and data warehousing environment At least 5 years’ proven experience in drafting functional specifications and translating requirements between business and functional stakeholders BI Business Analysis, data design and systems analysis experience in a data and analytics environment Relevant business area knowledge Data and analytics Business Analysis Data Warehouse Methodologies BI Best Practice Data Analysis Data Governance Financial systems and procedures Visualisation tools Data Product Life Cycle Data modelling Ideal Skills, Experience & Knowledge Required: Power BI Visual Basic AWS Business Information Business Analysis experience in an finance/banking environment Exposure to a credit environment Banking systems environment Banking business model Agile development life cycle Best practices for Quality Assurance (QA) Microsoft Appliance (APS)   Duties: Identify, clarify and agree data and analytics requirements. Liaises with business to understand and document their data and analytics requirements; performing analytical processes and KPIs/measures related to the processes. Adopts multiple actions with stakeholders to elicit the requirements; uses interviews, document analysis, requirements workshops, surveys, business process descriptions, user cases, scenarios and business analysis. Provides functional knowledge and expert input during planning, design and implementation phases of projects and initiatives between Data and Analytics and business. Assists stakeholders (e.g. Product Managers) with data-related scoping and planning. Applies end-to-end best practice to deliver data and analytics requirements. Ensures appropriate testing is done and provides the business with assistance during user acceptance testing. Designs training material and conducts training with solution users. Provides business with functional and technical assistance during data and analytics implementations. Applies business and data and analytics functional knowledge at all times to identify possible improvement opportunities and motivate with business. Owns personal continued professional development to remain current with data and analytics industry trends, particularly around data and analytics tools and technologies. Establishes effective and collaborative partnerships with data and analytics teams and relevant business teams (Business Process Analysts, BI source systems).   Translate business data and analytics requirements to the Data and Analytics teams. Analyses, understands and document relevant data and analytics technical requirements; performs data modelling and maps the analytic solution to the relevant data sources. Works closely with the Data Architect(s) and Data Modeller(s) to design, refine and implement analytic solutions in order to execute the functional design of the relevant data and analytics solution; including reports and dashboards. Provides input to data governance and data and analytics quality assurance; identifies and communicates all risks. Performs functional testing and data validation of reports and other data and analytics deliverables before presenting to business users. Applies data and analytics functional knowledge at all times to identify and motivate possible data and analytics support/improvements.   Facilitate the Data Product Life Cycle and application of best practice/process. Acts as the custodian of reporting catalogue; maintains the information framework and reports. Engages with Front end development lead to ensure adherence to processes that will keep the catalogue current. Facilitates the process between Source Data Owners, Feature Teams and Data and Analytics regarding data governance and processes.   Stakeholder Engagement This includes taking full ownership and operating as a primary contact for both internal and external clients within a specified product area.   Quality Assurance Consistently produces quality documentation that is accurate, and enables the team to deliver the functional product that meets the stakeholders’ requirements as well as identify additional opportunities for future consideration.   Level of Complexity Level of analysis is complex (required to be able to join data and source information from multiple sources/processes and integrate external data sources where such do not exist in the data warehouse) and develop appropriate metrics and measures on exist in the data warehouse) and develop appropriate metrics and measures on this information for analysis and interpretation which takes into account the business processes.   Autonomy Works generally without supervision. Actively participates in and steers the communities of practices (COPs).   Qualifications/ Certification: A relevant 3 year tertiary qualification (degree / diploma) in statistics, finance, actuarial science, mathematics, computer science, information systems, data or mathematical sciences, or engineering Ideally: Business-related qualification, FTI or similar Business Analysis
Salary: Negotiable

BI Business Analyst Reference No: 3826084453 | Cape Town, South Africa | Posted on: 30 June 2022

PBT Group has a requirement for a Senior Business Intelligence Analyst with solid understanding and experience in the BI industry, banking experience would be preferable.    DUTIES: Responsible for the support and analysis of current and new business requirements with the focus on meeting the relevant business objectives. The individual will be responsible to operate within both support and project environments. Analyse the business environment related to the past, present and future. Work with Project Manager to assist with the estimation and planning of activities. Document requirements, including KPI’s, measures, reporting and business dimensions, business processes, data modeling requirements, interface layouts, data flows, screen and report layouts, etc. Investigate and define requirements for business processes and the documentation thereof. Formulate strategies and guidelines to improve the business environment. Analyse existing business processes to determine problems, risks and opportunities for improvement. Facilitate the implementation of new / enhanced processes. Review processes on an ongoing basis and conduct process audits. Render support to and facilitate sessions with end-users. Work closely with the Solution Architects and Data Modellers to design and implement the best possible solution within the limits of the tools available. System and user acceptance testing. Provide input to Quality Assurance. Business assistance during implementation. Provide input for user training.   REQUIRED SKILLS: Substantial Business Analyst & Requirement Analysis experience in a BI environment. Elicitation, documentation, testing and project management. Experience with SQL Server (ability of profile data and perform testing, which would require the person to write SQL code). Must have some technical foundation and SQL scripting experience A good understanding of business processes. Ability to assimilate and apply relevant business principles. Work independently. Must be a team player. Work on more than one project at a time. Be able to work within the framework of project methodologies and work independently on support and maintenance tasks. Strong communication skills. Good writing skills. Must be able to pay attention to detail. Good general understanding of the relevant industry.   REQUIRED QUALIFICATIONS / TRAINING: Ideally candidates should have an IT or business-related qualification. FTI or similar BA qualification will be advantageous.  
Salary: Negotiable

Senior Data Engineer Reference No: 3395860260 | Cape Town, South Africa | Posted on: 30 June 2022

PBT currently has a role for a Senior Data Engineer About the role: Responsible for creating ETL processes for transforming data residing in various source systems into actionable information using ETL tools and coding primarily in MS SQL. Interpreting user requirements and building data pipelines to populate data structures that are easily accessible and provide accurate information which supports consistent and informed operational, tactical and strategic business decisions. About you: Relevant tertiary qualification in Information Technology or similar 5+ years’ commercial Business Intelligence (Microsoft Stacks) development Essential technology experience: SQL, SSIS. SSRS, SSAS (multi-dimensional and tabular models), MDX, PowerBI (advantageous) To be successful in this role you will need to have experience working with the Microsoft BI Stack and be well versed in the Ralph Kimball methodology Strong analytical, problem-solving and conceptual thinking skills essential Attention to detail and commitment to delivery is important
Salary: Negotiable

Business Intelligence Graduate Program 2023 Reference No: 3845801055 | Johannesburg, South Africa | Posted on: 20 June 2022

PBT Group, leading Data Specialists, is looking for exceptional graduates wanting to embark on a specialist IT career path. Our program will equip you with Business Intelligence (BI) best practices, real-life case studies, intensive training and on-the-job mentoring culminating in your deployment into business.   About PBT PBT Group is a professional services provider to large national and international clients, and one that is focused on transforming data into a tangible asset. PBT Group provides an end-to-end data services and solutions offering, including Data Strategy, Data Engineering, Data Visualisation, Data Analytics, as well as Application Development.   PBT Group has worked in more than 27 countries around the world and has implemented large-scale data projects throughout Africa, the Middle East, Australia and Europe in the banking, insurance, healthcare, telecommunications and retail sectors.   With a staff complement of more than 750 highly skilled professional consultants, PBT Group has a reputation for delivery according to expectations. Worldwide expertise and local wisdom - that’s what makes us different!   What is Business Intelligence? BI is the process of gathering information in the field of business. It can be described as enhancing data into information and then into knowledge. Businesses realises that in this very competitive, fast-paced and ever-changing business environment, a key competitive quality is how quickly they respond and adapt to change. BI enables businesses to use information gathered to quickly and constantly respond to changes. Further reading: http://en.wikipedia.org/wiki/Business_intelligence.   Graduate Program Requirements: Bachelor’s Degree or final year student in Information Systems or Computer Science. Academic record: a sustained average of 65% and above (your final mark will determine your consideration for the intake into the program). Strong knowledge of the Systems Development Life Cycle. Strong mathematical and statistical skills. Firm understanding of database functionality. Strong analytical skills. Strong programming skills. The ability to plan, research, analyse and interpret data. Good communication and language skills. Strong leadership qualities. Applicants must be under the age of 28.   Program Duration The program spans over 12 months, with the option to extend for a further period thereafter. The first 6 months focuses on theoretical training, followed by 6 months of on-the-job training.   Apply Now If you are interested and meet the above requirements, please send the following documents to graduates@pbtgroup.co.za. CV ID Matric Certificate Academic Transcripts (Results) for Tertiary Education Degree Certificate if you have finished   Please note that only South African residents with a valid ID document will be considered. If the above does not accompany your application, we will not be able to consider you for our Graduate Program.
Salary: Negotiable

Business Intelligence Graduate Program 2023 Reference No: 4245184493 | Cape Town, South Africa | Posted on: 20 June 2022

PBT Group, leading Data Specialists, is looking for exceptional graduates wanting to embark on a specialist IT career path. Our program will equip you with Business Intelligence (BI) best practices, real-life case studies, intensive training and on-the-job mentoring culminating in your deployment into business.   About PBT PBT Group is a professional services provider to large national and international clients, and one that is focused on transforming data into a tangible asset. PBT Group provides an end-to-end data services and solutions offering, including Data Strategy, Data Engineering, Data Visualisation, Data Analytics, as well as Application Development.   PBT Group has worked in more than 27 countries around the world and has implemented large-scale data projects throughout Africa, the Middle East, Australia and Europe in the banking, insurance, healthcare, telecommunications and retail sectors.   With a staff complement of more than 750 highly skilled professional consultants, PBT Group has a reputation for delivery according to expectations. Worldwide expertise and local wisdom - that’s what makes us different!   What is Business Intelligence? BI is the process of gathering information in the field of business. It can be described as enhancing data into information and then into knowledge. Businesses realises that in this very competitive, fast-paced and ever-changing business environment, a key competitive quality is how quickly they respond and adapt to change. BI enables businesses to use information gathered to quickly and constantly respond to changes. Further reading: http://en.wikipedia.org/wiki/Business_intelligence.   Graduate Program Requirements: Bachelor’s Degree or final year student in Information Systems or Computer Science. Academic record: a sustained average of 65% and above (your final mark will determine your consideration for the intake into the program). Strong knowledge of the Systems Development Life Cycle. Strong mathematical and statistical skills. Firm understanding of database functionality. Strong analytical skills. Strong programming skills. The ability to plan, research, analyse and interpret data. Good communication and language skills. Strong leadership qualities. Applicants must be under the age of 28.   Program Duration The program spans over 12 months, with the option to extend for a further period thereafter. The first 6 months focuses on theoretical training, followed by 6 months of on-the-job training.   Apply Now If you are interested and meet the above requirements, please send the following documents to graduates@pbtgroup.co.za. CV ID Matric Certificate Academic Transcripts (Results) for Tertiary Education Degree Certificate if you have finished   Please note that only South African residents with a valid ID document will be considered. If the above does not accompany your application, we will not be able to consider you for our Graduate Program.
Salary: Negotiable

SQL BI Developer Reference No: 3951591681 | Cape Town, South Africa | Posted on: 06 June 2022

PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS. REQUIRED SKILLS: - Microsoft BI: Strong SQL, SSIS, SSAS, SSRS - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. - System analysis and design skills are necessary to design and document the data extractions and transformations. - Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. - Good organisation, planning and basic management skills. - Good interpersonal and communication skills. - Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: - Relevant data warehouse and BI solution training is essential. - B.Sc. or related degree is advantageous. - 5+ years programming experience.   DUTIES: Duties: Back-end - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   Duties: Front-End - Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. - Develop the semantic layer, metadata, reports and report definitions. - Develop graphs and portal interfaces. - Load and maintain the metadata for the data access tool. - Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. - Produce complex, efficient, error-free reporting solutions and related documentation. - BI front end development on data structures, cubes, reporting, dashboards, etc.
Salary: Negotiable

BI Analyst Reference No: 2011158008 | Cape Town, South Africa | Posted on: 06 June 2022

A BI Business Analyst or BIBA has a crucially important role to play, in bridging any gaps between business and IT, to understand how data-driven changes to process, products, services, software and hardware can improve efficiencies and add value for clients.   The BIBA is involved in the end-to-end Data Product Lifecyle, including requirement definition, data analysis, data modeling   Skills Required: Mid-level: at least 3 years’ experience with a proven track record of delivering Data & Analytics projects through facilitating the Data/Analytics Development Lifecycle. SQL skills preferable, but not a primary requirement Facilitate user requirements workshops Document user requirements Apply BIBA methodology in agile environments Some systems analysis (source-to-target mappings, data profiling) Deep knowledge of modern data platforms Strong leadership and people skills (will be required to work closely with all Data & Analytics Guilds and with business users)  
Salary: Negotiable

Data Engineer Reference No: 928516494 | Cape Town, South Africa | Posted on: 06 June 2022

We currently have numerous vacancies for Data Engineers skilled in tools such as the Microsoft Stack (SSIS, SSRS, SSAS), Power BI, AWS, Azure, DataStage, SAS etc.   Duties: Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. Perform root cause analysis, performance monitoring and application related issues. Review IT work products from the team members for completeness and quality. Accurately translate business requirement to technical documentation and test case or results. Analyse and map data from source systems to target operational data stores and data marts. Maintain and provide application support in production. Code or folder migration from one environment to another as part of release management. Participation in all aspects of quality assurance. Active participation in systems integration and user acceptance testing.   Required Skills: Strong modular system design skills. Conventional and data warehouse modeling skills are required, in order to understand the various data models and to define the mappings between them. System analysis and design skills are necessary to design and document the data extractions and transformations. Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. Good organisation, planning and basic management skills. Good interpersonal and communication skills. Decision making and problem solving skills.   Required Qualifications / Training: Relevant data warehouse and BI solution training is essential. B.Sc. or related degree is advantageous. 5+ years programming experience.
Salary: Negotiable

BI Business Analyst (BIBA) Reference No: 2858043065 | Cape Town, South Africa | Posted on: 06 June 2022

PBT Group has an opportunity for a Business Intelligence Business Analyst (BIBA). A BI Business Analyst or BIBA has a crucially important role to play, in bridging any gaps between business and IT, to understand how data-driven changes to process, products, services, software and hardware can improve efficiencies and add value for clients.   The Business Intelligence Business Analyst (BIBA) primarily serves as liaison between the end users and BI project team and gathers business requirements. The BIBA is an expert in understanding business objectives, questions, and problems, and at obtaining and presenting data to address the issues. The analyst understands the tools and techniques used to create data results that range from basic queries through multidimensional analyses and data mining, forming new relations and derivations as necessary, and extracting the maximum amount of valid information content from the data. Extensive insight into the business and the data are essential.   The BIBA participates in design of data marts to provide the optimal balance of data availability, format, flexibility, and performance. The BIBA is involved in the end-to-end Data Product Lifecyle, including requirement definition, data analysis, data modelling.   Duties:   1. Requirement’s definition phase: Interview end users to determine requirements for data, reports, analyses, metadata, training, service levels, data quality, and performance Help identify and assess potential data sources Validate that BI meets requirements and service level agreements Coordinate prototype reviews Gather prototype feedback Document requirements in relevant formats: Data Warehouse content requirements Data Mart requirements Information output requirements Information exploitation tool – functional requirements 2. Data Profiling, Feasibility and Scope Definition Phase: Analyse business information requirements Recommend appropriate scope of requirements and priorities Work with production data to validate business requirements Map business needs/requirements to subject area model and to logical enterprise model Discover dimension hierarchies Validate hierarchies with production data Define business rules for state detection 3. Design Phase: Work with architects to translate requirements into technical specifications Discover business transformation rules Work with production data to design access structures Classify business users by type Develop security rules/standards Create state transformation models 4. Development Phase: On-hand support to development team to accurately interpret requirements and translate into a quality solution. 5. Testing Phase: Plan acceptance test (functional and data integrity) Execute acceptance test plan internally Facilitate user acceptance testing 6. Change Management and Deployment: Educate users on warehousing capabilities Design training infrastructure Define and get agreement with business users on service-level agreements Develop training materials Write users' guide Train BI users Assist with definition of support plan Interface with process teams regarding business process reengineering Assist users in finding the right information   Skills and Experience Required: At least 3 / 5 years’ experience with a proven track record of delivering Data & Analytics projects through facilitating the Data/Analytics Development Lifecycle.   1. General BA competencies Business analysis planning and monitoring Requirement’s elicitation Requirements management and communication Business architecture analysis Requirement’s analysis Solution assessment and validation 2. BA tools and techniques Acceptance and Evaluation Criteria Definition Benchmarking Brainstorming Business Rules Analysis Data Dictionary and Glossary Data Flow Diagrams Data Modeling Decision Analysis Document Analysis Focus Groups Interviews Metrics and Key Performance Indicators Non-functional Requirements Analysis Observation Organization Modeling Problem Tracking Process Modeling Prototyping Requirements Workshops Risk Analysis Scenarios and Use Cases Structured Walkthrough 3. Personal skills: Strong communication skills. Good writing skills. Must be able to pay attention to detail. Work independently. Must be a team player. Work on more than one project at a time. Strong leadership and people skills (will be required to work closely with all Data & Analytics Guilds and with business users) 4. BI Project related skills: Apply BIBA methodology in agile environments Strong SQL skills Some systems analysis (source-to-target mappings, data profiling) Deep knowledge of modern data platforms Good general understanding of the relevant industry. Substantial business analysis experience in a BI environment. A good understanding of business processes. Ability to assimilate and apply relevant business principles. Be able to work within the framework of project methodologies and work independently on support and maintenance tasks.   Required Qualifications/ Certification: Ideally candidates should have an IT or business-related qualification. FTI or similar BA qualification will be advantageous.
Salary: Negotiable

Power BI Front End Developer with strong analysis experience Reference No: 3673863337 | Johannesburg, South Africa | Posted on: 06 June 2022

PBT Group, Data Specialists, has a requirement for a mid-senior Power BI Front End Developer with strong analysis experience.   Duties: Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. Develop the semantic layer, metadata, reports and report definitions. Develop graphs and portal interfaces. Load and maintain the metadata for the data access tool. Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. Produce complex, efficient, error-free reporting solutions and related documentation. BI front-end development on data structures, cubes, reporting, dashboards, etc.   Required Skills: Solid experience with Power BI Strong analysis experience Data warehouse modeling skills is advantageous, in order to understand the data warehouse data models. A sound knowledge of SQL, or the language used to access the data warehouse from the access- or end-user reporting tools. A sound knowledge of the capabilities of the data access- and reporting tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the end user programs or reports. Keep abreast of new releases of these tools and work-arounds to overcome problem areas using these tools. Exposure to various BI front end applications, with working knowledge in at least one of them. Strong ability to analyse user requirements and build front-end BI applications according to specifications. Knowledge of scripting languages. Experience with one or more of the industry standard databases desired. Attention to detail and strong logical reasoning ability. Good communication skills. Pride of work, thoroughness and attention to detail.   Required Qualifications / Training: Relevant data warehouse and BI solution training is essential. B.Sc. or related degree is advantageous. 2+ years programming experience.
Salary: Negotiable

Senior Java Developer Reference No: 3714844102 | Johannesburg, South Africa | Posted on: 06 June 2022

PBT Group has an opportunity for a Senior Java Developer. We are looking for an exceptional individual to build Java integration services and applications with an enthusiasm for solving interesting technical challenges in a Banking environment. Be involved in all aspects of development playing a critical role in design, planning, development and deployment.   The ideal candidate will not just be an outstanding Java developer, but will bring a mindset of creativity, innovation and balanced bleeding edge technology development with a relentless pursuit of timely product engineering delivery. The role requires ownership, logical thinking, and estimation of your own work, coding, unit testing, trouble shooting and performance optimizations. The candidate will work in an Agile (SCRUM) environment and will be allocated and co-located to a small agile development team (squad). The candidate will collaborate with team members to understand the problem & define, design, and ship new features through the development lifecycle. This includes brainstorm, contribution to new ideas, conceive innovative strategies, and implement solutions to difficult problems. Must be able to work independently, effectively and efficiently in a collaborative agile environment with scrum masters, solution engineers, designers, and developers.     Duties: Key Roles, Responsibilities and Skills/Competencies: Strong technical/ software engineering background (‘hands-on’) Strong application/software development or programming background in Java Good experience in system, application architecture, design, development, implementation and deployment (end-to-end). Ability to work on different tiers of the application Object oriented Design and MVC-pattern Experience on web technologies (Web Development JavaScript Frameworks - preferably Angular 4, JavaScript, CSS, HTML5, Etc.) Solid experience on J2EE (Servlet, JSP, JDBC, JMS, EJB), Spring Framework, JPA, Hibernate, Open-Source Frameworks Solid experience with SOA-Architecture with the related integration protocols (e.g., Web Services (SOAP/XML), REST & JSON, and MQ), as well as the related SOA-security requirements/models. Solid application database management practices in a high-volume Java environment (SQL, DB2, and NoSql – Cassandra/MongoDB). Solid JEE/WebSphere Foundation experience, especially on WebSphere Application Server, JBOSS, Linux, Virtualisation technologies and Caching technologies. Design, build and run of IBM Websphere Application Server Infrastructure Solutions Migration from proprietary Application Servers to WAS Performance and troubleshooting of WAS Infrastructure Good experience with integrated system environments Practical experience in a high-volume banking environment. (E.g., application clustering, scaling, multi-threading, session management, etc.) Experience with re-use and standardisation, security considerations, deployment architecture like automated application builds, software configuration management & tools, etc. Experience with Application Integration challenges in a big corporate environment with ESB’s e.g. WebSphere MessageBroker, DataPower, MQ-Series, and API-Connect. Proven ability as a problem-solver Self-driven, self-starter, technology leader, and able to work independently. Must have working experience on the following tools/IDEs Eclipse InteliJ Git Maven Jenkins SonarQube Nexus Debugging & troubleshooting. Write well documented and maintainable code. Passion for software excellence and be quality driven. You must be prepared to bring new ideas to the workplace, but also to accept how things have been done and the reasons for doing things this way.   Experience: 10+ years Java application programming/development experience 8+ years JEE-Experience 5+ years Application Server experience i.e. Websphere Application Server 5+ years relational database experience (DB2 preferred) Strong application/software development or programming background in Java. Good experience in system, application architecture, design, development, implementation and deployment (end-to-end). Ability to work on different tiers of the application Object oriented Design and MVC-pattern. Experience on web technologies (Web Development JavaScript Frameworks - preferably Angular 4, JavaScript, CSS, HTML5, Etc.). Solid experience on J2EE (Servlet, JSP, JDBC, JMS, EJB), Spring Framework, JPA, Hibernate, Open Source Frameworks. Solid experience with SOA-Architecture with the related integration protocols (e.g. Web Services (SOAP/XML), REST & JSON, and MQ), as well as the related SOA-security requirements/models. Solid application database management practices in a high volume Java environment (SQL, DB2, and NoSql – assandra/MongoDB). Solid JEE/WebSphere Foundation experience, especially on WebSphere Application Server, JBOSS, Linux, Virtualisation technologies and Caching technologies. Design, build and run of IBM Websphere Application Server Infrastructure Solutions Migration from proprietary Application Servers to WAS. Performance and troubleshooting of WAS Infrastructure. Good experience with integrated system environments.   Qualifications/ Certification: B-Degree in Computer Science or related technical field.
Salary: Negotiable

Microsoft BI Developer Reference No: 3496612131 | Johannesburg, South Africa | Posted on: 06 June 2022

PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS.   REQUIRED SKILLS: - Microsoft BI: Strong SQL, SSIS, SSAS, SSRS - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. - System analysis and design skills are necessary to design and document the data extractions and transformations. - Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. - Good organisation, planning and basic management skills. - Good interpersonal and communication skills. - Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: - Relevant data warehouse and BI solution training is essential. - B.Sc. or related degree is advantageous. - 5+ years programming experience.   DUTIES: Duties: Back-end - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   Duties: Front-End - Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. - Develop the semantic layer, metadata, reports and report definitions. - Develop graphs and portal interfaces. - Load and maintain the metadata for the data access tool. - Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. - Produce complex, efficient, error-free reporting solutions and related documentation. - BI front end development on data structures, cubes, reporting, dashboards, etc.
Salary: Negotiable

SAS / SQL Data Engineer Reference No: 2194997981 | Johannesburg, South Africa | Posted on: 06 June 2022

PBT Group is looking for an experienced SAS / SQL Data Engineer to work with an existing team.   Duties: Focus is on ‘rebuilding and optimising’ ETL as part of an organisational and system change. Besides technical expertise, it will be required to assist and guide younger team members.   Experience: Main technologies – SAS (using the Base SAS application, Enterprise Guide & SAS Scripting) 5+ Years’ Experience in complex SAS Programming and Strong Data Integration experience handling disparate Data Sources using SAS ACCESS engines and the related Pass-through. AWS experience is a plus. Strong SQL experience. Experience with the MS BI stack (SSIS, SSRS, SSAS) would be beneficial.   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent SAS Certification would be an advantage
Salary: Negotiable

BI Analyst Reference No: 1965482096 | Johannesburg, South Africa | Posted on: 06 June 2022

PBT Group has an opportunity for a BI Analyst.   Duties: As Senior Business Intelligence Analyst you are responsible for gathering and documenting requirements, understanding clients’ business models and processes, assisting in solutions design, supporting the development efforts in the whole process of software development lifecycle and providing documentation and trainings to end users. The position is also expected to build good relationship to senior level stakeholders. As Senior Business Analyst you will be leading the client presentations, running demonstrations and demonstrating product proficiency that meets the clients’ business needs.   Experience: Minimum of 7 years relevant experience as a business analyst, functional consultant or other client facing role within the fintech/ financial services/banking industry. Must have solid SQL & Power BI experience Has working knowledge of implementing Management Information solutions, financial compliance solutions. Excellent communicator, confident in delivering presentations and product demonstrations, running workshops and trainings Highly skilled in stakeholder management, efficient in coordinating and managing client's expectations. Above average knowledge of BCBS239 regulations with practical experience within the analysis phase of a similar program Knowledge of debt management processes an advantage   Qualifications/ Certification: Relevant IT or business tertiary qualifications Recognised industry certifications
Salary: Negotiable

Data Engineer Reference No: 3452658987 | Cape Town, South Africa | Posted on: 06 June 2022

PBT Group has a requirement for a Senior Microsoft BI Developer who knows SSIS, SSAS, SSRS and Power BI. Ab Initio experience would be an advantage. REQUIRED SKILLS: - Microsoft BI: Strong SQL, SSIS, SSAS, SSRS and Power BI - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them. - System analysis and design skills are necessary to design and document the data extractions and transformations. - Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs. - Good organisation, planning and basic management skills. - Good interpersonal and communication skills. - Decision making and problem solving skills.   REQUIRED QUALIFICATIONS / TRAINING: - Relevant data warehouse and BI solution training is essential. - B.Sc. or related degree is advantageous. - 5+ years programming experience.   DUTIES: Duties: Back-end - Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. - Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues. - Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information. - Perform root cause analysis, performance monitoring and application related issues. - Review IT work products from the team members for completeness and quality. - Accurately translate business requirement to technical documentation and test case or results. - Analyse and map data from source systems to target operational data stores and data marts. - Maintain and provide application support in production. - Code or folder migration from one environment to another as part of release management. - Participation in all aspects of quality assurance. - Active participation in systems integration and user acceptance testing.   Duties: Front-End - Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. - Develop the semantic layer, metadata, reports and report definitions. - Develop graphs and portal interfaces. - Load and maintain the metadata for the data access tool. - Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. - Produce complex, efficient, error-free reporting solutions and related documentation. - BI front end development on data structures, cubes, reporting, dashboards, etc.
Salary: Negotiable

Data Management Consultant (Credit Data) Reference No: 3593314085 | Cape Town, South Africa | Posted on: 06 June 2022

PBT Group has an opportunity for Data Management Consultant to deliver data management, governance, stewardship and ownership principles and best practice across all Business and Operations.   Duties: Implement data governance framework to exercise authority control and shared decision making over the management of data assets. Maintain frameworks, standards, policies, and guidelines on how to use the data management technologies that support enterprise architectures in alignment with the required business needs Understand strategic enterprise data needs as well as the global data strategy. Devise the data roadmap driving towards data standardisation. Identify, source and make available key data required for day-to-day operational reporting and analytics in the Analytics Ecosystem platform. Apply Data Quality techniques to data to provide assurance that it is fit for consumption and meets the needs of consumers Establish project processes, standards, guidelines, and structures for master data, metadata and configuration data elements as well as data cleansing, data migration and upload activities Enable and clarify the mapping of all relevant master data management landscape that manages the distribution, replication, and archival of group’s data quality and master data management solutions Build reporting and analytics solutions to enable and improve decision-making   Experience: 1 x Data Management Specialist with the following skillsets: Microsoft Purview Informatica Data Quality, Metadata Management and Business Glossary Microsoft Azure Data Factory Azure Power Platform Engineering (Power BI) DevOps (Data Ops) Agile Methodology   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent  
Salary: Negotiable

QlikView Front End Developer Reference No: 3934646975 | Cape Town, South Africa | Posted on: 01 June 2022

PBT Group has a vacancy for strong QlikView Front End Developer. Programming skills would be a plus.   DUTIES: Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools. Develop the semantic layer, metadata, reports and report definitions. Develop graphs and portal interfaces. Load and maintain the metadata for the data access tool. Troubleshoot BI tools, systems and software; performance-tune these applications as necessary. Produce complex, efficient, error-free reporting solutions and related documentation. BI front end development on data structures, cubes, reporting, dashboards, etc.   SKILLS REQUIRED: Strong QlikView Front End Development experience Data warehouse modelling skills is advantageous, in order to understand the data warehouse data models. A sound knowledge of SQL, or the language used to access the data warehouse from the access- or end-user reporting tools. A sound knowledge of the capabilities of the data access- and reporting tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the end user programs or reports. Keep abreast of new releases of these tools and work-arounds to overcome problem areas using these tools. Exposure to various BI front end applications, with working knowledge in at least one of them. Strong ability to analyse user requirements and build front-end BI applications according to specifications. Knowledge of scripting languages. Experience with one or more of the industry standard databases desired. Attention to detail and strong logical reasoning ability. Good communication skills. Pride of work, thoroughness and attention to detail.   REQUIRED QUALIFICATIONS / TRAINING: Relevant data warehouse and BI solution training is essential. Sc. or related degree is advantageous.
Salary: Negotiable