Tommie Hoffman

I am a Business Intelligence professional born in 1995. I have a wife and 2 beautiful children. With over 9 years of experience in the BI sector. My expertise lies in SQL, data warehousing, SSIS, and developing end-to-end data solutions that empower businesses with meaningful insights.

I have a strong track record of designing and implementing robust reporting systems and data pipelines, both on-premises and in the cloud. My experience also includes working with Microsoft Azure tools such as Azure Data Factory and other cloud-based solutions.

Senior Data Engineer - MultiChoice

(2024-01)

Leading and executing data projects using SQL, SSIS, Azure Data Factory, and both on-prem and Azure SQL databases.

• Built an in-house analytics solution for 350+ social media accounts, integrating data from platforms like Facebook, TikTok, and X via APIs, using SSIS, C#, SQL, and JSON into our Data Warehouse.
• Developed Power BI and Report Builder dashboards for business reporting.
• Delivered data ingestion pipelines from diverse sources (Parquet, CSV, MySQL, JSON, etc.) into the data warehouse.
• Mentored junior and intermediate team members and reviewed their work.
• Assisted line manager with project analysis and planning.

BI Consultant and Team Lead - ITBusiness

(2018-01 - 2024-09)

Team Lead - ITBusiness

(2022-10 - 2024-09)

• Led and managed a team of BI Consultants
• Conducted one-on-one sessions, participated in MANCO meetings
• Engaged with clients for project planning and consultant placement

Senior BI Developer - ITBusiness

(2023-06 - 2024-09)

Working with SQL ETL in Trino/Hive

• Developed Power BI reports and documented processes using Confluence

Senior BI Developer - ITBusiness

(2021-03 - 2023-04)

• Built Azure Data Factory pipelines to ingest data from SQL Server, Salesforce, MySQL, JSON, and APIs into Azure SQL and Data Lake
• Created linked services, datasets, and automated workflows
• Developed Power BI dashboards and paginated reports
• Managed tasks via Azure DevOps and performed data analysis

Release Manager - ITBusiness

(2020-06 - 2020-12)

Sanlam – IFRS17 Project

• Oversaw code promotion across environments (Dev to Prod)
• Documented release procedures and provided operational support
• Led data lineage analysis using Informatica Axon
• Designed the incident management section of the support operating model.

BI Developer - Jurni

(2019-08 - 2020-06)

• Designed physical database schema and optimized data structures
• Worked on ETL processes using SQL, T-SQL, SSIS, and Power BI
• Provided Azure assistance and ongoing support during project phase

BI Developer - SBV (Rohr's and Associates)

(2018-10 - 2019-03)

• Developed reports using SSRS, uploaded to Report Server
• Built ETL workflows with SSIS and wrote complex T-SQL queries
• Created documentation and supported visualizations using Tableau and Excel

BI Consultant - GenwareComputer Solutions

(2017-01 - 2018-12)

• Developed and maintained dashboards using Spotfire
• Performed Spotfire installations, upgrades, and server maintenance
• Provided managed services and client support
• Handled SQL development and participated in support calls

BI Consultant - Karabina (Alron)

(2016-01 - 2017-12)

• Worked on a finance-focused BI project with Multichoice
• Built and deployed reports to Report Server, created stored procedures, views, and tables
• Conducted data analysis and produced documentation
• Developed backend and frontend SSRS reports with Lombard Insurance
• Created stored procedures and views for reporting
• Performed data analysis

Internal Support - Karabina

(2017-10 - 2017-11)

• Provided support across SSIS, SSRS, SSAS, TimeXtender, SQL queries
• Conducted data analysis, wrote documentation, and assisted with Excel-based reporting

MCSD Diploma - IT Systems Development - CTU Training Solutions, Potchefstroom (2014-01 - 2015-12)

MCSE Advanced Certificate - IT Database Development - CTU Training Solutions, Potchefstroom

Grade 12 - Hoërskool Schweizer Reneke (2013-01 - 2013-12)