Are you a visionary team player with a passion to design, develop, and maintain robust ETL processes? We're looking for an
ETL Developer
to join our dynamic Team at KFC Rohloff Group. This role requires advanced proficiency in Microsoft SQL Server Integration Services (
SSIS
) and SQL Server Analysis Services (
SSAS
), ensuring efficient data movement, transformation, and multidimensional modelling for BI solutions.
What You'll Be Cooking Up:
------------------------------
Design, develop, and optimize
ETL
workflows using
SSIS
for data extraction, transformation, and loading.
Build and maintain
SSAS
cubes for analytical reporting and OLAP solutions.
Collaborate with teams to
integrate
data from multiple sources into the data warehouse.
Perform
performance tuning
and troubleshooting of ETL processes and SSAS cubes.
Ensure data quality, integrity, and compliance with governance standards.
Document ETL processes and maintain version control for all packages.
Support production deployments and resolve ETL-related incidents promptly.
What You Bring to the Table:
--------------------------------
Microsoft
SSIS
: Advanced experience in creating, scheduling, and monitoring ETL packages.
Microsoft
SSAS
: Competent in cube design, partitioning, and processing.
Strong
T-SQL
skills for stored procedures, views, and query optimization.
Understanding of data warehousing concepts (star schema, snowflake schema).
Experience with SQL Server
administration
and
performance tuning
.
Familiarity with
Power BI
integration for
semantic layer
and reporting.
Exposure to REST API, OData, JSON, XML for data integration.
Certification in Database Administration or equivalent.
3+ years' experience in a similar role.
Knowledge of
SSRS
for reporting is a plus.
Knowledge of FMCG or retail industries is a plus.
Strong problem-solving and troubleshooting skills.
Analytical and detail oriented.
Proactive with a problem-solving attitude.
Business acumen and sense of urgency.
Self-managed and able to function independently.
Committed to continuous learning and skill improvement.
Why You'll Love It Here:
----------------------------
Competitive salary and bonuses.
Comprehensive benefits.
Collaborative, inclusive, and flexible work environment.
Ready to make an impact? Apply now and join us on this exciting journey!
Beware of fraud agents! do not pay money to get a job
MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.