Offer summary

Qualifications:

Bachelor’s degree in Information Technology or Computer Science preferred, or equivalent experience., 5+ years of experience in data analysis and reporting., Advanced knowledge of Microsoft Excel and SQL, with experience in Power BI., Strong analytical, problem-solving, and critical thinking skills, along with effective communication abilities..

Key responsibilities:

Collect, organize, and analyze data for regulatory filings and rate case support.

Develop models and perform sensitivity analysis to identify key drivers for the Rate Case.

Collaborate with stakeholders to translate needs into quantitative problems and communicate data trends.

Create and maintain reports and dashboards using tools like Power BI and Cognos, ensuring data accuracy and compliance.

Job description

Join our Growing Team and see why Summit Utilities, Inc was named as one of the Fastest Growing Denver Area Private Companies 2019 and 2020; Best Places to Work in Maine 2019, 2020, 2021 and 2022; and Best Places to Work in Arkansas 2020 and Oklahoma 2022

Summit is a growing natural gas utility company providing safe, reliable and clean burning natural gas service to homes and businesses in Arkansas, Colorado, Maine, Missouri and Oklahoma. Being part of the Summit team means embracing excellence, diversity and innovation, committing to safety each and every day, and doing all that we can to serve each other, our customers and the communities where we live. We aim to bring warmth and energy to everything we do.

We have an exciting opportunity open for Data Analyst II to work remotely from AR.

POSITION SUMMARY:

Our company is seeking a Data Analyst II to support regulatory requests. The successful candidate will have a strong background in data analysis and be able to collect, organize, and analyze large amounts of data to help us make informed business decisions. They will also be able to communicate complex data insights to both technical and non-technical audiences, work with cross-functional teams, and use analytical tools and techniques to support our company's rate case strategies. Additionally, the candidate should have experience working with regulatory-type requests and an understanding of the regulatory environment. The successful candidate will have the opportunity to work on an important project that will impact our company's future. If you are a skilled Data Analyst II with a passion for the utilities industry and regulatory compliance, and experience with SQL Server, Azure, and Power BI, we encourage you to apply.

PRIMARY DUTIES AND RESPONSIBILITIES

Collect, organize and analyze data related to the Rate Case to support rate design, revenue requirement analysis, cost of service studies, and other regulatory filings. Design, create, and deliver fully functioning reports.
Develop models and perform sensitivity analysis to support the identification of key drivers and scenarios for the Rate Case.
Create and maintain best practice security policies for all reporting platforms.
Assist in the preparation of data exhibits and testimony for the regulatory filing.
Work with stakeholders to understand their needs and translate that into quantitative problems.
Identify and communicate trends and patterns in the data to support strategic decision-making.
Collaborate with internal teams and external consultants to ensure data accuracy and consistency.
Provide support for ad hoc data analysis and reporting as needed.
Work with regulatory bodies to ensure compliance and timely submission of regulatory filings.
Create business insights through data and reports.
Build and maintain all reporting in tools such as Power BI and Cognos.
Utilize data in respective databases to build easily digestible dashboards.

EDUCATION AND WORK EXPERIENCE

Bachelor’s degree in Information Technology or Computer Science is preferred or combination of education and equivalent experience

5+ years’ related experience in data analysis and reporting.

KNOWLEDGE, SKILLS, ABILITIES

Advanced knowledge of Microsoft Excel and SQL.
Friendly and effective communication skills are a must.
Ability to work in a team environment and effectively communicate complex data insights to both technical and non-technical audiences.
Experience with Power BI data visualization tool.
SAP experience preferred.
Business Oriented
Strong analytical, problem-solving, and critical thinking skills.
Data Modeling
Azure environment experience preferred
SQL Server/Oracle/Excel experience preferred
Self-Driven
Understanding of the utilities industry, regulatory filings, and rate cases is a plus.
Ability to work with regulatory bodies and ensure compliance with regulatory requirements.

Summit offers competitive pay and medical/dental/vision and other benefits that provide flexibility, choice and support to our employees when they need it most. We understand that home and family are essential pieces of your life, and our benefits are designed to support you both at work and at home.

Summit Utilities, Inc. is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender, gender identity, sexual orientation, age, status as a protected veteran, or status as a qualified individual with disability.

Required profile