Senior Analyst - Marketing & Sales Support

UGI Utilities, Inc. provides a superior range of energy products and services to customers in a safe, affordable manner. Serving 750,000 customers across 45 counties in Pennsylvania and one county in Maryland, UGI is committed to safety, service, and integrity while fostering a diverse workforce and a collaborative environment with upward‑mobility opportunities and 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.

Responsibilities

• 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, work closely with internal users and outside programmers, identify bugs and opportunities for improved functionality, propose enhancements, write detailed specifications, lead projects, manage budgets, supervise programmers, develop and publish system reports and analysis, and provide hands‑on training and written training materials.
• Support key marketing databases (e.g., Datamart and various program databases) by troubleshooting production issues, testing enhancements, identifying automation opportunities, streamlining reports, completing necessary programming, and ensuring data accuracy.
• Develop, publish and analyze current and historic quantitative data, key metrics and trends used in strategic planning, budgeting, forecasting and sales performance programs—including monthly customer additions, lead volume, sales incentive/compensation, etc.; identify and interpret business challenges and recommend process improvements; develop and maintain Power BI dashboards to communicate results.
• Collaborate with Business Development Engineering and Sales Teams to present a comprehensive growth capital‑expenditure budget and ongoing forecast; track and report operating expenditures for sales, marketing and customer‑success cost centers; prepare annual budget templates; and provide growth‑margin and NPV analysis as needed.
• Develop and maintain key sales models such as residential savings, profitability and forecasting models; ensure consistent and accurate usage standards, profitability calculators and inputs; contribute to journey planning, content creation and advertising strategies 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.
• Expertise in Microsoft Excel and strong experience writing queries and developing reports and dashboards in Access, Crystal Reports and Power BI.
• 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 a related field (preferred).
• 8+ years of relevant experience (preferred).