Locations View all
Companies View all
Job Type

Data Warehouse Manager

Please leave your email to access this job on third-party website

Apply now
data warehouse developer
Africa
Waterfall
Agile
ETL
Python
Java
PHP
SQL
Micro Strategy
Pyramid
OBIEE
Microsoft Power BI
Qlikview

Responsibilities

  • Develop and prepare the schedule for a new DW.
  • Prepare plans for all ETL procedures and architectures.
  • Analyze large databases and recommend appropriate optimization.
  • Design data models and define both logical and physical models.
  • Administer all requirements and design various functional specifications for data.
  • Monitor DW work and provide subject matter expertise.
  • Provide training to all employees of the development team.
  • Coordinate with external clients and participate in various technical meetings.
  • Design and implement various unit tests on the system and prepare test data.
  • Map data between source systems, data warehouses, and data marts.
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  • Provide or coordinate troubleshooting support for data warehouses.
  • Conduct best practice assessments on data collection and storage within the company.
  • Define and develop methods, techniques and criteria for data warehousing.
  • Plan, coordinate, design and establish the DW to ensure effective management of data in the company.
  • Maintain the DW in support of business intelligence and analytics for the company.
  • Develop and maintain standards, processes and guidelines for the design of DW elements to ensure a consistent, well-managed and well-integrated secure data warehouse.
  • Think creatively: PEG is a place that is permanently pushing the boundaries within its industry. We are not looking for someone that will just estimate models, write analyses and code. We want someone that will extract insights and provide business recommendations.
  • Generate impact: We want someone obsessed with impact. We don’t want a person who is just interested in finding patterns in the data. We want someone that understands how to turn those discoveries into value for our customers and our internal teams every day.

Requirements

  • You have a bachelor's degree in computer science, management information systems, computer engineering or an equivalent qualification.
  • You have at least 5 years of experience in data warehouse design and development.
  • Proficiency in SQL is essential.
  • Very strong ETL skills are essential.
  • Experience in Cloud Data warehousing required.
  • Experience in implementing real-time developing is desirable.
  • You have a solid background in reporting and data analysis.
  • You have programming experience (Python).
  • Knowledge of Hadoop, Apache Spark is an advantage.
  • You have experience with information technology (IT) enablement strategies and planning knowledge.
  • You have extensive knowledge of business intelligence and analytics software, such as Micro Strategy, Pyramid, OBIEE, Microsoft Power BI and Qlikview.
  • You have extensive knowledge in ETL development and maintenance.
  • You have proven experience developing cubes, multi-dimensional models, tabular, data-marts, data-warehouses, etc.
  • You have experience with business functional areas like data extraction, new variable creation and data.

Nice-to-haves

  • Big picture thinker
  • Strategic thinker
  • Able to provide strategic input and execute/operationalise
  • Demonstrated collaborative skills
  • Demonstrated pragmatism and innovation
  • Avid learner, constantly keeping up-to-date with advances in technology
  • Demonstrated experience in the data domain
  • Project management - Waterfall and Agile

Compensation & Benefits

  • Apply and let's discuss your salary and benefits.
  • Choose to work in Accra, Abidjan, Dakar, Cape Town or New York. We're also offering the possibility to work remotely, with some travel required, for the right candidate.

Job description

Choose to work in Accra, Abidjan, Dakar, Cape Town or New York. We're also offering the possibility to work remotely, with some travel required, for the right candidate.
The role is a project-based 12-month contract with a possibility to extend to full-time.

The company

Life at PEG Africa

Apply now

Data Warehouse Manager