About the Role
Consertus is a global capital program management and advisory firm that utilizes human expertise and digital tools to achieve efficient and sustainable outcomes. With a team of over 1,000 professionals worldwide, Consertus supports clients in planning, executing, and optimizing large-scale capital programs across various sectors including aviation, transportation, water, healthcare, energy, and government.
As a Power BI Developer, you will be a key member of a consulting team, contributing to client engagements by delivering data and analytics solutions. This role involves designing, developing, and maintaining business intelligence solutions that convert complex data into actionable insights. You will collaborate with project teams and client stakeholders to gather requirements, develop data models, and deliver dashboards that support broader analytics and digital transformation initiatives. Success in this position requires technical proficiency, attention to detail, and the ability to work effectively in a client-facing environment.
Key Responsibilities
- Design and develop Power BI semantic models, dashboards, and paginated reports aligned with client requirements.
- Build and optimize DAX measures, Power Query (M) transformations, and implement row-level security.
- Engage with stakeholders to gather requirements and translate functional needs into technical specifications and scalable data models.
- Build SSRS reports and contribute to SSAS tabular model development.
- Develop and maintain ETL processes using SSIS, Power Query, Azure Data Factory, or similar tools, including data profiling and validation.
- Develop key performance indicators (KPIs) and performance metrics to support decision-making.
- Conduct testing, validation, performance tuning, and support user acceptance testing (UAT).
- Manage assigned tasks and workstreams across multiple client engagements, communicating progress, risks, and blockers.
- Ensure high quality and timely completion of assigned deliverables.
- Participate in client-facing meetings, demos, and walkthroughs.
- Produce clear documentation, including data dictionaries, technical designs, and user guides.
- Contribute to the development of internal best practices and continuous improvement initiatives.
Qualifications and Requirements
- Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Business, or a related field.
- A minimum of 3 years of experience in developing Power BI dashboards and reports.
- Strong proficiency with DAX, Power Query (M), and semantic data modeling techniques.
- Solid understanding of star schema and tabular modeling principles.
- Hands-on experience with SQL Server Reporting Services (SSRS).
- Experience with ETL tools such as SSIS or equivalent data integration technologies.
- Strong SQL and T-SQL skills, including expertise in joins, aggregations, and performance tuning.
- Proven experience working with large datasets and integrating data from multiple sources.
- Excellent analytical and problem-solving skills.
- Effective written and verbal communication skills.
Technical Skills
- Power BI development, including semantic models, dashboards, and paginated reports.
- Expertise in DAX and Power Query (M) for data transformation and calculation.
- Proficiency in semantic data modeling and tabular modeling principles.
- Experience with row-level security implementation.
- Hands-on experience with SQL Server Reporting Services (SSRS) and SSAS Tabular Models.
- Development and maintenance of ETL processes using SSIS, Power Query, and Azure Data Factory.
- Data profiling and data quality validation techniques.
- KPI development and performance metric definition.
- Performance tuning and optimization of BI solutions.
- User Acceptance Testing (UAT) support.
- Task management and ability to manage multiple workstreams.
- Client-facing communication and presentation skills.
- Strong documentation skills, including technical designs and user guides.
- Knowledge of internal best practices and continuous improvement methodologies.
- Advanced SQL and T-SQL skills.
- Understanding of star schema and dimensional modeling concepts.
- Strong analytical and problem-solving capabilities.
- Excellent written and verbal communication skills.
- Experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake).
- Familiarity with Azure data services, including Azure SQL, Synapse, and Data Lake.
- Experience with Git-based version control and deployment pipelines.
- Exposure to additional BI tools such as Tableau, Qlik, or Oracle BI Publisher.
- Experience with APIs (REST/SOAP) and handling JSON/XML data structures is a plus.
- Exposure to data warehousing concepts, including staging, data marts, and dimensional modeling.
- Understanding of capital project, construction, or asset lifecycle data is beneficial.
Additional Information
This is a full-time position located in Riyadh, Saudi Arabia. The required experience for this role is 2-5 years. Microsoft certifications such as PL-300, or progress toward DP-500 / DP-600, are advantageous. The ability to manage multiple priorities and work effectively within a consulting environment is essential.
Consertus offers comprehensive health coverage, company-paid life and disability insurance, and optional benefits. A 401(k) plan is provided with day-one eligibility and a company match. Generous time off includes 10 paid holidays and Paid Time Off (PTO) starting at 15 days annually. Access to Consertus Academy is available for continuous learning and professional development.
Consertus is an Equal Opportunity Employer committed to diversity and inclusion.
