Risk Advisory | Internal Client Services | Data & Business Analysis - Power BI / SQL BI Developer
When you work for us, you commit to a career at one of the largest and most prestigious professional services firms in the world. Looking for a rewarding career? Take a closer look at Deloitte & Touche ME. It has received numerous awards in the last few years which include Best Employer in the Middle East, best consulting firm, and the Middle East Training & Development Excellence Award by the Institute of Chartered Accountants in England and Wales (ICAEW).
A career in Risk Advisory is all about the challenge of helping our clients manage risk and uncertainty, from the boardroom to the network. The spectrum of risk is broad, and our core competencies encompass control assurance, internal audit, corporate governance consulting, risk management, regulatory consulting, and IT security services. To be a Risk Advisory professional with Deloitte & Touche Middle East means you will gain a wealth of experience across a wide spectrum of industries. Diversity is not just a part of the business landscape in the region but also an integral part of Deloitte & Touche Middle East. Just as we are committed to seeing our clients excel, we are committed to providing you with the right environment to learn and grow and to tailor a career to your needs.
Our Purpose
Deloitte makes an impact that matters. Every day we challenge ourselves to do what matters most—for clients, for our people, and for society. We serve clients distinctively, bringing innovative insights, solving complex challenges and unlocking sustainable growth. We inspire our talented professionals to deliver outstanding value to clients, providing an exceptional career experience and an inclusive and collaborative culture. We contribute to society, building confidence and trust in the markets, upholding the integrity of organizations and supporting our communities.
Our shared values guide the way we behave to make a positive, enduring impact:
- Lead the way
- Serve with integrity
- Take care of each other
- Foster inclusion
- Collaborate for measurable impact
During your tenure as a Data & Business Analysis - Power BI / SQL BI Developer, you will support the Middle East Risk Internal Client Services team in working on Power BI / SQL BI Developer practice, including but not limited to the following:
Power BI
- Design, develop, and implement visually appealing and interactive Power BI reports and dashboards based on business requirements.
- Utilize Power Query, DAX, and other advanced Power BI features to transform and model data from various sources.
- Implement data visualizations, drill-down capabilities, and advanced filtering to facilitate data exploration and analysis & row-level-security (RLS).
- Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
SQL
- Experience in Azure SQL and Azure Data analytic tools.
- Having knowledge in Dimensional Data Modelling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
- Proficient in Creating, configuring workflows designed in MS SQL Server Integration Services (SSIS).
- The Developer is responsible for designing, developing, monitoring, managing, and supporting Deloitte MIS platform.
- Your work will range from developing the MIS DB, reports, dashboards, and handling time-sensitive production issues such as restructuring MIS DB, building data warehouse modeling concept, automation initiatives and major platform changes.
- You'll work closely Finance Analytics team as well as with external counterparties and vendors.
- Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
- Performed data quality analysis using advanced SQL skills. Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
- Experience in writing T-SQL Stored procedures, Triggers, Constraints, and Indexes using various DDL and DML commands.
- Developed T-SQL scripts for performing automation tasks, Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
- Strong knowledge of Data Warehousing methodologies and including star schemas, snowflakes concepts.
- Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources and integrates data based on business logic and to load it in data warehouse.
- Maintaining the Log and Audit information in SQL tables, experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages.
- Data Lake knowledge is a plus.
Leadership Capabilities:
- Acts as a role model, embracing and living our purpose and values, and recognizing others for the impact they make
- Develops high-performing people and teams through challenging and meaningful opportunities
- Delivers exceptional client service; maximizes results and drives high performance from people while fostering collaboration across businesses and borders
- Influences clients, teams, and individuals positively, leading by example and establishing confident relationships with increasingly senior people
- Understands key objectives for clients and Deloitte, aligns people to objectives and sets priorities and direction
Qualifications:
- A bachelor’s degree or Professional qualification in business, economics, finance, accounting, or a related major or equivalent professional experience is required.
- A minimum of 1 to 4 years of practical hands-on experience, ideally in a similar role.
- Fluent in English, knowledge of Arabic is a plus.
- Candidate must have at least 4-year hands-on experience working in service industry developing Power BI dashboards and SQL queries/database.
- Experience in Databases –SQL Server and MYSQL
- Solid experience in developing BI applications utilizing SQL, BI stack, Power BI.
- Experience in Operating Systems – Windows, Linux
- Experience in Tools and Software - SQL Server Integration Services (SSIS), Microsoft SQL Server data tools, SQL server BID Studio, SQLServer Management Studio, Performance Point Server, Power BI
- Experience in PowerApps is a plus.