The Southern Company Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Southern Company Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Southern Company? The Southern Company Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Southern Company Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Southern Company.</li>
<li>Practice real Southern Company Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Southern Company Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Southern Company? The Southern Company Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Southern Company Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Southern Company.
- Practice real Southern Company Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Southern Company Business Intelligence interview.
        

Overview

Southern Company Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Southern Company Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Manager Team Sizes

<p>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Southern Company Business Intelligence Interview Questions

<p>This position will support the Enterprise Asset Management (MATRiX) organization in Southern Company Gas. The role plays a versatile part within our project teams, offering a broad range of skills to support various aspects of project execution. The individual is responsible for providing comprehensive support to our projects through detailed process documentation, effective project communication, and proactive project support. This position is equipped with an in-depth understanding of business environments, aiming to support business process improvements and system solutions that contribute to the success of the enterprise. It is dedicated to fostering end-to-end business process improvements, utilizing technical expertise and analytical acumen. The individual will work collaboratively across different project workstreams, providing essential support to ensure the effective implementation of business-aligned solutions and applications.

This position may be filled as Business Analyst III (GSE04) or Senior (GSE05). Individuals who demonstrate advanced skills in terms of work experience, education, and certifications may be eligible for the more advanced position.

The selected candidate could work out of the following locations: Georgia or Illinois

This position follows a Hybrid Work Schedule. Employees are required to be in the office Three (3) Days per week.

JOB RESPONSIBILITIES:

This role will be responsible for utilizing technical acumen, analytical capabilities, and collaborative skills to contribute to project success, ensuring that delivered solutions are effective and align with the organization's strategic objectives and includes but is not limited to:

Ensure business processes and technology are aligned.
Aligning business processes with technological capabilities to ensure seamless operations.
Offering analytical expertise and business insight to aid in the development of technical solutions.
Identify, document and explain improvements based on project data analysis.
Provide support throughout the testing process to ensure successful implementation and functionality of solutions.
Conduct comprehensive requirement gathering sessions with stakeholders to understand business needs and translate them into functional specifications.
Perform gap analysis to determine the differences between current and desired states of business processes.
Develop and utilize standard templates to accurately and concisely write requirements specifications.
Create detailed business analysis, outlining problems, opportunities, and solutions for the business.
Work closely with tech leads to ensure proper implementation of program and system specifications.
Supporting the creation of change management documentation, including FAQs, talking points, and other resources to facilitate smooth transitions.
Ensuring all communications are aligned with the company's brand, values, and culture to maintain consistency and trust.
Crafting clear, concise, and engaging communication materials, such as emails, newsletters, presentations, and training content.
Analyzing data from surveys and feedback mechanisms to measure communication effectiveness and employee readiness, using insights to drive improvements.
Participating in change impact assessments to understand the implications of changes and to develop targeted communication plans accordingly.
Coordinating with project teams to ensure timely dissemination of information regarding upcoming changes, milestones, and expectations.
Maintaining an up-to-date repository of communication assets and materials that can be easily accessed and utilized by the organization.
Develop and administer both internal and external surveys and provide full analysis of survey results.
Provide backup assistance to other roles within the department, as needed.
Participate in special projects, as requested.
Other duties as assigned.

JOB REQUIREMENTS:

Business Analyst III (GSE04)

Required:

Education, Certifications/Licenses:

Bachelor’s degree in business, Data Analytics, Technology or a related field / equivalent work experience.

Required:

Work Experience:

2-4 years combined experience with the utilities or other related experience.
1-3 years of experience analyzing data and process improvement.
Demonstrated ability to work independently and make well-informed decisions.
Strong organizational skills with attention to detail.
Proven track record of meeting deadlines and delivering high-quality work.
Knowledge of business practices and trends within the natural gas industry, with a willingness to expand expertise in this area.
Familiarity in Microsoft Office products, including Excel and PowerPoint, as well as other presentation software.
Knowledge of business-related systems (i.e. Click, Asset Repository, GCMA, CCB, etc.)

Preferred:

Ability to demonstrate flexibility in supporting various project aspects, including but not limited to process improvement, system enhancements, and strategic initiative implementation.
Experience contributing to project environments with a focus on delivering results within allocated budgets and timeframes.
Capability to handle multiple tasks and deliverables simultaneously in a team setting, collaborating effectively with diverse project leaders from various companies and business units.
Strong communication skills, both oral and written, with the ability to engage effectively with all levels of management.
Understanding of general management business practices and techniques, with a focus on continual learning and application.
Flexibility to support various tasks and adapt to shifting priorities in a dynamic work environment.

Senior Business Analyst (GSE05)

Required:

Related Work Experience:

3-5 years combined experience with the utilities or other related experience.
3+ years of experience analyzing data and process improvement.
Demonstrated ability to work independently and make well-informed decisions.
Strong organizational skills with attention to detail.
Proven track record of meeting deadlines and delivering high-quality work.
Ability to interpret and analyze complex data to inform business decisions.
Experience with regulatory compliance and industry standards within the utilities sector.
Knowledge of business processes and procedures, including exception processing.
Proficiency in Microsoft Office products, including Excel and PowerPoint, as well as other presentation software.
Knowledge of business-related systems (i.e. Click, Asset Repository, GCMA, CCB, etc.)

Preferred:

Strong oral and written communication skills and experience leveraging these skills to interact with all levels of management.
Versatility in project support, encompassing areas such as process optimization, system enhancements, and the execution of strategic initiatives.
Experience working in a project environment to deliver functionality within a budget and timeframe.
Experience managing multiple tasks and deliverables in a cross-functional team environment, working with diverse project leaders across multi-company and business units.
Must have extensive knowledge of general management business practices and techniques.
Ability to support multiple resources and adapt to changing priorities.

Behavioral Attributes

Models Our Values of Unquestionable Trust, Superior Performance and Total Commitment.
Ethical Behavior: Is widely trusted; deals fairly and ethically with everyone; presents facts in an honest and direct manner; maintains strict confidentiality of sensitive information.
Innovation: Looks for ways to improve workplace effectiveness; solicits the creative ideas of others; efficiently works within budget and time constraints; exhibits willingness to work out of comfort zone.
Diversity: Values differences in people; understands different perspectives and frames of reference; recognizes the link between diversity and organizational success and supports an inclusive workplace.
Customer Focus: Dedicated to meeting expectations and requirements of internal and external customers; maintains effective relationships across organizations.
Teamwork: Communicates openly and values honesty; listens to others; works with others toward common goals.

WORKING CONDITIONS/PHYSICAL REQUIREMENTS:

Infrequent travel required (10%)

About Southern Company Gas

Southern Company Gas is a wholly owned subsidiary of Atlanta-based Southern Company (NYSE:SO), America’s premier energy company. Southern Company Gas serves approximately 4.2 million natural gas utility customers through its regulated distribution companies in four states and approximately 600,000 retail customers through its companies that market natural gas. Other nonutility businesses include investments in interstate pipelines and ownership and operation of natural gas storage facilities. For more information, visit southerncompanygas.com .

Southern Company (NYSE: SO) is a leading energy provider serving 9 million residential and commercial customers across the Southeast and beyond through its family of companies. Providing clean, safe, reliable and affordable energy with excellent service is our mission. The company has electric operating companies in three states, natural gas distribution companies in four states, a competitive generation company, a leading distributed energy infrastructure company with national capabilities, a fiber optics network, and telecommunications services. Through an industry-leading commitment to innovation, resilience, and sustainability, we are taking action to meet our customers’ and communities’ needs while advancing our commitment to net zero emissions by 2050. Our uncompromising values ensure we put the needs of those we serve at the center of everything we do and are the key to our sustained success. We are transforming energy into economic, environmental and social progress for tomorrow. Our corporate culture and hiring practices have earned the company national awards and recognition from numerous organizations, including Forbes, Military Times, DiversityInc, Black Enterprise, J.D. Power, Fortune, Human Rights Campaign and more. To learn more, visit www.southerncompany.com.

Southern Company is an equal opportunity employer where an applicant's qualifications are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or any other basis prohibited by law.

Job Identification: 6338

Job Category: Data Analytics

Job Schedule: Full time

Company: AGL Services Company
#J-18808-Ljbffr</p>

Southern Company Business Intelligence Interview Guide

Overview

Southern Company Business Intelligence Salary

Southern Company Business Intelligence Interview Process

Southern Company Business Intelligence Interview Questions

Southern Company Business Intelligence Jobs