Power BI & Analytics Lead (Hybrid)

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

Benefits offered by this job

Health insurance with HSA option

401(k) plan

Paid time off

Paid holidays

Professional development

Job summary

STV Incorporated is seeking a Business Intelligence Analyst to deliver accurate reporting and actionable analysis for executive leadership. You will develop dashboards, manage KPI reporting, and support project performance across business units in a hybrid work model.

The role requires 5+ years in advanced reporting, strong Power BI and DAX skills, ERP experience (Deltek Vantagepoint), and excellent communication. Collaboration with finance, operations, and business development is essential.

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 organisations.
• Strong understanding of project accounting concepts (revenue, backlog, utilisation, margin, WIP).
• Strong proficiency with data visualization tools (Power BI).
• Proven experience with Power BI data modelling and DAX.
• Experience working with ERP systems (Deltek Vantagepoint).
• Advanced Excel skills, pivot tables, advanced formulas and Power Query.
• Strong analytical and quantitative abilities; ability to communicate complex data clearly.
• High attention to detail and ability to manage multiple priorities in a fast-paced environment.
• Excellent communication and collaboration skills.

Responsibilities

• Develop, maintain, and optimize enterprise reporting dashboards for project performance and financial management.
• Create standardized reporting packages and deliver 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 and trends.
• Perform financial and operational performance analysis including KPI tracking and backlog reporting.
• Ensure data integrity by identifying inconsistencies and suggesting 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 to deliver timely analyses.
• Support strategic planning through ad-hoc analyses and scenario modelling.

Skills

Advanced Excel

Financial analysis

Data interpretation

Stakeholder communication

Data visualization

Data modeling

Education

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

Tools

Power BI

Deltek Vantagepoint

Power Query

Job description

STV Incorporated is seeking a Business Intelligence Analyst to deliver accurate reporting and actionable analysis for executive leadership. You will develop dashboards, manage KPI reporting, and support project performance across business units in a hybrid work model.

The role requires 5+ years in advanced reporting, strong Power BI and DAX skills, ERP experience (Deltek Vantagepoint), and excellent communication. Collaboration with finance, operations, and business development is essential.