Infrastructure & Capital Projects – Power BI Analyst – Airports, ANS (Power BI)

Location: Los Angeles, CA; on-site at client and partner sites

Salary: $170,000–$187,000 per year

Company

hirify.global Infrastructure & Capital Projects delivers infrastructure and capital-project solutions across public infrastructure, transportation, grids, and related sectors using real-world expertise, digital innovation, and AI.

What you will do

• Design, develop, and maintain interactive Power BI reports and dashboards covering operational performance, KPIs, trends, risks, and opportunities.
• Partner with business stakeholders to translate reporting requirements into accurate, user-friendly analytical solutions.
• Connect, transform, and integrate data from multiple business systems using Power Query, SQL, Microsoft Fabric, and related tools.
• Develop semantic models, measures, data pipelines, and reusable reporting standards.
• Support database management, data validation, quality assurance, documentation, and troubleshooting.
• Perform ad hoc analysis and automate manual reporting using Power BI, Excel, SQL, Python, and related technologies.

Requirements

• Bachelor’s degree in business, finance, economics, information systems, data analytics, computer science, or a related field.
• Two or more years of experience developing reports, dashboards, data models, or analytical solutions with Power BI and Excel.
• Experience writing SQL queries and working with relational databases.
• Experience with Power Query and DAX for data transformation, modeling, and analysis.
• Working knowledge of Python or another programming language used for data analysis and automation.
• Experience with Microsoft Fabric, SSMS, MySQL, or comparable database and data-platform technologies, plus strong analytical, communication, problem-solving, and documentation skills.

Nice to have

• Experience with enterprise Power BI semantic models, dataflows, deployment pipelines, or governed reporting environments.
• Experience integrating data from enterprise systems, APIs, SharePoint, cloud platforms, or operational data sources.
• Familiarity with data governance, security, quality assurance, version control, and reporting-development best practices.
• Experience supporting capital programs, project controls, financial management, aviation, transportation, construction, or large-scale public-sector operations.
• Experience creating executive dashboards, maps, visualizations, and performance indicators.

Culture & Benefits

• On-site collaboration with clients and partners to support delivery and client relationships.
• Medical, dental, and vision coverage, plus life and disability insurance.
• 401(k) with employer match, health savings and flexible spending accounts.
• Paid time off and holidays, maternity and parental caregiver leave.
• Adoption and surrogacy assistance, supplemental insurance, employee assistance, legal resources, and identity theft protection.