Senior Analyst - Marketing & Sales Support

UGI Utilities Inc.; Denver (Lancaster County); On-site; USD 85,000 - 120,000; Full time

Job summary

UGI Utilities, Inc. is seeking a Senior Analyst in Marketing & Sales Support to track and analyze data, build dashboards, and support growth initiatives. The role emphasizes data-driven decision making, reporting, and collaboration with sales, marketing, and engineering teams.

The position requires strong Excel, SQL, and VBA skills, experience creating Power BI dashboards, and a strategic focus on improving sales performance and efficiency. Onsite in Denver, PA.

Qualifications

• 2/4 year degree in Marketing/Statistics/BA/Programming preferred.
• 8+ years of relevant experience preferred.
• Strong data analysis and reporting skills required.

Responsibilities

• Track, analyze data, and maintain reports and dashboards for Sales and Marketing growth.
• Develop and publish KPIs, monthly trends, and forecasting models.
• Build and maintain Power BI dashboards to communicate results.
• Collaborate with Business Development Engineering and Sales on budget forecasting and variance analysis.
• Develop and maintain key sales models (e.g., profitability, forecasting).

Skills

Data analysis

SQL

VBA

Excel

Power BI

Education

2/4 year degree in Marketing/Statistics/BA/Programming

Tools

Datamart

Power BI

Job description

UGI Utilities

Position title: Senior Analyst - Marketing & Sales Support

Location: Denver, PA, US, 17517

Senior Analyst - Marketing & Sales Support

Location: Denver, PA, US, 17517

Workplace Environment: Onsite

Company: UGI Utilities, Inc

Requisition Number: 30665

At UGI Utilities, Inc. we believe in providing a superior range of energy products and services to our customers in a safe, affordable manner. As our energy needs evolve, UGI will be there providing safe and reliable service that brings warmth and comfort to our 750,000 customers in 45 counties in Pennsylvania and 1 county in Maryland.

We strive to reflect the communities we serve by attracting and retaining top talent, while maintaining a diverse workforce that embraces our culture of safety, service, and integrity. As an employee of UGI Utilities, you can expect a competitive total compensation plan and comprehensive benefits. Employees work in a collaborative environment, have upward mobility opportunities, and the ability to enjoy a true work life balance.

To learn more about UGI's workplace culture, sustainability efforts, and commitment to inclusivity, we invite you to visit our UGI Corporate sustainability page.

Job Summary:

This position will track and analyze data and develop and maintain reports and dashboards, models and systems critical to monitoring, facilitating and achieving Sales and Marketing growth goals and activities.

Duties & Responsibilities:

• Growth Systems Administrator - Serve as the primary administrator and subject matter expert for Fieldbook/Moata the Marketing Lead Tracking System (MLTS). Maintain, update, test and troubleshoot the application, working closely with internal users and outside programmers. Identify bugs as well as opportunities for improved functionality and continuous sales efficiency. Propose new enhancements and write detailed specifications for modifications; lead project, manage budget and supervise outside programmers to implement these changes. Develop and publish system reports and analysis. Provide handson training to internal users and also develop written training materials.
• Support key marketing databases (e.g. Datamart and various program databases) including troubleshooting production issues and testing enhancements. Identify opportunities to automate or streamline reports and complete necessary programming. Develop and perform processes to ensure data accuracy.
• KPIs Tracking, Analysis and Reporting - Develop, publish and analyze current and historic quantitative data, key metrics and trends used in strategic planning, budgeting, forecasting and sales performance program including monthly customer additions, lead volume, sales incentive/compensation, etc. Identify and interpret business challenges using data and recommend solutions to improve processes. Develop and maintain Power BI dashboards as appropriate to communicate results.
• Financial Tracking, Analysis and Reporting – Collaborate with and provide supporting data to the Business Development Engineering and Sales Teams to present a comprehensive growth capital expenditure budget and ongoing forecast. Additionally, track and report upon operating expenditures for sales, marketing and customer success cost centers and prepare corresponding budget templates annually. Provide growth margin and NPV analysis as needed.
• Models - Develop and maintain key sales models, such as residential savings model, profitability model, forecasting models. Ensure usage standards, sales profitability calculators, and profitability inputs are consistent and accurate. Have a strong voice in journey planning, content creation, and advertising strategies in order to facilitate sales buy-in and adoption.

Knowledge, Skills and Abilities:

• Ability to understand, synthesize, present and summarize complex datasets and data models
• Solid working knowledge of programming languages such as VBA and SQL statements
• Expert in Microsoft Excel and solid working knowledge of writing queries and development reports and dashboards in Access, Crystal Reports and PowerBI
• Ability to identify gaps in business processes and recommend and implement solutions
• Extremely proficient in database design, data schemas and joins

Education & Experience:

• 2 or 4 year degree in Marketing, Statistics, Business Administration, Programming or similar, preferred
• 8+ years of relevant experience, preferred

UGI Utilities, Inc is an Equal Opportunity Employer. The Company does not discriminate on the basis of race, color, sex, national origin, disability, age, gender identity, sexual orientation, veteran status, or any other legally protected class in its practices.

Successful applicants shall be required to pass a pre-employment drug screen as a condition of employment, and if hired, shall be subject to substance abuse testing in accordance with UGI policies.

As a federal contractor that engages in safety-sensitive work, UGI cannot permit employees in certain positions to use medical marijuana, even if prescribed by an authorized physician. Similarly, applicants for such positions who are actively using medical marijuana may be denied hire on that basis.

Nearest Major Market: Lancaster

Job Segment: Sales Support, Substance Abuse, Behavioral Health, Outside Sales, Sustainability, Sales, Healthcare, Energy

Equal employment opportunity, including veterans and individuals with disabilities.

PI287308638