Senior Data and ETL Engineer at Equity Bank Kenya

Description

• Translate business requirements into a star schema data model, develop ETLs, build cubes, and validate results with business representatives
• Support implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
• Design and plan BI solutions
• Write relational and multidimensional database queries
• Configure, deploy and maintain ETL

Qualifications

• Bachelor's degree in Computer Science , Engineering or a related discipline
• 4 - 7 years of experience in a complex data warehouse environment, hands-on Data warehousing project experience and experience in full life cycle Business Intelligence development, implementation, tuning and support
• Hands on experience in relational and multi-dimensional data modeling, including multiple source systems from databases and flat files, and the use of standard data modeling tools, preferably Oracle Data Warehousing
• Hands on Experience with Open source Big data Technology Spark , hadoop ,Kafka ect
• Hands on ETL development experience, preferably using ODI 
• Oracle, MSSQL,  Postgree Database experience required
• Python , SQL , PLSQL , Scala scripting languages experience preferred
• Strong analytical skills to solve and model complex business requirements
• Sound understanding of BI Best Practices/Methodologies, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques
• Ability to collaborate on a team with infrastructure, BI report development and business analyst resources, and clearly communicate solutions to both technical and non-technical team members
• Work closely with BI analysts to deliver effective global BI architecture in a timely manner
• Design, develop and troubleshoot Oracle packages that implement complex ETL processes
• Expertise utilizing ETL/data integration tools (SQL , ODI , ) a must
• Manage Scheuled Jobs data processing for ongoing success —  troubleshoot and rectify any production related issues
• Adherence to all development standards and protocols including the likes of Change Management, Code Review, Documentation and Testing
• Educate and advise internal customers on how to leverage available data for consumption
• Demonstrated SQL skills with extensive experience in developing stored procedures, views, functions, triggers and advanced logical methods.
• Experience with Oracle Data services and Web services a strong plus, data modeling experience a plus

 Deadline: Aug 21, 2023