PBT Group has an opportunity for a Data Engineer to ensure effective movement, collection, integration, storage and provisioning of data to meet business objectives through sound understanding of business unit requirements and frequent collaboration with relevant stakeholders (such as Enterprise Architecture, Database and Solution Architects, Business Intelligence Developers, Data Scientists and Product Owners, etc).
Control expenditure and identify process improvements to contain and reduce costs
Build working relationships across teams and functional lines to enhance work delivery, collaboration and innovation
Conduct research on architectural systems
Contribute to business analysis processes
Manage acquisition, consumption and deployment of data for operational use
Manage data and system integration and testing
Provide required support in designing and developing systems and solutions
Develop, encourage and nurture collaborative relationships across area of specialization
Participate in planned activities that are appropriate for own development
3 to 5 years in Extract, Transform and Load (ETL) of data from source systems or experience in data integration for consumption use cases
Strong experience in Hybrid cloud environments, Strong experience in optimising ETL, Strong analysis and communication skills.
Analysis And Attention to Detail: The ability to be systematic and rule oriented in gathering, reviewing, evaluating and visualising data from a variety of perspectives; includes the ability to work with precision
Problem Solving: Cuts to the core of issues and applies effective analysis, logic and creativity to implement solutions
Influencing And Impact (inc. Negotiation): Creates impact and influences others to support an idea, concept or direction through being credible, trusted and authentic
Presentation And Facilitation: Uses appropriate presentation and facilitation techniques to engage an audience and help them understand, retain and respond appropriately to the message
Process And Technological Competence: Utilises, identifies, engineers and leverages processes and technologies to meet business needs
Research Competence: The capacity to work with research questions, gather and structure relevant data and present results as compelling, defensible arguments. Identifies and leverages multiple platforms and sources to stay abreast of and / or influence current thinking
Building Relationships: In the business of being human, builds sound relationships based on trust and openness.
Drive And Results Orientation: Is a self-starter who produces consistently high-quality outputs within agreed deadlines. Prompt and proactive in driving for results and sets challenging goals for self and others
Data Management: Loading, extraction, staging, transformations and quality assurance of data to support business decisions.
Ability to fully comply with data-content standards - accuracy of data should balance back to source/business. Runs Basic and Exception reports
Ability to manipulate quantitative data into understandable format for the user
Accurately conducts data profiling. Structures profiles in accordance with best practice and in line with business needs. Ability to provide guidance and advice in this regard
Ability to spot errors/discrepancies/anomalies in the data. Initiate steps to improve accuracy and reliability of data
Testing all monthly exception files against source to ensure the rules are correct.
Sending monthly exception reports to users
Proficient in loading, extraction, staging, transformations and quality assurance of data to support business decisions
Ability to clean data and perform fuzzy matches
Data Warehouse development
Understands and can apply knowledge of the skills terminology, concepts and principles.
The focus is on applying and enhancing knowledge/skill.
Can apply the skills independently in most situations
Understands and can discuss the application and implications of changes to policies, processes and procedures in this area.
Design and development methodologies and skills, including coding language skills
Is recognised as a subject matter expert in this knowledge/skill area
Focus is on broader organisational or practice issues. Can provide practical and relevant ideas for improvement in policies/processes or procedures.
Capable of coaching others in the application of this skill, translating complex concepts into easy-to-understand terms.
Can assist in the development of reference and resource materials for this skill/knowledge area.
Understanding of Business Systems Data: Understand the underlying data of the various systems, what each field means and how the systems interact from a data perspective.
Demonstrates comprehensive knowledge of business data, how it is structured, relationships between elements of data and limitations within business systems data
Knowledge of some of the fields/logic used in calculations. Requires some guidance for complex calculations
Ability to identify anomalies in data and diagnose possible reasons at a high level
A degree in Computer Science / Information Systems / Business Administration / Commerce or