Summit Utilities, Inc. is recognized for its growth and commitment to excellence, diversity, and innovation. Providing safe and reliable natural gas service across Arkansas, Colorado, Maine, Missouri, and Oklahoma, Summit invites you to be part of a team that prioritizes safety and community service.

If you're a skilled Data Analyst II with expertise in SQL Server, Azure, and Power BI, Summit offers an exciting remote opportunity based near Fort Smith, AR or Little Rock, AR. You'll support regulatory requests, analyze data for strategic decisions, and work on impactful projects. With your strong background in data analysis, you'll translate complex insights, collaborate with cross-functional teams, and ensure compliance with regulatory bodies.

Join Summit to leverage your analytical skills and contribute to a company that values work-life balance and offers competitive benefits. Explore more about Summit Utilities, Inc., and ace your interview process with tips and insights available on Interview Query.

Submitting Your Application

The first step is to submit a compelling application that reflects your technical skills and interest in joining Summit Utilities, Inc. as a Data Analyst II. Whether you were contacted by a Summit recruiter or have taken the initiative yourself, carefully review the job description and tailor your CV according to the prerequisites.

Tailoring your CV may include identifying specific keywords that the hiring manager might use to filter resumes and crafting a targeted cover letter. Furthermore, don’t forget to highlight relevant skills and mention your work experiences.

Recruiter/Hiring Manager Call Screening

If your CV happens to be among the shortlisted few, a recruiter from Summit Utilities’ Talent Acquisition Team will make contact and verify key details like your experiences and skill level. Behavioral questions may also be a part of the screening process.

In some cases, the Summit Utilities data analyst hiring manager stays present during the screening round to answer your queries about the role and the company itself. They may also indulge in surface-level technical and behavioral discussions.

The whole recruiter call should take about 30 minutes.

Technical Virtual Interview

Successfully navigating the recruiter round will present you with an invitation for the technical screening round. Technical screening for the Summit Utilities data analyst role usually is conducted through virtual means, including video conference and screen sharing. Questions in this 1-hour long interview stage may revolve around Summit’s data systems, ETL pipelines, and SQL queries.

In the case of data analyst roles, take-home assignments regarding product metrics, analytics, and data visualization are incorporated. Apart from these, your proficiency against hypothesis testing, probability distributions, and machine learning fundamentals may also be assessed during the round.

Depending on the seniority of the position, case studies and similar real-scenario problems may also be assigned.

Onsite Interview Rounds

Followed by a second recruiter call outlining the next stage, you’ll be invited to attend the onsite interview loop. Multiple interview rounds, varying with the role, will be conducted during your day at the Summit Utilities office. Your technical prowess, including programming and ML modeling capabilities, will be evaluated against the finalized candidates throughout these interviews.

If you were assigned take-home exercises, a presentation round may also await you during the onsite interview for the data analyst role at Summit Utilities.

Quick Tips for Summit Utilities Data Analyst II Interviews

• Understand Regulatory Compliance: Familiarize yourself with regulatory requests and the utilities industry. Summit places a high emphasis on regulatory compliance and analyzing data related to rate case strategies.
• Excel in SQL and Data Visualization Tools: Ensure you're comfortable with Microsoft Excel, SQL, and Power BI, as these are fundamental tools mentioned in the job description.
• Clear Communication: Be prepared to effectively communicate complex data insights to both technical and non-technical audiences. Practicing clear and concise explanations can greatly benefit your candidacy.

Typically, interviews at Summit Utilities, Inc. vary by role and team, but commonly Data Analyst interviews follow a fairly standardized process across these question topics.

• Select the top 3 departments with at least ten employees and rank them by the percentage of employees making over 100K. Given employees and departments tables, select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.

What is the average salary for a Data Analyst at Summit Utilities, Inc.?

Q: What makes Summit Utilities, Inc. a great place to work? Summit Utilities, Inc. has been recognized as one of the Fastest Growing Denver Area Private Companies and Best Places to Work in various states from 2019 to 2022. We value excellence, diversity, innovation, and a strong commitment to safety. Our benefits are designed to support our employees both at work and at home, ensuring a good work-life balance.

Q: What does the Data Analyst II position entail? The Data Analyst II position involves collecting, organizing, and analyzing data to support regulatory requests and make informed business decisions. The role requires strong analytical skills, the ability to communicate complex data insights, and experience with SQL Server, Azure, and Power BI. It also involves building and maintaining dashboards and reports, and working with cross-functional teams to ensure data accuracy and consistency.

Q: What qualifications are required for the Data Analyst II position at Summit Utilities, Inc.? Applicants should have a Bachelor's degree in Information Technology or Computer Science (or equivalent experience), 5+ years of related experience in data analysis, and advanced knowledge of Microsoft Excel and SQL. Experience with Power BI, regulatory-type requests, and the utilities industry is beneficial. Strong communication skills and the ability to work collaboratively are also key.

Q: Can the Data Analyst II position be performed remotely? Yes, the Data Analyst II position can be performed remotely with proximity to our Fort Smith, AR or Little Rock, AR locations. This offers flexibility and work-life balance to our employees.

Q: How can I prepare for an interview at Summit Utilities, Inc.? To prepare for an interview at Summit Utilities, Inc., research the company and its values, familiarize yourself with common data analysis tools such as SQL Server and Power BI, and hone your data visualization skills. Practicing common technical and behavioral questions on Interview Query can also help you excel in your interview.

Embark on a promising career journey with Summit Utilities, Inc., renowned for its rapid growth and excellence in the utilities sector. As a Data Analyst II, you'll play a crucial role in driving strategic decisions through advanced data analysis and regulatory support. If you're passionate about data, regulatory compliance, and making a tangible impact, don't miss this opportunity. For deeper insights and to ace your interview, check out our comprehensive Summit Utilities, Inc. Interview Guide. At Interview Query, we provide the tools and guidance you need to excel. Explore all our company interview guides for thorough preparation, and feel free to reach out with any questions. Good luck on your journey with Summit Utilities!