PBT Group Careers

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

Filters

City
Industries
Date Posted

Microsoft Power BI Administrator Reference No: 1661458679 | Johannesburg, South Africa | Posted on: 09 April 2021

PBT Group has an opportunity for a Power BI Administrator. The Power BI Administrator will be responsible for the safe and efficient operation of the Power BI environment. This person will limit what users can do in the Power BI environment in order to maintain organizational policies and take care of all resources and solutions in the Power BI environment.   Duties: Supporting production BI solutions by monitoring and tuning queries and data imports into Power BI. Define standard templates, procedures and processes for deploying reports within EIS Naming conventions of workspaces Scheduling of reports When to use direct SQL versus imports Manage capacity workloads on premium workspaces Managing user licenses Managing size of datasets Standardize Deployment Architecture in SA (workspaces, capacity settings, etc). Creating new enterprise gateways and scheduling reports. Provide usage adoption reports. Data should be integrated into the big data platform. Monitoring of premium capacity resources and provide recommendations to ensure efficient utilisation. Should have experience in on-premise Power Bi server set up and maintenance. Evaluate and if required, support installation of on-premise solution. Assist with deploying redundant Power BI gateways. Identify key performance indicators and consistently monitor those. Maintain documentation for all processes implemented. Document all standards, architecture on the wiki. Reviewing proposed production changes to ensure the highest quality data standards and lowest production impact. Power BI datasets optimization to reduce the size and improve report performance. Collaborate with other operational and development teams during investigations and resolution of operational issues.   Experience: 5+ years visualisation development experience in Power BI. Proficient in Data Modelling and Data Mart Design. Proficient in SQL (both Oracle SQL and Hive SQL). Proficient in writing DAX queries in Power BI desktop. Experience required with version control software such as SVN or GIT. Confident in engaging with business stakeholders. Excellent in analytical thinking for translating data into informative visuals and reports. The candidate must have sound knowledge of ETL. Worked in environments with large data volumes. Excellent written and spoken English. Needs to be self-driven.   Qualifications/ Certification: Education: a 3-year diploma or higher
Salary: Negotiable

Microsoft Power BI Developer Reference No: 1360702620 | Johannesburg, South Africa | Posted on: 09 April 2021

PBT Group has an opportunity for a Microsoft Power BI Developer. The visualisation specialist will be involved in the end-to-end process from initial stakeholder engagement and requirements gathering phases through to solution delivery and implementation. This person will be responsible for building customer (internal) facing dashboards/reports.   Duties: Understand business requirements in BI context and design data models to transform raw data into meaningful insights. Develop dashboards and interactive visual reports using Power BI. Analysing data and present data through reports that aid decision-making. Convert business requirements into technical specifications and decide timelines to accomplish. Perform DAX queries and functions in Power BI. Addressing user questions concerning data integrity. Define standard templates, procedures and processes for deploying reports within EIS Naming conventions of workspaces When to use direct SQL versus imports Managing size of datasets Versioning/source control Maintain documentation for all reports/dashboards implemented. Reviewing proposed production changes to ensure the highest quality data standards and lowest production impact. The developer will be expected to use multiple data sources for report/dashboard development, for example Oracle Database, the big data environment and Microsoft SSAS cubes. Create standard templates/ style sheets for visualizations/reports.   Experience: 5+ years visualisation development experience in Power BI. Proficient in Data Modelling and Data Mart Design. Proficient in SQL (both Oracle SQL and Hive SQL). Proficient in writing DAX queries in Power BI desktop. Experience required with version control software such as SVN or GIT. Confident in engaging with business stakeholders. Excellent in analytical thinking for translating data into informative visuals and reports. The candidate must have sound knowledge of ETL. Worked in environments with large data volumes. Excellent written and spoken English. Needs to be self-driven.   Qualifications/ Certification: Education: a 3-year diploma or higher
Salary: Negotiable

Microsoft SSAS Developer Reference No: 2050928290 | Johannesburg, South Africa | Posted on: 09 April 2021

PBT Group has an opportunity for a SSAS Developer. The SSAS Developer will be responsible for the development, maintenance, and enhancement of cubes. The role involves working extensively with the reporting end user community to identify user requirements and recommend solution options. This person will perform as the subject matter expert for development, maintenance and performance of the cubes.   Duties: Collaborate with other teams within the organization and be able to devise the technical solution as it relates to the business & technical requirements. Work with Business intelligence data engineers to define SSAS cube requirements. Develop and improve Microsoft analysis services cubes (tabular and multi-dimensional) to meet business requirements. Ensure that SSAS cubes complies with data visualization or presentation to meet business requirements. Maintain documentation for all cubes implemented. Adhere to and suggest improvements to coding standards, best practices, and contribute to the improvement of these best practices. The developer will be expected to use multiple data sources for cube development, for example Oracle Database and the big data environment. Should have solid experience in creating SSIS packages to process cubes. Participate in design and peer reviews. Mentoring junior and new resources on best practices and development. Design and implement data analytics key performance indicators that are aligned to business measures and analytics. Implement best practices on creating partitions and aggregations on cubes. Provide guidance and assistance to end user queries.   Experience: Experience in working with Microsoft SQL Server Analysis Services (SSAS) in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects. Good experience in writing MDX queries while creating and customizing cubes using SSAS. Experience in tabular and dimensional data modelling. Experience in handling of dynamic partitioning in tabular models. Extensive knowledge in SSAS storage and partitions. Highly proficient in SQL (both Oracle SQL and Hive SQL). Knowledge of Unix and/or Linux operating systems. Confident in engaging with business stakeholders. The candidate must have sound knowledge of ETL. Worked in environments with large data volumes. Experience required with version control software such as SVN or GIT. Excellent written and spoken English. Demonstrable experience in developing SSAS cubes in SQL Server, including Tabular Models. Proven experiences of large data sets. Strong Knowledge of SQL Server. Should have basic knowledge on SSAS administration. Development experience in OBIEE dashboards, Power BI or any other visualization tool. Needs to be self-driven. Telecommunications industry experience would be beneficial.   Qualifications/ Certification: Education: a 3-year diploma or higher
Salary: Negotiable

Microsoft SSAS Administrator Reference No: 4029301312 | Johannesburg, South Africa | Posted on: 09 April 2021

PBT Group has an opportunity for a SSAS Administrator. The SSAS Administrator will be responsible for providing the overall SSAS environment administration and support.   Duties: Manage and support environment installations, patching, upgrades and migrations to ensure that the SSAS environment is always at the latest release. Implement and manage security aspects pertaining to sensitive data. Provide development standards and guidelines for all SSAS development to ensure that best practices are implemented and adhered to. Integrate performance metrics of cubes into the big data platform for reporting. Provide usage adoption reports. Data should be integrated into the big data platform. Monitoring and performance tuning of existing SSAS environment and cubes. Perform server-level administrative functions including creating databases and setting server-level properties. Document all standards and architecture for the SSAS environment on the Wiki also maintain up to date documentation for all implemented SSAS cubes. Collaborate with other teams within the organization and be able to devise the technical solution as it relates to the business & technical requirements. Engage with Microsoft to resolve issues that cannot be resolved internally. Standardize cube deployment architecture. Continually evaluate and improve development, test and production promotion standards. Design, develop and maintain existing and new SSAS cubes according to best practices.   Experience: Strong knowledge of Microsoft SQL Server and Analysis Services Server. Experience in performing administrative tasks on Microsoft SQL Server Analysis Services (SSAS) - Installation, configuration, security configuration, configuring logging, deployment and performance monitoring. Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects. Good experience in writing MDX queries while creating and customizing cubes using SSAS. Highly proficient in SQL. Experience in tabular and dimensional data modelling. Extensive knowledge in SSAS storage and partitions. Knowledge of Microsoft operating systems and power shell scripting. The candidate must have sound knowledge of ETL. Worked in environments with large data volumes. Experience required with version control software such as SVN or GIT. Excellent written and spoken English. Needs to be self-driven. Telecommunications industry experience would be beneficial.   Qualifications/ Certification: Education: a 3-year diploma or higher  
Salary: Negotiable

Senior BI Data Modeller Reference No: 1641756107 | Johannesburg, South Africa | Posted on: 06 April 2021

PBT Group has an opportunity for a Senior Data Modeller to design and maintain optimal data models/structures at both an enterprise and system / application level that meet the business and architectural objectives of the organisation. To create structures that enable data to be persisted in a structured way to enable the value of the data to be unlocked. To create appropriate data and class structures that enable the flow of data between providers and consumers. Where required, lead a team of modellers performing this work.   The primary technology used is IDA (Infosphere Data Architect (Data Modelling Tool)) and Aginity Workbench DB2.   It will also be most beneficial to have knowledge of IGC (Infosphere Governance Catalogue).   Duties: Design data models that meet the business requirements and align to the agreed architecture framework. Ensure data modelling deliverables are delivered according to project plan and budget to meet commitment to stakeholders. Ensure all data modelling activities and deliverables are aligned to the development methodology and to the data modelling principles and standards Apply the approved tooling to create the data modelling deliverables. Adopt the Enterprise Data Model (which is based on the IFW) as a standard for data model designs to leverage best practice and fast track data modelling efforts. Translate business requirements into data requirements. Analyse and profile the source data to understand data quality issues, relationships, patterns and rules in the data. Structure data requirements into logical data constructs based on the Enterprise Data Model, including ERD models, dimensional models to ensure optimal implementation. Compile Source to Target Mapping Specifications including the appropriate Transformation Rules Identifying definitive or authoritative source of data; analysing source data; and identifying gaps to target structures Enable physical implementation of the data structure by generating the first cut physical data model from the logical data model. Facilitate dataflow understanding by collating dataflow diagrams outlining the flow of data across systems and interfaces. Reduce non-value adding work by identifying opportunity for re-use of the Enterprise Data Model Maintain up to date knowledge of latest developments in the Data Modelling domain, including reading; continuous professional development courses; seminars and conferences. Assists to provide a comprehensive governed framework by working with the data modelling CoE and contributing towards defining the data modelling standards. Advise stakeholders and other staff on application of data modelling practices through consultation. Ensure consistency and re-use of data models by acting as a primary advocate of date modelling activities and methodologies and by driving the adoption of enterprise data modelling across the bank. Ensure improved performance by providing feedback on improvements to the data modelling framework. Perform review on work performed by team members as well as review and govern work performed by other modelling teams Identify opportunities to improve or enhance processes. Provide Overall Data Management Guidance and alignment to the Data Management framework and standards Seek opportunities to improve business processes, models and systems though agile thinking. Support the achievement of the business strategy, objectives and values Participate and support corporate responsibility initiatives for the achievement of business strategy   Skills & Experience Required: 5 – 8 years IT related experience with 5yrs+ in a Data Modelling role Able to demonstrate practical experience in relational and dimensional modelling techniques as well as leading teams of data modellers Has demonstratable experience in developing custom data models as well as data modelling utilising Industry data models such as IFW BFMDW Experience in model management Experience in compiling and monitoring standards and developing/maturing a data modelling practice OO modelling experience also an advantage Experience using Infosphere Data Architect or any other Data Modelling Tool Firm understanding of Data Management (DMBOK), systems development lifecycle methodologies and IT Architecture Relevant regulatory knowledge, and understanding of banking and financial services Experience in NoSQL and other forms of database modelling advantageous   Advanced knowledge of: Industry Model Understanding Pattern Recognition, conceptual and abstract thinking Presenting Problem solving and creativity Language skills Data analysis and inference Data Integrity Data Modelling - Data Warehouse Layers Metadata Data Quality Data Warehousing Overview and Architecture Database Model Concepts Data and business requirements Gathering Data Modelling Tools   Intermediate knowledge of: Using SQL in Databases Agile Concepts Banking Product Knowledge   Basic knowledge of: Data Governance Data Architecture Management Data Integration DevOps Tooling and methodologies Master and Reference Data Management     Qualifications/ Certification: Advanced Diplomas/National 1st Degrees/equivalent NQF level 6 qualification Bachelor of Commerce, Bachelor of Science: Information Systems / Computer Science Honours level TOGAF, DAMA
Salary: Negotiable

BI Business Analyst (BIBA) Reference No: 133884888 | Cape Town, South Africa | Posted on: 01 April 2021

Main Purpose: The primary purpose of the role is to gather, analyze and document Business data and reporting requirements and translate them into BI solutions in partnership with the BI Architect and technical teams. Key Responsibilities: Responsible for gathering and documenting the reporting requirements for the respective business areas Investigate data sources and query the data using SQL Document Functional Requirements to the source system Document Source to Target mapping for new solutions Develop conceptual BI solution design Contribute to the logical design of Star Schema Develop functional designs and provide recommendations on presentation of information Train and support users Create test cases and plans Functional testing (ensure that solutions meet the requirements and needs of the business) Manage data test process, including unit, system integration, functional and user acceptance testing Effective internal and external stakeholder relationship management Keep abreast of latest market developments with regards to Data tools and methodologies Key Competencies: Strong facilitation skills Strong communication skills Attention to detail Ability to collaborate with developers and business users in order to achieve desired results Analytical ability Solution orientated with ability to resolve complex Data challenges Ability to prioritize and manage multiple deliverables Solid planning and organizational skills Data and business literacy Qualifications and Experience: 3-year Degree/Diploma in Information Technology or related fields - essential Data analysis experience Experience in working with data visualization tools (Cognos or PowerBI preferred) for Proof of Concepts Proficient in SQL for data analysis - essential Knowledge of Dimensional Modelling/Data Warehousing MS Office Experience in Financial Services or Retail advantageous
Salary: Negotiable

BI ETL Developer (Senior) Reference No: 1476787933 | Cape Town, South Africa | Posted on: 01 April 2021

Main Purpose: Responsible for creating ETL processes for transforming data residing in various source systems into actionable information using ETL tools and coding primarily in Transact-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. 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: Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements Adjusting existing ETL processes, or designing and building new ETL processes to accommodate new requirements Testing and reconciliation of warehouse data to source data to ensure data integrity Adhering to company’s internal BI SDLC and development methodologies Provide a high-level of customer service Key Competencies: Strong analytical, problem solving and conceptual thinking skills essential 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 Presentable with excellent communication skills Qualifications and Experience: 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) Working Understanding of Ralph Kimball methodology Experience in Business Intelligence environment in Financial Services or Retail industry – desirable Other technologies: Active Batch Visio / Erwin modelling tools Visual Studio Cognos / Tableau
Salary: Negotiable

Senior Project Manager with Capital Markets Experience Reference No: 1737364549 | Johannesburg, South Africa | Posted on: 31 March 2021

PBT Group has an opportunity for a Senior Project Manager with Capital Markets experience who would be responsible for planning, organising, and directing the completion of projects while ensuring these projects are on time, on budget, and within scope.   Duties: Planning and Defining Scope Activity Planning and Sequencing Resource Planning Developing Schedules Time Estimating Cost Estimating Developing a Budget Documentation Creating Charts and Schedules Risk Analysis Managing Risks and Issues Monitoring and Reporting Progress Team Leadership Strategic Influencing Business Partnering Working with Vendors Scalability, Interoperability and Portability Analysis Controlling Quality Benefits Realisation   Experience: Experience in Capital/Global Markets business and delivering projects in this area (greater than 5 years’ experience). Experience in projects involving Structured Products and Derivatives (ability to hold a conversation with Business SMEs). Experience in platform setup in offshore markets (desirable). Ability to manage more than one project concurrently.   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent
Salary: Negotiable

Oracle PL/SQL BI Developer Reference No: 1432068628 | Johannesburg, South Africa | Posted on: 29 March 2021

An opportunity exists to work in the Business Intelligence Department centered in Sandton 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

Manager: Data and Information Architecture / Senior Business Intelligence Analyst Reference No: 658658601 | Johannesburg, South Africa | Posted on: 23 March 2021

PBT Group has an urgent vacancy for a Data and Information Architecture / Senior Business Intelligence Analyst Manager.   Duties: Facilitating the relationship between developers and business analysts to ensure business and functional requirements are correctly translated into technical specifications and system guidelines. Analysis, scoping, specification and design of business rules and database solutions Rapid prototyping of business solutions to determine viability and to prove concepts. Focus on optimizing current databases and reporting processes. Lead projects with specific focus on automation and effectivity. Special Project: Pan Africa Client Revenue Reporting Replacement of end-to-end legacy database process into new SQL system Full analysis of business, reporting and database requirements for various African countries including Botswana, Ghana, Mozambique, Kenya, Mauritius, Tanzania, Seychelles, Zambia. Analysis and sourcing of various new and existing data sources within SQL, Oracle, Hadoop. Defining business rules and preparing prototypes using BI analytical tools, such as QlikView. Establishing new product and client hierarchies Creating datasets and SQL contracts to cater for data consumption and business transformation rules. Manage and ensure that processes are automated, sustainable and future proof. Status: Fully in production and project delivered on time     Experience: Extensive QlikView knowledge: Developer and Designer Training QlikView 11 Developer and Designer Certification QlikView 12 Knowledge in various programming languages: SQL Oracle Alteryx R, MATLAB, C++, SAS, Excel VBA (University level) Good computer typing skills Good in Microsoft Office (PowerPoint, Excel, Word) Good SAP knowledge in following areas: Procurement and Logistics, Taxation SharePoint basic training completed: SharePoint Site Collection and Site Administration SharePoint 2013 Branding and User Interface Design Core Solutions of Microsoft SharePoint Server 2013 SharePoint 2010 Designer (ICT Specialist)   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent  
Salary: Negotiable

Azure Data Engineer Reference No: 1889398864 | Johannesburg, South Africa | Posted on: 23 March 2021

PBT Group has an opportunity for Azure Developers who are well versed in the Azure Stack.   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

Informatica Data Engineer Reference No: 1683091404 | Johannesburg, South Africa | Posted on: 15 March 2021

: PBT Group has an urgent requirement for an Informatica Developer.   The Data Integration Developer is responsible for the design, build, and deployment of the project's data integration component. A typical data integration effort usually involves multiple Data Integration Developers developing the Informatica mappings, executing sessions, and validating the results.   DUTIES: Uses the Informatica Data Integration platform to extract, transform, and load data Develops Informatica mapping designs Develops Data Integration Workflows and load processes Ensures adherence to locally defined standards for all developed components Performs data analysis for both Source and Target tables/columns Provides technical documentation of Source and Target mappings Supports the development and design of the internal data integration framework Participates in design and development reviews Works with System owners to resolve source data issues and refine transformation rules Ensures performance metrics are met and tracked Writes and maintains unit tests Conduct QA Reviews Performs production migrations   SKILLS REQUIRED: Understands data integration processes and how to tune for performance Has SQL experience Experience with Oracle highly advantageous Possesses excellent communications skills Has the ability to develop work plans and follow through on assignments with minimal guidance Has Informatica Data Integration Platform experience Is an Informatica Certified Designer Has RDBMS experience Has the ability to work with business and system owners to obtain requirements and manage expectations RECOMMENDED TRAINING Data Modeling PowerCenter – Level I & II Developer PowerCenter - Performance Tuning PowerCenter - Team Based Development PowerCenter - Advanced Mapping Techniques PowerCenter - Advanced Workflow Techniques PowerCenter - XML Support PowerCenter - Data Profiling PowerExchange
Salary: Negotiable

Senior SAP Migration Engineer Reference No: 1660039122 | Waterfall, South Africa | Posted on: 09 March 2021

Senior SAP Migration Engineer. Data Services knowledge. Migration to SAP S4 Hana. Knowledge of SAP PM ( Plant Maintenance) advantage
Salary: R850 to R1050

Azure Data Engineer Reference No: 1265254028 | Cape Town, South Africa | Posted on: 04 March 2021

PBT currently has a role for a Senior Azure Data Engineer Solid data engineering background with the ability to interpret business requirements and technical solutions to develop components of or complete data models. Development experience in BI. Standard ETL skills. Azure experience required, with a core focus on Azure data factory, Azure SQL database, Python, Azure data lake. General understanding and experience of big data would be an advantage, specifically HDFS and Hive. An additional advantage would be to have Azure Synapse skills. Focus on the detail but understand the high-level deadlines to enable delivery on time with limited time Ability to articulate thoughts and problem statements well.
Salary: Negotiable

Data Modeler Reference No: 4088763356 | Cape Town, South Africa | Posted on: 04 March 2021

About the Role: Create and implement comprehensive conceptual logical and physical data models. Perform detailed data analysis to develop the data warehouse’s / BI solution’s data model. Participate in the business requirements definition activities in a secondary role, for which a good understanding of business rules is essential. Review models designed by other DBA’s and related the activities of other modelling efforts to the model under review. Model and understand the overall business architecture. Translate this business architecture to a conceptual data model. Structure of the enterprise data model so that it aligns with and enables the operational and analytics capabilities. This person must be able to market or sell the EDM to obtain buy-in and support from all levels within the organisation. About you: Knowledge about existing corporate data models, as well as knowledge of the business, is extremely important. Strong conventional (normalised) data modelling skills are beneficial, as the Data Modeler often must 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, multi-dimensional models, data vault models, big data models etc. Experience in other enterprise data modelling initiatives Understand the data requirements of front-end (reporting, dashboarding and analysis tools.) Ideally have data architecture experience Data warehouse design methodology training. Normalised and dimensional data modelling training. Must have worked with industry-standard data modelling tools. Strong experience working with a range of DBMS’s. Strong experience with SQL query and DBMS tuning.  
Salary: Negotiable

Hadoop Data Engineer Reference No: 2040826331 | Johannesburg, South Africa | Posted on: 23 February 2021

PBT Group has a requirement for a Hadoop Developer to interpret requirements provided by business and produce effective Big Data solutions.   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 (Intermediate level) - Hadoop based architecture with Hortonworks Data Flow & Data Platform clusters - HDF, HBase, Hive, Spark, Storm
Salary: Negotiable

Senior Oracle BI Apps and Reporting Consultant Reference No: 1186397365 | Johannesburg, South Africa | Posted on: 22 February 2021

PBT Group has an opportunity for Senior Oracle BI Consultant with Oracle BI Apps experience. Oracle BI Applications is a prebuilt business intelligence solution.   Oracle BI Applications supports Oracle sources, such as Oracle E-Business Suite Applications, Oracle's Siebel Applications, Oracle's PeopleSoft Applications, and non-Oracle sources, such as SAP Applications. Oracle BI Applications also provides complete support for enterprise data, including financial supply chain and workforce sources. These enterprise applications typically source from both Oracle data sources, such as Oracle EBS and PeopleSoft and non-Oracle data sources, such as SAP.   The role will focus on delivering and enhancing the financial and management reporting required by all stakeholders of the EPM and BI department. The role is focused on standardised and transparent reporting to ensure executive and external reporting adheres to the single version of the truth and allow for historical and predictive scenario reporting.   The primary aim of this project is to deliver standardisation, operational efficiency and drive adherence to the compliance framework across Africa and the Middle East.   The project will operate under strict project methodology, governance and compliance framework for the design, build, deployment and ultimate business transformation.   The dynamic nature of this role operates in an environment of continuous improvement within the overall objective of enhancing business value.   Duties: BI and Reporting will be responsible for all the BI applications. They will ensure the solutions are integrated and focus on usability and adoption across the group. Purpose specific solutions to address transparent reporting and analytics are vital for strategic support and decision making across the group. The group must utilise the same solutions to ensure seamless information flows and trust and confidence in the systems. The role is responsible for the growth of a BI team focused on the end user adoption by delivering targeted reporting, training and projects. The team’s guidance and growth to ensure a sustainable organisation supporting the critical investment in Cloud applications.   Other KPI’s: Business Intelligence and Warehousing Work with programme Manager, Project Managers and implementation partners to design and develop the oracle cloud solutions falling under the BI stack. Defining the strategy for BI and implementing it at an Opco level adhering to Group IT strategy Defining the strategy for BI and implementing it at OpCo level adhering to Group IT strategy Oracle Analytics Cloud comprising Oracle Business Intelligence Enterprise Performance Reporting Oracle data visualiser Oracle Essbase Oracle Transactional business intelligence Oracle day by day Oracle Client tool Oracle data integrator (ODI) BI publisher Data Sync   Experience 3-5 Years BI Strong Oracle BI Apps experience Microsoft, QlikView, Business Objects or other reporting and BI experience Cloud Experience (preferred)   Knowledge: Business Requirements documentation and review. KPI, Dashboarding and reporting standardisation. Relational scripting (SQL). Functional compliance and reporting standards. KPI design and delivery to track and enforce corporate strategies.   Skills: Problem solver Improvement driver Strong logical analytical and evaluation skills Effective conflict resolution Results focused. Fact based decision making. Behavioural: Complete candour Strong interpersonal skills Manages relationships. Emotional maturity Innovation Cultural awareness and adaptability   Education BSc/Bcom/Btech Relevant Software Certification or courses
Salary: Negotiable

Java Developer Reference No: 3478700491 | Cape Town, South Africa | Posted on: 15 February 2021

Evaluate and improve application performance, security, and high availability features. Build and deploy the system on an application server. Relevant tertiary qualification in Information Technology or Computer/Engineering Sciences. 2-3 years relevant experience as a senior back-end developer in a multi-tiered Java application development. Integrating systems (Analyses, Design, Model, Develop, Test and Implementation) using Java. Java – General (Object-Oriented programming, RMI, multithreaded programming, etc) Very strong SQL skills A thorough understanding of SDLC processes, tools and techniques.
Salary: Negotiable

Oracle PL/SQL Developer Reference No: 3441425130 | Cape Town, South Africa | Posted on: 15 February 2021

A solid technical understanding of data modelling, design and architecture principles and techniques. Data Modelling and Design courses, Data Transformation courses, Oracle certification (HIGHLY beneficial). 5 years plus working with  Oracle PL/SQL. Work with the technical architecture and development team to contribute to design and analysis. Requirements analysis and specification design at a system level. Interpret data and analyse results. Work with external teams to resolve data issues. Design\Implement Data Management strategies which include validation of source data and the use of data in management reporting Development of Functional Specifications and Technical specifications. Good technical understanding of data modelling, design and architecture principles and techniques. Experience in high data volume environments. Open to learning new cloud technologies i.e GCP, AWS, Azure
Salary: Negotiable

Application Developer Reference No: 2546020726 | Cape Town, South Africa | Posted on: 15 February 2021

Technical Skills: Good Knowledge of different platforms or browsers and how each work Do things need to be tweaked a little bit to ensure everything works across browsers, platforms, and devices. Very important to have as technology intensifies and diversifies. Wide range of knowledge pertaining to JavaScript Frameworks Experience with frameworks such as React/AngularJS/Redux HTML5/CSS3 Not just the basics. Knowledge of how to use the latest HTML5 and CSS3 features and functions in expert and innovative ways, particularly when it comes to combining them with different frameworks. Familiarity with technologies such as Bootstrap or other frameworks, LESS, SASS or similar pre-processing technologies Advanced skills particularly when it comes to animation and creative programming. JQuery Essential Must be able to develop plugins and extensions Responsible for creating UI Widgets Javascript Backend Programming not required, but knowledge of Nodejs/Express is advantageous Java Programming is advantageous Version Control GIT or SourceTree
Salary: Negotiable

Azure Consultants Reference No: 2025796051 | Johannesburg, South Africa | Posted on: 27 January 2021

  PBT Group has an opportunity for Full Stack Azure Consultants (Data Engineers, Data Architects) who are well versed in the Azure Stack and ideally PowerBI to assist with an Azure migration project.   Duties: 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. Migration to Azure   Experience: 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. Experience with Azure App Service Model, including Web Apps and Web Jobs Experience with creating, deploying, configuring, and scaling applications on Azure PaaS. Experience with Azure storage services and integration services, including SQL Database, Tables, Files, and Blobs, Service Bus, and Event Hubs Experience with participating in requirement gathering, analysis, and technical design. Knowledge of Cloud computing concepts and technologies, including IaaS, SaaS, PaaS, load balancing, and storage. Knowledge of Azure IaaS, including VMs, VNET, NSG Rules, VPN Gateways, and Express   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent  
Salary: Negotiable

Integration Developer Reference No: 4222809050 | Johannesburg, South Africa | Posted on: 21 January 2021

PBT Group has an opportunity for an Integration Developer to lead Business Technology in the business Unit/Functional Area with the purpose of supporting and enabling the realisation of business strategies and objectives.   The Integration Developer will be responsible developing, codify and documenting application and software integration solutions that are bespoke, innovative and sustainable for the fulfilment of business stated requirements.   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 develop solutions that align with the client’s Architecture minimum standards.   Solution design and build Consolidate and prepare solution design documentation in consultation with assigned Solution Architect(s). Apply standards and governance in such a way as to develop the best fit solution for business aligned to the Information Services framework. Coordinate and apply various coding efforts. Monitor and report on progress regularly for tracking implementation efforts. Address and develop solutions to problems and risks arising from coding efforts. Maintain code repositories and align with internal system change approval procedures. Comply, understand and implement all steps within IT development and meet governance in terms of legislative and audit requirements during programming execution. Collaborate with relevant stakeholders to ensure programs and build is completed in time and within budget.   Test Design relevant test scripts/ test cases to best determine system readiness and usability. Interface with platform test analysts to facilitate functional and regression testing.   Service handover Provide implementation and second tier support as required. Translate functional specifications into technical designs for implementation and deployment. Develop and produce related documentation that is both complete and concise on solutions implemented.   Experience:   In depth understanding and application of: MS SQL, Sybase Java development TIBCO integration Working in an Agile environment Understanding and experience in Agile methodologies Extensive demonstrable experience within Global Markets and/or Investment Banking delivering tangible results in a digital environment. Control-M or similar scheduling systems Engage and persuade multiple and complex stakeholders. 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: Bachelor Degree in Computing Science, Information Systems or related field  
Salary: Negotiable

Senior BI Data Modeller Reference No: 4177790947 | Johannesburg, South Africa | Posted on: 18 January 2021

PBT Group has an opportunity for a Senior Data Modeller to design and maintain optimal data models/structures at both an enterprise and system / application level that meet the business and architectural objectives of the organisation. To create structures that enable data to be persisted in a structured way to enable the value of the data to be unlocked. To create appropriate data and class structures that enable the flow of data between providers and consumers. Where required, lead a team of modellers performing this work.   The primary technology used is IDA (Infosphere Data Architect (Data Modelling Tool)) and Aginity Workbench DB2.   It will also be most beneficial to have knowledge of IGC (Infosphere Governance Catalogue).   Duties: Design data models that meet the business requirements and align to the agreed architecture framework. Ensure data modelling deliverables are delivered according to project plan and budget to meet commitment to stakeholders. Ensure all data modelling activities and deliverables are aligned to the development methodology and to the data modelling principles and standards Apply the approved tooling to create the data modelling deliverables. Adopt the Enterprise Data Model (which is based on the IFW) as a standard for data model designs to leverage best practice and fast track data modelling efforts. Translate business requirements into data requirements. Analyse and profile the source data to understand data quality issues, relationships, patterns and rules in the data. Structure data requirements into logical data constructs based on the Enterprise Data Model, including ERD models, dimensional models to ensure optimal implementation. Compile Source to Target Mapping Specifications including the appropriate Transformation Rules Identifying definitive or authoritative source of data; analysing source data; and identifying gaps to target structures Enable physical implementation of the data structure by generating the first cut physical data model from the logical data model. Facilitate dataflow understanding by collating dataflow diagrams outlining the flow of data across systems and interfaces. Reduce non-value adding work by identifying opportunity for re-use of the Enterprise Data Model Maintain up to date knowledge of latest developments in the Data Modelling domain, including reading; continuous professional development courses; seminars and conferences. Assists to provide a comprehensive governed framework by working with the data modelling CoE and contributing towards defining the data modelling standards. Advise stakeholders and other staff on application of data modelling practices through consultation. Ensure consistency and re-use of data models by acting as a primary advocate of date modelling activities and methodologies and by driving the adoption of enterprise data modelling across the bank. Ensure improved performance by providing feedback on improvements to the data modelling framework. Perform review on work performed by team members as well as review and govern work performed by other modelling teams Identify opportunities to improve or enhance processes. Provide Overall Data Management Guidance and alignment to the Data Management framework and standards Seek opportunities to improve business processes, models and systems though agile thinking. Support the achievement of the business strategy, objectives and values Participate and support corporate responsibility initiatives for the achievement of business strategy   Skills & Experience Required: 5 – 8 years IT related experience with 5yrs+ in a Data Modelling role Able to demonstrate practical experience in relational and dimensional modelling techniques as well as leading teams of data modellers Has demonstratable experience in developing custom data models as well as data modelling utilising Industry data models such as IFW BFMDW Experience in model management Experience in compiling and monitoring standards and developing/maturing a data modelling practice OO modelling experience also an advantage Experience using Infosphere Data Architect or any other Data Modelling Tool Firm understanding of Data Management (DMBOK), systems development lifecycle methodologies and IT Architecture Relevant regulatory knowledge, and understanding of banking and financial services Experience in NoSQL and other forms of database modelling advantageous   Advanced knowledge of: Industry Model Understanding Pattern Recognition, conceptual and abstract thinking Presenting Problem solving and creativity Language skills Data analysis and inference Data Integrity Data Modelling - Data Warehouse Layers Metadata Data Quality Data Warehousing Overview and Architecture Database Model Concepts Data and business requirements Gathering Data Modelling Tools   Intermediate knowledge of: Using SQL in Databases Agile Concepts Banking Product Knowledge   Basic knowledge of: Data Governance Data Architecture Management Data Integration DevOps Tooling and methodologies Master and Reference Data Management     Qualifications/ Certification: Advanced Diplomas/National 1st Degrees/equivalent NQF level 6 qualification Bachelor of Commerce, Bachelor of Science: Information Systems / Computer Science Honours level TOGAF, DAMA
Salary: Negotiable

Data Analyst (intermediate) Reference No: 620398218 | Cape Town, South Africa | Posted on: 18 January 2021

Analyse business requirements from documents and end-user discussions. Identify data requirements necessary to support business requirements or integrated application and subject areas. Identify and define the business rules associated with the data; these should include all data integrity/constraint requirements. Identify and perform a detailed analysis of all data sources for each application and subject area. Perform data profiling of data contained in source systems. Provide a detailed analysis of all data implemented into the database. Provide the data mapping and associated transformation rules for each data item. 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 ETL Analysts 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 Skills Required Degree or diploma in data analysis, Sound knowledge of business analytics and requirements gathering, Experience in modelling and ETL tools i.e. SQL  
Salary: Negotiable

Senior Java Developer Reference No: 224732607 | Johannesburg, South Africa | Posted on: 15 January 2021

PBT Group has an opportunity for a Senior 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

Python Developer Reference No: 495007041 | Cape Town, South Africa | Posted on: 12 January 2021

About the role 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 low-latency, high-availability, and performant applications Integration of data storage solutions Performance tuning, improvement, balancing, usability, automation Work collaboratively with the 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

Data Engineer Reference No: 2035447108 | Cape Town, South Africa | Posted on: 12 January 2021

PBT is currently recruiting for a Data Engineer with solids skills in Microsoft Full Stack development Experience in: SSIS, SSRS, SSAS (Tabular), T-SQL, Data Warehousing Experience, Kimball Team Player, Can-Do Attitude, Adaptability, Good Communicator Proven experience as a Data Developer In-depth understanding of database management systems, Cube and ETL framework Familiarity with BI technologies Proven abilities to take initiative and be innovative  
Salary: Negotiable

SAS Developer Reference No: 3880838900 | Johannesburg, South Africa | Posted on: 14 December 2020

PBT Group requires a Senior SAS Developers with Oracle and SQL, with at least 3 years relevant experience to join an existing project at a Short-term Insurance company.   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 KNOWLEDGE: 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 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.   SKILLS REQUIRED: SAS Base, Macros (in-depth knowledge) 3+ years ETL development experience 2 to 3 years Business intelligence/warehouse design experience SAS experience essential SAS tool knowledge/architecture Cubes Database build Dashboards Predictive modelling Enterprise search Interactive visualisation techniques In memory analytics Understanding of the integration challenges within BI Performance management Multi-dimensional data analysis   REQUIRED QUALIFICATIONS / TRAINING: Course on the ETL / related toolset. Relevant data warehouse and BI solution training B.Sc. or related degree is advantageous.
Salary: Negotiable

BI Business Analyst Reference No: 3802279556 | Cape Town, South Africa | Posted on: 09 December 2020

About the role The primary purpose of the role is to gather, analyze and document Business data and reporting requirements and translate them into BI solutions in partnership with the BI Architect and technical teams. Responsible for gathering and documenting the reporting requirements for the respective business areas Investigate data sources and query the data using SQL Document Functional Requirements to the source system Document Source to Target mapping for new solutions Develop conceptual BI solution design Contribute to the logical design of Star Schema Functional testing (ensure that solutions meet the requirements and needs of the business) Manage data test process, including unit, system integration, functional and user acceptance testing About you 3-year Degree/Diploma in Information Technology or related fields - essential Data analysis experience Experience in working with data visualization tools   Proficient in SQL for data analysis - essential Knowledge of Dimensional Modelling/Data Warehousing
Salary: Negotiable

Software Quality Engineer Reference No: 552360549 | Johannesburg, South Africa | Posted on: 08 December 2020

PBT Group has an opportunity for a couple of Software Quality Engineers.   Duties: Contribute to the systematic breakdown of the business need into manageable feature(s), stories and epics that can be delivered. Participate in the backlog grooming. Participate in the sprint planning, test estimation and success criteria per story. Discuss the low-level design and functional requirements with the Chapter Lead, Application/Solution Architect to understand the approach to test automation. Collaborate with the Core Technical Team to continuously improve the test harness, automation frameworks and overall platform. Promote the automation framework and tool adopted by the Enterprise Quality Assurance team. Perform adhoc peer review of the automated test assets being maintained by the Software Quality Engineer to ensure conformance of the process and governance. Collaborate with the environment DevOps engineer to investigate and correct bugs and inefficiencies. Develop the automation scripts using the automation framework for execution. Implement the test automation with the objective that it has adequate coverage within the sprint and can be re-used for regression testing. Ensure the solution meet the architectural and development standards that are re-usable and scalable. Confirm that the automation test suite implemented is appropriately catalogued and aligns with the governance. Responsible for testing of the system or component testing under load. Responsible for testing of the system or component high-availability and recoverability. Log defects using the pre-defined defect management tool and ensure the relevant information is captured accurately that will assist with the root cause analysis. Manage the product risk and communicate to the QA Lead the details and any possible mitigation factors. Collaborate with the stakeholder to ensure the resolution of a defect and the root cause analysis is performed and recorded. Report status of testing to the Quality Assurance squad daily. Participate in all retrospective reviews. Participate in the showcase to external stakeholders.   Experience: API automation is key focus (Karate / Rest Assured / SOAP UI etc) Front end (Selenium/Appium) NFT: JMeter Core programming is usually done in Java rather than C# in IntelliJ, with Maven / BitBucket / Git.   Qualifications/ Certification: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent  
Salary: Negotiable

Senior Technical Business Analyst Reference No: 2384937634 | Johannesburg, South Africa | Posted on: 08 December 2020

PBT Group has an opportunity for a Technical Business Analyst to translate business needs into detailed business information and data requirements functional integration and process specifications. Exposure to SQL and Oracle is highly advantageous. Data analysis skills would be an added bonus).   DUTIES:   Stakeholder relationship management Build and maintain professional working relationships with all stakeholders displaying excellent abilities to initiate dialogue, listen to advise, influence and negotiate to achieve win-win outcomes. Initiate meetings with key stakeholders to track progress manage expectations and ensure stakeholders requirements are delivered. Preserves relationships despite airing conflicting views and seeks mutual gains when addressing conflicts. Anticipates consequences and adapts problem solving based on continual feedback. Act speedily to resolve problems queries and complaints. Adapt communication styles to meet the needs of different audiences.   Requirements elicitation and root cause analysis Facilitate one-on-one or group workshops to elicit analyse communicate and validate requirements for changes to business processes and policies and where relevant, IT systems. Analyse existing processes and facilitate improvements with stakeholders. Analyse and model data and data requirements where applicable. Document business/functional requirements. Conduct a gap analysis to identify the most feasible solution to meet requirements. Work with business stakeholders to define metrics/performance goals and acceptance criteria for solution and ensure the implementation of the requirements.   Solution / project delivery Translate business needs into detailed business information and data requirements functional integration and process specifications. Clarify the business requirements technical solutions and functional or process specifications for relevant stakeholders. Work with project team to define metrics or performance goals and acceptance criteria for solution and system and ensure the implementation of the requirements. Coordinate and where required participate in the test effort to ensure that the delivered solution meets agreed business requirements and functional or process specifications. Participate in post project implementation review. Provide input into compiling or write system manuals where required. Compile training material and provide end-user training to stakeholders where relevant. Prioritize requirements (critical and non-critical) with Project Manager to identify project deliverables and time frames. Configure various systems to meet requirements.   Teamwork, self-management & alignment with group values Self-management: Demonstrates pride in the organisations brand services and products by consistently delivering on the brands promise. Self-management: Plan and manage own workflow anticipating obstacles juggling priorities and following through on objectives within agreed time-frames and according to quality standards. Self-management: Stay relevant and up-to-date with legislations and new development. Self-management: Maintain a positive attitude and respond openly to feedback. Self-management: Handle stress in ways that do not negatively impact others. Self-management: Take ownership of personal career development leveraging formal and informal opportunities. Self-management: Act in an ethical transparent and morally defensible manner including highlighting unethical practices. Teamwork: Continually share debate and communicate learnings. Teamwork: Flag and debate issues constructively. Teamwork: Contribute to a friendly co-operative climate in working with others to achieve collective goals. Teamwork: Be sensitive to others feelings needs values views and attitudes and be courteous and diplomatic when dealing with difficulties and problems others may be experiencing (EQ).   EXPERIENCE:   8+ years relevant experience as a Technical Business Analyst in a banking / financial sector. Solid Systems Analysis experience Exposure to SQL and Oracle would be highly advantageous. Data analysis skills would be an added bonus)   Analysis and Attention to Detail The 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 Able to apply specific analytical concepts and techniques within agreed structures Produces quality by ensuring accuracy and integrity of information Applies systematic thinking to diagnose root causes Evaluates existing practices for accuracy and compliance Can provide guidance and coaching on analysis to others   Problem Solving Cuts to the core of issues and applies effective analysis, logic and creativity to identify and implement solutions Accumulates the right information to solve problems Uses decision-tree logic to diagnose root causes Reflects on what is occurring to identify potential problems and obstacles Uses judgement and discretion to interpret issues based on learnt theory Solves problems with an awareness of the bigger picture; can see beyond immediate issues to anticipate consequences   Presentation and Facilitation The capacity to use appropriate presentation and facilitation techniques to engage an audience and help them to understand, retain and respond appropriately to the message Uses presentation aids to enhance understanding Presents confidently and engages the audience Creates presentations that are visually appealing and that enhance the message / information presented Adjusts presentation and delivery to audience's response Interacts well with the audience to solicit participation and feedback   Verbal and Written Communication (inc. Listening) The capacity to listen attentively, present information clearly and concisely and respond appropriately to the verbal and written communications of others. This includes the ability to regulate delivery in response to the needs of a target audience Able to communicate complex specialist knowledge and concepts clearly Delivers messages in ways that gain support and agreement Can communicate sensitive messages tactfully Knows which communication medium is most appropriate for the message Communicates with the recipient's perspective in mind   Knowledge Sharing Promotes the generation and sharing of knowledge and learning in order to enhance the collective knowledge of the team / organisation Acts in ways that encourage openness and knowledge sharing Stays abreast of current developments and trends in technical, professional or work-related areas Contributes positively to knowledge sharing forums Collects, stores and promotes information to allow easy access for self and others Keeps documentation and files up-to-date and readily accessible   Organisational Awareness Understands organisational systems, structures, policies and procedures and can navigate changing dynamics and power relationships Works well with other organisational structures Able to interpret and work within Standard Operating Procedures Understands how own responsibilities link to aligned roles Makes use of informal organisational structures to achieve goals Able to reference organisational goals and services   Process and Technological Competence Utilises, identifies, enhances and leverages processes and technologies to meet business needs Ensures consistent use of systems and processes through agreeing and maintaining standards Applies understanding of legacy and new systems and processes to solve internal and external problems Makes suggestions up-the-line regarding how systems and processes can be improved Tracks and reports effectiveness of new systems / processes against desired objectives Manages and maintains systems / Applications   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 Displays a sound understanding of customers' operational needs and requirements Displays sound analysis and logic in probing, analysing and resolving customers' needs Follows through on promises to clients Uses influence to encourage others to provide excellent customer service as a team Consistently models appropriate customer behaviour   Teamwork The capacity to work co-operatively with others to achieve shared goals Ensures team's purpose and goals are clear Demonstrates and demands commitment to team goals Gives and receives timely, constructive feedback Encourages open discussion and sharing Shares knowledge   Drive and Results Orientation Is a 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 success and sets demanding goals for self and others Consistently meets deadlines without compromising quality Able to implement solutions and deal with stumbling blocks; stays positive Sets and meets challenging goals (self and team) Focuses on what is important; doesn't get distracted Takes immediate action when confronted with a problem   Leading and Managing: Monitoring and Measuring The capacity to define, encourage, review and evaluate own and other's performance in relation to clearly defined objectives, time-lines and performance standards; includes the ability to identify and implement appropriate measures and benchmarks Plans and communicates team members' roles, responsibilities and performance standards Monitors consistently using agreed measuring and reporting tools Highlights mistakes and lessons learnt Gives constant developmental feedback Consistent and systematic in assigning and measuring work   Leading and Managing: Planning and Organising Defines tasks needed to accomplish goals and assigns and co-ordinates people, tasks and resources accordingly Plans and communicates team members' roles, responsibilities and performance standards Consistent and systematic in assigning and measuring work Uses discretion to resolve problems within agreed mandate Gives constant developmental feedback Assigns tasks based on knowledge of peoples' skills   QUALIFICATIONS/ CERTIFICATION: A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent
Salary: Negotiable

Data Analyst Reference No: 3880945636 | Johannesburg, South Africa | Posted on: 07 December 2020

PBT Group has an opportunity for a Data Analyst to source, research and create graphs and reports for the Research team, respond to client requests and ensure all information provided is accurate and current.   DUTIES:   Accurate, timely research: Based on internal and external stakeholder requirements, source relevant local and international data Know when data becomes available and create a schedule to access it Build and expand a network of global contacts who can provide specific information Build, maintain and update a database of raw information   Translation of raw data into accurate graphs and reports: Check with internal and external stakeholders to ensure their need has been properly communicated and understood Based on stakeholders’ specific requirements, manipulate data accordingly, providing data, graph(s) and/or reports per client request Maintain a library of templates for the graphs needed on a daily, weekly, monthly, quarterly and/or annual basis Update, adapt or generate new graphs as required, using the same format and colours for the different templates In migrating graphs from Excel to PowerPoint, create the graph, creating layers of superimposed information as required Ensure all information provided to clients is compatible with latest software Liaise with stakeholders to ensure information provided meets their needs Check internal stakeholders’ diaries to be able to plan ahead to provide graphs and other relevant information for their meetings   Accurate, timely research administration: Load finalised GM research onto Standard and Poor’s client intranet Send updated information through to specific publications (e.g. Financial Mail) in line with agreed deadlines Load clients onto Global Markets database to receive reports Provide administrative support to the Research team as required   Stakeholder relationship management: Build and maintain professional working relationships with all stakeholders, displaying excellent abilities to initiate dialogue, listen, advise, influence and negotiate to achieve win-win outcomes Initiate meetings with key stakeholders to track progress, manage expectations and ensure stakeholders’ requirements are delivered Preserves relationships despite airing conflicting views and seeks mutual gains when addressing conflicts Anticipates consequences and adapts problem solving based on continual feedback Act speedily to resolve problems, queries and complaints Adapt communication styles to meet the needs of different audiences   Self-management: Demonstrates pride in the organisation’s brand, services and products by consistently delivering on the brands promise Plan and manage own workflow, anticipating obstacles, juggling priorities and following through on objectives within agreed time-frames and according to quality standards Stay relevant and up-to-date with legislations and new development Maintain a positive attitude and respond openly to feedback Handle stress in ways that do not negatively impact others Take ownership of personal career development, leveraging formal and informal opportunities Act in an ethical, transparent and morally defensible manner, including highlighting unethical practices   Teamwork: Continually share, debate and communicate learning’s Flag and debate issues constructively Contribute to a friendly, co-operative climate in working with others to achieve collective goals Be sensitive to others’ feelings, needs, values, views and attitudes and be courteous and diplomatic when dealing with difficulties and problems others may be experiencing (EQ)   EXPERIENCE: 5+ yrs. exp in the BI Analyst Role Needs to be able to read and write SQL. Troubleshoot as well. Apply business analysis best-practices, consistent with the BABOK principles and standards. Support continuous improvement by identifying and solving opportunities. Experience with Business Intelligence tools such as Microsoft Business Intelligence, Business Objects etc. Experience with Data Visualization tools such as Microsoft PowerBI. Excellent communication, interpersonal and problem solving skills, including the ability to translate business requirements effectively. Perform root cause analysis with stakeholders, conduct interviews or workshops to further evaluate and identify solutions to meet business requirements. Assist with production issues within a given timeframe. Coordinate and participate in the test effort to ensure that the delivered solution meets agreed business requirements and functional/process specifications. Ensure all the business requirements and relevant documents are well documented. Assist the Lead by investigating, estimating and calculating costs and timelines for enhancements and projects. Very good written and verbal communication skills Team player, driven to succeed and transparent Be able to maintain the environment and provide support where required 3+ years’ research experience in a financial service and/or Treasury environment with exposure to specific products and asset classes Flexible and comfortable with change High learning agility Sound self-management and organisational skills TECHNICAL PRE-REQUISITE Basic economics knowledge General knowledge of current affairs Understanding of economic research engines (Reuters, Bloombergs, I-net Bridge) Knowledge of the Microsoft Office suite (particularly Word, Publisher, Excel and Powerpoint) Basic macroeconomic knowledge Basic knowledge of relevant products Basic knowledge of relevant asset classes Basic knowledge of company and sector specifics Internal systems, processes, policies, procedures and workflows Work templates, models and methodologies, including reporting templates   COMPETENCIES: Analysis and Attention to Detail Able to apply specific analytical concepts and techniques within agreed structures Produces quality by ensuring accuracy and integrity of information Applies systematic thinking to diagnose root causes Evaluates existing practices for accuracy and compliance Can provide guidance and coaching on analysis to others   Problem Solving Accumulates the right information to solve problems Uses decision-tree logic to diagnose root causes Reflects on what is occurring to identify potential problems and obstacles Uses judgement and discretion to interpret issues based on learnt theory Solves problems with an awareness of the bigger picture; can see beyond immediate issues to anticipate consequences   Excellence Orientation Uses discretion and informed judgement to diagnose what enables or disables quality performance (own and/or team) Monitors own and other’s work to identify and correct errors Pays attention to consistency of own and other’s work Motivates team members to take accountability for quality Guides others to improve the quality of their work   Drive for Results Consistently meets deadlines without compromising quality Able to implement solutions and deal with stumbling blocks; stays positive Sets and meets challenging goals (self and team) Focuses on what is important; does not get distracted Takes immediate action when confronted with a problem   Building Relationships Builds relationships based on warmth and understanding of stakeholders’ needs and requirements Displays patience and tact in dealing with difficult people and situations Displays sound analysis and logic in probing, analysing and resolving interpersonal issues Follows through on promises Uses influence to build and maintain good working relationships   Customer Service Orientation Displays a sound understanding of customers' operational needs and requirements Displays sound analysis and logic in probing, analysing and resolving customers' needs Follows through on promises to clients Uses influence to encourage others to provide excellent customer service as a team Consistently models appropriate customer behaviour   Verbal and Written Communication Able to communicate complex specialist knowledge and concepts clearly Delivers messages in ways that gain support and agreement Can communicate sensitive messages tactfully Knows which communication medium is most appropriate for the message Communicates with the recipient's perspective in mind   Research Competence Gathers information from multiple credible sources Shows awareness of metrics associated with the credibility of sources Identifies information that is relevant to a specific question or problem Networks with key individuals and bodies to gather up-to-date information, sometimes before results are published Regularly revises his/her understanding of key research findings and trends   Environmental Scanning Continually accesses documentation, reports, research and other sources of information that are relevant to own discipline Reads widely to gather information from diverse sources Analyses data and information relevant to own industry, organisation or discipline to gain insight into current and future trends Understands the impact that current trends may have on the organisation, discipline or industry Understands how different categories of information fit together   Planning and Organising Plans and communicates other’s roles and responsibilities clearly Consistent and systematic in assigning and measuring work Uses discretion to resolve problems within agreed mandate Gives consistent feedback to others Makes contingency plans for possible changing priorities   QUALIFICATIONS/ CERTIFICATION: Relevant degree / diploma
Salary: Negotiable

Data Engineer Reference No: 1694100912 | Johannesburg, South Africa | Posted on: 04 December 2020

PBT Group has an opportunity for a Data Engineer with financial services industry experience to architect and lead the development of data architectures across the company to enable business decision-making, governance, and best practice solutions.   The Data Engineer will design and implement data pipelines and systems to enable clean and usable data to inform data science and analytics.   Duties:   Macro environment Engage with the macro-environment to look for new opportunities, capabilities and trends that would add value to the required data engineering work. This includes ensuring that data systems meet the client’s regulatory commitments, and that data is reliable and efficient Adopt industry leading systems and ways of working to support best-in-class business capabilities for high performance database solutioning Actively participate in team, cross-discipline and vendor-driven collaboration sessions or forums to increase understanding of the working environment. This includes contribution and participation in the relevant Data Governance Frameworks   Business alignment Partner with Technology, Business and other stakeholders to ensure that database structures, programmes and applications meet business delivery requirements   Strategy formulation and execution Align to advance the clients’ data roadmap e.g. single data sourcing, architecture convergence and rationalisation of platforms.   Solution design Design and implement scalable end-to-end database solutions including: address issues of data migration i.e. validation, clean-up and mapping and consistently apply data dictionaries component design and development identify and resolve production and application development constraints develop prototypes and proof of concepts integrate new technologies and software into the existing landscape develop data set processes for data modelling, mining and production optimal utilisation of big data documentation management and disaster recovery   Architecture governance Monitor adherence to processes which support the prescribed data architectural frameworks and ensure development/delivery teams align to the required standards and methodologies Recommend appropriate interventions in own area of ways to improve data architectural compliance. This includes BU/FA representation at relevant forums e.g. Architecture Board, Cloud Steerco   Project/Programme Management Monitor adherence to processes which support the prescribed data architectural frameworks and ensure development/delivery teams align to the required standards and methodologies Recommend appropriate interventions in own area of ways to improve data architectural compliance. This includes BU/FA representation at relevant forums e.g. Architecture Board, Cloud Steerco   Experience: Worked in similar role in financial services industry In depth knowledge and understanding of: Data governance and data management frameworks BI and Warehouse design Metadata Management Enterprise Information/Enterprise Application Service Oriented Architecture Data Integration: Extract Transform Load (ETL), batch architecture and frameworks Event Driven Architecture XML and related technologies SOA & Web Services Logical Database Design Statistical analysis and modelling Database architectures Hadoop-based technologies (e.g. MapReduce, Hive and Pig, Spark) SQL-based technologies (e.g. Oracle and MSSQL) NoSQL technologies (e.g. Cassandra and MongoDB) Data modelling tools (e.g. ERWin, Enterprise Architect and Visio) Python, C/C++ Java, Perl MatLab, SAS, R Predictive modelling, NLP and text analysis Machine learning Data mining UNIX, Linux, Solaris and MS Windows   COMPETENCIES Innovation - ability to initiate new and better ways of doing things, using appropriate methods to identify opportunities, devise and implement solutions and measure impact Teamwork - capacity to work co-operatively with others to achieve shared goals 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 success and sets demanding goals for self Assertiveness- able to hold one's own in the face of opposition and exert influence calmly, firmly and fairly Influencing and Impact (incl. Negotiation) - capacity to create appropriate levels of impact by using verbal and non-verbal communication skills to influence and/or negotiate win-win agreements to proposals, plans or ideas Verbal and Written Communication - capacity to use appropriate presentation and facilitation techniques to engage an audience and help them to understand, retain and respond appropriately to the message   Qualifications/ Certification: Degree Preferred certifications (TOGAF, CDMP, DMBOK and UML Modelling)
Salary: Negotiable