Equity Bank Senior Data and ETL Engineer Job in Kenya
- Published date: March 11, 2021
- Category: Engineering
-
- Location: Nairobi, Nairobi
- Jop type:
- Salary: Ksh Not mentioned
- Company name: Jobs in Kenya
Job Description
Equity Bank Limited
Senior Data and ETL Engineer
Job Purpose: The Data developers will ensure the enterprises Data is stored and maintained in an efficient manner to ensure that insight can be derived from the Data assets.
Interpret BI business requirements into technical data designs and technical data models, Debugging, monitoring and troubleshooting the warehouse solutions, writing relational and multidimensional database queries and implementing extraction loading and transform tools/scripts.
He will be responsible for aggregating data from multiple sources in an efficient data storage .
Job Responsibilities / Accountabilities:
- 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
Essential Knowledge
- Financial /sector – Banking /Insurance and Telco knowledge is critical for this role
Key Critical Competencies
- Good oral and written communication skills, including ability to communicate complex ideas in a simple way
- Strong analytical skills and problem-solving skills
- Good organization skills
Requirements:
Technical Skills Required:
- 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
How to Apply
CLICK HERE to apply online.
Deadline: March 18, 2021
Related jobs
-
UTaNRMP Civil Engineer Management Trainee in KenyaJobs in Kenya
Ministry of Water, Sanitation and Irrigation Management Trainees / Interns Opportunities at Upper Tana Catchment Natural Resources Management Project (UTaNRMP) A. Background The Upper Tana Catchment Natural Resource...
-
Norwegian Refugee Council Civil Engineer Job in KenyaJobs in Kenya
Norwegian Refugee Council Job Title: WASH Officer – Civil Engineer Location: Turkana County, Kenya Responsibilities: 1) Analyze survey reports, maps, drawings, blueprints, aerial photography, and other topographical or geologic data to p...
-
Safaricom Automation Testing Engineer Jobs KenyaJobs in Kenya
Automation Testing Engineer Job, IT Jobs March, Engineer – Automation Testing – (21000066) We are pleased to announce the following Position in the Digital IT Department within the Technology Divis...