Senior Business Intelligence Analyst

United Site Services, Inc; Meridian (ID); On-site; USD 90,000 - 129,000; Full time

Benefits offered by this job

Holiday & Paid Time Off

Medical/Pharmacy

Dental

Vision

Employer‑Paid Short‑Term Disability

Employer‑Paid Employee Basic Life & AD

Voluntary Employee Life & AD

Voluntary Spousal Life

Voluntary Dependent Life

Hospital Indemnity, Accident and CI

Commuter/Transit Account

Healthcare Flexible Spending Account

Dependent Care Flexible Spending Plan

Health Savings Account

401(k) with employer match

Employee Assistance Program (EAP)

Employee Discounts

Job summary

United Site Services seeks a Senior Business Intelligence Analyst to join the Revenue Operations team. You will develop scalable analytics, data models, and automated processes to improve sales performance, forecasting, and pipeline visibility.

You will collaborate with Sales Leadership, Revenue Operations, Finance, Marketing, BI and IT to translate complex business needs into reliable analytical solutions, using SQL, Snowflake, dbt, Power BI, Salesforce, and workflow automation.

Qualifications

• Bachelor's degree in a related field.
• Minimum 5 years of experience in Sales Analytics, Revenue Operations, BI, or data analytics.
• Advanced SQL skills with complex queries and large datasets.
• Experience with Snowflake or similar cloud data platform and data modeling.
• Experience developing dbt models or similar frameworks.
• Strong Power BI skills including data modeling and executive reporting.
• Experience building automated workflows with Power Automate or similar.
• Experience with Salesforce data and CRM concepts.
• Solid understanding of sales performance concepts and analytics.

Responsibilities

• Build and maintain scalable data models supporting sales performance, forecasting, pipeline, and account health.
• Write, optimize, and maintain SQL transformations and dbt models for reporting and processes.
• Design and enhance Power BI dashboards and semantic models for executive reporting.
• Own analytical solutions from requirements gathering through deployment and support.
• Develop and maintain KPIs and frameworks related to revenue, pipeline, and attainment.
• Support forecasting, budgeting, pipeline analysis, and commercial planning.
• Collaborate with Sales and Revenue Operations to translate questions into analyses.
• Design and maintain automated reporting and workflow solutions using Power Automate and Salesforce.

Skills

Advanced SQL

Data Modeling

DAX

CRM concepts

Executive reporting

Analytical communication

Problem solving

Education

Bachelor's degree in Business, Analytics, Finance, Economics, Information Systems, Data Science, CS

Tools

Snowflake

dbt

Power Automate

Salesforce

Power BI

Job description

About USS

United Site Services is the industry leader in comprehensive site services, committed to creating partnerships that help enable our customers’ project and event success. Our deep industry expertise, excellence in process management, and dedication to corporate responsibility are pillars of our value proposition; each supported by tangible, best-practice programs.

Our success is fueled by the dedication and collaboration of our diverse team, which includes field technicians, customer care representatives, sales professionals, and functional experts. Each member of our team plays a vital role in ensuring a seamless and reliable experience for our customers.

By joining United Site Services, you will be part of an organization that values continuous improvement, teamwork, and excellence in every aspect of our business.

Primary Purpose

The Senior Business Intelligence Analyst is a key member of the Revenue Operations team, responsible for developing scalable analytics, data models, reporting solutions, and automated processes that improve sales performance, forecasting, pipeline visibility, and commercial decision-making.

Reporting directly to the Senior Director of Analysis & Insights, this role partners closely with Sales Leadership, Revenue Operations, Finance, Marketing, Business Intelligence, and IT to translate complex business needs into reliable analytical solutions and actionable insights. The role combines strong business acumen with hands‑on technical expertise across SQL, Snowflake, dbt, Power BI, Salesforce, and workflow automation.

This is a highly visible, hands‑on role requiring the ability to independently lead complex analytical initiatives, develop production‑quality data solutions, identify business risks and opportunities, and communicate findings effectively to both technical and executive audiences.

Essential Functions

• Build, develop, and maintain scalable data models supporting Sales Performance, Forecasting, Pipeline Management, Account and Book Health, New Business, and other Revenue Operations priorities.
• Write, optimize, and maintain complex SQL transformations and dbt models to support reporting, analytics, and recurring business processes.
• Design, develop, and enhance Power BI dashboards, semantic models, DAX measures, and executive‑level reporting solutions.
• Own analytical solutions from requirements gathering through development, validation, implementation, documentation, and ongoing support.
• Develop and maintain Sales Effectiveness KPIs and performance frameworks related to revenue, pipeline, forecasting, targets, attainment, productivity, and account management.
• Support sales forecasting, target setting, budgeting, pipeline analysis, and commercial planning through advanced data modeling and analysis.
• Partner directly with Sales and Revenue Operations leaders to translate business questions into analytical approaches, insights, and actionable recommendations.
• Design and maintain automated reporting and workflow solutions using tools such as Power Automate, Salesforce, and other available technologies.
• Own data quality within assigned areas through reconciliation, validation, exception monitoring, root‑cause analysis, and implementation of appropriate quality controls.
• Partner with BI, Data Engineering, and IT teams on data architecture, governance, model design, performance optimization, and enterprise analytics standards.

SUPERVISORY RESPOSIBILITIES

The position does not have direct supervisory responsibilities.

Qualifications

• Bachelor’s degree in Business, Analytics, Finance, Economics, Information Systems, Data Science, Computer Science, or a related field.
• Minimum of 5 years of experience in Sales Analytics, Revenue Operations, Business Intelligence, Data Analytics, or a related analytical function.
• Advanced SQL skills with demonstrated ability to work with complex queries, multiple tables, CTEs, window functions, transformations, and large datasets.
• Experience with Snowflake or a comparable cloud data platform and strong knowledge of modern data modeling practices.
• Experience developing and maintaining dbt models or working with a comparable data transformation framework.
• Strong experience with Power BI, including data modeling, DAX, semantic models, dashboard development, and executive reporting.
• Experience developing and maintaining automated workflows using Power Automate or a comparable workflow automation platform.
• Experience working with Salesforce data and a strong understanding of CRM concepts including accounts, opportunities, pipeline, ownership, and sales activity.
• Strong understanding of sales performance concepts including revenue, forecasting, pipeline, targets, attainment, productivity, account management, and new business.
• Strong problem‑solving, communication, and collaboration skills with the ability to work independently, manage multiple priorities, and translate complex analytical findings into clear business recommendations.

Physical Requirements

• Sit while driving and stand while servicing products
• Use hands and fingers to handle, control or feel objects tools or controls
• Repeat the same movements
• See details of objects that are less than a few feet away and also at greater distance
• Speak clearly so customers can understand
• Understand the speech of another person
• Focus on one source of sound and ignore others
• Hear sounds and recognize the difference between them
• See differences between colors, shades and brightness

Benefits Summary

All full‑time employees working an average of 30 hours or more per week are eligible for the following benefits:

• Holiday & Paid Time Off (pro‑rated for Part‑Time employees)
• Medical/Pharmacy
• Dental
• Vision
• Employer‑Paid Short‑Term Disability
• Employer‑Paid Employee Basic Life & Accidental Death and Dismemberment
• Voluntary Employee Life & Accidental Death and Dismemberment
• Voluntary Spousal Life
• Voluntary Dependent Life
• Hospital Indemnity, Accident and Critical Illness
• Commuter/Transit Account
• Healthcare Flexible Spending Account
• Dependent Care Flexible Spending Account
• Health Savings Account
• 401(k) with employer match
• Employer‑Paid Employee Assistance Program (EAP)
• Employee Discounts

Salary Range

$89,500.00 – $134,200.00 / year

Pay Transparency Statement

At United Site Services, our salary ranges reflect the minimum and maximum base pay for the posted position applicable to all locations across the US. Within the posted salary range, individual pay is determined by the geographic location, job related skills, experience, education, and certifications. Our total compensation package includes base pay plus a comprehensive benefits program.

EEO Statement

Some positions may require secure site access and/or domestic air travel. All candidates for positions which require secure site access and/or domestic air travel must possess an acceptable form of identification to comply with state and federal regulations, such as REAL ID‑compliant driver’s license or state ID, or U.S. passport. This statement is not intended to require documentation beyond what is acceptable under the federal I‑9 form process administered by the U.S. Citizenship and Immigration Services (USCIS); and should not be construed as creating additional employment eligibility verification requirements.

United Site Services is an equal opportunity employer. In accordance with applicable law, we prohibit discrimination against any applicant or employee based on any legally‑recognized basis, including, but not limited to: race, color, religion, sex (including pregnancy, lactation, childbirth or related medical conditions), sexual orientation , gender identity , age (40 and over), national origin or ancestry, citizenship status, physical or mental disability, genetic information (including testing and characteristics), veteran status, uniformed servicemember status or any other status protected by federal, state or local law. Our commitment to equal opportunity employment applies to all persons involved in our operations and prohibits unlawful discrimination by any employee, including supervisors and co‑workers.