Business Analyst, PMO

ENTRUST Solutions Group • Seattle, WA

7h • $85,000 - $125,000 • Hybrid

About The Position

As a Business Analyst, you will play a crucial role in supporting our strategic and operational initiatives. You will be responsible for developing data-driven reporting solutions, conducting performance analysis, automating reporting processes, and translating data into clear visual insights that support decision-making and operational improvements.

Requirements

• Associate or Bachelor’s Degree
• Minimum 5 years related experience
• 4+ years' experience with Excel, SQL, and Power BI

Nice To Haves

• Experience working within construction, energy, utilities, engineering (civil, mechanical, electrical), consulting or related space
• Experience with Metric Dashboarding
• Proficiency in Excel, Power BI, and SQL queries.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Experience in data analysis and reporting.

Responsibilities

• Develop and maintain interactive Power BI dashboards and reports to track key performance metrics.
• Transform complex data into clear, intuitive visualizations that effectively communicate trends, performance, risks, and opportunities.
• Apply visual storytelling techniques to enable leadership to quickly understand key insights and make informed decisions.
• Analyze historical and current data to identify trends and insights.
• Identify opportunities to automate recurring reports, data updates, and manual reporting processes.
• Develop automated reporting solutions and workflows using Power BI, Power Automate, Power Apps, and related tools.
• Improve reporting efficiency, accuracy, and speed through automation and process optimization.
• Analyze performance data by various segments such as cost elements, labor, and project types.
• Compare past performance with forecasts to identify trends and opportunities for improvement.
• Collaborate with senior leadership to identify and reach key performance indicators.
• Continuously enhance reporting solutions based on stakeholder feedback and evolving business needs.

Benefits

• A supportive and inclusive work environment that values diversity and encourages innovation.
• Opportunities for professional growth and career development.
• Competitive salary and comprehensive benefits package, including generous paid time off, retirement program with a company match, tuition reimbursement, and flexible work schedules.
• company-sponsored medical, dental, vision, and retirement program with company matches.
• tuition reimbursement
• voluntary life, disability, critical illness, accident and hospitalization plans.
• HSA or FSA medical accounts
• FSA dependent care and transportation/parking accounts are also available.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree