Data Engineer with SQL and Azure
Total Positions: 3
Job Type: Contract
Contract Period: 12 Months
Gender: No Preference
Salary: 350 ZAR - 400 ZAR (Hourly)
Education: Diploma or Bachelor′s degree
Experience: 5-10 Years
Location: Cape Town, South Africa
Candidate should be able to:
Participate in Business Requirements and Functional Requirements meetings, identify gaps in requirements and drive discussion around appropriate solutions.
Manage errors gracefully. Document code and work completed.
Provide support as needed throughout the Test and User Acceptance Testing phases.
Conduct thorough unit testing of code and document the unit test cases.
Conduct appropriate performance testing to ensure all solutions will meet SLAs and performance criteria.
Assist in architectural design reviews and ensure technology stack selection is relevant
Ensure development and testing follow industry standards
Design and code high-quality database solutions within a fast-paced sprint release cycle
Communicate design, requirements, feature set, functionality, usability, and limitations of the subsystem to team and/or development lead or manager.
Design and develop PL / SQL procedures / ETL jobs with optimized processing time.
Create Technical Design Specification documentation that clearly articulates the design and code being implemented.
Provide client communication as appropriate to the project.
translate technical specifications into finished programs and systems and also have a thorough understanding of developing solutions to handle large volume data sets that are typical with BI solutions.
Work on complex BI ecosystems and design / develop solutions based on SQL SSIS, Azure Databricks, SQL SSAS
Candidate should have:
strong experience with Azure Azure Data Lake / Azure Data Factory.
Excellent communication skills and the ability to work under continual deadline constraints are necessary
Ability to communicate with Business and developers accordingly.
work independently to implement a solution with minimal guidance.
Working knowledge on Cosmos / Big Data Platforms (Azure, Databricks) is recommended.
Strong Analytical and troubleshooting skills
Experience with Power BI
Excellent coding and debugging skills.
Strong understanding of BI areas. Ability to work in large, complex development BI projects including the proactive identification of issues and coordination of resolutions.
Expertise in T-SQL, DW Concepts, Tabular Cube.
Strong communication skills in both written and spoken English.
6 + years of development experience.