Strategic Operations Intern - Summer 2027

Republic Airways; Carmel (IN); On-site; USD 21,000 - 34,000; Full time

Benefits offered by this job

Mentorship program

Shadow departments

Professional development workshops

Departmental information sessions

Direct exposure to aviation industry

Job summary

Republic Airways offers an internship program in Carmel, IN that provides hands-on analytics work within Operations. You will shadow multiple departments, participate in mentorship, and collaborate on projects that influence scheduling, capacity planning, and performance insights.

You’ll develop advanced Excel skills, learn BI tools like Tableau or Power BI, and work with cross-functional teams on real-world data problems. This paid internship supports student growth and professional development.

Qualifications

• Pursuing a bachelor’s degree in Aviation Management, Industrial Management, Engineering, Finance, Mathematics, Statistics, Business Analytics, or other related analytical fields.
• Minimum 3.0 GPA on a 4.0 scale.
• Advanced analytical skills using Excel, including PivotTables, Power Query, formulas, and basic data modeling.
• Ability to work both independently and collaboratively in a business group.
• Strong analytical and communication skills.
• Familiarity with Tableau or Microsoft Power BI or other data visualization product.

Responsibilities

• Aggregate, analyze, and transform data from a variety of sources into actionable dashboards, reports, and business insights.
• Analyze operational performance, capacity trends, and resource constraints to identify improvement opportunities and support planning decisions.
• Prepare or reconcile budgets /data for various parts of Operations.
• Develop automated tools, dashboards, and performance metrics to track operational performance and resource utilization.
• Display information on data visualization platforms to support management decision making.
• Develop new reporting and analytical methods to improve process efficiency and accuracy.
• Utilize AI, automation, and advanced analytics tools to improve reporting efficiency and business processes, where appropriate.
• Communicate financial and technical information to cross-departmental teams.
• Perform other duties, analyses, reports, and presentations as assigned.

Skills

Excel

PivotTables

Power Query

Data modeling

Education

Bachelor's degree in analytics or related field

GPA 3.0+

Tools

Tableau

Power BI

Excel

Job description

Job Category:Human ResourcesProgram 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 programAbility to shadow various departmentsProfessional development workshops and departmental information sessionsDirect exposure to aviation industry, facilities tours, etc.Additional opportunities to work with other interns directly on projectsRelocation assistance provided, if applicableCompetitive hourly payESSENTIAL DUTIESTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Aggregate, analyze, and transform data from a variety of sources into actionable dashboards, reports, and business insightsAnalyze operational performance, capacity trends, and resource constraints to identify improvement opportunities and support planning decisions.Prepare or reconcile budgets /data for various parts of OperationsDevelop automated tools, dashboards, and performance metrics to track operational performance and resource utilizationDisplay information on data visualization platforms to support managem ent decision makingDevelop new reporting and analytical methods to improve process efficiency and accuracyUtilize AI, automation, and advanced analytics tools to improve reporting efficiency and business processes, where appropriateCommunicate financial and technical information to cross-departmental teamsPerform other duties, analyses, reports, and presentations as assignedEDUCATION and/or EXPERIENCEPursuing a bachelor’s degree (B.A. / B.S.) in Aviation Management, Industrial Management, Engineering, Finance, Mathematics, Statistics, Business Analytics, or other related analytical fieldsMinimum 3.0 GPA on a 4.0 scaleAdvanced analytical skills using Excel, including PivotTables, Power Query, formulas, and basic data modeling.Ability to work both independently and collaboratively in a business groupStrong analytical and communication skillsFamiliarity with Tableau or Microsoft Power BI or other data visualization productOTHER QUALIFICATIONSAbility to work onsite at our Carmel Headquarters location, unless otherwise directed by manager .Ability to work up to 40 hours per week with a minimum of 20 hours for spring and fall internsEligible to work in the United States without sponsorshipLANGUAGE SKILLSAbility 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 ABILITYAbility 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 MAKINGMakes 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 DEMANDSThe physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job.Able to move about the work environment .F requently required to stand, walk, sit, talk and hear.WORK ENVIRONMENTThe work environment characteristics described here are representative of those an associate encounters while performing the essential functions of this job.Typically not exposed to extreme environmental conditions.EQUAL OPPORTUNITY EMPLOYER, DISABILITY, AND VETERAN ACCOMODATIONSAll qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.Equal Opportunity Employer, Disability and Veteran AccommodationsAll qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.