Business Intelligence Analyst

STV

Douglassville (PA)

Hybride

USD 89 000 - 101 000

Plein temps

Il y a 4 jours
Soyez parmi les premiers à postuler

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Avantages offerts par ce poste

Health insurance
Dental insurance
Vision insurance
401(k) plan
Paid time off
Paid holidays
Professional licensure

Résumé du poste

STV seeks a Business Intelligence Analyst to support executive decision-making with accurate reporting, dashboards, and KPI insights. The role blends finance, operations, and project analytics and reports to the IT Director of Business Systems.

A hybrid work model (3 days in office) is offered at central/east offices. Responsibilities include designing Power BI dashboards, maintaining data models, and collaborating with ERP teams to ensure data quality and timely insights for project performance

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
  • Experience integrating ERP and large data sets into automated reporting workflows
  • Familiarity with AEC project processes, reporting structures, and performance metrics
  • Ability to develop and maintain data workflow technologies including SSIS, Data Factory (or equivalent)
  • Knowledge of statistical analysis techniques or SQL is a plus

Responsabilités

  • 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 our ERP and related business systems to assess pipeline activity, win rates, sales cycle 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 our ERP and reporting systems
  • Translate complex data findings into clear, concise insights for both technical and non-technical audiences
  • Partner closely 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 that inform leadership decisions

Connaissances

Power BI
DAX
Analytical thinking
Financial analysis
Communication

Formation

Bachelor's degree in Business Analytics or related field

Outils

Power BI
Deltek Vantagepoint
SSIS
Data Factory
Power Query
SQL

Description du poste

STV is seeking a Business Intelligence Analyst , reporting to the IT Director of Business Systems. This position is designated as hybrid (3 days per week in office) and can be located within a commutable distance of any of our main office locations, preferably within the central or east co.

This is a critical role in supporting business growth by delivering accurate, actionable reporting and analysis across all business units and for executive leadership. This position supports the development of reports, dashboards, KPIs, and performance insights that guide strategic decision‑making and ensure healthy project performance.

Key Responsibilities
Reporting & Visualization
  • 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
Data Management & Analysis
  • Extract, clean, validate, and analyze data from our ERP and related business systems to assess pipeline activity, win rates, sales cycle 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 our ERP and reporting systems
Strategic Insights & Cross ‑ Functional Partnership
  • Translate complex data findings into clear, concise insights for both technical and non‑technical audiences
  • Partner closely 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 that inform leadership decisions
Required 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
Preferred Qualifications
  • Experience integrating ERP and large data sets into automated reporting workflows
  • Familiarity with AEC project processes, reporting structures, and performance metrics
  • Ability to develop and maintain data workflow technologies including SSIS, Data Factory (or equivalent)
  • Knowledge of statistical analysis techniques or SQL is a plus
Compensation Range

$88,777.71 - $101,460.24

STV offers the following benefits
  • Health insurance, including an option with a Health Savings Account
  • Dental insurance
  • Vision insurance
  • Flexible Spending Accounts (Healthcare, Dependent Care and Transit and Parking where applicable)
  • Disability insurance
  • Life Insurance and Accidental Death & Dismemberment
  • 401(k) Plan
  • Retirement Counseling
  • Employee Assistance Program
  • Paid Time Off
  • Paid Holidays
  • Back-Up Dependent Care
  • Parental Leave
  • Continuing Education Program
  • Professional Licensure and Society Memberships

STV is committed to paying all of its employees in a fair, equitable, and transparent manner. The listed pay range is STV's good‑faith salary estimate for this position. Please note that the final salary offered for this position may be outside of this published range based on many factors, including but not limited to geography, education, experience, and/or certifications.

Not sure this role is the perfect match? We encourage you to apply if STV's work and values resonate with you. We know great candidates don't always meet every qualification, and research shows women and people of color are less likely to apply unless they do. At STV, we believe strong talent comes from a wide range of backgrounds, and your skills and experience may align with t

Outside agencies, or unsolicited applicants will not be considered

THIS POSITION DOES NOT QUALIFY FOR SPONSORSHIP

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Business Intelligence Analyst
Business Intelligence Analyst

STV • Charlotte (NC)

Hybride
USD 89 000 - 101 000
Health insurance
Dental insurance
Vision insurance
+11
Business Intelligence Analyst
Business Intelligence Analyst

STV • Philadelphia

Hybride
USD 89 000 - 101 000
Health insurance
Dental insurance
Vision insurance
+4
Business Intelligence Analyst
Business Intelligence Analyst

STV • Atlanta (GA)

Hybride
USD 89 000 - 101 000
Health insurance
Dental insurance
Vision insurance
+12
Business Intelligence Analyst
Business Intelligence Analyst

STV Incorporated • Douglassville (PA)

Hybride
USD 89 000 - 101 000
Health insurance with HSA option
401(k) plan
Paid time off
+2
Market Analytics & Insights Manager
Market Analytics & Insights Manager

STV • Jacksonville (FL)

Hybride
USD 114 544 - 152 726
Health insurance
Dental insurance
Vision insurance
+3
Business Intelligence Analyst
Business Intelligence Analyst

STV Incorporated • Pennsylvania

Hybride
USD 89 000 - 101 000
Health insurance
Dental insurance
Vision insurance
+2
Data Analyst I
Data Analyst I

STV • New York (NY)

Sur place
USD 96 000 - 110 000
Health insurance (with HSA option)
Dental insurance
Vision insurance
+12
Data Analyst I
Data Analyst I

STV Incorporated • New York (NY)

Sur place
USD 96 000 - 110 000
Health insurance
Dental insurance
Vision insurance
+5
Senior Human Resources Generalist
Senior Human Resources Generalist

STV Incorporated • New York (NY)

Hybride
USD 84 000 - 96 000
Health insurance
Dental insurance
Vision insurance
+12
Billing Specialist
Billing Specialist

STV Incorporated • Inwood (TX)

Hybride
USD 58 000 - 66 000
Health insurance
Dental insurance
Vision insurance
+3