STV Logo

STV

Business Intelligence Analyst

Posted 4 Days Ago
Hybrid
Chicago, IL, USA
89K-101K Annually
Senior level
Hybrid
Chicago, IL, USA
89K-101K Annually
Senior level
Develops and optimizes Power BI dashboards, semantic models, DAX measures, and enterprise reporting for project, financial, and business development performance. Analyzes ERP data, KPIs, revenue, margins, backlog, WIP, forecasting, and client trends. Ensures data integrity, supports automated reporting workflows, performs scenario analysis, and translates findings into actionable insights for executives and cross-functional teams.
The summary above was generated by AI

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

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

STV offers the following 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.


Not sure this role is the perfect match? We encourage you to apply if STV’s work and values resonate with you. We know great candidates don’t always meet every qualification, and research shows women and people of color are less likely to apply unless they do. At STV, we believe strong talent comes from a wide range of backgrounds, and your skills and experience may align with this or another opportunity as we continue to grow.

STV Chicago, Illinois, USA Office

Chicago, United States

Similar Jobs

13 Days Ago
In-Office
75K-110K Annually
Senior level
75K-110K Annually
Senior level
Cloud • Information Technology • Machine Learning
Build and maintain finance data models, automated pipelines, dashboards, and reports for planning, forecasting, close, and executive reporting. Govern finance metrics, reconcile data to source systems and the general ledger, resolve data quality issues, and collaborate with FP&A, Accounting, and Data Engineering. Apply BI best practices such as dimensional modeling, documentation, testing, version control, and data governance while translating finance needs into scalable data solutions.
Top Skills: BigQueryDatabricksDbtLookerNetSuitePower BIPythonSalesforceSigmaSnowflakeSQLTableau
3 Days Ago
In-Office
Mid level
Mid level
Real Estate • Financial Services
Build interactive dashboards and visualizations for operational metrics, prepare and clean data from multiple sources, write database queries, and deliver insights for real estate and workplace planning decisions. The role partners with business, client, IT, and data teams; supports data quality and security; trains colleagues on data tools; and evaluates emerging AI and analytics technologies.
Top Skills: Aws SagemakerAzure MlDatabricks Ai
3 Days Ago
In-Office or Remote
84K-110K Annually
Senior level
84K-110K Annually
Senior level
Energy • Renewable Energy
Leads data governance, quality, business intelligence, operational analytics, and process improvement across the Service organization. Develops executive dashboards, analyzes operational and financial data, establishes governance standards, improves reporting, and automates workflows using Microsoft Power Platform. Partners with business teams to deliver actionable insights and evaluates AI-enabled tools, cloud data platforms, and automation opportunities.
Top Skills: AirtableAzureDaxMicrosoft 365Microsoft CopilotExcelMicrosoft FabricMicrosoft TeamsOnedrivePower AppsPower AutomatePower BIPower QuerySharepoint

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account