Job Information
AECOM PowerBI Developer in Taguig City, Philippines
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.
Job Description
AECOM is seeking for a Power BI Developer to be based in Manila, Philippines
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.
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 Power BI.
Building Analysis Services reporting models.
DAX queries in Power BI desktop.
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
Qualifications
Minimum Requirements:
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
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.
Additional Information
About AECOM
AECOM is the world’s trusted infrastructure consulting firm, delivering professional services throughout the project lifecycle – from advisory, planning, design and engineering to program and construction management. On projects spanning transportation, buildings, water, new energy and the environment, our public- and private-sector clients trust us to solve their most complex challenges. Our teams are driven by a common purpose to deliver a better world through our unrivaled technical and digital expertise, a culture of equity, diversity and inclusion, and a commitment to environmental, social and governance priorities. AECOM is a Fortune 500 firm and its Professional Services business had revenue of $14.4 billion in fiscal year 2023. See how we are delivering sustainable legacies for generations to come at aecom.com and @AECOM.
Freedom to Grow in a World of Opportunity
You will have 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.
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.
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. As an Equal Opportunity Employer, we believe in each person’s potential, and we’ll help you reach yours.
All your information will be kept confidential according to EEO guidelines.
ReqID: REF17908F
Business Line: Geography OH
Business Group: DCS
Strategic Business Unit: GBS
Career Area: Digital & Engineering Technology
Work Location Model: Hybrid