Data Engineer at Tsebo Solution

About Us    

• Tsebo Solutions Group is looking for a Data Engineer who will be responsible for designing, building, and maintaining scalable data pipelines and systems to ensure reliable data flow for analytics and reporting. This role focuses on integrating, cleaning, and preparing data from various sources, transforming it into structured formats to drive business insights and support decision-making processes. The Data Engineer will ensure that data infrastructure is optimized and meets the needs of analytics and business intelligence initiatives.

Duties & Responsibilities    
Data Engineering & Pipeline Development

• Design and implement data pipelines for ingesting and processing data from multiple sources.
• Optimize Azure Synapse data marts and other data storage systems for efficient data extraction and transformation.
• Ensure data quality and consistency across databases and applications.

Data Integration & Processing

• Extract, transform, and load (ETL) data from varied sources, maintaining data integrity and accuracy.
•  Collaborate with data stakeholders to identify and address data-related issues.
• Develop automated data processing workflows and routines for timely data availability.

Data Management & Governance

• Contribute to master data management efforts, enforcing data standards and governance.
• Document data sources, transformations, and target mappings to align with business requirements.
• Perform data validation checks and manage data version control.

Data Visualization & Reporting

• Develop Power BI dashboards to deliver visual insights and support reporting needs.
• Assist in data presentation, ensuring clarity and accessibility for business users.
• Continuously improve data visualization tools and methods for enhanced usability.

Collaboration & Support

• Work closely with IT, business units, and data scientists to support analytics objectives.
• Provide technical assistance in data integration and troubleshoot data pipeline issues as needed.

Skills and Competencies    

• Data engineering experience with Python, SQL, and SSIS ETL.
• Expertise in data warehousing principles and tools, including dimensional modeling.
• Proficiency in Power BI for data visualization and reporting.
• Familiarity with data governance, master data management, and source-target mapping.
• Knowledge of data integration, cleansing, and validation techniques.
• Business Analysis experience for eliciting requirements from business stakeholders
• Experience building dimensional models, preferably with knowledge of Ralph Kimball methodologies.
• Strong SQL skills for data querying and transformation.
• Python programming skills, especially in data manipulation.
• Experience with SSIS ETL processes and Power BI (DAX) for data presentation.
• Data Bricks experience is advantageous

Qualifications    

• Diploma or equivalent certification in Informatics, Statistics, Data Engineering, or a related field. BSc or BCom degree is advantageous
• 1-2 years working with Azure Synapse Analytics or AWS.

Closing Date    
2024/12/06