ETIC, Business Intelligence Engineer- Senior Associate

Line of Service

Advisory

Industry/Sector

Technology

Specialism

Advisory - Other

Management Level

Senior Associate

Job Description & Summary

You’ll be joining our Data engineering, Reporting and Analytics practice, a core part of our Technology, Data & Analytics business unit. We support our clients in delivering a variety of transformation projects across the commercial sector from defining data strategies to helping architect, design and implement modern data and analytics solutions using the latest cloud technologies.

The role will provide you with an opportunity to work across a portfolio of clients, with a focus on large and complex organizations.

You will work in the team that reports to the Data Analytics delivery service leadership team and will be an integral part of the team based in Cairo, as well as those delivering client transformation programmes across the PwC Global Network, including the UK, Germany and Middle East.

We are seeking a highly skilled and experienced BI Engineer to join our team. As a BI Engineer, you will play a critical role in developing and maintaining our business intelligence infrastructure, with a focus on Power BI, data warehousing (DWH), data modeling, SQL, and Python. The ideal candidate should have a minimum of 4 years of relevant experience, along with a strong understanding of cloud technologies.

- Develop, maintain, and enhance our business intelligence infrastructure, including data pipelines, data models, and reporting solutions.

- Design and implement Power BI dashboards and reports that provide actionable insights based on business requirements.

- Collaborate with business stakeholders to gather requirements and translate them into technical solutions.

- Optimize data models and queries to ensure efficient and accurate data retrieval and analysis.

- Perform data profiling, cleansing, and transformation to ensure data quality and integrity.

- Develop and maintain ETL processes to extract data from multiple sources and load it into the data warehouse.

- Collaborate with data engineers and data scientists to ensure seamless integration of data across various systems.

- Provide technical guidance and support to other team members on BI tools, data modeling, SQL, and Python.

- Stay up-to-date with the latest trends and advancements in BI technologies, data modeling techniques, and cloud platforms.

Requirements:

- Bachelor's degree in Computer Science, Information Systems, or a related field.

- Minimum of 4 years of experience in a similar role, with a focus on business intelligence, data warehousing, and data modeling.

- Strong expertise in Power BI, including dashboard and report development.

- Proficiency in SQL for data extraction, manipulation, and analysis.

- Solid understanding of data warehousing concepts, dimensional modeling, and ETL processes.

- Good knowledge of Python for scripting, data manipulation, and automation tasks.

- Familiarity with cloud platforms such as AWS, Azure, or GCP is a plus.

- Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.

- Excellent communication and collaboration skills to work effectively with cross-functional teams.

- Self-motivated and able to work independently, with a strong attention to detail.

Additional skills:

● Performance optimization of PowerBI reports
● Enhancing PowerBI reports with row-level security and configuring this functionality
● Data Analysis Expressions (DAX)
● Creating advanced data processing workflows in Alteryx, with skills in the tool categories not mentioned above (e.g. Predictive, Prescriptive, Spatial, Demographic Analysis)
● Publishing of workflows to Alteryx Server and scheduling workflows
● Creating Alteryx Macros
● Creating SnapLogic pipelines
● Working with DataBricks

Education
● University Degree, in computer science/engineering, business analytics, information systems, statistics, mathematics or other related disciplines preferably
● Microsoft Power BI Certification is needed
● Tableau Certification is a plus
● Celonis certification is a plus
● Alteryx Certification is a plus

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required:

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

0%

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date