Fresh Openings at Moyo Business Advisory

• We are seeking an experienced Senior Data Engineer – Team Lead to join our team and drive innovation through data. This role combines advanced technical expertise in data engineering with leadership skills to guide and mentor a team in delivering impactful data solutions. The ideal candidate has a knack for data analysis, modelling, and transformation, and thrives in translating business needs into actionable technical strategies. As a Team Lead, this role starts with pre-execution phases to provide critical technical input. You will oversee a project team, ensuring successful execution, and deliver technical guidance to meet and exceed client expectations.

Core Data Engineering Responsibilities:

• Identify valuable data sources and automate collection processes.
• Perform pre-processing of structured and unstructured data.
• Analyse large datasets to uncover trends, patterns, and actionable insights.
• Design, build, and develop relational and star-schema data models.
• Architect, develop, and optimize data warehouses and database solutions.
• Implement ETL solutions using tools like SSIS, Azure Data Factory, and SQL Server procedures.
• Develop and maintain real-time analytics and batch processing frameworks.
• Utilize Big Data technologies like Hadoop, Spark, and Kafka for distributed storage and processing.
• Implement cloud-based analytical applications in environments such as AWS and Microsoft Azure.
• Collaborate with engineering and product development teams to deliver data-driven solutions.

Team Leadership and Project Oversight

• Provide technical guidance and day-to-day mentoring to team members.
• Foster effective communication and collaboration to meet team objectives.
• Monitor project execution, ensuring adherence to quality standards and timelines.
• Identify and address technical and project risks proactively.
• Cultivate a culture of accountability, trust, and continuous improvement.
• Manage client expectations through consistent communication and effective issue resolution.

Project Planning and Strategy

• Engage in pre-execution phases of projects, providing valuable technical input and strategic guidance.
• Translate business requirements into technical strategies, ensuring alignment with client goals.
• Propose solutions and strategies to address business challenges using data insights.

Additional Responsibilities

• Perform database performance tuning and optimization.
• Present information through data visualization tools like Tableau or Power BI.
• Update database structures and maintain data quality processes.
• Research and implement emerging data engineering tools and methodologies.

Required Qualifications

• Tertiary degree, diploma, or certificate in a related field (e.g., BSc Computer Science, B.IT, Informatics).
• DP-203: Data Engineering on Microsoft Azure Certification.

Experience and Knowledge

• 5-7 years of experience as a Data Engineer or Database Developer.
• Expertise in data mining, large-scale data modelling, and business requirements analysis.
• Proficiency in designing and implementing data integration and ETL solutions.
• Experience with Dimensional Modelling and/or Data Vault methodologies.
• Working knowledge of data quality processes and master data management.
• Familiarity with Big Data technologies (Hadoop, Spark) and event processing tools (Kafka, Event Hub).
• Proficiency in database languages (T-SQL, ANSI SQL, PL/SQL).
• Experience with cloud-based tools like Azure SQL, Synapse, Data Lake, and Databricks.
• Additional skills in Tableau, Power BI, Python, R, Scala, and advanced mathematics are advantageous.
   

go to method of application »

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.