Lead BI Consultant

Location: Cairo, Al Qahirah EG

Apply

Requisition Number: 209682

Position Title: Analytics Consulting IV

External Description:

Senior BI Lead

Location: Cairo Egypt

Role: BI Solution Lead /Architect/ Semantic Modeler

Summary

This individual leads the analysis, architecture, design and development of business intelligence solutions. Develops and recommends strategies and specifications for BI solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.  This person shall be thought leader/expert and familiar in the use of project management tools and can effectively estimate projects and monitor their status.

 

Areas of Responsibility

  • Act as an authority on BI strategies and technologies and the appropriate application of these products and serve as an architecture expert to the organization
  • Cover all aspects of the development lifecycle required to successfully deploy the BI solution including the following: semantic layer design, BI technical architecture, performance tuning BI applications, and logical and physical data model design and implementation.
  • Analyze business requirements to determine the data elements needed in the Semantic Layer data models to support the BI solution
  • Understand the long-term business objectives and suggest technical strategies to meet those objectives by introducing innovation through technology, right selection of tools from BI tool suite
  • Design end-to-end solutions (ETL, Warehouse, Reporting) to meet specific client requirements using a variety of technologies.
  • Effectively analyze, resolve and document business problems with minimal oversight from senior management (i.e. accountable for owning and resolving issues)
  • Effectively multi-task between initiatives and consistently produce quality deliverables requiring minimal QA from peers/supervisors.
  • Demonstrate ability to effectively coach and mentor; regarded and sought by more junior staff as a coach and mentor
  • Keep current on new/relevant technologies.

 

 

Education

  • Bachelor’s Degree from a reputed Educational Firm.
  • Degree in Computer Science, Mathematics/Statistics, Computer Engineering or related fields is preferred
  • Post-Graduate degree is a plus

 

 

General Skills

Required:

  • Excellent Consulting, Oral and Written communication, and Presentation skills
  • Strong SQL and Database experience with a major RDBMS (for example Teradata, SQL Server, DB/2, Oracle)
  • Excellent Troubleshooting skills
  • Strong background in IT
  • Experience with Logical and Physical Data Modelling, Database Architecture
  • Experience with Data Warehousing and ETL Methodologies
  • Familiarity with Erwin, Power designer or similar modelling tool.

 

Preferred:

  • Any background/experience with Graphic Design

 

Technical Experience

Required:

  • 10+ years of Data Warehousing Experience
  • Experience with Design of end-to-end BI solutions and managing complex integration projects.
  • Leadership experience (Technical Lead)
  • 3+ Years of experience with Microsoft PowerBI/MicroStrategy. This includes knowledge of Architecture, Installation, Configuration and Development tools.
  • Experience with at least 1 front end BI tool (Either Tableau, Cognos, OBIEE, or Business Objects). This includes knowledge of Architecture, Installation, Configuration and Development tools.
  • Extensive knowledge with design and development experience on scripting languages like Shell/Perl.

Dimensional Modeling:

  • Comprehensive Knowledge of Ralph Kimball's Data Modeling Concepts including Transaction dimensions, conformed dimensions, and facts, slowly changing dimensions, multi-Star/ Snowflake Schema Modeling, different types of Fact tables
  • Prior experience implementing DW presentation layer - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules
  • Comprehensive Knowledge of Bill Inmon's Data Modeling Concepts (Logical and Physical) including 3NF, Supertypes, Subtypes, Abstraction, Associative entities / tables
  • Experience in designing enterprise wide solutions and its expansion
  • Experience with Solution Development Life Cycle, including requirements gathering, documentation testing and knowledge transfer is required.
  • Experience of successful project delivery following Agile methodology.

CountryEEOText_Description:

City: Cairo

State: Al Qahirah

Community / Marketing Title: Lead BI Consultant

Job Category: Consulting

Company Profile:

We’re conducting virtual interviews to keep our candidates and employees safe. Many roles will be temporarily remote or work from home, while others will remain remote. Read more on our response here: Teradata Response to COVID-19.

Teradata helps businesses unlock value by turning data into their greatest asset.  We’re the cloud data analytics platform company, built for a hybrid multi-cloud reality, solving the world's most complex data challenges at scale. Collectively, we endeavor to serve equal parts innovator and contributor. Because our mission isn’t just about the collection of data – it’s about revolutionizing the future of transportation to save lives, optimizing energy costs to make the planet a cleaner place, and using data to predict and identify cancer risks.

Location_formattedLocationLong: Cairo, Al Qahirah EG

.

© 2020, Teradata. All rights reserved. | Privacy | Terms of Use | Fraud Alert | Tracking Consent | Teradata is an Equal Opportunity Employer | www.teradata.com