Oh Snap!
This job is no longer active - but you can still view the details below.

SQL Developer Intern

| Greater Boulder Area

Company Description

Zayo Group Holdings, Inc. (NYSE: ZAYO) provides communications infrastructure solutions, including fiber and bandwidth connectivity, colocation and cloud infrastructure to the world’s leading businesses. Customers include wireless and wireline carriers, media and content companies, cloud providers, finance and professional services and other large enterprises. Zayo provides customers with flexible solutions and self-service through Tranzact, an innovative online platform for managing and purchasing bandwidth.

Eligibility

The Zayo internship program is open to graduating seniors and current students. All internships are paid, full-time work experiences. All internships are from June 3* - August 9, 2019 (*start date flexible to academic obligations).

Position Description

The SQL Developer Intern will primarily be responsible for creating SQL queries, tables, and procedures based on requirements collected from the business by the Business Intelligence analysts, thereby enabling Zayo to make impactful insights. The intern should have an understanding of ETL protocol, specifically Cast Iron, and able to support the movement of data via such protocols to where the data can be best utilized. An effective intern will work well in a collaborative team environment and be willing to ask questions and interact with large or small teams of individuals.

Responsibilities

  • Responsible for designing, coding, and implementing database solutions using modern techniques and programming languages, including table design, stored procedures, and overall best practice methodologies.

  • Work harmoniously in a cross-functional team to ensure the delivery of software solutions as planned

  • Design database schema based on data modeling of business requirements and entities

  • Create, modify, read and understand stored procedures

  • Create, modify and troubleshoot SQL jobs

  • Develop, optimize and execute complex SQL queries from diverse data sets

  • Perform code reviews, analyzing execution plans, and refactoring inefficient code

  • Diagnose, triage and correct, MS SQL Server deficiencies, including, but not limited to, performance, misconfigurations, and incorrect data structures

  • Collect and review database performance metrics and proactively address performance concerns

  • Work closely with Analytics teams and provide technical expertise where needed

  • Completes documentation on all assigned systems and databases, including business rules, logic, and processes

Qualifications

  • Studying/degree in Data Science, Computer Science, Information Systems or related

  • Proficient in SQL including stored procedures

  • Experience with JSON, XML, ETL, data warehouse architecture

  • Salesforce and Einstein Analytics experience a plus

  • Ability to communicate effectively both orally and in writing

  • Strong interpersonal, teamwork, and leadership skills

  • Excellent organizational and time-management skills

Learning Outcomes

  • Gain practical experience with data warehousing and SQL coding in a real world environment

  • Exposure to business groups to develop an understanding of business practices,and the relation to data structure and business intelligence

  • Gain industry experience, an education in telecom, and understanding of Zayo’s foundational role in broadband

  • Strengthen critical thinking, problem solving, and communication skills

  • Gain an expertise understanding of Salesforce

  • Exposure to a variety of networking opportunities

Rewards

  • Excellent benefits including 401 (k) and medical for interns

  • Fitness membership discounts

  • Internships are full-time (40 hours/week), paid positions with the option of converting into full-time/part-time employment pending a successful internship.

Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.

Read Full Job Description

Technology we use

  • Engineering
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • ApexLanguages
    • ReactLibraries
    • ReduxLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • Microsoft SQL ServerDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • SalesforceCRM

Location

Our Boulder campus is located in the 29th Street Mall where employees can benefit from access to restaurants, retail, fitness and more!

What are Zayo Perks + Benefits

Zayo Benefits Overview

Zayo Group is committed to providing our employees with a benefits program that is both comprehensive and competitive. Our benefits program offers health care, dental and vision coverage, as well as financial secruity to our employees and their families.

Culture
Volunteer in local community
Partners with Nonprofits
B Strong, Greenhouse Scholars, A Precious Child, AMP the Cause, There With Care, Boulder Parks and Rec, and many more....
Friends outside of work
Eat lunch together
Open door policy
Diversity
Someone's primary function is managing the company’s diversity and inclusion initiatives
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Flexible Spending Accounts (FSAs) enable you to put aside money for important expenses & help reduce your income taxes at the same time. Zayo employees can contribute up to $2,650 annually.
Disability Insurance
If you are out of work for an extended period or time due to a disabling injury or illness, disability insurance covers 60% of annual salary up to $5000 monthly maximum payout.
Dental Benefits
Dental exams can help you & your dentist detect problems in the early stages when treatment is simpler & costs are lower. Regular exams are an important part of maintaining your medical health.
Vision Benefits
The vision plan covers routine eye exams and also pays for all or a portion of the costs of glasses or contact lenses if you need them.
Health Insurance Benefits
Each person's health care needs are different. That's why our medical plan offers multiple options (3) so that you can choose the coverage level best-suited to your personal situation.
Life Insurance
Your family depends on your income for a comfortable lifestyle and for the resources necessary to make their dreams a reality! Zayo offers Basic Term Life and AD&D as well as supplemental insurance.
Wellness Programs
Team workouts
Do you love working out? So do we which is why Zayo offers access to group fitness sessions and company-sponsored events, such as the B Strong Ride.
Retirement & Stock Options Benefits
401(K)
Zayo Group offers a 401(k) plan through Fidelity. Eligible employees may join the plan as soon as administratively feasible after their date of hire and may contribute up to the IRS limit of $19,000.
401(K) Matching
Zayo matches 50% of employee contributions up to 4% with a cap at 2% match.
Child Care & Parental Leave Benefits
Generous Parental Leave
Zayo provide 12 weeks paid maternity leave, 2 weeks paid paternity leave, and 4 weeks paid adoptive/foster leave.
Vacation & Time Off Benefits
Generous PTO
Zayo employees receive between 0 and 25 days per year of paid time off based on years of service.
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Zayo Group offers the option to elect Commuter Benefits which helps you pay for public transportation and parking costs while commuting to and from work using pretax dollars.
Game Room
Our game room includes Ping Pong, Foosball, Shuffle Board, Video Games.
Happy Hours
Happy hours are hosted twice monthly and include alcoholic and non-alcoholic options.
Parking
Parking is available at Zayo offices.
Recreational Clubs
Love sports? So do we! We offer a variety of options to get involved with your co-workers outside of the office.
Fitness Subsidies
We strongly believe that there is nothing more important than the health and well-being of our employees and families. To promote health and fitness, Zayo has partnered with GymPass.
Professional Development Benefits
Tuition Reimbursement
The tuition reimbursement program provides an opportunity for Zayo employees to further their education and to apply to be reimbursed for eligible education expenses.
Lunch and learns
Zayo is committed to providing opportunities for employees to expand and grow their knowledge base through lunch and learn sessions.
Promote from within
Mentorship program
More Jobs at Zayo87 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Operations
new
Boulder
Product
new
Boulder
Developer
new
Denver
Finance
new
Denver
Operations
new
Boulder
Operations
new
Boulder
Finance
new
Boulder
Finance
new
Denver
Developer
new
Boulder
Operations
new
Denver
Project Mgmt
new
Denver
Operations
new
Denver
Operations
new
Denver
Developer
new
Denver
Operations
new
Denver
Project Mgmt
new
Boulder
Finance
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Project Mgmt
new
Boulder
Finance
new
Boulder
Finance
new
Boulder
Finance
new
Boulder
Data + Analytics
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Sales
new
Boulder
Sales
new
Boulder
Sales
new
Boulder
Sales
new
Boulder
Data + Analytics
new
Boulder
Design + UX
new
Boulder
Sales
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Developer
new
Boulder
Operations
new
Boulder
Project Mgmt
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Developer
new
Boulder
Sales
new
Boulder
HR
new
Boulder
Sales
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Developer
new
Boulder
Developer
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Sales
new
Boulder
Sales
new
Boulder
Finance
new
Denver
Finance
new
Denver
Product
new
Denver
Finance
new
Denver
Finance
new
Denver
Marketing
new
Denver
Design + UX
new
Denver
Marketing
new
Denver
Project Mgmt
new
Denver
Project Mgmt
new
Boulder
Finance
new
Denver
Operations
new
Boulder
Operations
new
Boulder
Finance
new
Boulder
Operations
new
Boulder
Data + Analytics
new
Denver
Data + Analytics
new
Boulder
Project Mgmt
new
Denver