Bjorn Julius
BI Specialist
Roodepoort
Summary
Results-driven Business Intelligence Specialist and SQL Developer with extensive expertise in Microsoft SQL Server, T-SQL, ETL processes, and comprehensive reporting. Proficient in query development, data cleansing, and transformation, leveraging advanced skills in SSIS, SSRS, SSAS Tabular, and Power BI to deliver actionable insights. Successfully transitioned from operational roles to crafting impactful BI solutions while fostering strong stakeholder engagement. Holds a Bachelor of Business Administration from Stadio, providing a solid foundation in business principles.
Overview
20
20
years of professional experience
Work History
BI Specialist
Liquid Capital (Motus Pty Ltd)
03.2017 - Current
- Develop and support business intelligence and reporting solutions using Microsoft SQL Server and T-SQL.
- Support Power BI reporting and investigate data or reporting issues raised by business users.
- Developed and maintained data-processing logic for cleansing, validation, transformation, and loading activities to ensure data integrity.
- Translate business questions and reporting requirements into SQL queries, data checks and reporting outputs.
- Supported SSRS reporting by managing datasets, parameters, subscriptions, and report-user queries to enhance reporting effectiveness.
- Work with SSIS-based ETL and data-integration processes and associated reporting data structures.
- Support SSRS reporting, including datasets, parameters, subscriptions, tablix-based outputs and report-user queries.
- Investigate reporting discrepancies and data-quality issues across source and reporting environments.
- Engage with stakeholders to clarify requirements, investigate problems and communicate practical solutions.
- Engaged with stakeholders to clarify requirements, investigate problems, and communicate solutions for improved reporting accuracy.
Call Logger
Itec
11.2015 - 02.2017
- Logged and managed CRM service calls, ensuring accurate case information for effective issue resolution.
- Provided second-line support, liaising with clients to efficiently resolve service issues.
- Monitored response times and supported delivery against service-level requirements.
- Executed various operational and administrative tasks to support team efficiency.
Supervisor / Data Administrator
Liquid Capital
11.2010 - 05.2015
- Collected, cleaned, and loaded daily data into C.A.T.I. to ensure data accuracy for analysis.
- Produced daily, weekly and monthly reports.
- Collected, cleaned and loaded daily data into C.A.T.I.
- Produced daily, weekly, and monthly reports to provide insights for decision-making.
- Liaised with dealerships to address queries and logged calls in Automate and Autoline for efficient issue resolution.
Call Centre Agent
Liquid Capital
04.2007 - 11.2010
- Conducted customer-satisfaction and Facilitated calls to assess customer satisfaction.
- Captured and maintained accurate data to support effective decision-making.
- Liaised with clients to resolve queries, ensuring timely and satisfactory resolutions.
Education
BBA - Marketing Management
Stadio
Krugersdorp, South Africa 04.2001 -
Skills
Microsoft SQL Server / T-SQL
SSIS / ETL
ETL and data-loading processes
Data integration
Query optimization
Stored procedure logic
Data quality assurance
Reporting datasets and data investigation
SSRS / Reporting
Report Builder and SSRS reporting
SSAS / Power BI
SSAS concepts
Power BI reporting
Timeline
BI Specialist
Liquid Capital (Motus Pty Ltd)
03.2017 - Current
Call Logger
Itec
11.2015 - 02.2017
Supervisor / Data Administrator
Liquid Capital
11.2010 - 05.2015
Call Centre Agent
Liquid Capital
04.2007 - 11.2010
BBA - Marketing Management
Stadio
04.2001 -