Revenue Business Analyst

Service Corporation International; Houston (TX); On-site; USD 85,000 - 110,000; Full time

Job summary

Service Corporation International in Houston, TX is seeking a Revenue Business Analyst to perform comprehensive analyses, implement and manage pricing data systems, and generate BI insights for multiple functions.

You will develop polished Power BI dashboards, validate large data sets, write SQL/T-SQL scripts, and coordinate testing (SIT/UAT). This role requires strong communication and collaboration with stakeholders and IT teams to optimize pricing and profitability.

Qualifications

• Bachelor's degree in CS, Information Management, or related field.
• Minimum 3 years as Technical/Business Analyst or similar.
• 1 year Power BI experience with refreshable data connections.
• Proficient in SQL with complex queries.

Responsibilities

• Develops business analytics for cost and pricing.
• Creates polished Power BI reports for executive reviews.
• Writes SIT, UAT, and regression test scripts.
• Creates SQL scripts and testing evidence for data accuracy.
• Collaborates with data warehouse and business users to solve problems.
• Reports project status according to timelines.

Skills

SQL queries

Power BI

Excel

Data analysis

T-SQL

Excel VBA

Communication

Teamwork

Data validation

Education

Bachelor’s degree in CS/Information Management

Tools

Team Foundation Server

SQL Server

Excel

Job description

Our associates celebrate lives. We celebrate our associates. The Revenue Business Analyst generates comprehensive analyses, database implementation and management, recurring reporting and business intelligence for multiple functions. This role also maintains pricing data systems and coordinates operational system’s needs. Tests software releases to ensure system applications are performing correctly.

JOB RESPONSIBILITIES

System Administration and Maintenance

• Protect the stability of various Pricing and Cost Applications and ensure the integrity of the data involved.
• Assess, coordinate and review issues and impacts to support and business processes.
• Analyze, document and communicate application issues to management and programming team.
• Documents business and functional system requirements.
• Write SIT, UAT, and regression test scripts.
• Create necessary SQL scripts and testing evidence to correct system data.
• Responsible for requesting, tracking, testing for all changes needed in the Team Foundation Server Portal.
• Uses customer service skills to identify the root of the problem being reported.
• Demonstrates the skill and ability to effectively provide quality support in a high volume environment.
• Escalates obstacles/issues in a timely manner.
• Reports project status according to prescribed timelines.

Data Analysis

• Develops business analytics for cost and pricing.
• Including developing new insights and understanding of business performance based on data and statistical methods.
• Analyzes external market dynamics and internal data sources to assess trends and develop actionable insights.
• Applies knowledge of data auditing, statistical and quantitative analysis, explanatory modeling, and fact-based management to support recommendations.
• Develops polished executive-level Power BI reports and confidently delivers information in a clear and concise fashion.
• Coordinate and communicate between business users and the data warehouse organization, balancing requirements and resources to solve business problems.
• Perform extensive data validation/quality assurance analysis within large datasets.
• Writes ad hoc reports, builds tabular reports, visualizations, and Excel pivot tables or macros to review and report data.
• Communicates effectively with Corporate and Field users.

MINIMUM REQUIREMENT

Education

• Bachelor’s degree in Computer Science, Information Management, or related discipline.

Experience

• A minimum of three (3) years’ experience as a Technical Analyst, Business Analyst or similar role.
• One (1) year of experience using Power BI to build metrics/KPIs dashboards with refreshable data connections.

Knowledge, Skills and Abilities

• Proficiency in SQL, including writing complex queries, aggregations, subqueries, and joins to extract and manipulate data from relational databases Communicates effectively in both written and oral.
• Knowledge in operational business processes and systems.
• Proficient in various software programs, including Excel, Word, Outlook and PowerPoint.
• Experience writing TSQL, view, stored procedures, functions, and triggers.
• Demonstrates knowledge of process improvement Understanding of databases, logic views, query tools, and standard file layouts for conversions and interfaces.
• Proven success in a collaborative, team-oriented environment.
• Experience writing Excel VBA macros a plus.

WORK CONDITIONS

Work Environment

Work indoors during all seasons and weather conditions Comply with Corporate dress code policy Work

Work Postures

Sitting continuously for many hours per day, up to 6 hours per day May climb stairs to access buildings frequently

Physical Demands

Physical effort requiring manual dexterity is required, includes paperwork, calculators, computers and phone usage

Work Hours

Working beyond “standard” hours as the need arises

Job Location

Postal Code: 77019 Category (Portal Searching): Marketing and Advertising Job Location: US-TX - Houston

Who we are. What we do.

We are a company committed to supporting families at difficult times. Nowhere will you find a group of caregivers and teams more passionate about the work they do or more invested in the well-being of the families they serve. The Dignity Memorial name is a symbol of trust and a mark of excellence. As the largest provider of funeral, cemetery and cremation services in North America, we're dedicated to celebrating the life and legacy of every loved one with professionalism, compassion and attention to detail that is second to none. "SCI” refers to Service Corporation International and its affiliates.

Equal Opportunity Employer, M/F/D/V SCI Shared Resources, LLC is committed to an inclusive, barrier-free recruitment and selection process. On request, we will seek to provide appropriate accessibility options to all applicants with disabilities.