Business Data Analyst
Business Capital Group Johannesburg
We are looking for a Data Analyst who is passionate about analytics and using data to help drive business
decisions. You enjoy working with structured and/or unstructured data and are motivated to produce highly
Experience working with SQL, Excel, Power BI, or other relevant tools.
Ability to create, update, and share databases.
Strong troubleshooting and report writing abilities.
Attentive and considerate team player
Microsoft Office i.e., Advanced Excel
Collections knowledge
Knowledge of the Cheetah system and data
MS SQL
Advanced Reporting and Analytical skills
Data and integration skills
Project management
Good numerical skills
Attention to detail.
Excellent interpersonal skills
Understanding processes and lifecycles
Commercial awareness
Team working skills.
Good oral and written communication skills
Extracting of data from a SQL server relational database.
Advance SQL querying and reporting.
Manipulation and interpretation data from a SQL server relational database.
Conducting and supporting peer reviews to ensure data is fit for purpose with regards to the development
Interpret data, analyze results using statistical techniques and provide ongoing reports.
Locate and define new data process improvement opportunities.
Ensuring that data flows through the various processes correctly
Recording and reporting on volumes of data flowing through the various data processes
Documenting existing data processes
Support in system integration and data mappings for new client take-on
Act as business analyst for data requirements and management between clients and IT
Provide support on data queries relating to integration.
Work with management to prioritize business and information needs.
Respond to inquiries and requests for information from stakeholders in a timely manner.
Build reporting, data analytics, and other strategies that optimize statistical efficiency and quality to
support the business.
Identify, analyze, and interpret trends or patterns in complex data sets.
Developing and testing data models to capture client’s KPIs and data transformations.
Working closely with IT, internal stakeholders, and SMEs to interpret data requirements, identify
solutions in relation to data management, and recommend technical solutions on data elements to
support business decisions.
Assisting with the establishment and ongoing review and refinement of the data governance policy(s)
and/or management such as data ownership, master data management and metadata management
Generating management information reports as and when required
Interpreting the validity and integrity of reports produced before distribution
Submitting code on a regular basis to produce predefined extracts and reports
Recommending improvements regarding code where possible in order to improve the process
decisions. You enjoy working with structured and/or unstructured data and are motivated to produce highly
actionable results. You are experienced in architecting data ETL workflows and schemas. Critical thinking and
problem-solving skills are essential for this role. You will collaborate closely with cross-functional teams, including IT, BI, Risk and OPS, to ensure the efficient flow and availability of data throughout the organization.
Minimum requirements (Qualifications and Experience)Degree in management information systems, finance, econometrics, statistics, or similar.
Demonstrable experience as a reporting analyst, preferably with client-facing experienceExperience working with SQL, Excel, Power BI, or other relevant tools.
Ability to create, update, and share databases.
Strong troubleshooting and report writing abilities.
Attentive and considerate team player
Cheetah System Knowledge (Advantage)
Required Minimum Work Experience- 5 Years working experience performing daily administrative and business support activities in a back
office/shared services center environment.
Competencies RequiredMicrosoft Office i.e., Advanced Excel
Collections knowledge
Knowledge of the Cheetah system and data
MS SQL
Advanced Reporting and Analytical skills
Data and integration skills
Project management
Good numerical skills
Attention to detail.
Excellent interpersonal skills
Understanding processes and lifecycles
Commercial awareness
Team working skills.
Good oral and written communication skills
Self-motivation
Key Responsibilities
Data Analysis (40%)Extracting of data from a SQL server relational database.
Advance SQL querying and reporting.
Manipulation and interpretation data from a SQL server relational database.
Conducting and supporting peer reviews to ensure data is fit for purpose with regards to the development
of Proof of Concepts, dashboards, and reports.
Acquiring and processing data from multiple sources and systems using SQL and data visualization toolsInterpret data, analyze results using statistical techniques and provide ongoing reports.
Locate and define new data process improvement opportunities.
Filter and “clean” data by reviewing reports, and performance indicators to locate and correct problems.
Administration (10%)Ensuring that data flows through the various processes correctly
Recording and reporting on volumes of data flowing through the various data processes
Documenting existing data processes
Controlling and managing data documentation and reports generated
Client System and Integration Support (10%)Support in system integration and data mappings for new client take-on
Act as business analyst for data requirements and management between clients and IT
Provide support on data queries relating to integration.
Work with management to prioritize business and information needs.
Respond to inquiries and requests for information from stakeholders in a timely manner.
Support interfaces with external clients’ systems such as CAS, Vision, FutureSoft, Tallyman etc.
Reporting (40%)Build reporting, data analytics, and other strategies that optimize statistical efficiency and quality to
support the business.
Identify, analyze, and interpret trends or patterns in complex data sets.
Developing and testing data models to capture client’s KPIs and data transformations.
Working closely with IT, internal stakeholders, and SMEs to interpret data requirements, identify
solutions in relation to data management, and recommend technical solutions on data elements to
support business decisions.
Assisting with the establishment and ongoing review and refinement of the data governance policy(s)
and/or management such as data ownership, master data management and metadata management
Generating management information reports as and when required
Interpreting the validity and integrity of reports produced before distribution
Submitting code on a regular basis to produce predefined extracts and reports
Recommending improvements regarding code where possible in order to improve the process
Prepare and produce ad-hoc reports as and when required
CuriskaJohannesburg
Hiring: Data Analyst in Stellenbosch!
Seeking an experienced Data Analyst with a strong background in the financce indistry. This role involves analyzing financial data, creating reports, and providing insights to drive decision-making.
Key...
Network RecruitmentJohannesburg
completion.
• Develop a deep understanding of the risk landscape, document internal controls, and assess control adequacy and effectiveness.
• Conduct thorough fieldwork, perform data analytics, and identify process and control gaps.
• Provide draft opinions...
Deka Minas Pty LtdJohannesburg
Data Scientist required for a 3 month contract in Sandton. This role will be apart of the Global Markets Data Analytics department and involves collaborating with various departments, including Sales, Trading, and IT, to ensure data integrity...