Crew helps our clients deliver change through IT project delivery, business process improvement, and operational efficiency efforts. Our consultant training programs, investment in career development, and premier client portfolio ensure constant challenge and rapid growth for our employees. Crew data analysis associates bring data insights to life with predictive and descriptive analytics, create meaningful business intelligence and data visualization dashboards, and learn data profiling and cloud data practices.
Requirements
- Proficiency in SQL and experience with large relational databases (Oracle, Teradata)
- Exposure to coding
- Familiarity with SQL, Python and AWS (S3, Lambda, Glue, etc.)
Responsibilities
- Perform detailed impact analysis and scenario planning related to pilot contracts, schedules, and pay structures
- Develop a working knowledge of the Delta Pilot Working Agreement (PWA) and FAA regulations
- Use data to ensure compliance and anticipate downstream impacts
- Build presentations and reports that translate complex analytics into compelling business cases for leadership and stakeholders
- Extract, clean, and transform large datasets using SQL, Oracle, and Teradata
- Leverage Python and AWS for advanced analytics where possible (ETLs creating a pipeline)
- Partner with internal teams to streamline workflows, automate recurring analyses, and identify opportunities for operational efficiency
Other
- 0–2 years of experience in analytics, consulting, or related field
- Strong analytical problem-solving skills with the ability to connect detail to business impact
- Clear and confident communication skills, including data storytelling and presentation development
- High intellectual curiosity, resilience, and ability to learn quickly in ambiguous environments
- PowerPoint skills
