Senior Data Engineer

Job Title: Senior Data Engineer/Developer

Location: Remote

Industry : IT

Salary: R 780 000 - R1200 000

Hire Resolve’s Client is seeking a talented and experienced Senior Data Engineer/Developer. The successful candidate will build and optimize the Microsoft-based data infrastructure powering real-time financial analytics, fraud detection, and business intelligence systems. You will also design scalable data pipelines using Azure Data Platform, implement cutting-edge solutions with Microsoft Fabric, and ensure data quality and governance across our fintech ecosystem - all with uncompromising security, performance, and reliability.

Responsibilities:

• Maintaining an understanding of the latest SQL features and programming practices through education, study, and participation in conferences, workshops, and groups.
• Back up files from local directories to share and VSTS.
• Identifying problems uncovered by customer feedback and testing and correcting or referring problems to appropriate personnel for correction.
• Evaluating code to ensure it meets industry standards, is valid, is properly structured, and is compatible with various Azure SQL versions.
• Determining user needs by analysing technical requirements.
• Managing data analysis and integration of disparate systems
• Ensuring high quality and optimum performance of code delivered
• Following internal standard guidelines
• Understanding database operations and optimization for Microsoft SQL Server
• Developing reporting systems that provide accessible information for decision-making.
• Test and prove that the software meets major architectural requirements.
• Prove for scalability and performance of a software.
• Ensuring the quality of the system as a whole
• Staying up to date with the latest Microsoft data technologies, Azure services, and data engineering best practices
• Troubleshooting and optimizing Azure data pipelines, SQL Server performance, and resolving data quality issues.
• Continuously improving data infrastructure to reduce latency, increase throughput, and optimize Azure costs using FinOps principles.
• Evaluating and integrating new Microsoft data tools and Azure services to enhance our data platform capabilities.
  
• Mentoring and guiding junior data engineers on the team.
• Participating in architecture reviews and ensuring all data solutions adhere to high-quality standards and best practices.
• Communicating with stakeholders to understand data requirements and provide technical solutions.
• Working independently and delivering high-quality work within tight deadlines

• BSc/BEng in Computer Science, Data Science, or comparable experience.
• 7+ years professional data engineering experience, 3+ years in a senior/lead capacity.
• Data Processing: 7+ years T-SQL/SQL Server expertise, deep Azure Synapse Analytics skills, C#/.NET for data processing applications.
• Microsoft Data Stack: Strong Azure Data Factory, Azure Databricks, SQL Server Integration Services (SSIS), Azure Stream Analytics, Event Hubs.
• Cloud & Infrastructure: Azure Synapse Analytics, Power Designer for data modelling, Azure DevOps for CI/CD.
• Data Modelling: Dimensional modelling with Power Designer, SQL Server Data Tools (SSDT), schema design for OLAP/OLTP, performance optimization.
• Business Intelligence: Power BI integration, SSAS/SSRS experience, DAX/MDX knowledge, semantic layer design.
• DevOps & Orchestration: Azure DevOps pipelines, ARM templates/Bicep, Azure Monitor, Application Insights.
• Testing: Unit testing for T-SQL and data pipelines, data quality frameworks, integration testing with Azure Data Factory.
• Strong in basic DB concepts, joins, aggregate functions and commands (DDL, DML, TCL DCL) and help write and optimize in-application SQL statements.
• Proficiency in advance SQL concepts like CTE, Recursive queries, Pivots, Self joins, Temporary functions, UDF, etc.,
• Deep understanding of relational database concepts with a 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.
• Good communication and leadership skills.

How To Apply :

Contact Hire Resolve today for your next career-changing move

Our client is offering a highly competitive salary for this role based on experience.

Send your CV to: [email protected]  or connect with Sonique Beetge via LinkedIn.

Alternatively, you can also contact me directly at Hire Resolve [email protected]

We will contact you telephonically in 3 days should you be suitable for this vacancy. If you are not suitable, we will put your CV on file and contact you regarding any future vacancies that arise.