Job Description

Company Description

At AECOM, we\'re delivering a better world.

We believe infrastructure creates opportunity for everyone. Whether it\'s improving your commute, keeping the lights on, providing access to clean water or transforming skylines, our work helps people and communities thrive.

Our clients trust us to bring together the best people, ideas, technical expertise and digital solutions to our work in transportation, buildings, water, the environment and new energy. We\'re one global team - 47,000 strong - driven by a common purpose to deliver a better world.

Here, you will have freedom to grow in a world of opportunity.

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.

When you join us, you will connect and collaborate with a global network of experts - planners, designers, engineers, scientists, consultants, program and construction managers - leading the change toward a more sustainable and equitable future. Join us and let\'s get started.



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.

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

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 managing Power Bi instances and environments within the Power Bi admin center
• 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.
• Implement row-level security on data and understand application security layer models in

. * Building Analysis Services reporting models.
. * Design methodology and project documentation creation

• Developing, publishing, and scheduling Power BI report as per the business requirements.
• Properly understand business requirements and develop data models accordingly
• Creating advanced level calculations to provide prescriptive and predictive analysis
• to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation.
• Develop automated operational reports and dashboards using Power BI and other reporting tools (including Power Bi report builder and SQL reporting services)
• Understand business requirements to set functional specifications for reporting applications

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.

Additional Information

With infrastructure investment accelerating worldwide, our services are in great demand, and there\'s never been a better time to be at AECOM! Join us, and you\'ll get all the benefits of being a part of a global, publicly traded firm - access to industry-leading technology and thinking and transformational work with big impact and work flexibility.

AECOM provides a wide array of compensation and benefits programs to meet the diverse needs of our employees and their families. We also provide a robust global well-being program. We\'re the world\'s trusted global infrastructure firm, and we\'re in this together - your growth and success are ours too.

As an Equal Opportunity Employer, we believe in each person\'s potential, and we\'ll help you reach yours.

Join us and let\'s get started.

AECOM