Hybrid Power BI Data Analyst: Strategic Reporting

STV; Philadelphia (Philadelphia County); Hybrid; USD 89,000 - 101,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k) plan

Paid time off

Paid holidays

Flexible spending accounts

Job summary

STV is seeking a Business Intelligence Analyst to deliver accurate reporting and actionable insights across the organization. You will develop dashboards, KPIs, and performance insights to guide leadership decisions and support project health.

The role requires collaboration with finance, operations, and business development teams, with a hybrid work arrangement (3 days in office) and proximity to main office locations in central or eastern areas.

Qualifications

• Bachelor’s degree in a related field is required.
• 5+ years of experience in advanced reporting, business analytics, or financial analysis; AEC industry experience preferred.
• Experience supporting financial reporting for professional services or project-based organizations.
• Strong understanding of project accounting concepts (e.g., revenue, backlog, utilization, margin, WIP).
• Power BI data modeling and DAX experience; ERP systems experience (Deltek Vantagepoint).
• Advanced Excel skills including pivot tables, formulas and Power Query.

Responsibilities

• Develop, maintain, and optimize enterprise reporting dashboards for project performance and financial management.
• Create standardized reporting packages with monthly, quarterly, and annual performance reports.
• Design semantic models and optimize Power BI models for performance and reusability.
• Collaborate with IT to manage deployment pipelines, data refresh strategies, and lifecycle management.
• Translate data findings into clear insights for stakeholders; partner with BD, operations, finance, and support teams.

Skills

Analytical thinking

Communication

Attention to detail

Multitasking

Business analytics

Education

Bachelor’s degree in Business Analytics, Data Science, Information Systems or related field

Tools

Power BI

Deltek Vantagepoint

Excel

Job description

STV is seeking a Business Intelligence Analyst to deliver accurate reporting and actionable insights across the organization. You will develop dashboards, KPIs, and performance insights to guide leadership decisions and support project health.

The role requires collaboration with finance, operations, and business development teams, with a hybrid work arrangement (3 days in office) and proximity to main office locations in central or eastern areas.