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 *****@*****.co.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
GO APPLY NOW
Safe & secure application process
Explore More Opportunities
Get Similar Job Alerts
Job Seeker Tip
Quantify your achievements on your CV using numbers and percentages where possible.
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
Boksburg: Internal Sales Consultant posted by Kenesis
About the Company:We are a dynamic marketing company helping businesses grow online through Google Ads, Facebook Ads, and website design.…
View JobJohannesburg South: Actuarial Analyst posted by Network Finance
Key Responsibilities:Build, nurture, and expand strong, mutually beneficial client partnerships.Develop compelling product positioning strategies and...
View JobJohannesburg North: Actuary Manager posted by Network Finance
Key Responsibilities:- Assist with the development, testing, and validation of market risk models.- Support consulting projects across banking clients...
View JobWestern Cape: Client Relationship Coordinator posted by Manpower Group
Duties & ResponsibilitiesLead Screening & QualificationContact inbound and outbound leads to assess interest and fit.Ask qualifying questions to determine...
View JobGauteng: Sales Representative posted by Phakisa Holdings
Sales RepresentativeType: Temporary Location: JHB - BenoniDuties and Responsibilities:Sell products and services to potential customersBuild relationships...
View JobHotazel: Mine Technical Services Manager posted by Hire Resolve
Description:Hire Resolve's Client is currently looking for an experienced Mine Technical Services Manager to join their mining company based in…
View Job
Browse Employers
Job Alerts