Intern - Business Intelligence Analyst - Summer 2025 - Lumen

**About Lumen** Lumen connects the world. We are igniting business growth by connecting people, data and applications - quickly, securely, and effortlessly. Together, we are building a culture and company from the people up - committed to teamwork, trust and transparency. People power progress. Lumen's commitment to workplace inclusion and employee support shines bright. We've made the Newsweek 2024 Greatest Workplaces for Diversity list and achieved a perfect score of 100 on the Human Rights Campaign Corporate Equality Index (CEI) for the fifth consecutive year. Plus, we're the top employer in the communications and telecom industry, ranking 12th overall across all industries in The American Opportunity Index. We're looking for top-tier talent and offer the flexibility you need to thrive and deliver lasting impact. Join us as we digitally connect the world and shape the future. **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 Requisition #: 334960 **Background Screening** If you are selected for a position, there will be a background screen, which may include checks for criminal records and/or motor vehicle reports and/or drug screening, depending on the position requirements. For more information on these checks, please refer to the Post Offer section of our FAQ page (https://jobs.lumen.com/global/en/faq) . Job-related concerns identified during the background screening may disqualify you from the new position or your current role. Background results will be evaluated on a case-by-case basis. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. **Equal Employment Opportunities** We are committed to providing equal employment opportunities to all persons regardless of race, color, ancestry, citizenship, national origin, religion, veteran status, disability, genetic characteristic or information, age, gender, sexual orientation, gender identity, gender expression, marital status, family status, pregnancy, or other legally protected status (collectively, "protected statuses"). We do not tolerate unlawful discrimination in any employment decisions, including recruiting, hiring, compensation, promotion, benefits, discipline, termination, job assignments or training. **Disclaimer** The job responsibilities described above indicate the general nature and level of work performed by employees within this classification. It is not intended to include a comprehensive inventory of all duties and responsibilities for this job. Job duties and responsibilities are subject to change based on evolving business needs and conditions. **Salary Range** **Salary Min :** 26 **Salary Max :** 43 This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Individual pay is based on skills, experience and other relevant factors. This position is eligible for either short-term incentives or sales compensation. Director and VP positions also are eligible for long-term incentive. To learn more about our bonus structure, you can view additional information here. (https://jobs.lumen.com/global/en/compensation-information) We're able to answer any additional questions you may have as you move through the selection process. As part of our comprehensive benefits package, Lumen offers a broad range of Health, Life, Voluntary Lifestyle and other benefits and perks that enhance your physical, mental, emotional and financial wellbeing. You can learn more by clicking here. (https://centurylinkbenefits.com) Please be advised that Lumen does not require any form of payment from job applicants during the recruitment process. All legitimate job openings will be posted on our official website or communicated through official company email addresses. If you encounter any job offers that request payment in exchange for employment at Lumen, they are not for employment with us, but may relate to another company with a similar name. Note: For union-represented postings, wage rates and ranges are governed by applicable collective bargaining agreement provisions. **Application Deadline** 10/19/2024