ZIYANDA M.
Mid-Level Data Engineer
Open to offersNew to PlatformAbout
Ziyanda M. is a seasoned Data Engineer with a comprehensive background in data analysis and business intelligence. She boasts substantial experience in the insurance and IT industry, having contributed significantly to companies like TRACKER CONNECT and MIWAY INSURANCE. Ziyanda is adept at managing BI processes using tools like PowerBI, SSMS, and T-SQL. Her role as a Data Engineer involves the development of dashboards, automation of data flow, and modernization of ETL workloads with cloud solutions. She has excelled in applying skills such as SQL and DAX for cloud-based analytics, furthering modern ETL practices. In prior roles as a BI Developer at RCS and EQSTRA Fleet Management, she played a key role in business improvement, data automation, and systems implementation. Additionally, her leadership capabilities were demonstrated during her tenure as Team Lead at Sovereign Foods, where she managed projects and a team of BI developers. Her education from Rhodes University underscores a strong foundation in management and information systems, making her a vital asset in optimizing organizational data strategies.
Experience
Data Engineer
TRACKER CONNECT · 2023 — PresentDeveloped data dashboards and visualizations. Engaged in data analysis, application development, and systems implementation. Automated data flow processes and maintained BI operations. Transitioned MS Fabric and applied SQL and DAX skills in cloud-based analytics. Modernized ETL workloads from SSIS to Fabric Data Pipelines. Contributed to business continuous improvement as a BI Developer. Utilized Excel for Power Query and Pivoting, and interacted with SSMS for reporting and querying. Created data flow diagrams and entity relation diagrams, along with T-SQL for Data Warehousing, Analysis (SSAS), Reporting and Integration Services (SSIS and stored procedures), as well as web reports through SSRS. Managed PowerBI development and debugging tasks, performed data warehousing activities, and engaged in dimensional modeling.BI Developer
MIWAY INSURANCE · 2022 — 2023Focused on the Claims Department, managing legal, assessment, and procurement processes. Handled daily maintenance of BI operations while using Excel for Power Query and Pivoting. Engaged in reporting and querying through SSMS. Developed data flow diagrams and entity relation diagrams. Worked with T-SQL, data warehousing, analysis (SSAS), reporting, and integration services (SSIS and stored procedures) along with web reports through SSRS. Utilized PowerBI in various applications and ensured effective debugging of systems. Automated data flow processes.BI Developer
RCS · 2021 — 2022Automated data flow processes and maintained BI operations on a daily basis. Contributed to ongoing business improvements as a BI Developer. Employed Excel for Power Query and Pivoting, while utilizing SSMS for reporting and querying. Created data flow diagrams and entity relation diagrams, utilizing T-SQL for Data Warehousing, Analysis (SSAS), Reporting and Integration Services (SSIS and stored procedures), and web reports through SSRS. Engaged in PowerBI tasks and performed debugging activities. Managed documentation related to application development and systems implementation within data warehousing and dimensional modeling.Team Lead – BI Commercial
Sovereign Foods · 2020 — 2021Led a team of two BI Developers, an intern, and a software developer. Managed project timelines and activities. Oversaw DBA tasks, including ETL, database, and systems maintenance. Handled budgeting and PO approvals. Presented strategies and project progress to executive management regarding mid to long-term MIS plans.BI Developer
EQSTRA Fleet Management (ENX Corporation) · 2020 — 2021Performed project management utilizing the Agile methodology. Planned, signed-off, and allocated tasks to junior developers. Developed reports and dashboards using PowerBI, importing data from SQL Server DB and Azure SQL DB. Created new stored procedures and optimized existing ones. Explored data across multiple visualizations with PowerBI. Used Excel for Power Query and Pivoting. Provided user training on report generation and querying. Engaged with Azure - DevOps and QlikView for data visualization. Investigated and resolved operational issues while ensuring effective SQL maintenance and quality assurance checks prior to deployment.Junior BI Developer
Sovereign Foods · 2016 — 2019Collaborated with outsourced companies to facilitate system development. Engaged in requirements gathering and identified system gaps. Developed reports utilizing T-SQL, data warehousing, analysis, and various integration services (SSAS, SSIS, and SSRS). Managed documentation for application development and systems implementation. Conducted user training sessions for new systems and supported testing phases. Handled daily operations, investigating and resolving issues with systems. Managed data integration into a consolidated reporting repository, ensuring quality assurance checks before deployment.Provincial Intern
Local Government SETA East London Provincial Office · 2016 — 2016Performed administrative tasks focusing on quality assurance of documentation submitted by training providers and learners engaged in funded programs. Compiled reports on applications from training providers, assessors, and facilitators. Assisted in organizing provincial meetings for Eastern Cape skills facilitators linked to municipalities.
Skills & Expertise
Education
- B. CommerceRhodes University · — — 2015
Interested in this professional?
Sign in as an employer to save this profile or invite ZIYANDA M. to a job.
Sign in as an employer