Hybrid Power BI Analyst — Insights & Reporting Leader

STV; Douglassville (PA); Hybrid; USD 89,000 - 101,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Flexible Spending Accounts

Disability insurance

Life Insurance and AD&D

401(k) Plan

Retirement Counseling

Employee Assistance Program

Paid Time Off

Paid Holidays

Back-Up Dependent Care

Parental Leave

Continuing Education Program

Licensure and Society Memberships

Job summary

STV seeks a Business Intelligence Analyst to deliver accurate, actionable reporting across all business units and executives. You will develop dashboards, KPIs, and insights to guide strategic decisions in a hybrid, office-centric environment.

With 5+ years of analytics experience, you will partner with operations, finance, and sales teams, owning data modeling, performance reporting, and process improvements using Power BI and Deltek Vantagepoint.

Qualifications

• Bachelor’s degree in Business Analytics, Data Science, Information Systems, or a related field.
• 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).
• Strong proficiency with data visualization tools (e.g., Power BI).
• Proven experience with Power BI data modeling and DAX.
• Experience working with ERP systems (e.g., Deltek Vantagepoint).
• Advanced Excel skills, including pivot tables, advanced formulas, and Power Query.
• Strong analytical and quantitative abilities, with the capacity to interpret and clearly communicate complex data.
• High attention to detail and proven ability to manage multiple priorities in a fast-paced environment.
• Excellent communication and collaboration skills.

Responsibilities

• Develop, maintain, and optimize enterprise reporting dashboards supporting project performance, financial management, and business development initiatives.
• Create standardized reporting packages and deliver ongoing monthly, quarterly, and annual performance reports.
• Design and maintain semantic models, relationships, measures, and calculated columns using DAX.
• Optimize Power BI models for performance, scalability, and reusability.
• Collaborate with technical staff on deployment pipelines, data refresh strategies, and lifecycle management.
• Extract, clean, validate, and analyze data from ERP and related systems to assess pipeline activity, win rates, sales trends, and client behavior.
• Perform financial and operational performance analysis, including KPI tracking, revenue and margin variance analysis, backlog and WIP reporting, forecasting support, and project health assessments.
• Ensure data integrity by identifying inconsistencies, correcting gaps, and recommending process improvements across ERP and reporting systems.
• Translate complex data findings into clear, concise insights for technical and non-technical audiences.
• Partner with business development, operations, finance, and support teams to understand reporting needs and deliver timely analysis.
• Support strategic planning through ad-hoc analyses, scenario modeling, and client insights for leadership.

Skills

Power BI

DAX

Excel (Advanced)

ERP systems (Deltek Vantagepoint)

Data analysis

Communication skills

Education

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

Tools

SSIS

Data Factory

Job description

STV seeks a Business Intelligence Analyst to deliver accurate, actionable reporting across all business units and executives. You will develop dashboards, KPIs, and insights to guide strategic decisions in a hybrid, office-centric environment.

With 5+ years of analytics experience, you will partner with operations, finance, and sales teams, owning data modeling, performance reporting, and process improvements using Power BI and Deltek Vantagepoint.