Be an Early Applicant
The Role
Develops data requirements, sources, normalizes, integrates, and analyzes large datasets for business intelligence and GIS reporting. Designs and maintains relational databases, spatial geodatabases, dashboards, statistical and spatial models, and data visualizations using SQL Server, Excel, Tableau, R, and GIS tools. Interprets findings, creates recommendations and presentations, trains employees on visualization practices, and collaborates with IT and GIS teams on database security, backups, and infrastructure.
Summary Generated by Built In
Our client in the Government and Public Sector is looking for a Business Intelligence Analyst/Specialist to join their diverse and performance driven team. If you meet the below requirements, do not hesitate to submit your CV for consideration.
People living with Disabilities are highly encouraged to apply.
Duties:
- Establish the data requirements of internal/external clients through
running consultation for developing data definitions and standards.
- Identify potential data sources through defining the data requirements
and hypotheses, searching the general data environment and establishing
partnerships and/or agreements with data custodians.
- Receive data in line with agreed partnerships, arrangements and/or
agreements with internal/external clients as required.
- Review and normalize each set of data received from different sources
through verifying the reliability, consistency and accuracy of the data in
terms of data infrastructure standards.
- Integrate data from different sources through creating an integrated data
framework, establishing relationships between data and identifying potential
data conflicts or duplication.
- Design, develop and support databases required for BI/GIS reporting.
- Work closely with the IT team to install, configure, maintain and
administer database servers as and when required.
- Work closely with the IT team to ensure that the security and integrity
of the database is maintained at all times.
- Work closely with the IT team to ensure that backups of the database are
done and restored daily.
- Work closely with the GIS team to build spatial geodatabases.
- Analyze and manipulate raw data and create information products that can
be used across various business units of the organization based on clients’
needs.
- Use GIS software to collect, analyze and interpret spatial data.
- Use statistical software packages such as Microsoft Excel or R to
process and summarize large volumes of qualitative and quantitative data.
- Use programming, scripting and/or model builders to develop spatial and
statistical models that could be used to support operational and strategic
decision-making.
- Interpret findings from data analysis and develop conclusions and
recommendations for application by clients.
- Use Business Intelligence tools such as Microsoft Excel PowerPivot or
Tableau to visualize operational and strategic data in the form of interactive
dashboards and infographics.
- Use various GIS tools to visualize spatial data effectively.
- Develop presentations and communicate findings of analyses to various
clients.
- Guide principles for data
visualization and train fellow employees on best practices for data
visualization techniques
Requirements
- At least a degree in Computer Science, Information Systems, Geo-informatics,
Statistics, Engineering or related disciplines.
- Must be literate in Microsoft technologies such as Microsoft SQL Server,
Microsoft Excel Pivot Tables & Power Pivot and Microsoft Access.
- Must have experience in Tableau and/or other BI tools, as well as
integration with statistical packages such as R.
- More than five years of current experience designing, implementing, and
maintaining databases and applications in a relational environment, along with
experience in data visualization, data analysis and working with large
quantities of data.
- More than three years of current experience in GIS and statistical
modelling.
- Experience in assessing client needs and translating them into
information products and services is also required.
- Comprehensive knowledge of Business Intelligence, data management and
data visualization is required.
- Excellent statistical and analytical skills are required.
- Advanced database design and SQL skills are required.
- Programming and scripting is required to develop statistical or spatial
models.
- Good communication and presentation skills.
- Experience in Geographic Information Systems (GIS).
- Must be able to pay attention to detail and work under time constraints
to accomplish project deadlines.
- Keep abreast of new trends and innovations in business
intelligence, database design, spatial and statistical modelling, as well as
related hardware and software.
- A valid driver’s license is required as traveling is required from
time-to-time.
Skills Required
- Degree in Computer Science, Information Systems, Geo-informatics, Statistics, Engineering, or a related discipline
- Literacy in Microsoft SQL Server, Microsoft Excel PivotTables and Power Pivot, and Microsoft Access
- Experience with Tableau or other business intelligence tools and integration with statistical packages such as R
- More than five years of current experience designing, implementing, and maintaining relational databases and applications
- Experience in data visualization, data analysis, and working with large quantities of data
- More than three years of current experience in GIS and statistical modeling
- Experience assessing client needs and translating them into information products and services
- Comprehensive knowledge of business intelligence, data management, and data visualization
- Excellent statistical and analytical skills
- Advanced database design and SQL skills
- Programming and scripting experience for statistical or spatial models
- Good communication and presentation skills
- Experience with Geographic Information Systems
- Ability to pay attention to detail and work under time constraints to meet project deadlines
- Valid driver's license
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Ziyana Group is an Africa-based, black-owned professional services provider delivering people-management, HR, training, and technology solutions across Africa. Its offerings include talent sourcing, payroll and HR management, project and change management, leadership coaching, digital skills and learning, and AI-powered HR technology. The company aligns organizational effectiveness, workforce capability, and business strategy to improve client performance and support sustainable growth.
