PBT Group Careers
Be part of our team of Data Specialists and embark on a career of the future!
Search
Filters
(0 Active)
City
▼Industries
▼Date Posted
▼Your search did not return any results.
SQL Developers Reference No: 1194742859 | Cape Town, South Africa | Posted on: 30 January 2023
PBT Group has an opportunity for a SQL Developer in the health administration sector. We have a solid track record and in-depth knowledge and experience of the South African, Australian and Botswana Health Care markets and their related interfaces, boasting a proud number of satisfied customers over a long period.
We are looking for a SQL developer who will be responsible for designing and developing our existing insurance administration platform.
We require strong analytical and database design skills.
You will also work with other developers optimizing in-application SQL statements as necessary and establishing best practices.
You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.
You will be able to take on new challenges, both in programming and other fields of IT where you could develop yourself and grow significantly.
The company is very flexible, allowing you to enjoy a pleasant work/life balance.
The company has a friendly and innovative corporate culture, the company's employees work in a pleasant and family-like environment, where mutual support and team spirit are essential.
Duties:Support existing and develop new functionality and components
Help write and optimize in-application SQL statements
Design and Development scalable application solutions
Interpret business requirements
Ensure performance, security, and availability of databases
Prepare documentation and specifications
Handle common database procedures such as upgrade, backup, recovery, migration, etc.
Capable of troubleshooting common database issues
Do root cause analysis on bugs to find and fix the cause of a problem in an integrated system.
Profile server resource usage and optimize and tweak as necessary
Collaborate with other team members and stakeholders
Write optimized queries, views and triggers for integration with other applications
Maintain high standards of data quality and integrity
Understand issues related to network performance and security
Assist with testing efforts
Experience:3+ years relevant experience as a back-end developer in MS SQL application development.Strong proficiency with SQL and its variation among popular databases
Experience with some of the modern relational databases (SQL Server would be an advantage)
Knowledge of design patterns
Skills to back up and support the DBA would serve as an advantage
Skilled at optimising large, complicated SQL statementsA thorough understanding of SDLC processes, tools, and techniques.
Proficient understanding of code versioning tools
Ability to work in a team environment.
Health Care / Insurance industry experience is a huge bonus.Exposure to data analytics and machine learning will be advantageous
Personal Profile:Self-starter, self-motivated and a team player
Excellent communication and interpersonal skills
Strong attention to detail
Able to work under pressure and meet deadlines
Able to coordinate pieces of work across multiple components of the application platform.
Finisher
The Offer:Competitive salary above the market
A challenging and fulfilling position with several different projects
Pleasant hybrid work environment
Opportunity to be exposed to new and exciting technologies
Qualifications/ Certification:A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent
Salary: 65000
SQL Data Engineer Reference No: 1872561267 | Johannesburg, South Africa | Posted on: 25 January 2023
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
Oracle PL/SQL Data Engineer Reference No: 3380345115 | Johannesburg, South Africa | Posted on: 25 January 2023
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
Project Manager (Asset Management) Reference No: 659067748 | Johannesburg, South Africa | Posted on: 24 January 2023
PBT Group has an opportunity for a Project Manager in the Banking / Financial Services Industry.
The project manager is responsible for the direction, coordination, implementation, executive, control and completion of the project while remaining aligned with the strategy, commitments and goals of the organization.
Project management responsibilities include the coordination and completion of projects on time within budget and within scope following the Minimum Standards Framework. Oversee all aspects of projects. Set deadlines, assign responsibilities, and monitor and summarize progress of project. Prepare reports for upper management regarding status of project.
The successful candidate will work directly with clients to ensure deliverables fall within the applicable scope and budget. He or she will coordinate with other departments to ensure all aspects of each project are compatible.
May need to rely on limited experience and judgment to plan and accomplish goals. Perform a variety of tasks. Lead and direct the work of other team members. A wide degree of creativity and latitude is expected. Reports to head of PMO.
Duties:Coordinate internal resources and third parties/vendors for the flawless execution of multiple projects
Ensure that all projects are delivered on-time, within scope and within budget
Assist in the definition of project scope and objectives, involving all relevant internal stakeholders and ensuring technical feasibility
Ensure resource availability and allocation
Develop a detailed project plan to monitor and track progress
Manage changes to the project scope, project schedule, and project costs using appropriate verification techniques
Measure performance using appropriate project management tools and techniques
Report and escalate to management as needed
Manage the relationship with the client and relevant stakeholders
Perform risk management to minimize potential risks
Establish and maintain relationships with stakeholders
Create and maintain comprehensive project documentation
Meet with clients to take detailed ordering briefs and clarify specific requirements of each project
Track project performance, specifically to analyse the successful completion of short and long-term goals
Meet budgetary objectives and make adjustments to project constraints based on financial analysis
Develop comprehensive project plans to be shared with clients as well as other staff members
Perform other related duties as assigned
Develop spreadsheets, diagrams and process maps to document needs
Project manager requirements:10+ years proven working experience in Project Management
Financials Services Asset Management experience within Corporate and Investment Banking is required
5 years investment banking experience in implementing Business Technology solutions
Fully comfortable with Agile delivery methodology and ceremonies (Scrum or SAFe)
Ability to manage a number of dependencies outside their project
Must be a strong project manager focused on driving delivery (i.e. willing to get their hands dirty to land the project), not just pushing Admin.
This person will also be interacting regularly with one of our strong Exco members, so they must be able to stand their ground but also come across as professional with a high-quality output.
Excellent client-facing and internal communication skills
Excellent written and verbal communication skills
Solid organizational skills including attention to detail and multitasking skills
Strong working knowledge of Microsoft Office
Project Management Professional (PMP) / PRINCE II / CAPM certification is a plus
Bachelor's Degree in appropriate field of study or equivalent work experience
Experience with project management software tools and in particular Jira & Confluence
Project Manager skills & proficiencies:Excellent communication skills
Problem-solving and leadership skills
Project planning, risk management, time management and other project management skills
Experience in strategic planning, risk management and/or change management
Proficiency in project management software tools
Conflict resolution experience
Qualifications/ Certification:Must have a degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent
Project Management Certification )( Project Management Professional (PMP) / PRINCE II / CAPM certification)
Agile Project Management Certification
Salary: Negotiable
Financial Accountant Reference No: 117865119 | Cape Town, South Africa | Posted on: 24 January 2023
Description
PBT Group has a requirement for a Bookkeeper to provide financial information by maintaining and reconciling accounts and preparing financial reports for business decision-making.
About the role:Full accounting function, including processing and preparing monthly accounting records.
Bank recons, General Ledger and subsidiary ledger reconciliations.
Processing accounts payable and receivable, including managing the full debtors and creditors function.
Compiling invoices and monthly customer statements.
Analysing financial information and explaining variances.
Calculation and submission of VAT returns, including VAT reconciliations.
Fixed Asset Registers – Monthly depreciation & the accuracy of maintaining the Fix Asset Registers.
Intercompany transactions – Interest Calculations & maintaining amortized schedules.
Financial Reporting – Income statements, Balance sheets, management accounts, etc.
Liaise with external Auditors.
Foreign exchange differences – valuation of foreign clients and bank accounts.
Ad hoc financial and administrative support to employees and the finance team.About you:8+ years of relevant experience in a similar role
Experience in CaseWare essential
Bookkeeping qualification/accounting diploma
Must be familiar with doing the books for multiple sites/locations
Good understanding of accounting principles and month-end processes
Ability to maintain a high level of accuracy in performing all essential duties and strong attention to detail
Ability to work in a team environment with a variety of individuals in a constructive and collaborative manner
Exceptional organisational and communication skills, including the ability to effectively present information to various levels of an organization
High level of energy and the desire to work in a fast-changing working environment
Proven ability to succeed in a fast-paced and constantly changing environment while managing tight deadlines
Strong Excel skills, and comfortable with large data volume
Pastel knowledge and proficiency
SAGE Evolution (would be advantageous)
Microsoft Word and Excel proficiency
Valid driver’s license and own transport
Salary: Negotiable
Lead Business Analyst Reference No: 3023147878 | Cape Town, South Africa | Posted on: 23 January 2023
PBT Group has an opportunity for a Lead Business Analyst. As a Business Analyst, you will play a critical role as a problem solver and be the person who assists in defining and enabling business change in an agile environment. Your primary responsibility is to deliver solutions that are fit for purpose, that focus on efficiencies and that deliver business value.
Duties:Understanding business needs as they relate to a potential change or transformation
Acting as an advisor to the business on best outcomes for a particular business problem or initiative
Facilitating group workshops and meetings
Explaining technical jargon to non-technical/ business teams
Gathering, identifying, and documenting business requirements
Simplifying requirements, so they are easily understood across the whole team
Building relationships with all key stakeholders that includes business owners, product owners, development teams, trainers, and users
Business process modelling and improving business processes across various business units, processes, and systems
Implementing, testing, and deploying solutions to business problems (includes facilitating and co-ordinating User Acceptance testing)
Supporting business transition and helping to establish change (includes transfer of knowledge to users, trainers, and peers)
Assist in the continuous development, improvement, and implementation of the analysis framework
Working in an agile team within the scrum framework
Work around the assessment that needs to be conducted.
Gathering requirements
Facilitating workshops
Working with technology partners to refine and define user stories.
Support the programme and all the follow-on activities that is required.
Experience:At least 5 years working experience in the Financial Services industry (required)
Investment management industry experience (very advantageous)
Experience as a seasoned Business Analyst working on large transformation programmes
Demonstrated experience as a Business Analyst across technology and business domains (required)
Technology aspectsSystems integration (Administration side - integration with front end portals, external parties, product behaviours & attributes)
Migration experience
Platform experience
Jira Atlassian/ Confluence
Standard MS
Candidate ProfilePragmatic candidates who can take initiative.
Hold their own in certain audiences/ engage with stakeholders
Explaining technical concepts in novice narrative
Will need to be able to pace themselves as it is a fast paced environment and a multiyear programme
Competencies:Detail orientated
Big picture thinking
Client focused
Collaborates
Drive results
Taking ownership
Cultivate innovation
Be resilient
Excellent communication skills (verbal & written)
Ability to work across multiple teams and manage conflicting priorities
Strong facilitation and negotiation skills
Analytical thinking & problem-solving
Information gathering
Excellent documenting and diagramming (BPMN 2.0) skills
Planning, prioritising, and organising
AttributesPositive, enthusiastic ‘can do’ attitude
Teamwork
Ability to work independently / under pressure
Honesty, integrity and respect
Qualifications/ Certification:Relevant formal qualification in Business Analysis. E.g., Certification of Competency in Business Analysis (CCBA) or Advanced Diploma in Business analysis (AdBA) (advantageous)
Bachelor’s degree in information technology / systems or equivalent (advantageous)
Honours degree in information technology / systems or equivalent (advantageous)
Salary: Negotiable
BI Big Data Engineer Specialist Reference No: 1852575411 | Johannesburg, South Africa | Posted on: 20 January 2023
PBT Group has an opportunity for a BI Big Data Engineer Specialist to interpret requirements provided by business and produce effective Big Data solutions. Programming exposure for data transformations and integrating the big data solution with existing systems. Develop information solutions from a variety of sources for both structured and unstructured data. Productionisation of machine learning models. Technical ownership of Big Data solutions for structured and unstructured data.
Duties:Develop and implement big data models and solutions
Research, prototyping and design
Feature set engineering and automation
Design and implement ETL/ELT methodologies and technologies and the integration with big data
Work in an Agile environment and attend to daily standups, retros and sprint planning
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/ELT system
Optimization of the solutions
Implementing machine learning algorithms in production through integration
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
Optimization of machine learning models produced by Data Scientists.
Develop data processing functions (DPF’s) using Java and Python
Experience:SQL (Advanced)
Data Warehouse principles and practices (Advanced)
Docker and container setup (Intermediate)
Linux Shell Scripting (Intermediate)
Python/R/Scala Programming (Intermediate)
Git versioning
Flask/Django framework
CI/CD
Systems Development Life Cycle (SDLC) (Intermediate)
Spark framework Configuration (Intermediate)
Data Security and Protection Policies (Intermediate)
MS Excel (Intermediate)
Kimball Methodology (Intermediate)
ETL development using SSIS, Python & Java (Intermediate)
Java/.net Programming (Advantageous)
Big Data using Hadoop (Advantageous)
Big Data Ingestion using Sqoop/Kafka (Advantageous)
Linux administration (Advantageous)
Distributed programming skills on a cluster environment (Advantageous)
Qualifications/ Certification:Matric (Essential)
National Diploma in IT (BTech) or appropriate certification (Essential)
Bachelor of Science (Information Systems, Computer Science, Mathematics) Advantageous
Salary: Negotiable
Linux Engineer Reference No: 2375951655 | Johannesburg, South Africa | Posted on: 20 January 2023
PBT Group has an opportunity for a Linux Engineer to provide continuous monitoring and support of Linux environments. Design and implement containerized solutions for machine learning models. Technical leadership and ownership of Linux environments.
Duties:Administration & continuous monitoring of Linux environments
Optimize machine learning models & solutions produced by Data Scientists & Actuaries
Participate in the architecture of ML environments and frameworks
Provide ongoing support and enhancement to ML models
Estimate time and resource requirements for business requirement
Container management and automation
Implement Redhat/Linux best practice and standards
Conduct root cause analysis on production issues
Technical leadership of entire information management process of both structured and unstructured data
Implementing machine learning algorithms in production through integration
Configuration of the Big Data infrastructure and environment for optimal performance
Work closely with Data Scientists & Actuaries in productionisation of ML model
Producing relevant technical documentation and specifications
Develop data processing functions (DPF’s) using Java or Python, etc.
Experience:Minimum 3 – 5 years experience
Linux administration (Intermediate)
Linux Shell Scripting (Intermediate)
Distributed programming skills on a cluster environment (Intermediate)
Container setup (e.g. Docker) (Intermediate)
Python/R/Scala Programming (Intermediate)
Git versioning
Spark Configuration (Intermediate)
CI/CD
Systems Development Life Cycle (SDLC) (Intermediate)
Data Security and Protection Policies (Intermediate)
Big Data using Hadoop (Intermediate)
SQL (Basic)
Java/.net Programming (Advantageous)
Big Data Ingestion using Sqoop/Kafka (Advantageous)
MS Excel (Basic)
Qualifications/ Certification:Matric (Essential)
Redhat certification (Advantageous)
National Diploma in IT (BTech) or appropriate certification (Advantageous)
Bachelor of Science (Information Systems, Computer Science, Mathematics) Advantageous
Salary: Negotiable
BI Data Engineer Specialist Reference No: 3223312278 | Johannesburg, South Africa | Posted on: 20 January 2023
PBT Group has an opportunity for a BI Data Engineer Specialist to interpret requirements provided by business and produce effective data engineering solutions. Develop information solutions from a variety of sources for both structured and unstructured data. Productionisation of machine learning models. Provide ongoing support and maintenance of ETL solutions.
Duties:Design and implement ETL/ELT methodologies and technologies
Maintenance and support of ETL and ML environments
Conduct root cause analysis on production issues
Technical leadership of entire information management process of both structured and unstructured data
Optimization of the solutions
Implementing machine learning feature set pipelines in production through integration
Integrate with statistical and actuarial analysts to build models
Producing relevant technical documentation and specifications
Estimate time and resource requirements for business requirement
Optimization of machine learning models produced by Data Scientists.
Experience:ETL development using SSIS (Advanced)
SQL (Advanced)
.net Programming (Intermediate)
Performance & optimization (Intermediate)
Data Warehouse principles and practices (Intermediate)
Kimball Methodology (Intermediate)
Git versioning (Basic)
Python/R Programming (Basic)
Systems Development Life Cycle (SDLC) (Intermediate)
Data Security and Protection Policies (Intermediate)
MS Excel (Basic)
Container setup and understanding - Docker (Advantageous)
Distributed programming skills on a cluster environment (Advantageous)
Qualifications/ Certification:Matric (Essential)
National Diploma in IT (BTech) or appropriate certification (Essential)
Bachelor of Science (Information Systems, Computer Science, Mathematics) Advantageous
Salary: Negotiable
Data Test Analyst Reference No: 3033873794 | Johannesburg, South Africa | Posted on: 17 January 2023
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
Oracle PL/SQL BI Developer Reference No: 3637697328 | Cape Town, South Africa | Posted on: 13 January 2023
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:
- 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
Data Governance Analyst Reference No: 571449150 | Cape Town, South Africa | Posted on: 12 January 2023
PBT Group has an opportunity for an experienced Data Governance Analyst.
The Data Governance Analyst will monitor and enhance enterprise data governance activities including monitoring the quality and managing the protection of sensitive data and information assets.
The position will focus on ensuring adherence to the data policies, standards and processes, by all squads in the bank, to achieve the required level of consistency, quality and protection to meet overall business needs. The Data Governance Analyst will work closely with Business squad leadership to improve the quality and value of core data assets, respond to regulatory protection requirements as well as support the strategic requirements of the squads.
The analyst will also establish and enhance Data Policies, Standards and Processes and assist the Squads in adhering to the established standards and process. These standards will ensure the democratisation of all data assets in the bank and provide a well-documented, discoverable register of all data and related business meaning. This will also enable the meeting of regulatory requirements by ensuring all data in the bank is owned, managed, curated and documented. Driving Data Quality improvements and further ensuring trust is built in all data assets in the bank.
Duties:
Operational DeliveryExecute data governance strategy and overall objectives set by the relevant data governance forums
Align data governance with the business goals and priorities
Provide performance related reports and build consensus for the data governance strategy across the bank
Establish and govern an enterprise data governance implementation roadmap including strategic priorities for development of information-based capabilities in line with the bank’s information management strategy and principles
Roll out an enterprise-wide data governance framework, with a focus on improvement of data quality and the protection of sensitive data through modifications to organization behaviour policies and standards, principles, governance metrics, processes, related tools and data architecture
Eliminates redundancy and streamlines the external data sources.
Identify the new business opportunities with the use of data assets to achieve efficiency and represent the data as the business asset.
Coordinate regarding the implementation of Data Governance Strategy across operational units
Collaborate with leadership across the organisation to identify business needs and implement data governance processes
Responsible for development and maintenance of standard data operating procedures
Ensuring adherence to an enterprise data governance framework for data practices, policies, and standards both at a technical and functional level.
Focus on minimizing the risk of regulatory fines.
Defines the roles and responsibilities related to Data Governance and ensures accountability for the stewardship and master data assets of the enterprise.
Should serve as a liaison between business and its functional as well as technical areas of the technology and protect the sensitive and confidential data.
Eliminates redundancy and streamlines the external data sources.
Identify the new business opportunities with the use of data assets to achieve efficiency and represent the data as the business asset.
Coordinate regarding the implementation of Data Governance Strategy across operational units ComplianceEnsure effective internal controls by monitoring metrics and driving performance through improvement initiatives
Champion enterprise data governance and data initiatives
Ensure appropriate representation and participation in data governance forums across the business
Lead and guide the data governance organisation to achieve desired business results
Deliver on data governance strategy and overall objectives
Ensure data governance initiatives result in enterprise and functional benefits
Serve as a liaison between Business and Functional areas and technology to ensure that data related business requirements for protecting sensitive data are clearly defined, communicated and well understood and considered as part of operational prioritization and planning
Develop & maintain inventory of the enterprise information maps, including authoritative systems, owners
Facilitate the development and implementation of data quality standards, data protection standards and adoption requirements
Define indicators of performance and quality metrics and ensure compliance with data related policies, standards, roles and responsibilities, and adoption requirements
Provide progress reports on data governance issues and oversee periodic updates to Data Governance Roadmap Delivery ManagementEnsures the Data is manageable and provides more support to accelerate data-driven digital transformation.
Assist with the assignments of the roles and responsibilities to the Data Users, Data Owners, and Data Stewards
Assist business with identifying data Quality requirements and implement monitoring and remediation processes
Develop & Maintain inventory of the enterprise data.
Facilitate the development and implementation of Data Protection, Data quality standards across the enterprise.
To assist in resolving end-to-end issues regarding Data Governance that may arise from different departments in the Enterprise. Technical LeadershipProject Management
Risk Management
Data Governance
Business Analysis Techniques
Master Data Management
Experience:A minimum of 4 -6 years of strong data governance industry focussing on:Operationalizing data governance and data Quality
Implementing data management and governance roles, principles, processes and procedures
Implementing enterprise level data quality, master data management and related metrics
Conducting customer interviews and strong consumer interaction skillsBachelor’s Degree in Computer Science or similar fields like Information Systems, Big Data, etc. or a minimum of 4 - 6 years of strategic analysis, or data governance experience
Data Governance certification(s) would be advantageous
Qualifications/ Certification:Bachelor’s Degree in Computer Science or similar fields like Information Systems, Big Data, etc. or a minimum of 4 - 6 years of strategic analysis, or data governance experience
Data Governance certification(s) would be advantageous
Salary: Negotiable
Senior Data Modeller Reference No: 3191611299 | Cape Town, South Africa | Posted on: 12 January 2023
PBT Group has an opportunity for Data Modellers 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.
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
Ensure complete and correct data by identifying definitive or authoritative source of data; analysing source data; and identifying gaps
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.
Skills Required:
Data Management Domain Knowledge:Data Modelling Concepts: Erwin & SAP Sybase Power Designer
Canonical Data Modelling
Entity Relationship Modelling
Physical Database Design
Configuration Management
Data Flow Management
Data warehousing,
Data Integration,
Data Mining
Data Quality
Master Data Management
Metadata
Tools- Technical Skills:IBM Infosphere Information Governance Catalog - Building the Governance Catalog
IBM Information Analyzer Essentials v
IBM InfoSphere DataStage Essentials
IBM InfoSphere Advanced DataStage - Parallel Framework
IBM InfoSphere DataStage v - Advanced Data Processing
IBM InfoSphere QualityStage Essentials v
IBM InfoSphere Advanced QualityStage v
Collibra
Talend
Metadex -(SSIS)
Linux
SQL
Skill package will include knowledge in:APIs, PERL, Python, SQL, XML, Java, C/C++ and others.
Understanding of at least some of the newest trends in the DBMS debate like:NoSQL platforms such as Cassandra, MongoDB, Couchbase, Riak, Redis, FlockDB, Stig
Cloud Knowledge:AWS, Azure, IBM etc.
Experience Required:3-5 years and/or relevant industry experience as well as experience in the Data Modelling discipline
Able to demonstrate practical experience in relational and dimensional modelling techniques, OO modelling also an advantage
Experience using Infosphere Data Architect or any other Data Modelling Tool
Experience with industry models such as IFW BDW and FSDM
Broad understanding of Data Management (DMBOK), systems development lifecycle methodologies and IT Architecture
Relevant regulatory knowledge, and understanding of banking and financial services
Technical Competencies:Data analysis: Applies data analysis, data modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions). Advises database designers and other application development team members on the details of data structures and associated components.
Data Modelling: Specialist knowledge of database concepts, object and data modelling techniques and design principles.
Behavioural Competencies:Exercises substantial personal responsibility and autonomy. Plans own work to meet given objectives and processes in an efficient manner. Plans, schedules and monitors work to meet time and quality targets.
Work includes a broad range of complex technical or professional activities, in a variety of contexts. Investigates, defines and resolves complex issues.
Accomplishing tasks by considering all areas involved, no matter how small; showing concern for all aspects of the job; accurately checking processes and tasks; being watchful over a period of time.
Makes decisions which influence the success of projects and team objectives.
Selects appropriately from applicable standards, methods, tools and applications. Communicates fluently, orally and in writing, and can present complex information to both technical and non-technical audience.
Facilitates collaboration between stakeholders who share common objectives.
Setting high goals for personal and group accomplishment; using measurement methods to monitor progress toward goals; tenaciously working to meet or exceed goals while deriving satisfaction from that achievement and continuous improvement.
Participates in external activities related to data modelling
Takes responsibility for driving own development by actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities. Rapidly absorbs new information and applies it effectively.
Qualifications/ Certification:A degree/diploma in Computer Science / Information Systems / Business Administration / Commerce or equivalent
Preferred Qualifications: TOGAF
Salary: Negotiable
Python Backend Engineer Reference No: 2901097373 | Cape Town, South Africa | Posted on: 12 January 2023
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
Microsoft BI Data Engineer in AWS Environment Reference No: 3941551581 | Cape Town, South Africa | Posted on: 12 January 2023
PBT Group has a requirement for a Microsoft BI Developer with 3+ years experience in SSIS, SSAS, SSRS, T-SQL, AWS, DW, Python, Kimball.
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: SSIS, SSAS, SSRS, T-SQL,
AWS, DW, Python, Kimball
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-endDesign, 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-EndCreate 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
AWS Data Engineer Reference No: 2092892233 | Cape Town, South Africa | Posted on: 12 January 2023
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
BI Business Analyst (BIBA) Reference No: 3923612053 | Cape Town, South Africa | Posted on: 12 January 2023
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 requirements2. 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 detection3. 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 models4. 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 testing6. 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 competenciesBusiness analysis planning and monitoring
Requirement’s elicitation
Requirements management and communication
Business architecture analysis
Requirement’s analysis
Solution assessment and validation2. BA tools and techniquesAcceptance 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 Walkthrough3. 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 platformsGood 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
BI Analyst (BIBA) Reference No: 4284567598 | Johannesburg, South Africa | Posted on: 11 January 2023
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 requirementsData 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 detectionDesign 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 modelsDevelopment 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 testingChange 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 competenciesBusiness analysis planning and monitoring
Requirement’s elicitation
Requirements management and communication
Business architecture analysis
Requirement’s analysis
Solution assessment and validationBA tools and techniquesAcceptance 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 WalkthroughPersonal 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 environmentsStrong SQL skills
Some systems analysis (source-to-target mappings, data profiling)
Deep knowledge of modern data platformsGood 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
Business Intelligence Business Analyst (BIBA) Reference No: 1648825185 | Johannesburg, South Africa | Posted on: 11 January 2023
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 requirementsData 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 detectionDesign 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 modelsDevelopment 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 testingChange 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 competenciesBusiness analysis planning and monitoring
Requirement’s elicitation
Requirements management and communication
Business architecture analysis
Requirement’s analysis
Solution assessment and validationBA tools and techniquesAcceptance 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 WalkthroughPersonal 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 environmentsStrong SQL skills
Some systems analysis (source-to-target mappings, data profiling)
Deep knowledge of modern data platformsGood 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
Business Analyst (Data Analyst) Reference No: 3330273933 | Johannesburg, South Africa | Posted on: 11 January 2023
PBT Group has an opportunity for a Business / Data Analyst with a strong overall and in-depth understanding of credit processes, systems, information requirements, flows and functional system requirements.
Duties:Builds, develops and maintains the business processes for Credit to help identify and understand the workings of the business, and thereby to derive the business requirements and constraints that the resultant systems implementations must address (Including current and to-be business processes). Continuously updates and aligns the to-be business processes as business changes.
Determine the impact of change of proposed projects on the business and on the IT systems supporting the business.
Perform impact assessments on new requirement and their impact on upstream and downstream systems.
During analysis ensure that the full end to end Credit system and their dependencies have been assessed.
Supports the Credit Business Architecture and conforms to the Business Architecture standards.
Analyse the gaps between the current and future state to determine the extent of change required to realise the future state objective. Identifies processes in need for re/design (e.g. due to inefficient operations) and identifies options to improve them gaining stakeholder buy-in.
Document the end-to-end Credit process flows with reference to existing documentation generated to date i.e. capture the activities performed in a business process, inputs, outputs and resources used for those activities, including performance measures.
Supports the efficiency measures and targets of end-to-end Credit processes including touch points in Business Units.
Defining report requirements, functional and process specifications for business and IT changes, as part of the overall definition of solutions to support business needs.
Understanding existing systems and all inter-dependencies (As Is analysis).
Analysing business processes and system requirements, with ability to propose re-engineering or optimization of processes.
Ensure projects within credit business architecture are aligned and delivered to achieve the to-be architecture. Following same definitions, business rules etc.
Understanding functional and technical system specifications in order to be able to identify business solutions, opportunities and system limitations.
Applying and influencing the use of Business Architecture guidelines to ensure consistent and high quality business requirements/functional/process specifications for any solution.
Assisting Technical Designers in translating the business requirements and functional/process specifications into detailed technical requirements.
Overseeing functional, integration and user acceptance testing activities to ensure that the delivered solution meets agreed business requirements and functional / process specifications.
Identifying proactively operational problems and proposing solutions.
Interfacing with other Business Analysts and Project Managers.
Working closely with the technical architects in defining the systems landscape in Credit.
Challenging business demands and identifying duplications or redundant needs across Credit.
Creating, developing and maintaining a Credit business information model and guidelines for data input, processing and output.
Provide expert advice to resources in Credit.
Keeping abreast with changes in the business, in credit management and best practices.
Required Skills & Experience:Strong generic BA skills
2 - 5 years demonstrated practical experience in major projects / areas with relevant exposure to the credit business.
Strong background in implementation of build and buy business solutions.
Experience in the investment banking sector
Ability to have a technical discussion
Project Management experience gained in a complex Financial Service environment.
Strong generic BA skills
Data skills
Good SQL knowledge
Good knowledge on reporting tools and dash boarding
Understanding of AI and analytics
Understanding of warehousing and virtual warehouses
Understudying of data integration
Agile
Qualifications/ Certification:A degree in Computer Science / Information Systems / Business Administration / Commerce or equivalent
Salary: Negotiable
Data Engineer (Senior) Reference No: 3507715398 | Johannesburg, South Africa | Posted on: 11 January 2023
To complement the existing cross-functional team, PBT Group is looking for a Senior Data Engineer who will design and implement scalable and robust processes to support the data engineering capability. This role will be responsible for implementing and supporting large-scale data ecosystems across the Group. This thought leader will use best practices in cloud engineering, data management and data storage to continue our drive to optimize the way that data is stored, consumed and ultimately democratized. The incumbent will also collaborate with stakeholders across the organisation with use of the Data Engineering practices to facilitate the improvement in the way that data is stored and consumed.
Assist in designing and implementing scalable and robust processes for ingesting and transforming complex datasets.
Designs, develops, constructs, maintains and supports data pipelines for ETL from a multitude of sources.
Creates blueprints for data management systems to centralize, protect, and maintain data
Focused on data stewardship and curation, the data engineer enables the data scientist to run their models and analyses to achieve the desired business outcomes
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.
Provide input into the management of demand across the various data streams and use cases.
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.
Provides technical leadership to junior data engineers in the team
ROLE & QUALIFICATIONS REQUIREMENTSMatric, with a degree in Computer Science, Business Informatics, Mathematics, Statistics, Physics or Engineering.
3+ years of data engineering experience
3+ years of experience with any data warehouse technical architectures, ETL/ELT, and reporting/analytics tools including , but not limited to , any of the following combinations: (1) SSIS and SSRS, (2) ETL Frameworks, (3) Data conformance, (4) Caching, (5) Spark (6) AWS data builds
The candidate having DBA ability and knowledge across at least 2 platforms (example: TSQL, SAS, PSQL, IBM VSAM, DynamoDB and DB2) will also be beneficial.
Should be at least at a proficient level in at least one of Python, Java, C/C++ or similar
Should be Proficient in bash/ksh, perl, SQL
Some experience with R, AWS, XML, json, cron will be beneficial
Experience with designing and implementing Cloud (AWS) solutions including use of APIs available.
Some experience with Dev/OPS architecture, implementation and operation would be advantageous.
Knowledge of Engineering and Operational Excellence using standard methodologies. Best practices in software engineering, data management, data storage, data computing and distributed systems to solve business problems with data.
Some experience in applying SAFe/Scrum/Kanban methodologies.
Knowledge and understanding of business process management lifecycle which covers the design, modelling, execution, monitoring, and optimization as well as business process reengineering.
Good problem solving skills: The ability to exercise judgment in solving technical, operational, and organizational challenges, to identify issues proactively, to present solutions and options leading to resolution
Good programming, performance tuning and troubleshooting skills, using the latest popular programming languages such as python, scala, java and suite of Microsoft languages C# and F# preferable.
COMPETENCIES:Collaboration and precise communication
Establishing and maintaining strong working relationships with stakeholders across all levels
Strategic thinking
Leading with Influence
Innovating and being curious about technology
Quality in execution and outcomes
Customer First attitude
Personal Mastery (Learning)
Problem Solving
Data Management
Working with ambiguity
Working independently and within a team
Salary: Negotiable