Job Description
Responsibilities:
- Stay Current with SQL: Continuously learn and apply the latest SQL features and programming practices through education, study, and participation in conferences, workshops, and groups.
- Data Management: Oversee data backups from local directories to shared drives and VSTS.
- Issue Resolution: Identify and resolve problems stemming from customer feedback and testing, correcting them or escalating to appropriate personnel.
- Code Quality Assurance: Evaluate code to ensure it meets industry standards, is valid, properly structured, and compatible with various Azure SQL versions.
- Requirements Analysis: Analyze technical requirements to accurately determine user needs.
- System Integration: Manage data analysis and the integration of disparate systems.
- Performance Optimization: Guarantee high quality and optimal performance of delivered code, adhering to internal guidelines.
- Database Expertise: Apply deep understanding of database operations and optimization for Microsoft SQL Server.
- Reporting Development: Develop effective reporting systems that provide accessible information for decision-making.
- Troubleshooting: Conduct thorough troubleshooting on code, tables, indexes, and SQL Server instances.
- Report Generation: Generate and deliver quality reports to customers, performing comprehensive quality assurance checks.
- Cross-functional Collaboration: Partner with various teams to translate business requirements into scalable data solutions.
- Design Participation: Contribute to design reviews, providing valuable input on requirements, product design, and potential issues.
- Software Validation: Test and validate software against major architectural requirements, with a focus on scalability and performance.
- System Quality: Ensure the overall quality of the entire system.
- Technology Advancement: Stay up-to-date with the latest Microsoft data technologies, Azure services, and data engineering best practices.
- Performance Enhancement: Troubleshoot and optimize Azure data pipelines and SQL Server performance, and resolve data quality issues.
- Cost Optimization: Continuously improve data infrastructure to reduce latency, increase throughput, and optimize Azure costs using FinOps principles.
- Tool Integration: Evaluate and integrate new Microsoft data tools and Azure services to enhance our data platform capabilities.
- Mentorship: Mentor and guide junior data engineers, fostering their growth.
- Architectural Oversight: Participate in architecture reviews, ensuring all data solutions meet high-quality standards and best practices.
- Stakeholder Communication: Communicate effectively with stakeholders to understand data requirements and provide technical solutions.
- Independent Delivery: Work autonomously and deliver high-quality work within tight deadlines.
Minimum Requirements:
- Data Processing: 7+ years of T-SQL/SQL Server expertise, deep Azure Synapse Analytics skills, and C#/.NET for data processing applications.
- Microsoft Data Stack: Strong proficiency in Azure Data Factory, Azure Databricks, SQL Server Integration Services (SSIS), Azure Stream Analytics, and Event Hubs.
- Cloud & Infrastructure: Experience with Azure Synapse Analytics, Power Designer for data modeling, and Azure DevOps for CI/CD.
- Data Modeling: Expertise in dimensional modeling with Power Designer, SQL Server Data Tools (SSDT), schema design for OLAP/OLTP, and performance optimization.
- Business Intelligence: Experience with Power BI integration, SSAS/SSRS, and knowledge of DAX/MDX and semantic layer design.
- DevOps & Orchestration: Proficient with Azure DevOps pipelines, ARM templates/Bicep, Azure Monitor, and Application Insights.
- Testing: Experience with unit testing for T-SQL and data pipelines, data quality frameworks, and integration testing with Azure Data Factory.
- Strong understanding of basic DB concepts, joins, aggregate functions, and commands (DDL, DML, TCL DCL).
- Proficiency in advanced SQL concepts like CTE, Recursive queries, Pivots, Self joins, Temporary functions, UDF, etc.
- Deep understanding of relational database concepts with solid knowledge of MS-SQL.
- Proficiency with version control systems such as Git and Azure Repos.
- Strong problem-solving and troubleshooting skills in Microsoft environments.
- Experience with ETL tools.
- Expertise in SQL Server performance tuning and optimization of large-scale data systems.
Advantageous Skills
- Experience with Azure Machine Learning and Azure Cognitive Services for ML pipelines.
- Experience with Microsoft Fabric and its unified analytics platform.
- Real-time analytics with Azure Stream Analytics and Complex Event Processing.
- Azure Cost Management and FinOps experience optimizing data workloads.
- Power Platform integration (Power Apps, Power Automate) for data workflows.
- Experience with Cosmos DB for multi-model database scenarios.
- Microsoft Certified: Azure Data Engineer Associate or Azure Solutions Architect certification.
Benefits:
- Competitive salary based on experience.
IF you meet the above requirements and want to make a career-changing move, apply today by emailing your CV to .za
You can also connect with Daniel on LinkedIn or contact Hire Resolve
If you meet the above requirements we will contact you within 3 working days
How to Apply
Click the green “Go Apply” button below to apply directly online with the employer.
About Other IT/Computer Jobs in Gauteng
The IT and computer industry is one of the most dynamic and growing sectors in Gauteng, with a thriving job market that offers a wide range of opportunities for career advancement.
In terms of salary ranges, IT professionals in Gauteng can expect to earn anywhere from R800 000 per annum for junior positions to over R2 million for senior executives. The average salary for software engineers is around R1.5 million, while data analysts can earn between R900 000 and R1.2 million. With experience and skills, IT professionals in Gauteng can expect significant salary increases, with some roles offering bonuses and benefits that can increase their overall remuneration.
To succeed in the IT industry in Gauteng, candidates need to possess a range of key skills, including programming languages such as Java, Python, and C++, as well as experience with databases, cloud computing, and cybersecurity. Strong problem-solving skills, attention to detail, and excellent communication skills are also essential for success in this field. Additionally, knowledge of ITIL (Information Technology Infrastructure Library) and Agile methodologies can be highly valued by employers.
Several major companies and industries in Gauteng are currently hiring IT professionals, including technology firms such as Microsoft, IBM, and Oracle, as well as banks and financial institutions like Standard Bank and Nedbank. The finance industry is also a significant employer of IT staff, with roles ranging from software development to data analytics and cybersecurity.
Career growth opportunities are abundant in the IT industry in Gauteng, with many companies investing heavily in employee training and development programs. With experience and skills, IT professionals can move into senior leadership positions or start their own businesses, while also pursuing further education and certifications. The Johannesburg Stock Exchange (JSE) is also a significant employer of IT staff, with roles ranging from software development to data analytics and cybersecurity.
Overall, the IT industry in Gauteng offers a wide range of exciting career opportunities for job seekers with the right skills and experience. With salaries that are competitive with those offered by major companies globally, there has never been a better time to pursue a career in this dynamic and rapidly evolving field.
This information provides general career guidance. Actual salaries and requirements vary by employer.
GO APPLY NOW
Safe & secure application process
Explore More Opportunities
Get Similar Job Alerts
Job Seeker Tip
Follow up your job application with a polite email if you haven't heard back within a week.
How to Apply
Click “GO APPLY NOW” to visit the company’s application page.
Follow their instructions carefully.
JVR Jobs connects you with employers – we don’t process applications directly.
Latest Job Opportunities
Industria: Logistic and Debtor Positions available
Flour Milling company in Industria has positions available in its logistics department and Debtors department Ideal candidates should be willing…
View JobDurbanville: Junior Quantity Surveyor – Built Environment posted by Hire Resolve
Hire Resolve's client is in search of a driven and meticulous Junior Quantity Surveyor to become an integral part of…
View JobJohannesburg: Hydrogeologist – Water and Environmental Consulting Industry posted by Hire Resolve
Job Title: Mid-Level HydrogeologistLocation: Johannesburg, South AfricaJob Summary: Hire Resolve's client, a leading firm in the Water & Environmental...
View JobJohannesburg: Junior Hydrogeologist – Water and Environmental Consulting posted by Hire Resolve
Position: Junior HydrogeologistLocation: Johannesburg, South AfricaJob overview:Hire Resolve's client, a leading Water and Environmental Consulting company,...
View JobDurban: Professional Civil Engineer – Consulting Industry posted by Hire Resolve
Job Title: Professional Civil EngineerLocation: Durban, South AfricaJob Overview:Hire Resolve's client, a leading engineering consulting firm, is seeking a...
View JobRandburg: Professional Quantity Surveyor (Prqs) posted by Hire Resolve
Are you an experienced and dedicated Quantity Surveyor seeking an exciting new opportunity to demonstrate your skills? Our client in…
View Job
Browse Employers
Job Alerts