Principal data Engineer

• Sep 2022 - Present

Senior Specialist: Data Engineer

• Jan 2020 - Sep 2022

Implement high quality, scalable and extendable BI solutions leveraging Azure technology including, but not limited, to Synapse, Data Lake, Azure Data Factory and PowerBI.Follow and incorporate DataOps standards and practices.Participate in the development of workflow, coding, testing and deployment solutions.Implement unit testing for all assigned deliverables to ensure deployment success.Support and maintain solutions.Design and develop data models using dimensional modelling and data vault techniques.Work from high level requirements through to detailed specifications, prototypes, software deployment and administration.Deliver incremental business value per sprint.Deliver iteratively throughout the sprint.Conduct peer reviews within and across squads.Profile and analyse data sets.Lead technical delivery within squads and provide oversight of solutions.Challenge and contribute to development of architectural principals and patterns.Ensure solutions adhere to MultiChoice patterns, guidelines and standards.Operate within project environments and participate in continuous improvement efforts.

Senior Specialist: Analytics & Insights

• Jan 2019 - Dec 2019

Create Business Requirements documents for Solutions up to Data Modelling and Data Mapping stages including Presentation Specifications (excluding Technical Specifications).Conducting Data Mining - Create compelling actionable insight that significantly improves knowledge of customer behaviour, and opens new commercially viable opportunities for Churn, Revenue and Margin improvement.Turn data into actionable insights providing a better understanding of the gaps within the business. Manage the post-activity reports and in-depth performance evaluation to determine how existing decisioning rules can be enhanced to drive increased business benefits.Interpret data, analyse results using statistical tools and provide ongoing reports.Develop and implement data collection and data analytics processes.Acquire data from primary or secondary data sources and maintaining databases/data systems.Identify, analyse and interpret trends in complex data sets - Understand analytical information needs: Proactively lead and identify areas of customer behaviour, and commercial base performance (inflow, base, recommitment, outflow) that require understanding.Work closely with project managers to ensure that progress is in line with business units Roadmap, any risks or issues are actioned upon timely, provide subject matter expertise where required.

BI Developer – PDW Technical Team Lead

• Aug 2017 - Dec 2018

Design, create and maintain dimensional models.SSIS 2015: Create, maintain, deploy and schedule SSIS packages to populate tables as well as backup servers.Create the necessary ETL processes required to populate tables.Design, plan and implement a semantic layer (Denormalized tables) using PDW (parallel data warehouse) technology.Support and maintain the SQL server 2016 on development and production ETL environments.Support and maintain the Physical servers that served as the ETL servers for PDW. This included installing updates, managing security and managing disk space.Support and maintain the PDW physical servers for both the Development and production environments. This included maintain all VM’s, looking after space and making sure that the servers are always operational.Advise and support the APL team in various technical areas.Advise and assist business and technical resources with legacy solutions that I have worked on at Multichoice.

Senior Consultant

• Aug 2015 - Jul 2017

Create dimensional models.Create, maintain, deploy and schedule SSIS packages to populate tables - SSIS 2012/2013/2015.Create the ETL processes required to populate the dimensional models.Create tables, indexes, views, stored procedures, functions and schedule jobs - SQL Server 2012/2016.Create SSAS tabular models and MDS models.Design, plan and implement a semantic layer (De normalized tables) using PDW (parallel data warehouse) technology.Lead technical team working on PDW technology.

BI Technical Consultant

• Jul 2013 - Jul 2015

Create dimensional models.Create, maintain, deploy and schedule SSIS packages to populate tables - SSIS 2010.Create the necessary ETL processes required to populate the dimensional models.Create tables, indexes, views, stored procedures, functions and schedule jobs - SQL Server 2008/2012.Create, maintain and deploy timextender solutions.Create SSAS tabular models.

BI Developer - Data Warehouse Developer

• Aug 2012 - Jul 2013

Create dimensional models.Create, maintain, deploy and schedule SSIS packages to populate tables - SSIS 2005/08.Create the necessary ETL processes required to populate the dimensional models.Create tables, indexes, views, stored procedures, functions and schedule jobs - SQL Server 2000/05/08.Exposure to HTML 5 where we built custom reports.Create and maintain Excel reports.

Software Developer

• Mar 2008 - Jul 2012

Delphi software developer, - Create mobile and web applications to support the retail industry.Design and create applications from the ground up. Including visual design of applications. Templates, Logo's and databases.Create and maintain MSSQL databases, SSIS packages and Excel Reports.interact with users to resolve queries.Meet with clients to gather requirements.