Job Vacancies at P:Cubed

Job description

Job Purpose

This role will serve as a business intelligence, analytics & reporting specialist, responsible for integrating and analysing data from multiple sources. This role requires one to capture analytical and reporting requirements, perform source data analysis, develop the semantic layer and metadata, and create effective visualisation and data intelligence services - reports, dashboards, and infographics and data models. In addition this role will create and deliver end-user training and will provide support to the organisation and its clients. This role requires the capacity to develop a clear understanding of the business needs and deploy in accordance to best practice BI methodologies.

Key Responsibilities

• Development and Delivery
• Use MS SQL, Tableau and any other identified tool sets to create, support and manage dashboards, reports and BI cubes/data sets for customers and internal business units.
• Responsible for consulting with internal clients on business needs, to understands the business questions that users are trying to get answered and translates them into analytics and reporting requirements.
• Ensure quality checks throughout profiling source system data, identifies data anomalies and proposes data cleansing rules.
• Interfaces with internal clients to ensure successful delivery of client reporting.
• Defines and captures Metadata and rules associated with BI processes.
• Identifies user profiles and designs report delivery environment to meet user’s needs.
• Develops Semantic layer or BI objects for end users.
• Creates reports and report templates, performance dashboards and Adhoc analysis environments.
• Develops BI tool training and documentation.
• Trains users in using the toolset and data. Implements and supports complex BI processes.
• Adapts BI processes to accommodate changes in source systems and new business user requirements.
• Cultivates an ongoing partnership with power users in the business, maintaining knowledge of business operations, strategies, information requirements, and priorities.
• Initiate process changes and enhancements where necessary and see to successful implementation.
• Service Excellence/Customer Service
• Committed to the achievement and maintenance of quality, sets high standards for Self and others
• Provides a prompt, efficient and personalised service to clients, goes out of his/her way to ensure that customer needs are met.
• Resolution of delegated client queries. Where necessary escalates issues appropriately to management and project teams.
• Ensuring client understanding and acceptance of recommended/implemented solution (with advice/assistance from supervisor).
• Collaborating with end users to identify needs and opportunities for improved data management and delivery.
• Proactively identifies opportunities for Information usage.
• Technical
• Demonstrates detailed knowledge and expertise in relation to the job, readily absorbs new technical information and keeps up to date in specialist areas
• Full understanding and sound knowledge of Tableau software solutions, and SQL language to ensure that the technical requirements are in line with best practice
• Mentors and supports colleagues within the organization.
• Stays abreast with industry trends.
• Planning and Organising
• Plans, organises and prioritises work in order to achieve one’s objectives
• Create action plans when required, for problem resolution and solution amendment gaining acceptance from relevant parties and commitment to execute
• Management of own time and tasks to ensure completion of work projects on time.
• Monitoring of own work/tasks completion time.
• Demonstrates a high level of integrity and maturity to work on multiple projects and deliver consistently on time.
• Active participation in large projects.
• Problem Solving
• Breaks problem in to its parts, makes use of logic and draws sound inferences from information available
• Willing to make firm and informed decisions and commit to definite courses of action, on the basis of limited information if necessary
• Communication
• Produces written communications which are clear, fluent, concise and readily understood by intended recipients.
• Communicates in a manner which is clear, fluent, and to the point, and which holds the audience’s attention, both in groups and one-on-one situations.
• Takes a proactive approach to cross-functional communication.

Qualifications/Experience

• Bachelor's degree in Business/IT/Science preferred
• Specific experience using Tableau Server and Desktop v8.0 and above essential.
• Proficient with Microsoft SQL (T-SQL) – at least 3 years’ experience
• 3-5 years’ experience in BI, MIS, data warehousing and reporting
• 3-5 years’ experience in developing data models, frameworks and reports
• Experience in managing large volumes of data from different sources
• Microsoft Office Suite
• Experience in Power BI preferred.
• Experience in Business Analysis and Consulting preferred
• Exposure to financial or credit industry advantageous.
• Experience in Power BI advantageous.
• Behaviours/Skills/Competencies
• Exceptional analytical skills
• Excellent Problem Solving skills
• Customer Focused Approach
• Action oriented
• Good communication skills (verbal and written) and across various levels
• Good planning and organizing skills
• Ability to work independently
• Self-motivated
• Team Player
• Ability to multi task and work under pressure

Job requires after hours work

Please note: If no response is received within 14 days, please regard your application as being unsuccessful.

go to method of application »

Job description

Job Purpose

Provide expertise to acquire, manage, process, load, merge, manipulate, extract and analyze large amounts of data, from various sources. Analysis of bureau & internal data. Monitoring of previous campaigns to refine current processes and further enhance client deliveries. The person will be responsible for interpreting user requirements, developing SQL code, data processing through various software solutions, and ensuring that a consolidated, concise database infrastructure is maintained on a SQL 2008/2014 platform, operating on Microsoft Server 2008, all the while, maintaining the dynamic and evolving process of customer deliveries, support and service.

Key Responsibilities

• To develop, monitor and maintain a suite of databases to enhance and utilize the data more effectively.
• To implement strategic and tactical segmentation of customer bases for marketing and analysis.
• To improve understanding of customer behavior.
• Maintain contacts with external centers of statistical expertise in order to keep in touch with technical developments and to actively promote the application of best practice techniques.
• Understands Credit Bureau Data, geo-demographic, Deeds data, and other spatially-based data.
• Thoroughly prepare data – Retrieving, Combining and Validating Data, from multiple sources. Strong ability to recognize data errors and inconsistencies.
• Application of agreed rules and processes to extract the relevant information for client marketing campaigns / initiatives.
• Maintains multiple databases of campaign history and generic data, and feedback files from clients.
• Create statistical / data analyses reports on an ad hoc basis.
• Validates client data for accuracy and reasonability of data before delivery.
• Present analysis in an understandable concise language.
• Initiate process changes and enhancements where necessary and see to successful implementation.
• Communicate findings and results by means of presentations, and written communication, both internally and externally.
• Ability to identify trends in information, and recommend actions or alternatives to the findings.
• Importing, cleaning, transforming, authenticating or modeling data with the purpose of understanding and making sound deductions from the data for decision making purposes.
• Refining data quality and designing or presenting conclusions gained from analyzing data using statistical tools like Microsoft Excel and others.
• Committed to the achievement and maintenance of quality, sets high standards for Self and others
• Implement and manage a detailed quality assurance process on all work
• Provides a prompt, efficient and personalised service to clients, goes out of his/her way to ensure that customer needs are met.
• Resolution of delegated client queries.
• Ensuring client understanding and acceptance of recommended/implemented solution (with advice/assistance from supervisor).
• Completes system testing and onsite testing with client throughout the development, testing and post implementation process.
• Demonstrates detailed knowledge and expertise in relation to the job, readily absorbs new technical information and keeps up to date in specialist areas.
• Full understanding and sound knowledge of Microsoft SQL server, and T-SQL. To ensure that the technical requirements are in line with standards.
• Plans, organises and prioritises work in order to achieve one’s objectives.
• Create action plans when required, for problem resolution and solution amendment gaining acceptance from relevant parties and commitment to execute.
• Management of own time and tasks to ensure completion of work projects on time.
• Monitoring of own work/tasks completion time.
• Project management of small projects, under supervision.
• Active participation in large projects.
• Breaks problem in to its parts, makes use of logic and draws sound inferences from information available.
• Willing to make firm and speedy decisions and commit to definite courses of action, on the basis of limited information if necessary.
• In cooperation with others, progress and implement systems and other policies that enhance analytical efficiency and data quality.
• Produces written communications which are clear, fluent, concise and readily understood by intended recipients.
• Communicates in a manner which is clear, fluent, and to the point, and which holds the audience’s attention, both in groups and one-on-one situations.
• Good use of grammar, punctuation.
• Ability to get one’s message across.
• Easily understood.

Skills/Qualification/Experience

• Degree/Diploma/Certification in Software Programming or related studies e.g. Computer Science, Systems Engineering or Maths/Stats.
• Analytical and statistical experience.
• Experience in managing large volumes of data from different sources.
• Microsoft SQL Server – in depth knowledge of database configurations, tuning efficiency.
• Minimum 2 years of SQL Programming – Proficient at query development, Stored Procedures, process optimization etc.
• Proficient in Microsoft Windows 8/10 and Windows Server.
• Proficient in Microsoft Office Suite.
• Cognos/Tableau skills advantageous

Please note: If no response is received within 14 days, please regard your application as being unsuccessful.

go to method of application »

Job description

Job Purpose and Responsibilities

We are looking for an industrial psychologist to join our dynamic team and product. This individual must be interested in organisational culture, reward and recognition, motivation, behavioural economics as well as technology.

Our team is dynamic and self-driven and we are looking for someone who is able add value to our product and service offering.

As a Behavioural Consultant you will navigate clients through the process of defining the behaviors which drive their company objectives and culture. The Behavioral Consultant sets-up – and ensures a smooth implementation of the program and provides a key account management function. The position furthermore requires doing research for product development and writing articles and content for our trendy Do Work Happy and Workpoints blog sites on a rotating basis.

As part of a new venture, additional duties may include supporting the business in marketing and sales initiatives.

Preferred Qualifications/Experience

• Registered industrial psychologist with the HPCSA ·
• Interest or expertise in motivation, rewards/loyalty environment ·
• 1-2 years’ work experience (see list below) ·
• Must have a valid driver’s license and own vehicle ·
• Experience within software development industry will be advantageous.

Behaviours /Competencies

• Ability to self-manage and think on your feet; ·
• Emotionally intelligent; ·
• Well presented; ·
• Values high quality of work and timeous execution; ·
• Enjoys research and sales; ·
• Entrepreneurial spirit; ·
• Solution orientated; ·
• Ability and willingness to fulfil roles beyond normal IOP qualification; ·
• Adaptable and flexible; ·
• Professional and accountable ·
• Ability to listen, debate and defend ideas

Skills

• Broad understanding of behavioral psychology and organizational psychology;
• Interest in, and understanding of organizational culture;
• Interest in, and understanding of reward and recognition programmes;
• Deep understanding of business principles;
• Business level communication skills (verbal, written and presentation);
• Project management;
• Data analysis and solution development;
• Key account management;
• Ability to execute;
• General administration.

Please note: If no response is received within 14 days, please regard your application as being unsuccessful.