Intern - Business Intelligence Analyst - Summer 2025 - Lumen

Legal Statement

In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information.

The Role

Lumen offers a fully immersive, 10-week summer internship program. Our interns demonstrate curiosity, innovation, and a passion for advancing technology. We believe that empowering our people and helping them reach their full potential is essential for the long-term success of both Lumen and our customers.

Program dates: May 30 – August 8, 2025.

Location

• This position is fully remote/ work from home with potential for in-person collaboration in local Lumen Offices such as Denver, CO.

The Main Responsibilities

As a Business Intelligence Analyst intern in our Enterprise Operations organization, the Intern will work collaboratively with our Enterprise Operations Reporting-Deep Analytics team to support project management systems and processes specifically around data collection, reporting development, data analytics, and automation required to onboard and maintain data for customers. Tasks during the 10 weeks will focus on transforming data into meaningful insights that drive strategic decision-making within the organization.  This role involves gathering, analyzing, and interpreting large datasets to inform business operations, identify trends, support data-driven decision making, and to improve efficiency in the business/team.

Phase 1: Understanding the Business Requirements

• Begin by meeting with key stakeholders to understand their data needs and the business problems they are looking to solve. This phase involves:
• Conducting interviews and surveys with department team members and/or decision-makers.
• Identifying key performance indicators (KPIs) and metrics that are crucial for the business.
• Documenting the requirements in a detailed project plan.

Phase 2: Data Acquisition

• In this phase, you will collect data from various sources, including:
• Conduct a thorough review of current datasets used within the organization.
• Identify common data fields and structures that can be standardized.
• Design a Star Schema model that fits the business requirements.
• Transform raw data into the designed schema format.
• Ensure data accuracy and integrity by implementing validation checks.
• Evaluate the quality and completeness of the data.
• Ensure the data is in a format that is compatible with your analysis tools.

Phase 3: Data Cleaning, Preparation, Testing and Validation

• Data cleaning is a critical step to ensure the accuracy of your analysis. This phase includes:
• Removing duplicates and irrelevant information.
• Handling missing data through imputation or deletion.
• Normalizing data to ensure consistency.
• Creating test cases to validate the dataset.
• Conducting performance tests to ensure scalability.
• Documenting any issues and working on resolutions.

Phase 4: Data Analysis

• Employ various analytical techniques to interpret the data. This can involve:
• Descriptive statistics to summarize the data.
• Predictive analytics to forecast future trends.
• Data mining techniques to uncover hidden patterns.
• Tools such as R, Python, and SQL will be instrumental in this phase.

Phase 5: Visualization and Reporting

• Create visualizations to make the data easily understandable. This can include:
• Dashboards using tools like Tableau or Power BI.
• Graphs and charts to highlight key findings.
• Interactive reports that allow stakeholders to explore the data.

Phase 6: Presenting Findings and Recommendations

• Conclude the project by presenting your findings to the stakeholders. This phase involves:
• Preparing a comprehensive report summarizing the project's outcomes, challenges faced, and lessons learned.
• A fully developed standard dataset adhering to the Star Schema model.
• Comprehensive documentation including dataset structure, validation checks, and test cases.
• Providing actionable recommendations based on the data insights.
• Conducting a presentation to showcase your findings and answer any questions.

What We Look For in a Candidate

Program eligibility is contingent on the candidate’s commitment of the entire 10-week program. No exceptions will be made.

• Required qualifications
  • Enrolled at a 4-year accredited college or university, rising senior level education status at the start of the internship
  • Graduating August 2025 – May 2027
  • Preferred fields include bur not limited to: Computer Science, Information Systems or related field.
  • Intern must be able to work 40 hours per week during the 10-week program (May 30 – August 8, 2025)
  • US work authorization is required. Individuals needing visa sponsorship are not eligible.
• Proficiency and understanding of:
  • Microsoft Office Suites with emphasis in Microsoft Excel knowledge.
  • Familiarity and/or proficiency in data analysis and data transformation tools such as SQL, R, Python, or similar
  • Data Mining, Data Modeling, Data Cleaning and Database Design Principles
  • Analyze complex data sets to identify patterns, trends, and insights
  • Develop data models and visualizations that effectively communicate findings
  • Apply statistical methods and techniques to analyze data
  • Managing Data Privacy
  • Project Management:  Ability to manage projects and deadlines
  • Microsoft Power BI experience is a plus
  • Data Analytics experience is a plus
• Professional Attributes
  • Critical thinking, analytical, and problem-solving skills
  • Attention to detail and ability to work independently
  • Strong written and verbal communication skills
  • Adheres to deadline and delivers quality results
  • Exhibits good business judgement with the ability to overcome obstacles and think strategically to solve business problems
  • Organization and time-management skills
  • Ability to be resourceful, independent, and adaptable
  • Self-starter mentality

Compensation

Internship compensation ranges depend on each individual’s level of education, geographic location, and experience/qualifications aligned to the role.

Hourly Based Pay Range:
Min: $26.00/hour
Max:  $43.00/hour

What to Expect Next

After completion and submission of your application, you will be asked to participate in a virtual video interview. This on demand interview will be a way for Lumen to learn more about you and your experience as it aligns to the internship position.  A separate email invitation will be sent to you (check your spam) within 6 hours of application.  For continued consideration in the summer internship program, please ensure you complete the video interview within 5 business days of application. 

Application & Interview Timeline:

• October – First Round Interviews with top, qualified candidates
• November - Interview panel with work team
• December - All Summer 2025 offers will be extended by end of month