Job Description

Job Purpose:

• Design, implement, and maintain the reporting database architecture
• Build and optimize ETL pipelines
• Develop and maintain semantic models
• Support business projects through reporting

Qualifications and or Experience:

• Three years of experience in data engineering or related field
• MS SQL and SSMS
• NoSQL
• SSIS and ETL pipeline development
• Diploma / Degree in Information Systems, computer science or related field
• Strong understanding of data modelling and data warehouse design
• Ability to create entity relationship diagrams (ERDs)
• Exposure to cloud platforms is an added advantage
• Microsoft 365 suite

Beneficial

• Python
• R (programming language)
• Power BI

• Microsoft Power Automate
• Microsoft Forms
• Microsoft Dataverse
• Working knowledge of other BI technologies

Skills, Knowledge and Attributes:

• Project management skills
• Good communication skills
• Analytical skills (Information processing)
• Interpersonal skills
• Good understanding of IT Infrastructure
• Good understanding of Microsoft applications and SQL Databases
• Experience with APIs
• Experience with data warehousing and architecture
• Ability to take ownership of a data problem or project from beginning to completion
• Excellent written, communication and presentation skills
• Excellent organizational and follow-up skills
• Competent in problem solving (problem analysis)
• Ability to create, update, and maintain technical documentation with an architectural focus, including ETL processes and entity relationship diagrams (ERDs)
• Pay attention to detail
• Monitoring
• Record keeping and documentation
• Planned change control knowledge
• Ability to work in a team
• Ability to work under pressure
• Deadline orientated
• Apply company ISO policies relating to data
• Self-starter
• Intrinsic motivation
• Ability to work on their own without constant supervision
• Driven

• Teachable
• Open to feedback and to constructive criticism
• Confident in their area of knowledge
• Ability to make decisions
• Adapts well to change