> Markdown version of [/jobs/ext/2288954-business-intelligence-analyst](https://www.wearedevelopers.com/jobs/ext/2288954-business-intelligence-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Analyst - **Company:** STV Incorporated - **Location:** Douglassville, PA, United States - **Experience:** Expert - **Salary:** $88,778.0 - $101,460.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Analysis of Variance (ANOVA), Business Systems, Information Systems, Data Integrity, Data Visualization, Excel Formulas, Pivot Tables, Power BI, SQL Databases, SQL Server Integration Services, Delivery Pipeline, Powerquery, Performance Monitor, Data Management - **Published:** August 29, 2026 - **Apply:** https://www.careerjet.com/job/usd0b67ebc50af17540597b65c90953624/eaa ## About the Role * 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 ## Description 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., 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 ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Valven Atlas: Engineering Intelligence That Delivers](https://www.wearedevelopers.com/videos/1660-valven-atlas-engineering-intelligence-that-delivers) - [Scaling Talent from Within: How Upskilling Fuels Growth](https://www.wearedevelopers.com/videos/1379-scaling-talent-from-within-how-upskilling-fuels-growth) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)