Intern Gas Services-SQL

Job Description

What this Department does:

The Business Analyst groups provide a variety of analytical services that support and promote the gas services department, including but not limited to analysis in the following areas: Financial (forecast support), Invoicing, Contracts Administration, Regulatory and systems/IT (reporting and system user). Tallgrass seeks a highly skilled SQL Reporting Intern to develop and support our growing analytics needs as an infrastructure company.

Responsibilities

What You'll Do

In this role, you will be responsible for creating SQL views that will be leveraged for customer-facing reports. These views will replace aging reports that no longer satisfy the business needs. You will work directly with a team of mentors that will educate you on the business mechanics of the natural gas industry. This internship offers a hands-on opportunity to gain valuable experience in SQL reporting and business process implementation.

You Can Expect To

• Develops, designs, and optimizes SQL queries to create custom views for reporting.
• Be able to give and receive feedback on requirements or code reviews and accurately apply comments/feedback.
• Participate in SQL modernization projects.
  
  

Qualifications

What you will bring:

Education

Currently pursuing an accredited degree in Computer Engineering, Computer Science, Management Information Systems, or related field with an expected graduation date of December 2024-December 2025

Experience/Specific Knowledge

• Coursework or experience in SQL technology
• Coursework or experience in SQL BI Developments (SSRS/PowerBI/MSSQL)
• Coursework or familiarity with Atlassian tools (Jira, Confluence)
  
  

What Will Make You Stand Out

• Ability to work independently on projects and within a remote team environment.
• Ability to execute assigned projects within established deadlines.
• Analytical and problem-solving skills.
• Verbal and written communication skills.
• Self-motivated and eager to contribute.
• Proficient in SQL.
• Proficient in Microsoft Office Suite (Word, Excel, PowerPoint).
• Strong analytical skills and attention to detail.
  
  

What Else You Need To Know

Our internships are temporary full-time positions, in-person/remote hybrid at our Lakewood, CO. office. We will host our Summer 2025 interns from May-August for 10 weeks.

Compensation And Other Benefits

• Pay Range $26.29-30.04 USD hourly
• You may be eligible for a stipend to subsidize housing costs
• The final pay for this role will depend on a variety of factors, including a specific candidate's experience, qualifications, skills, and working location. The total compensation package for this role may also include overtime pay, paid time off, a housing stipend, and more.
  
  

About Us

Tallgrass was named one of the 2023 Top Workplaces USA and highlighted in Colorado's Top Workplaces for the past seven consecutive years. Tallgrass is a leading energy infrastructure company focused on safely, reliably, and sustainably delivering the energy and services that power our nation and enable our quality of life.

At Tallgrass, we value our teams and strive to create an environment where employees feel respected, and their contributions are valued. We aim to support employees' physical, mental, and financial well-being through a comprehensive Total Rewards Program.

• Industry competitive pay
• Health insurance package options that include Flexible Spending & Health Savings Accounts
• Infertility Coverage
• Parental Leave
• 401(k) with up to a 6% match that vests immediately plus an employer discretionary contribution of up to 4%
• Wellness Programs and Mental Health Resources
• Employer-paid life insurance, short-term disability, and long-term disability coverage
• Critical Illness & Accident Insurance
• Vacation, sick days, paid caregiver leave, volunteer and bereavement paid time off
• Identity theft protection
• Annual discretionary bonus
• Generous Tuition Reimbursement Program
• Company-paid holidays and floating holidays
• Company vehicle (if applicable)
• Employee discounts; vehicles, tires, cellular plans, and more
• Networking and employee engagement events
• Personal development to grow your career with us based on your strengths and interests
  
  

Application Deadline: Recruiting timelines vary by position; however, all Tallgrass positions accept applications for at least five business days from the posting date. This position is open and still accepting applications.

Compensation: Compensation ranges are provided in good faith based on what we anticipate when researching wages for this position at the state and national levels. We may ultimately pay more or less than the posted range. This salary range may also be modified in the future.

Notice to External Search Firms: Tallgrass does not accept unsolicited resumes from search firms or employment agencies. Unsolicited referrals and resumes are considered Tallgrass property; therefore, Tallgrass will not pay a fee for any placement resulting from the receipt of an unsolicited referral. Approved vendors may be invited to refer talent for specific positions at Tallgrass's request only. A fully executed agreement with Tallgrass must be in place and current in these cases.

EEO Statement: Tallgrass complies with all Equal Employment Opportunity (EEO) affirmative action laws and regulations. Tallgrass does not discriminate on the basis of age, race, religion, color, sex, national origin, marital status, genetic information, sexual orientation, gender Identity and expression, disability, veteran status, pregnancy status, or other status protected by law.