Data Analyst (Loyalty Program and Credit Cards) - Seattle, WA

Details: • 1.5 Year Contract, Through 2026 - Potential to Extend/Convert • 100% Onsite: Seattle, WA 98188 • $40/hr - $47/hr • Monday - Friday, 8am - 5pm • Must be USC or Permanent Resident. No C2C or Visa Sponsorships. • Must be able to work on W2. MUST HAVE: (1 of the following to be considered) • Customer Loyalty Experience OR • Credit Cards Experience OR • Data Bricks Experience Role Summary The Loyalty Economics Analyst is a subject matter expert in Loyalty programs for our airline. This role supports the Loyalty team to deliver high quality, sustainable loyalty program features and benefits to guests. As an individual contributor, this role manages analytics projects to support loyalty program growth and engagement metrics and manages financial and data analysis and reporting for operational performance, product, and feature development. Key Duties: • Leads analyses for Loyalty program initiatives, including cobrand credit card analysis and reporting, new product or feature launches, product or market tests, and historical data analyses to support recommendations. • Performs complex analysis to inform optimal program design and structure decisions. • Manages the analysis and preparation of business reporting in conjunction with Financial Planning and Analysis (FP&A), and Loyalty Accounting on the monthly loyalty Profit and Loss (P&L) (e.g., forecasting, identifying resulting variances, conducting analyses, and formulating recommendations). • Automates ETL workflows to support Loyalty programs and promotions • With minimal direction from leadership, mines for customer insights and recommend optimizations across lifecycle programs, offers and channels to grow guest loyalty. • Models and forecast costs of loyalty offers, elite benefits and incentives in collaboration with loyalty principals and develops reporting to track performance vs. forecast. • Develops and implements forecasting tools, commercial and operational dashboards leveraged by operational managers, channel/product owners and vendor partners to manage the business. • Develops reports, PowerPoints, and dashboards on an ad-hoc basis to support the business as assigned. • Proactively drives analysis to inform annual budgeting and planning. • Analyzes data for new and maturing product/service initiatives and conducts competitive benchmarking. Required: • 2-4+ years of experience in data analysis or financial analytics roles within aviation, e-commerce, technology, hospitality, marketing, or a loyalty-related area. • Bachelor's degree in Business, Marketing, Economics, Computer Science, or Technical Degree (Engineering), or an additional two years of relevant training/experience in lieu of this degree. • Strong communication skills (e.g., verbal, written, and listening) with an ability to communicate clearly and concisely to both internal and external stakeholders. • Proficiency with Microsoft Office applications (e.g., Word, Excel, PowerPoint, and Outlook) • Proficiency in database querying and business intelligence tools such as SQL, Databricks, Tableau, and Tableau Prep • Advanced in Excel and able to work with data analysis tools, statistical/reference formulas, and pivot tables. • Detail oriented and highly organized, with ability to multi-task and work independently. • High school diploma or equivalent. • Must be authorized to work in the U.S. Preferred: • Knowledge of loyalty program and co-brand credit card mechanics. • Experience with Python for data manipulation and analysis. • Experience with cloud technologies, Azure, Databricks. • Demonstrated ability to have significant impact on products, services, or financial performance with data-driven recommendations. • Detail oriented in the delivery of work product and identifying idiosyncrasies in guest-facing experiences or inconsistencies in data sources. • Experience tracking and reporting on financial and operational performance of consumer-facing products or services. • Proven ability to gather, prep and blend data, then present complex data sets in a compelling and concise format. #AJ1 Job Types: Full-time, Contract Pay: $40.00 - $50.00 per hour Benefits: • 401(k) • Dental insurance • Health insurance • Vision insurance Work Location: In person