Business Intelligence Analyst
About The Position
STV is seeking a Business Intelligence Analyst reporting to the IT Director of Business Systems. This hybrid position requires working in the office three days per week and may be based within commuting distance of any main office location, preferably in the central or east coast. The role supports business growth by delivering accurate, actionable reporting and analysis across business units and to executive leadership. It develops reports, dashboards, KPIs, and performance insights to guide strategic decisions and support healthy project performance. The analyst builds and maintains reporting and visualization solutions, analyzes data from ERP and related business systems, and evaluates financial and operational performance. The role also safeguards data integrity, translates findings for technical and non-technical audiences, and partners with business development, operations, finance, and support teams. It supports strategic planning through ad hoc analysis, scenario modeling, and client insights.
Requirements
- Bachelor’s degree in Business Analytics, Data Science, Information Systems, or a related field.
- At least 5 years of experience in advanced reporting, business analytics, or financial analysis.
- Experience supporting financial reporting for professional services or project-based organizations.
- Strong understanding of project accounting concepts, such as revenue, backlog, utilization, margin, and WIP.
- Strong proficiency with data visualization tools such as Power BI.
- Proven experience with Power BI data modeling and DAX.
- Experience working with ERP systems, such as Deltek Vantagepoint.
- Advanced Excel skills, including pivot tables, advanced formulas, and Power Query.
- Strong analytical and quantitative abilities, including the ability to interpret and clearly communicate complex data.
- High attention to detail and ability to manage multiple priorities in a fast-paced environment.
- Excellent communication and collaboration skills.
Nice To Haves
- AEC industry experience.
- Experience integrating ERP systems 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.
Responsibilities
- Develop, maintain, and optimize enterprise reporting dashboards for project performance, financial management, and business development.
- 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 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.
- Identify data inconsistencies, correct gaps, and recommend 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 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.
Benefits
- Health insurance, including an option with a Health Savings Account.
- Dental insurance.
- Vision insurance.
- Flexible Spending Accounts for healthcare, dependent care, and transit and parking where applicable.
- Disability insurance.
- Life insurance and Accidental Death & Dismemberment coverage.
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
