Senior BI Analyst – Team Lead needed at Moyo Business Advisory

Primary Duties and Responsibilities

• The Senior BI Analyst – Team Lead is responsible for turning data into actionable insights that drive business decisions. This role encompasses the full lifecycle of data analysis, including requirements analysis, design, database development, and reporting. It also involves monitoring performance, quality control, and implementing improvements.
• The ideal candidate is not only technically proficient but also enjoys taking a leadership role within the team—guiding projects, motivating colleagues, and ensuring alignment with client and business expectations. This role’s project involvement begins during the pre-execution phases, providing technical input to lay the foundation for successful project execution.

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.