Senior Analyst - Marketing & Sales Support

UGI Corporation; Denver (Lancaster County); On-site; USD 90,000 - 130,000; Full time

Job summary

UGI Utilities, Inc is seeking an experienced data analytics professional to track and analyze data, develop reports and dashboards, and support growth initiatives across Sales and Marketing.

The role focuses on maintaining MLTS systems, building Power BI dashboards, and delivering actionable insights through robust data models and forecasting tools.

Qualifications

• Ability to understand, synthesize, present and summarize complex datasets and data models.
• Solid working knowledge of VBA and SQL.
• Expert in Microsoft Excel; experience with Access, Crystal Reports and PowerBI.
• Experience in data modeling and data governance.
• Strong problem-solving and communication skills.

Responsibilities

• Track and analyze data and develop and maintain reports and dashboards to monitor sales and marketing growth.
• Maintain and support Fieldbook/Moata MLTS; manage budgets and supervise external programmers as needed.
• Develop KPIs and publish reports to assist strategic planning, budgeting, forecasting and sales performance.
• Collaborate with Business Development Engineering and Sales to track expenditures and provide growth analyses.
• Develop and maintain key sales models and forecasting tools; contribute to journey planning and ad strategy.

Skills

VBA

SQL

Power BI

Excel

Data modeling

Education

Bachelor's degree in a related field

Tools

Access

Crystal Reports

Power BI

Job description

Location: Denver, PA, US, 17517

Company: UGI Utilities, Inc

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.

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 hands‑on 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.