Sr Analyst, Industry & Segment Analytics
HAZ99: Field Office - AZ Remote Location, Remote City, AZ, 85001 USA
Date Posted:
2024-11-14Country:
United States of AmericaLocation:
HAZ99: Field Office - AZ Remote Location, Remote City, AZ, 85001 USAPosition Role Type:
RemoteAre you a data analyst who is interested in strategy? The Sr Analyst, Industry and Segment Analytics is part of the Collins Aerospace Corporate Strategy organization. The Industry and Segment Analytics team is responsible for informing key decisions, crafting industry outlooks, developing platform model and regional forecasts, providing foundational data, defining key segment trends, distributing insightful analyses, educating future leaders, and serving as influential thought leaders.
The Corporate Strategy organization influences the long-term vision of Collins Aerospace by working with teams across the company focused on strategic planning and analysis, competitive intelligence, strategic forecast initiatives, critical decision support, mergers and acquisitions, portfolio analysis as well as revenue synergies. Other important stakeholders include Strategic Advisory Council (SAC), Finance, Investor Relations, Board of Directors, Customer Account Management, sales inventory operations planning (SIOP), and aftermarket teams.
This position can be worked remotely from anywhere in the domestic US.
What You Will Do:
Analyze key industry trends and leading indicators within commercial aerospace to signal business impacts to Collins Aerospace
Conduct complex forecast modeling to evaluate short and long-term scenarios to better understand size, growth and risk
Leverage Tableau to manage existing and create new insightful internal and external visualization dashboards
Develop and maintain scripts in Python and SQL using integrated development environments and relational database management systems like Jupyter, SSMS, PGAdmin, Visual Studio Code for automation, coding, debugging, and testing
Develop and maintain ETL workflows that interact with a variety of systems
Review aggregate data inputs, forecast-to-actuals, external analysis and perform deep-dives to improve business intelligence and forecasts
Provide analyses, forecasts and insights in support of team peer processes relevant to commercial fleet forecasts, utilization, and airline health assessment
Partner with strategic business units (SBUs) on future analytics projects and forecasting opportunities with internal and external data sets
Create PowerPoint presentations that are used in consultation with segment leaders to provide recommendations and develop business strategies
Provide training on key tools to various internal and external team members
Perform ad hoc requests from management and executive leadership
Present key findings to leadership in a clear and concise manner
Travel expectations <10% (Domestic 1-2 weeks a year)
What You Will Learn:
You will gain exposure and contribute to company and product strategy development.
You will learn all aspects of commercial aerospace industry dynamics, players, trends, and drivers.
You will become a subject matter expert in commercial aerospace traffic, capacity, and load factors.
Qualifications You Must Have:
Typically requires a University Degree and minimum 2 years of prior relevant experience or an Advanced Degree in a related field or in absence of a degree, 6 years of relevant experience.
Must be authorized to work in the U.S. without sponsorship now or in the future. Collins Aerospace will not offer sponsorship for this position.
2+ years of experience in a data focused role, including designing, implementing, and optimizing data pipelines and Extract, Transform & Load (ETL) processes.
Qualifications We Prefer:
Experience with MS Office, SQL, Alteryx, and Tableau
Programming skills in Python and proficiency with libraries and frameworks such as Pandas, Selenium, and SQL Alchemy
Experience working with relational databases with an emphasis on creating and maintaining database tables and views
Experience working with large-scale datasets, complex data architectures, and unstructured data
What We Offer:
Some of our competitive benefits package includes:
Medical, dental, and vision insurance
Three weeks of vacation for newly hired employees
Generous 401(k) plan that includes employer matching funds and separate employer retirement contribution, including a Lifetime Income Strategy option
Tuition reimbursement program
Student Loan Repayment Program
Life insurance and disability coverage
Optional coverages you can buy pet insurance, home and auto insurance, additional life and accident insurance, critical illness insurance, group legal, ID theft protection
Birth, adoption, parental leave benefits
Ovia Health, fertility, and family planning
Adoption Assistance
Autism Benefit
Employee Assistance Plan, including up to 10 free counseling sessions
Healthy You Incentives, wellness rewards program
Doctor on Demand, virtual doctor visits
Bright Horizons, child and elder care services
Teladoc Medical Experts, second opinion program
And more!
Learn More & Apply Now!
Diversity drives innovation; inclusion drives success. We believe a multitude of approaches and ideas enable us to deliver the best results for our workforce, workplace, and customers. We are committed to fostering a culture where all employees can share their passions and ideas so we can tackle the toughest challenges in our industry and pave new paths to limitless possibility.
#reempowerprogram
This role is also eligible for the Re-Empower Program. The Re-Empower Program helps support talented and committed professionals as they rebuild their capabilities, enhance leadership skills, and continue their professional journey. Over the course of the 14-week program, experienced professionals will gain paid, on-the-job experience, have an opportunity to participate in sessions with leadership, develop personalized plans for success and receive coaching to guide their return-to-work experience. Upon completion of the program, based on performance and contributions participants will be eligible for a career at RTX.
Collins Aerospace, an RTX company, is a leader in technologically advanced and intelligent solutions for the global aerospace and defense industry. Collins Aerospace has the capabilities, comprehensive portfolio, and expertise to solve customers’ toughest challenges and to meet the demands of a rapidly evolving global market.
At Collins Aerospace, our customers are at the core of our business. And meeting each of their unique needs is the key to our success.
Are you a strategic thinker who can see beyond the now? Be part of a team that is developing the strategy and direction of one of the biggest players in the aerospace industry. The Strategic Development team is a major influencer in the long-term vision of Collins Aerospace. Working together with teams across the company, we focus on strategic planning and analysis, mergers and acquisitions and revenue synergies. Join a team that has its pulse on the future of aerospace and watch your career take flight.
*Please ensure the role type (defined below) is appropriate for your needs before applying to this role.
Remote: Employees who are working in Remote roles will work primarily offsite (from home). An employee may be expected to travel to the site location as needed. *Position is remote; however, if you live within a reasonable commute of a Collins site with other colleagues you interact with, your manager will discuss whether there is a degree of onsite presence associated with this role.
At Collins, the paths we pave together lead to limitless possibility. And the bonds we form – with our customers and with each other -- propel us all higher, again and again.
Apply now and be part of the team that’s redefining aerospace, every day.
The salary range for this role is 64,000 USD - 128,000 USD. The salary range provided is a good faith estimate representative of all experience levels. RTX considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate’s work experience, location, education/training, and key skills.Hired applicants may be eligible for benefits, including but not limited to, medical, dental, vision, life insurance, short-term disability, long-term disability, 401(k) match, flexible spending accounts, flexible work schedules, employee assistance program, Employee Scholar Program, parental leave, paid time off, and holidays. Specific benefits are dependent upon the specific business unit as well as whether or not the position is covered by a collective-bargaining agreement.Hired applicants may be eligible for annual short-term and/or long-term incentive compensation programs depending on the level of the position and whether or not it is covered by a collective-bargaining agreement. Payments under these annual programs are not guaranteed and are dependent upon a variety of factors including, but not limited to, individual performance, business unit performance, and/or the company’s performance.This role is a U.S.-based role. If the successful candidate resides in a U.S. territory, the appropriate pay structure and benefits will apply.RTX anticipates the application window closing approximately 40 days from the date the notice was posted. However, factors such as candidate flow and business necessity may require RTX to shorten or extend the application window.
RTX is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.
Privacy Policy and Terms:
Click on this link to read the Policy and Terms
ApplyJob Profile
Must be authorized to work in the U.S. without sponsorship Onsite
Benefits/PerksAdoption Assistance And more Autism Benefit Birth, adoption, parental leave benefits Bright Horizons Child and elder care services Competitive benefits Competitive benefits package Dental Disability Disability coverage Doctor on Demand Eligible for the Re-Empower Program Employee assistance plan Employee Assistance Program Employer matching funds Employer retirement contribution Exposure to strategy development Flexible Spending Accounts Flexible work schedules Generous 401k Generous 401k plan Healthy You Incentives Home and auto insurance Innovation Life Insurance Life insurance and disability coverage Medical Medical, dental, and vision insurance Optional coverages Ovia Health, fertility, and family planning Paid Time Off Parental leave Parental leave benefits Pet Insurance Re-Empower Program Remote work Retirement Scholar program Second opinion program Student Loan Repayment Student Loan Repayment Program Subject matter expertise Teladoc Medical Experts Three weeks of vacation Three weeks of vacation for newly hired employees Tuition reimbursement Tuition reimbursement program Vacation Virtual doctor Virtual doctor visits Vision Vision Insurance Wellness Wellness rewards Wellness rewards program
Tasks- Analysis
- Analyze industry trends
- Conduct forecast modeling
- Create presentations
- Debugging
- Develop
- Develop business strategies
- Develop dashboards
- Development
- Forecasting
- Maintain scripts
- Plan
- Planning
- Provide training
- Strategic Planning
- Support
- Testing
Account management Aerospace Aerospace Industry Alteryx Analysis Analytics Assessment Automation Business Business Intelligence Coaching Coding Competitive Intelligence Core Dashboards Data Data analysis Database Management Databases Data Pipelines Debugging Defense Defense industry ETL ETL Processes Finance Forecasting Forecast modeling Innovation IT Leadership Legal Mergers and acquisitions Modeling MS Office Operations Operations Planning Organization Pandas Planning PowerPoint Product Strategy Programming Python Recommendations Relational Database Management Systems Sales SQL Strategic planning Strategy Strategy Development Tableau Testing Training Visualization Workflows
Experience2 years
EducationAdvanced degree Advanced Degree in a related field Analytics AS Business Degree Education Finance IT Legal MS Operations Related Field University Degree
TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9