Key Responsibilities
Data Analysis and Reporting
Conduct data analysis, design, and reporting to address business needs.
Design and develop databases for data storage and reporting.
Create and update database structures, ensuring data accuracy and integrity.
Prepare analytical reports and information communication procedures.
Perform data mapping and transformation to meet project requirements.
Project Leadership and Oversight
Provide day-to-day guidance and mentoring to project team members.
Oversee project execution, ensuring alignment with quality standards and deadlines.
Identify technical and project risks and implement proactive measures.
Manage client expectations through clear communication and timely resolution of issues.
Foster a culture of accountability, trust, and continuous improvement within the team.
Technical Contribution and Innovation
Update knowledge about emerging technologies and industry trends.
Research available technologies and recommend innovative solutions.
Migrate existing client deliveries to new business intelligence platforms.
Document operational procedures and technical specifications.
Cultivate partnerships with business power users to align on strategies and information needs.
Team Leadership and Collaboration
Facilitate effective team communication and collaboration to achieve project goals.
Oversee and direct development teams throughout the project lifecycle.
Mentor junior consultants and support their learning curve.
Translate strategy and objectives into measurable, executable projects.
Required Qualifications
Education
Tertiary degree, diploma, or certificate in a related field (e.g., BSc in Computer Science, BIT, Informatics).
Experience and Knowledge
7+ years of experience as a BI Reporting Analyst, Database Developer, or Software Consultant.
Extensive knowledge of database design and data analytics (especially Power BI).
5+ years of experience with the following technologies/tools:
Visualization and Reporting: Tableau, Power BI.
Database Development: MS SQL, SSRS, SSIS, SSAS.
Big Data: Hive, Pig, Flume, Sqoop, Uzi, Spark.
Predictive Analytics: Alteryx, Python, R.
Database Warehousing: Data consolidation and reporting.
Competencies
Critical Thinking: Use logic to identify strengths and weaknesses of solutions or approaches.
Active Learning: Apply new information to improve decision-making and problem-solving.
Systems Analysis: Assess how changes in operations or conditions affect systems.
Complex Problem Solving: Review information to develop and evaluate options and implement solutions.
Deductive and Inductive Reasoning: Apply general rules and combine information to reach logical conclusions.
Communication Skills: Engage with C-level stakeholders and communicate business and technical concepts effectively.
Technical Literacy: Evaluate how software solutions fit into an organization's structure.
Analytical Assessment: Examine systems to determine project needs and scope.
Schedule Management: Ensure development schedules and milestones are met for both self and team.
Team Leadership: Guide teams throughout the development lifecycle, ensuring alignment and motivation.
Technical Expertise
Business Intelligence and Analytics: Tableau, Power BI, SSRS, SSAS, SSIS.
Database Technologies: MS SQL, data warehousing, database consolidation.
Big Data Tools: Hive, Pig, Spark, Sqoop, Flume.
Programming Languages: Python, R.
Predictive Analytics: Alteryx.
Development and Reporting Frameworks: Familiarity with Agile methodologies, design patterns, and transformation tools.
Additional Requirements
Ability to work under pressure and manage complex tasks independently.
Valid driver's license and own transport.
Flexible and adaptable to dynamic environments.
Demonstrated ability to initiate process changes and enhancements for successful implementation.