Data Analytics Intern - Summer 2027

We need to output only HTML fragment, with headings

for sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. Must not repeat job title. Must not include Job ID etc. Must preserve all substantive info, not invent or summarize away detail. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. We need to parse the posting. Content: - Job Category Human Resources Program Overview and Benefits: Republic Airways is proud to offer an internship program that prepares students for the workforce. While we provide resources to help interns sharpen skills and make meaningful contributions in their department, we also provide the following during the internships: - Mentorship program - Ability to shadow various departments - Professional development workshops and departmental information sessions - Direct exposure to aviation industry, facilities tours, etc. - Additional opportunities to work with other interns directly on projects - Relocation assistance provided, if applicable - Competitive hourly pay - Essential Duties (list): - Analyzes business and operational data to identify trends, generate insights, and communicate findings through reports, dashboards, and visualizations. - Supports the end-to-end analytics lifecycle, including requirements gathering, development, testing, validation, and delivery of data products. - Develops and maintains automated data pipelines, data transformations, and Power BI dashboards to improve reporting efficiency and scalability. - Supports the finance team's delivery of monthly and ad-hoc financial and operations reporting - Delivers high-quality work in a collaborative environment using agile practices, version control systems, documentation standards, and project management tools. - Performs other duties as assigned - Preferred Skills And Experience (list): - Advanced Microsoft Office skills; specifically, Excel - Familiarity with Tableau or Microsoft Power BI - Proficient in data wrangling and transformation techniques using SQL and related tools. - Programming skills in R or Python - Knowledge of advanced statistical methods and machine learning techniques - Familiarity with corporate financial statements and basic accounting methods - Experience with code repository tools and agile development methodology - EDUCATION (list?): - Pursuing a bachelor’s degree (B.A. / B.S.) in Data Science, Computer Science, Statistics or related area. - Minimum 3.0 GPA on a 4.0 scale - Demonstrates teamwork and collaboration skills - Strong communication skills including the ability to translate and generalize technical jargon - Appetite to continually learn new skills, methods and technologies - Other Qualifications (list): - Ability to work onsite at our Carmel Headquarters location, unless otherwise directed by hiring manager - Ability to work up to 40 hours per week with a minimum of 20 hours for spring and fall interns - Eligible to work in the United States without sponsorship - Language Skills (list): - Ability to read, analyze, and interpret common scientific and technical journals, financial reports, and legal documents. - Ability to respond to common inquiries or complaints from customers, regulatory agencies, or members of the business community. - Ability to effectively present information to top management, public groups, and/or boards of directors. - REASONING/PROBLEM SOLVING ABILITY (list): - Ability to define problems, collect data, establish facts, and draw valid conclusions. - Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables. - Able to read and interpret technical, regulatory and contractual documentation. - Able to maintain confidentiality. - DECISION MAKING (list): - Makes day to day decisions used to support strategic direction. - Decisions often require some thought without established precedents or procedures. - Decisions tend to be short term and usually of moderate cost. - Able to work independently or as part of a team to drive results. - PHYSICAL DEMANDS (list): - Able to move about the work environment. - Frequently required to stand, walk, sit, talk and hear. - WORK ENVIRONMENT (list): - Typically not exposed to extreme environmental conditions. - Then duplicate EEO etc. Remove. We need to map to sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide which content goes where. - About the role: Could be the program overview paragraph (first paragraph). That's about the internship program. - Responsibilities: Essential Duties. - Requirements: Could be Education and maybe other qualifications? Usually Requirements includes education, GPA, eligibility, etc. Could be "Requirements" section. - Qualifications: Could be Preferred Skills And Experience? Or maybe "Qualifications" includes both required and preferred? The instruction says use headings for sections like Qualifications, Skills, Benefits, Pay, Schedule. We need to decide mapping. We have "Preferred Skills And Experience" which is skills. So Skills heading. We have "Other Qualifications" (onsite, hours, eligibility) maybe goes under Requirements or Qualifications. Could be Requirements. We have Language Skills, Reasoning/Problem Solving Ability, Decision Making, Physical Demands, Work Environment. Those could be under Qualifications or maybe separate sections like Requirements? But we only have limited headings. We could combine many under Qualifications or Requirements. We must not create sections with filler like "not specified". We have actual content for each of those sub-sections, so we can include them under a heading like "Qualifications" as a list. But we also have Benefits: we have Mentorship program, ability to shadow, professional development workshops, direct exposure, additional opportunities, relocation assistance, competitive hourly pay. Those are benefits. So Benefits heading. Pay: we have "Competitive hourly pay" mentioned under Benefits but also could be separate Pay heading. The instruction says include Pay section only if posting actually states them. It does state competitive hourly pay, but no specific number. However "competitive hourly pay" is vague but still states pay. Should we include Pay heading? The instruction: "never emit a heading followed by filler/placeholder text (e.g. "commensurate with experience", "not specified", "N/A", "varies", "TBD")". "Competitive hourly pay" is not a specific number but it's not filler like "commensurate with experience"? It's somewhat vague but still a statement. It's not "commensurate with experience" but it's still non-specific. Might be considered filler? The instruction says avoid filler like "commensurate with experience". "Competitive hourly pay" is similar. Safer to not create Pay section if it's just generic. However we already have competitive hourly pay listed under Benefits. Could incorporate that into Benefits. The instruction: "Prefer a few substantive sections over many thin ones." So we can combine pay into Benefits. Schedule: we have ability to work up to 40 hours per week with minimum 20 hours for spring and fall interns. That's schedule info. So we can have Schedule heading. Thus sections: - About the role (program overview) - Responsibilities (essential duties) - Requirements (education, GPA, eligibility to work in US, maybe language skills? but language skills could be under Qualifications) - Qualifications (preferred skills and experience, other qualifications like onsite, hours? but hours already schedule; maybe other qualifications like ability to work onsite, etc.) - Skills (maybe we already used Qualifications for preferred skills; but we need Skills heading per instruction. Could put preferred skills under Skills.) - Benefits (mentorship, shadowing, workshops, exposure, projects, relocation assistance, competitive hourly pay) - Schedule (hours per week) We must not repeat job title. We must not include boilerplate like EEO etc. We must output only HTML fragment. Let's craft:

About the role

Republic Airways is proud to offer an internship program that prepares students for the workforce. While we provide resources to help interns sharpen skills and make meaningful contributions in their department, we also provide the following during the internships:

• Mentorship program
• Ability to shadow various departments
• Professional development workshops and departmental information sessions
• Direct exposure to aviation industry, facilities tours, etc.
• Additional opportunities to work with other interns directly on projects
• Relocation assistance provided, if applicable
• Competitive hourly pay

But note that competitive hourly pay is also in Benefits; we already listed it there. Might duplicate. Better to keep About the role just the overview paragraph without list; then Benefits section includes those items. Let's restructure. About the role: just the paragraph describing program overview. Then Benefits: list of mentorship, shadowing, workshops, exposure, projects, relocation assistance, competitive hourly pay. Responsibilities: essential duties list. Requirements: education, GPA, eligibility to work in US, maybe language skills? Actually language skills is a skill; but we can put under Qualifications. Qualifications: preferred skills and experience, other qualifications (onsite, hours? but hours schedule), language skills, reasoning/problem solving, decision making, physical demands, work environment. Skills: maybe we separate preferred skills as Skills heading, and other qualifications as Qualifications? But we have both Skills and Qualifications headings allowed. Let's assign: - Skills: Preferred Skills And Experience list. - Qualifications: Education, GPA, eligibility, language skills, reasoning/problem solving, decision making, physical demands, work environment, other qualifications (onsite, hours? but hours schedule). However we have Schedule heading for hours. Thus Qualifications includes education, GPA, eligibility, language skills, reasoning/problem solving, decision making, physical demands, work environment, ability to work onsite. Schedule: ability to work up to 40 hours per week with minimum 20 hours for spring and fall interns. Pay: we omitted; but we have competitive hourly pay in Benefits. Could we add Pay heading with "Competitive hourly pay"? Might be considered filler but it's a statement. However we already have it in Benefits; maybe we can keep it only in Benefits to avoid thin Pay section. The instruction: "Prefer a few substantive sections over many thin ones." So better to not create Pay section if we already have that info in Benefits. Thus final sections: About the role, Benefits, Responsibilities, Skills, Qualifications, Schedule. Check that we have not missed any substantive info: Mentorship program, shadowing, workshops, exposure, projects, relocation assistance, competitive hourly pay (in Benefits). Essential duties list (Responsibilities). Preferred skills list (Skills). Education, GPA, eligibility, language skills, reasoning/problem solving, decision making, physical demands, work environment, ability to work onsite (Qualifications). Schedule: hours per week. We omitted "Ability to work up to 40 hours per week with a minimum of 20 hours for spring and fall interns" -> Schedule. We omitted "Eligible to work in the United States without sponsorship" -> Qualifications. We omitted "Ability to work onsite at our Carmel Headquarters location, unless otherwise directed by hiring manager" -> Qualifications. We omitted "Demonstrates teamwork and collaboration skills", "Strong communication skills including the ability to translate and generalize technical jargon", "Appetite to continually learn new skills, methods and technologies" from Education bullet list. Those are under Education bullet list; they are more like qualifications. Should we include them in Qualifications? Yes. Thus Qualifications list will include: - Pursuing a bachelor’s degree (B.A. / B.S.) in Data Science, Computer Science, Statistics or related area. - Minimum 3.0 GPA on a 4.0 scale - Demonstrates teamwork and collaboration skills - Strong communication skills including the ability to translate and generalize technical jargon - Appetite to continually learn new skills, methods and technologies - Eligible to work in