Overview
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.
Responsibilities
- 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 Experience
Three years of experience in data engineering or related fieldMS SQL and SSMSNoSQLSSIS and ETL pipeline developmentDiploma / Degree in Information Systems, computer science or related fieldStrong understanding of data modelling and data warehouse designAbility to create entity relationship diagrams (ERDs)Exposure to cloud platforms is an added advantageMicrosoft 365 suiteBeneficial
PythonR (programming language)Power BIMicrosoft Power AutomateMicrosoft FormsMicrosoft DataverseWorking knowledge of other BI technologiesSkills, Knowledge and Attributes
Project management skillsGood communication skillsAnalytical skills (Information processing)Interpersonal skillsGood understanding of IT infrastructureGood understanding of Microsoft applications and SQL DatabasesExperience with APIsExperience with data warehousing and architectureAbility to take ownership of a data problem or project from beginning to completionExcellent written, communication and presentation skillsExcellent organizational and follow-up skillsCompetent in problem solving (problem analysis)Ability to create, update, and maintain technical documentation with an architectural focus, including ETL processes and ERDsPay attention to detailMonitoringRecord keeping and documentationPlanned change control knowledgeAbility to work in a teamAbility to work under pressureDeadline orientatedApply company ISO policies relating to dataSelf-starterIntrinsic motivationAbility to work on their own without constant supervisionDrivenTeachableOpen to feedback and to constructive criticismConfident in their area of knowledgeAbility to make decisionsAdapts well to change#J-18808-Ljbffr