Power Bi Specialist

Details of the offer

Job Summary
AECOM is looking for a Power BI Developer who has experience in Business Intelligence and is proficient in Data Modelling and Dimensional Analysis.
Be the liaison between Business Analysts, Developers, Quality Assurance, Systems Support, and Customers/Users with a reputation for timely resolution of issues and a drive for business results.
Minimum Requirements
Power Bi Specialist
**Requirements**:
Proficiency in Data Modelling and Dimensional Analysis.
Effective liaison between Business Analysts, Developers, Quality Assurance, Systems Support and Customers/Users with a reputation for timely resolution of issues and a drive for business results.
Experience performing Data cleanse and Data Quality control activities

Experience in communicating with stakeholders, Subject Matter Experts (SMEs), and end - users to better understand, analyse, communicate, and validate requirements.
Experience working with Query Editor to connect to different data sources and working on Data models.
Experience setting up and manage Power Bi instances and environments within the Power Bi admin centre

Experience creating new Calculated Tables, Calculated Columns and Measures.
Experience in developing custom reports, and different types of Tabular Reports, Matrix Reports, Ad-hoc Reports, Drilldown, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports using SQL Server Reporting Services (SSRS).
Ability to create relationships between different tables from different data sources.
Experience working with Power BI Service for creating Dashboards and sharing them to business users.
Previously worked with DAX formulae for creating variables like Previous Month, Previous Quarter, etc.
and creating interactive visuals using geographic data.
Creating powerful calculations, key metrics, and key performance indicators (KPIs).
Excellent communication, interpersonal, problem solving, and analytical skills.
Ability to work in groups as well as individually with minimum supervision.
Ability to adapt to fast changing skills and work.
Willing to learn new technologies as and when needed.
**Responsibilities**:
Power BI development and administration.
Connecting to data sources, importing data and transforming data for Business Intelligence.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Building Analysis Services reporting models.
DAX queries in Power BI desktop.
Design methodology and project documentation creation

Developing, publishing and scheduling Power BI reports as per the business requirements.
Properly understand business requirements and develop data models accordingly

Creating advanced level calculations to provide prescriptive and predicative analysis

Develop automated operational reports and dashboards using Power BI and other reporting tools (including Power Bi report builder and SQL reporting services)

Good to have

Familiarity with JavaScript, CSS, and other JavaScript libraries.
Excellent in analytical thinking for translating data into informative visuals and reports.
Should have knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, Visual Studio, etc.
Develop custom visuals for Power BI.
Prototyping, designing, and requirement analysis.
Preferred Qualifications
Experience

3+ years of experience in Business Intelligence (Power BI desktop, Power BI desktop Pro, Power BI Service, Power Automate and Power BI report server), and other related IT development technologies like MS BI Stack (MS SQL Server, Dataverse, SSIS, SSAS, SSRS), and MS Excel PowerPivot.
3+ years of experience in SQL/TSQL.
Creating complex Custom Views using SQL, ETL services or Dataverse to create data sets for Power BI dashboards.
You must be able to evidence that you have a number of the skills outlined and a willingness to learn any gaps in the requirements below
What We Offer
We will give you the flexibility you need to do your best work with hybrid work options.
Whether you're working from an AECOM office, remote location or at a client site, you will be working in a dynamic environment where your integrity, entrepreneurial spirit and pioneering mindset are championed.
You will help us foster a culture of equity, diversity and inclusion - a safe and respectful workplace, where we invite everyone to bring their whole selves to work using their unique talents, backgrounds and expertise to create transformational outcomes for our clients.
We will encourage you to grow and develop your career with us through our technical and professional development programs and diverse career opportunities.
We believe in leadership at all levels.
No matter where you sit in the organization you can make a lasting impact on the projects you work on, the teams and committees you join and our business.
We offer competitive pay and benefits, well-being programs to support you and your family, and the development resources you need to advance your career.


Nominal Salary: To be agreed

Source: Whatjobs_Ppc

Requirements

Built at: 2025-02-15T20:08:12.997Z