{"id":21138,"date":"2025-10-09T12:02:09","date_gmt":"2025-10-09T12:02:09","guid":{"rendered":"https:\/\/jobs.dataaxisnode.com\/southafrica\/job\/data-engineer-payroll-and-office-administrator-biotechnology-sales-representative\/"},"modified":"2025-11-07T00:24:35","modified_gmt":"2025-11-07T00:24:35","slug":"data-engineer-payroll-and-office-administrator-biotechnology-sales-representative","status":"expired","type":"job_listing","link":"https:\/\/jobs.dataaxisnode.com\/southafrica\/?post_type=job_listing&p=21138","title":{"rendered":"Data Engineer \n\n\n            \n\n            \n            Payroll and Office Administrator \n\n\n            \n\n            \n            Biotechnology Sales Representative"},"content":{"rendered":"<p>Introduction:<\/p>\n<p>\tOur client, a fast-growing data solutions start-up based in Pretoria East, is looking for a motivated and detail-oriented Data Engineer to join their dynamic team.<br \/>\n\tThis is an exciting opportunity for someone passionate about data, technology, and innovation to contribute to building scalable data systems and play a key role in shaping the company\u2019s data engineering capability.<\/p>\n<p>Job Purpose:<\/p>\n<p>\tTo design, develop and maintain robust, scalable and secure data engineering solutions across the full data lifecycle, from data ingestion and transformation to warehousing and integration.<\/p>\n<p>REQUIREMENTS<br \/>\nMinimum education (essential):<\/p>\n<p>\tBSc in Computer Science, Engineering or relevant field\u00a0<\/p>\n<p>Minimum applicable experience (years):<\/p>\n<p>\t2-4 years<\/p>\n<p>Required nature of experience:<\/p>\n<p>\tExperience with SQL Server and Azure Synapse Analytics\/Microsoft Fabric for query writing, indexing, performance tuning and schema design.<br \/>\n\tHands-on experience developing ETL pipelines, including data extraction from REST\/SOAP APIs, databases and flat files.<br \/>\n\tProficiency in data transformation using Python and Azure-native tools.<br \/>\n\tExperience with data warehousing.<br \/>\n\tBackground in data modelling, including dimensional modelling, schema evolution and versioning.<br \/>\n\tPractical knowledge of cloud-based data storage and processing using Azure Blob Storage.<br \/>\n\tFamiliarity with pipeline optimisation, fault tolerance, monitoring and security best practices.<br \/>\n\tExperience developing web applications using C# and the .NET platform.<br \/>\n\tExperience with front-end development using Blazor, React.js, JavaScript\/TypeScript, HTML, CSS\/SCSS.\u00a0<\/p>\n<p>Skills and Knowledge (essential):<\/p>\n<p>\tSQL Server, Azure Synapse Analytics, Azure Blob Storage, Microsoft Fabric<br \/>\n\tPython<br \/>\n\tREST\/SOAP APIs, Data Extraction, Transformation, Loading (ETL)<br \/>\n\tAzure Data Factory, Pipeline Orchestration<br \/>\n\tDimensional Modelling, Schema Evolution, Data Warehousing<br \/>\n\tPower BI<br \/>\n\tPerformance Optimisation, Indexing, Query Tuning<br \/>\n\tCloud Data Processing, Backups<br \/>\n\tC#, .NET, Blazor<br \/>\n\tJavaScript\/TypeScript, HTML, CSS\/SCS<\/p>\n<p>Other:<\/p>\n<p>\tProficient in Afrikaans and English<br \/>\n\tOwn transport and license<\/p>\n<p>KEY PERFORMANCE AREAS AND OBJECTIVES<\/p>\n<p>ETL and Pipeline Development<\/p>\n<p>\tDesign, build, and orchestrate efficient ETL pipelines using Azure Synapse for both batch and near-real-time data ingestion.<br \/>\n\tExtract data from a variety of structured and unstructured sources including REST APIs, SOAP APIs, databases, and flat files.<br \/>\n\tApply robust data transformation logic using Python and native Azure Synapse transformation tools.<br \/>\n\tOptimise data flows for performance, scalability, and cost-effectiveness.<br \/>\n\tImplement retry mechanisms, logging and monitoring within pipelines to ensure data integrity and fault tolerance.<\/p>\n<p>\u00a0Data Architecture and Management<\/p>\n<p>\tDesign and manage scalable and efficient data architectures using Microsoft SQL Server and Azure services, including Synapse Analytics\/Microsoft Fabric and Blob Storage.<br \/>\n\tDevelop robust schema designs, indexes and query strategies to support analytical and operational workloads.<br \/>\n\tSupport schema evolution and version control, ensuring long-term maintainability and consistency across datasets.<br \/>\n\tImplement and maintain metadata repositories and data dictionaries for improved data governance and transparency.<br \/>\n\tDefine and maintain role-based access control to ensure data security and compliance.<\/p>\n<p>Data Warehousing and BI Integration<\/p>\n<p>\tArchitect and manage enterprise data warehouses using Azure Synapse Analytics.<br \/>\n\tApply best practices for data loading, partitioning strategies, and storage optimisation.<br \/>\n\tIntegrate warehousing solutions with Power BI and other analytics platforms for seamless business intelligence consumption.<\/p>\n<p>Data Modelling &amp; Standards<\/p>\n<p>\tDevelop and maintain conceptual, logical and physical data models.<br \/>\n\tImplement dimensional modelling techniques (e.g., star\/snowflake schemas) to support advanced analytics and reporting.<br \/>\n\tApply normalisation standards and relational modelling techniques to support OLTP and OLAP workloads.<br \/>\n\tEnsure consistency of data models across systems and support schema versioning and evolution.<\/p>\n<p>\u00a0Reporting and Communication<\/p>\n<p>\tProvide clear, timely updates on task status and progress to senior developers \/ management.<br \/>\n\tContribute to reports, manuals, and other documentation related to software status, operation, and maintenance.<br \/>\n\tCollaborate effectively with team members and stakeholders using the appropriate communication channels.<br \/>\n\tMaintain system and product change logs and release notes according to company standards.<\/p>\n<p>\u00a0Automation, Monitoring and Optimisation<\/p>\n<p>\tAutomate recurring data engineering tasks and deploy solutions with CI\/CD best practices.<br \/>\n\tImplement monitoring and alerting mechanisms to detect data quality issues and pipeline failures.<br \/>\n\tAnalyse and optimise query performance across platforms (SQL Server, Azure Synapse).<br \/>\n\tSupport scalability planning and cost control by monitoring pipeline execution and resource usage<\/p>\n<p>Security and Best Practices<\/p>\n<p>\tEnforce security best practices for data access, including encryption and secure authentication.<br \/>\n\tEnsure compliance with data governance policies and applicable regulatory standards.<br \/>\n\tDocument processes, architectural decisions and technical implementations in alignment with organisational standards<\/p>\n<p>\u00a0Contribution to The Team<\/p>\n<p>\tCollaborate with developers, data analysts, data scientists and business teams to understand data requirements and deliver scalable solutions.<br \/>\n\tWork with the team to integrate pipelines with source control and deployment workflows<\/p>\n<p>Quality Management and Compliance<\/p>\n<p>\tDocument data processes, transformations and architectural decisions.<br \/>\n\tMaintain high standards of software quality within the team by adhering to good processes, practices and habits.<br \/>\n\tEnsure compliance to the established processes and standards for the development lifecycle, including but not limited to data archival.<br \/>\n\tSafeguard confidential information and data.<\/p>\n<p>Closing:\u00a0 2025-11-06<\/p>\n<p>go to method of application \u00bb<\/p>\n<p>Apply via company website ( N \/ A ) or<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"author":2,"featured_media":0,"template":"","meta":{"_promoted":"","_job_location":"","_application":"","_company_name":"CLS Human Capital Specialists","_company_website":"http:\/\/N%20\/%20A","_company_tagline":"Founded in 1996, we at CLS Human Capital Specialists offer a comprehensive range of solutions integral to Human Resources and Organisational Development. We partner with small and medium businesses, and render specialised services developed to adapt to any company\u2019s unique needs. We offer or... read moreganisational development, HR consultancy services based on our clients unique needs and recruitment and selection services. Let us assist and guide you through the recruitment process, from application to an offer of employment.","_company_twitter":"","_company_video":"","_filled":0,"_featured":0,"_remote_position":0,"_job_salary":"","_job_salary_currency":"","_job_salary_unit":""},"job_listing_region":[11],"job-types":[12],"class_list":["post-21138","job_listing","type-job_listing","status-expired","hentry","job_listing_region-gauteng","job-type-full-time"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job-listings\/21138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job-listings"}],"about":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/types\/job_listing"}],"author":[{"embeddable":true,"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/users\/2"}],"wp:attachment":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/media?parent=21138"}],"wp:term":[{"taxonomy":"job_listing_region","embeddable":true,"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job_listing_region?post=21138"},{"taxonomy":"job_listing_type","embeddable":true,"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job-types?post=21138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}