Business Intelligence Analyst

Business Intelligence AnalystSTV 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 ResponsibilitiesReporting & VisualizationDevelop, maintain, and optimize enterprise reporting dashboards supporting project performance, financial management, and business development initiativesCreate standardized reporting packages and deliver ongoing monthly, quarterly, and annual performance reportsDesign and maintain semantic models, relationships, measures, and calculated columns using DAXOptimize Power BI models for performance, scalability, and reusabilityCollaborate with technical staff on deployment pipelines, data refresh strategies, and lifecycle managementData Management & AnalysisExtract, clean, validate, and analyze data from our ERP and related business systems to assess pipeline activity, win rates, sales cycle trends, and client behaviorPerform financial and operational performance analysis, including KPI tracking, revenue and margin variance analysis, backlog and WIP reporting, forecasting support, and project health assessmentsEnsure data integrity by identifying inconsistencies, correcting gaps, and recommending process improvements across our ERP and reporting systemsStrategic Insights & Cross-Functional PartnershipTranslate complex data findings into clear, concise insights for both technical and non-technical audiencesPartner closely with business development, operations, finance, and support teams to understand reporting needs and deliver timely analysisSupport strategic planning through ad-hoc analyses, scenario modeling, and client insights that inform leadership decisionsRequired QualificationsBachelor's degree in Business Analytics, Data Science, Information Systems, or a related field5+ years of experience in advanced reporting, business analytics, or financial analysis; AEC industry experience preferredExperience supporting financial reporting for professional services or project-based organizationsStrong 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 DAXExperience working with ERP systems (e.g., Deltek Vantagepoint)Advanced Excel skills, including pivot tables, advanced formulas, and Power QueryStrong analytical and quantitative abilities, with the capacity to interpret and clearly communicate complex dataHigh attention to detail and proven ability to manage multiple priorities in a fast-paced environmentExcellent communication and collaboration skillsPreferred QualificationsExperience integrating ERP and large data sets into automated reporting workflowsFamiliarity with AEC project processes, reporting structures, and performance metricsAbility to develop and maintain data workflow technologies including SSIS, Data Factory (or equivalent)Knowledge of statistical analysis techniques or SQL is a plusCompensation Range: $88,777.71 - $101,460.24STV offers the following benefits: Health insurance, dental insurance, vision insurance, flexible spending accounts, disability insurance, life insurance, 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.