Power BI Analyst - Infrastructure & Capital Projects, Onsite

Accenture Infrastructure and Capital Projects, LLC; Santa Monica (CA); On-site; USD 170,000 - 187,000; Full time

Job summary

Accenture Infrastructure and Capital Projects, LLC in Santa Monica, CA is seeking a Power BI-focused professional to design, develop, and maintain interactive dashboards that reveal operational performance and trends.

You will translate stakeholder needs into efficient data models, connect data from multiple sources, and deliver reliable reporting solutions supporting data-driven decisions on capital projects and public infrastructure initiatives.

Qualifications

• Bachelor’s degree required or equivalent experience in a related field.
• 2+ years of experience developing Power BI reports and dashboards.
• Experience writing SQL queries and working with relational databases.
• Experience using Power Query and DAX for data transformation and analysis.
• Proficiency in Python or similar for data analysis and automation.
• Familiarity with data-platform technologies like SSMS and MySQL.

Responsibilities

• Design, develop, and maintain Power BI reports and dashboards for operational performance, KPIs, trends, risks, and opportunities.
• Partner with stakeholders to translate reporting needs into analytical solutions and support data-driven decisions.
• Connect, transform, and integrate data from multiple systems using Power Query, SQL, and Microsoft Fabric.
• Develop semantic models, measures, data pipelines, and reporting standards for consistent information.
• Support database management, data validation, and troubleshooting to ensure reliable reporting.
• Perform ad hoc analysis and build analytical tools using Power BI, Excel, SQL, and Python.
• Identify opportunities to automate manual reporting and improve data accessibility and quality.

Skills

Power BI

Excel

SQL

Power Query

DAX

Python

Data analysis

Data visualization

Education

Bachelor’s degree in Business Administration, Finance, Economics, Information Systems, Data Analytics, Computer Science, or related field

Tools

Microsoft Fabric

SQL Server Management Studio

MySQL

Job description

Accenture Infrastructure and Capital Projects, LLC in Santa Monica, CA is seeking a Power BI-focused professional to design, develop, and maintain interactive dashboards that reveal operational performance and trends.

You will translate stakeholder needs into efficient data models, connect data from multiple sources, and deliver reliable reporting solutions supporting data-driven decisions on capital projects and public infrastructure initiatives.