Business Intelligence Analyst

Key Responsibilities

• Reporting & Visualization
  • Create, 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
• 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 supporting financial reporting for professional services or project-based organizations
• 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
• Knowledge of statistical analysis techniques or SQL

Pay & Benefits

Compensation Range: $88,777.71 - $101,460.24
STV offers a comprehensive benefits package including:

• 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
• Retail Counseling
• Employee Assistance Program
• Paid Time Off
• Paid Holidays
• Back-Up Dependent Care
• Parental Leave
• Continuing Education Program
• Professional Licensure and Society Memberships