Business Intelligence Analyst

STV Incorporated

Douglassville (PA)

Hybride

USD 89 000 - 101 000

Plein temps

Il y a 6 jours
Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Avantages offerts par ce poste

Health insurance with HSA option
401(k) plan
Paid time off
Paid holidays
Professional development

Résumé du poste

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.

Responsabilités

  • 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.

Connaissances

Advanced Excel
Financial analysis
Data interpretation
Stakeholder communication
Data visualization
Data modeling

Formation

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

Outils

Power BI
Deltek Vantagepoint
Power Query

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 modelling, 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 organisations
  • Strong understanding of project accounting concepts (e.g., revenue, backlog, utilisation, margin, WIP)
  • Strong proficiency with data visualization tools (e.g., Power BI)
  • Proven experience with Power BI data modelling 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

Outside agencies, or unsolicited applicants will not be considered THIS POSITION DOES NOT QUALIFY FOR SPONSORSHIP #LI-AW1 #LI-HYBRID

Compensation Range: $88,777.71 - $101,460.24

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.

STV is one of the top infrastructure‑focused professional services firms in North America. Founded in 1912, STV advises, plans, designs, engineers and delivers the infrastructure that powers local economies, including transportation systems, buildings, water and other facilities. Headquartered in New York City, the company has more than 65 offices and 3,400 employees who reimagine the solutions and structures that connect our communities. The firm is ranked 32nd in Engineering News‑Record’s Top 500 Design Firms survey and is 10th in its transportation category. STV is deeply committed to investing in its people and creating a world‑class employee experience. We are passionate about mentoring, coaching and cultivating our talent because we know they are destined to become the next generation of industry leaders. We’re also committed to delivering formative career experiences – and we do that by providing challenging and unique work experiences, by mapping multiple ways to advance (beyond the traditional career ladder!) and by recognizing those who successfully chart new and exciting paths for the firm. We value a wide range of perspectives and experiences, without regard to any factor or characteristic, regardless of whether it is a category protected by federal, state and/or local law, making them an integral part of how we work. Our approach ensures that every individual is respected, heard, and given opportunities to contribute meaningfully. We remove barriers and create pathways for growth, embedding fairness into our daily operations. Learn more atstvinc.com. STV exists to make communities better through innovative solutions that connect people, places and the present to the future. Our local teams throughout the country deeply understand the needs of their communities and have the expertise to provide solutions. We are also committed to giving back to our communities and our neighbors through volunteering and philanthropic activities; fundraising events; scholarships, internships, and mentoring; and sustainability and community improvement projects. Learn more. STV provides equal employment opportunities to all qualified applicants without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Senior PMO Specialist
Senior PMO Specialist

STV Incorporated • New York (NY)

Sur place
USD 96 000 - 110 000
Health insurance
Dental insurance
Vision insurance
+4
Digital Strategy Lead
Digital Strategy Lead

STV Incorporated • Mount Pleasant (WI)

Sur place
USD 140 000 - 160 000
Health insurance
Dental insurance
Vision insurance
+2
Business Intelligence Analyst
Business Intelligence Analyst

STV • Douglassville (PA)

Hybride
USD 89 000 - 101 000
Health insurance
Dental insurance
Vision insurance
+4
Billing Specialist
Billing Specialist

STV Incorporated • Inwood (TX)

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

STV Incorporated • Inwood (TX)

Sur place
USD 104 000 - 119 000
Health insurance
401(k) Plan
Paid Time Off
+2
Cost Engineering Specialist
Cost Engineering Specialist

STV Incorporated • Pompano Beach (FL)

Sur place
USD 99 000 - 114 000
Health Insurance
Dental Insurance
Vision Insurance
+6
Project Manager - Mission Critical
Project Manager - Mission Critical

STV Construction Incorporated • Illinois

Sur place
USD 131 000 - 150 000
Health insurance
Dental insurance
Vision insurance
+2
Senior Architect/Spec Writer
Senior Architect/Spec Writer

STV Incorporated • New York (NY)

Sur place
USD 150 000 - 171 000
Health insurance
Dental insurance
Vision insurance
+2
Project Manager - Mission Critical
Project Manager - Mission Critical

STV Incorporated • Mount Pleasant (WI)

Sur place
USD 131 000 - 150 000
Health insurance
Dental insurance
Vision insurance
+10
Senior BIM Lead - Water Practice
Senior BIM Lead - Water Practice

STV Incorporated • Inwood (TX)

Sur place
USD 117 000 - 134 000
Health insurance
Dental insurance
Vision insurance
+2