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 and 2021; and Best Places to Work in Arkansas 2020.

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 a Data Analyst I/II based in one of our locations in AR, MO or ME.

POSITION SUMMARY:

A Data Analyst assists in the daily management and maintenance of all enterprise reports, as well as the design and creation of queries to fulfill data requests. Successful candidates are self-driven, and comfortable with a fast-paced environment. They have the ability to resolve data quality issues that may be or become present. A Database Analyst II communicates daily with IT personnel for database needs, and personnel outside of IT for data requests and report needs, and therefore must be an excellent communicator. They must be able to work with Data Engineers to resolve data anomalies found in data pipelines. They must have the ability to teach business departments basic reporting skills to allow for self-service driven reporting.

PRIMARY DUTIES AND RESPONSIBILITIES

• Analyze data in order to fulfill report and ad hoc data requests
• Design, create, and deliver fully functioning reports
• Provide schema and data assistance and guidance to Analysts
• Create and maintain best practice security policies for all reporting platforms
• Resolve data quality and anomaly issues within source systems, data pipelines, or target systems discovered by the business end users.
• Work with stakeholders to understand their needs and translate that into quantitative problems.
• Communicate data analysis findings with the business.
• Define common data segments, processes or event models.
• Document and Catalog data within the enterprise data structures.
• Building Enterprise Reports for upper management.
• Create business insights through data and reports.
• Teaching business departments to build reports for self-services.
• Host training for Power BI report building to business when needed.
• Utilize data in respective databases to build easily digestible dashboards
• Setting Power BI Report Standards

EDUCATION AND WORK EXPERIENCE

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

• 2 years’ related experience in Database or Business Intelligence systems

KNOWLEDGE, SKILLS, ABILITIES

• Power BI experience preferred
• T-SQL/SQL
• Moderate level knowledge of ETL Tools
• Friendly and effective communication skills are a must
• SAP experience preferred
• Problem-solving attitude
• Business Oriented
• Business Analytics
• Strong mathematical aptitude and analytical skills
• Data Modeling
• Azure environment experience preferred
• SQL Server/Oracle/Excel experience preferred

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.