Summer Intern, Business Intelligence

KGPCo is the go-to partner to Communications Service Providers. Our customers rely on our extensive range of network solutions and services to help them build, maintain, and transform networks that connect the world.

The communications industry is evolving every day and we are at the frontline of these innovations. From ground to cloud, the work we do is transforming networks and impacting communities nationwide. It's work that happens because of our motivated teams of doers and problem solvers.

Our Core Values define how we do business:
* The Customer is Everything.
* Relationships Matter. All of Them.
* Question Things. Take Action.
* Work Hard. Work Smart. Enjoy the Experience.
* Growth Mindset.

It's not just a job - it's a step in your career!

SUMMARY

This internship position does not offer relocation assistance, and candidates must be able to work at the designated location without employer-provided relocation support. Additionally, this position is not eligible for U.S. work visa sponsorship. Candidates must be legally authorized to work in the United States at the time of application and for the duration of the internship without sponsorship.

The Business Intelligence Intern is responsible for analyzing and reviewing data that is collected in our current and future products and services. Working with our Data Scientist team, the Business Intelligence Intern would need to be able to take this data and apply to the markets our products are in for us to better serve our customers. This position will require a high degree of attention to detail along with ability to review calculations for quality assurance. Troubleshooting and problem solving, as well as working closely with managers and software developers to solve these problems, will also be needed. This position requires good communication and organization skills, along with a working knowledge of day to day operations and priorities within their department and the company. Experience with Microsoft Excel preferred; skills in SQL, Tableau, Microsoft Power BI, and/or R/Python are helpful but not required. Assume other duties as assigned.

ESSENTIAL DUTIES & RESPONSIBILITIES

Assist in the development and maintenance of PowerBI dashboards and reports.
• Collaborate with team members to gather and analyze data requirements.
• Utilize SQL to extract and manipulate data from various databases.
• Apply DAX (Data Analysis Expressions) to create complex calculations and measures.
• Support data cleaning, transformation, and visualization tasks.
• Participate in team meetings and contribute to project planning and execution.
• Provide insights and recommendations based on data analysis.

SAFETY DUTIES & RESPONSIBILITIES

• Adhere to, promote, and accept responsibility for compliance to Federal and Local Occupational Safety and Health Regulations, Industry Consensus Standards, and KGPCo Injury and Illness Prevention Program Manual.
• Participate in job site safety and hazard analysis.

QUALIFICATION REQUIREMENTS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform essential functions.

EDUCATION and/or EXPERIENCE

• Currently pursuing an undergraduate degree in Computer Science, Information Technology, or a related field.
• Coursework or experience in data analysis, data visualization, or related areas.
• Self-taught proficiency in PowerBI, with a portfolio or examples of previous work.
• Experience with SQL for data extraction and manipulation.
• Familiarity with DAX for creating measures and calculations in PowerBI.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Attention to detail and a passion for working with data

Preferred Qualifications:

• Previous internship or project experience in data analytics or business intelligence.
• Knowledge of other data visualization tools or programming languages (e.g., Python, R).

REQUIRED SKILLS

• Ability to read and understand basic instructions, short communications, and memos; draft simple written correspondence; and effectively communicate in one-on-one or small group settings with customers, clients, and colleagues.
• Proficiency in adding, subtracting, multiplying and dividing. Capable of performing calculations involving American currency and standard units of weight, volume, and distance.
• The ability to follow written, verbal, or diagram-based instructions and solve problems involving concrete variables in standardized situations.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of this position.

While performing the duties of this position, the employee is regularly required to listen and speak. The employee frequently is required to sit, use their hands to handle, touch, or feel objects, tools, or controls, and reach with their arms and hands.

Specific vision abilities required by this position include close vision, color vision, peripheral vision and the ability to adjust focus.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually moderate.

BENEFITS

• Medical, Dental, Vision and Supplemental insurance plans
• Flexible Spending Accounts
• 401(k) with Company match
• Generous vacation, holiday, and sick/safe time
• Pet insurance for our non-human family members

KGPCo is an Equal Opportunity Employer - M/F/Veteran/Disability/Sexual Orientation/Gender Identity