Twiga Foods is a social
impact enterprise that connects rural farmers to urban retailers in informal
markets. Twiga is built around a simple notion, if you have efficient
logistics, you can build a marketplace that pays farmers more and delivers to
vendors quality produce at a lower price.
The business intelligence
analyst shall oversee development, deployment, and maintenance of Business
Intelligence (BI) reporting interfaces. This include query tools, data
visualization and interactive dashboards, ad hoc reporting, and data modelling
tools This role shall therefore be three layered as shown below:
At the data
source layer, he/she shall be required to guide the data engineers on
the schema in which he needs 3rd party data sources to be stored given that
most data are already archived in a data warehouse.
At the warehouse
layer he/she shall be required to have working knowledge of technologies
that facilitate both warehousing and tools for performing Extraction,
Transformation, and Loading (ETL) with the aim of creating single version
of truth, accessing business data from one place and standardizing data in a
coherent format.
At the reporting
layer which is the actual BI interface that allows users to access
data, the BI Developer and Analyst shall be required to have strong analytical
capabilities in Data Studio, Power BI and Excel to fulfil business reporting
requirements
Responsibilities
- Perform complex quantitative analyses
and translate results into meaningful business insights.
- Design, develop and maintain scalable
interactive management reports and dashboards for various departments to
visualize and measure Key Performance Indicators.
- Work with data engineers to integrate
new datasets that can be leveraged through the business operations.
- Undertake ad-hoc data requests to meet
changing business needs.
- Develop reporting systems that provide
accessible information for decision making.
- Use warehouse data to generate reports
to support business decision making and business performance monitoring.
- Evaluate and improving existing BI
dashboards.
- Work with BI Technical Lead in creating
technical documentation for all BI Dashboards and reports.
Requirements
- A Bachelors degree in Statistics,
Mathematics, Computer Science, Engineering, or related field.
- Background in data warehouse design
(e.g. dimensional modelling) and data mining, i.e. Big Query
- In-depth understanding of database
management systems, online analytical processing (OLAP) and ETL (Extract,
transform, load) framework
- Advanced proficiency with BI
technologies i.e. Data Studio, Microsoft Power BI
- Advanced proficiency with SQL queries,
SQL Server Reporting Services (SSRS) and SQL Server Integration Services
(SSIS)
- Business analysis skills to help set
precise requirements for future analytics framework and make the right
strategic decisions.
- Debugging/troubleshooting skills given
that each stage of designing, developing, and maintaining BI dashboards
requires strong troubleshooting skills around security issues, data
access, permissions, updates, and maintenance of the whole BI platform.
- Experience with BI tools by either
developing or configuring existing ones. Solid understanding of all the
underlying infrastructure required for data integration tools, ETL/ELT
processes, data formatting, and warehouse architecture.
- Industry experience as a BI Developer or
Analyst.
- Strong attention to detail.
- Ability to work in a team.
- Good communication skills.
- Proven abilities to take initiative and
be innovative
- Analytical mind with a problem-solving
aptitude
Performance Indicators
- Data Studio and Power BI
reports/dashboards designed and developed for departments to visualize and
measure their respective Key Performance Indicators
- Quantitative analyses performed to meet
changing business needs
- Warehouse data and new datasets
leveraged to meet the business reporting and analysis requirements
Required competencies
- Customer Focused: Ensuring that
the customer perspective is a driving force behind business decisions and
activities; crafting and implementing service practices that meet
customers and own organizations needs. Level 3
- Negotiation and Influencing
Others: Effectively exploring alternatives and positions to reach
outcomes that gain the support and acceptance of all parties. Using
interpersonal styles and methods to inspire and guide individuals toward
higher levels of performance. Level 3
- Business Acumen: Planning and
supporting the development of individuals skills and abilities so that
they can meet current and future business needs. Providing feedback,
instruction, and development guidance to help others excel in their
current or future job responsibilities. Level 2
- Building ad Growing Relationships:
Builds collaborative alliances and strategic relationships to achieve
common goals. Working effectively and cooperatively with others;
establishing and maintaining good working relationships. Level 2
- Planning and Organizing:
Establishing courses of action for self and others to ensure that work is
completed efficiently. Level 2
- Passion for Results: Driving high
standards for individual, team, and organizational
accomplishment; tenaciously working to meet or exceed challenging
goals; deriving satisfaction from goal achievement and continuous
improvement. Level 3
- Decision Making: Obtaining and
comparing information from multiple sources to identify alternative
solutions; committing to an action after analyzing potential solutions
against decision criteria; considers the wider business impact of the
decisions. Level 3
- Coaching and Developing Others:
Planning and supporting the development of individuals skills and
abilities so that they can meet current and future business needs.
Providing feedback, instruction, and development guidance to help others
excel in their current or future job responsibilities. Level 3
- Facilitating Change: Identifying
and driving organizational and cultural changes needed to adapt
strategically to changing market demands, technology, and internal
initiatives; catalyzing new approaches to improve results by transforming
organizational culture, systems, or products/services. Encouraging others
to seek opportunities for different and innovative approaches to
addressing problems and opportunities. Level 2
- Strategic Thinking: Establishing and committing to a long-term business direction based on an analysis of systemic information and consideration of resources, market drivers, and organizational values. Level 2
To apply, visit: https://bit.ly/3k3H5T0