Job Description
- The purpose of this role is to construct data acquisition, warehousing and reporting solutions.
- The role is expected to provide technical solutions in response to the needs of stakeholders by interpreting business requirements; defining solution; defining build and test tasks; constructing solutions; performing testing; participating in the deployment of solutions and ensure the systems meet immediate business requirements by providing third tier support and constructing enhancements to systems in Production.
- Define a task sequence that delivers value to business promptly by applying lean management, Minimum Viable Product MVP and iterative delivery concepts.
- Ensure tasks are clearly scoped, with defined acceptance criteria, to ensure clarity of what is required to complete work.
- Construct mechanisms to acquire data from a range of sources with controls that deliver to required data quality standards.
- Apply appropriate continuous integration practices to prevent defects.
- Build solutions that are aligned with the technology strategy and future proofed through appropriate coding practices.
- Ensure applicable standards are addressed in the solution design.
- Apply best data integration, warehousing and reporting practices while utilising MS SQL 2019 technology.
Qualifications
- BSc in IT, Computer Sciences or related field.
- Professional certification such as Azure Data Fundamentals can be an added advantage.
Experience :
- Building databases, warehouses and reporting solutions, Building data integration solutions
- Experience operating within an agile team
- Knowledge of Data Management, Data Warehousing concepts & methodologies familiarity with at least one of the following databases & design principles: DWH, DataLake, Lakehouse, Delta etc. will be considered an asset. Basic knowledge of web development technologies HTML, CSS, JavaScript and their integration with databases. ETL environment and understanding of ETL processes.
Additional Information:
Behavioural Competencies:
- Adopting Practical Approaches
- Articulating Information
- Challenging Ideas
- Developing Expertise
- Documenting Facts.
Technical Competencies:
- Big Data Frameworks and Tools
- Data Engineering
- Data Integrity
- IT Knowledge
- Stakeholder Management IT.