Senior BI Analyst – Team Lead | Moyo Business Advisory

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.