Job Description

Position: Internal Azure Data Engineer (EBS)
Location: Hybrid - Cape Town
Type: Full-Time
About Us:
We are the tech company with people at heart.
At Advania, we believe in empowering people to create sustainable value through the clever use of technology. As one of Microsoft's leading partners in the UK, specialising in Azure, Security, Dynamics 365, and Microsoft 365, we have a proven track record of success in delivering transformational IT services.
Job Purpose
As the Internal Azure Data Engineer in the Enterprise Business Systems (EBS) department, you will be responsible for designing, implementing, and managing data solutions on the Microsoft Azure and Microsoft 365 cloud platforms. You will create and maintain data pipelines, data storage solutions, data processing, data integration and data classification automation to enable data-driven decision-making within the organisation
You will work alongside the Architect's in EBS and the Data Protection Officer (DPO) to build the data architecture and develop and configure the related tools to ensure the architecture is implemented and aligns with the data governance policies and compliance requirements of the business
You'll be expected to help mentor and train a data analyst in finance to administer and maintain the existing Datawarehouse systems built on Azure principals and tools
Duties and Responsibilities

• Design and manage scalable, high-performance, and cost-effective data storage systems using Azure SQL Database, Azure Data Lake Storage, Azure Cosmos DB, and Azure Blob Storage.

• Develop and implement data integration processes using Azure Data Factory to extract, transform, and load (ETL) data from various sources into data warehouses or data lakes.

• Utilize big data technologies like Azure Databricks and Apache Spark to handle and analyse large volumes of data. Create data processing workflows and pipelines to support data analytics, machine learning, and other data-driven applications.

• Work closely with various departments, including IT, finance, and business teams, to understand data requirements and deliver solutions that meet business needs.

• Maintain detailed documentation of data solutions, including architecture, processes, and maintenance procedures.

• Ensure data solutions comply with security policies and regulations. Implement data governance and protection measures.

• Build and maintain Power BI reports for purposes of business reporting and data validation

Experience and Qualifications

• Proven year's of experience in a similar role, preferably within a large organization or a technology-driven environment.
• Experience managing data projects from inception to completion, ensuring timely delivery and quality outcomes.
• Proficiency in Azure data services (e.g., Azure Data Factory, Azure Synapse, Azure Data Lake Store Gen 2, CosmosDB) and M365 services (e.g., SharePoint, Power Apps, Power Automate).
• Experience with programming languages such as SQL, Python, and R for data manipulation and analysis.
• Strong understanding of data modelling, data warehousing, and data architecture principles.
• Ability to analyze complex data sets and provide actionable insights.
• Excellent communication skills to collaborate with cross-functional teams and present data findings effectively.
• Power BI report development
• Azure Data Engineer Associate (DP-800)
• Fabric Data Engineer Associate (DP-700)

Essential individual attributes:

• Ability to clearly express complex data concepts and findings to both technical and non-technical stakeholders.
• Strong collaboration skills to work effectively with cross-functional teams.
• Flexibility to adapt to changing requirements and environments.
• Strong analytical and critical thinking skills to identify and resolve data-related issues.
• Meticulous attention to detail to ensure data accuracy and integrity.
• Ability to manage multiple tasks and projects efficiently, meeting deadlines and delivering high-quality results.
• Ability to work well within team, supporting and mentoring other team members.
• Contributes towards the team's corpus of knowledge by writing (and keeping current) documentation, procedures and guides for general staff while informing others.
• Continuously maturing your skill set in line with evolving technologies. Undertaking technical training and obtaining associated accreditations
• Shows initiative to innovate and continue improving systems, processes and people.

#LI-Hybrid
Budgeted salary range for this role is ZAR 45,000 - 65,000 and Benefits.
Our Selection Process:
We are committed to ensuring an equitable experience for all candidates, regardless of race, religion or belief, ethnic or national origin, disability, age, citizenship, marital, domestic or civil partnership status, sexual orientation, gender identity, or any other basis as protected by applicable law.
Please do let us know if you'll need any reasonable adjustments as part of the selection process by highlighting these on your application form.
As part of our commitment to our clients we will need to carry out background checks, including a criminal record check, for all offers of employment. If you have any unspent criminal convictions or questions about the screening process, please notify your recruiter once the application has been submitted.
We are the tech company with people at heart.
Tech is created for people. Our services impact every part of life. We are passionate about understanding your issues, your business, your needs. Our business is built around understanding people, and our employees are empowered to act on this understanding every day.