Our Fortune 100 financial services client is seeking a Loyalty Customer Data Analyst to support the Loyalty team in delivering high quality, sustainable loyalty card program features and benefits to guests.
Requirements
- Proficiency with Microsoft Office applications (e.g., Word, Excel, PowerPoint, and Outlook)
- Proficiency in database querying or business intelligence tools such as Structured Query language (SQL), Alteryx, Toad, Tableau
- Advanced experience in Excel and ability to work with data analysis tools, statistical/reference formulas, and pivot tables.
- Experience with Python for data manipulation and analysis
- Experience with cloud technologies, Azure, Databricks
- Knowledge of loyalty program and co-brand credit card mechanics.
- Experience tracking and reporting on financial and operational performance of consumer-facing products or services.
Responsibilities
- Lead analyses for Mileage Plan program initiatives, including new product or feature launches, product or market tests, and historical data analyses to support recommendations.
- Perform complex analysis to inform optimal program design and structure decisions.
- Manage 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).
- Automate ETL workflows to support Loyalty programs and promotions.
- Mine for customer insights and recommend optimizations across lifecycle programs, offers, and channels to grow guest loyalty.
- Model and forecast costs of loyalty offers, elite benefits, and incentives in collaboration with loyalty principals; develop reporting to track performance vs. forecast.
- Develop and implement forecasting tools as well as commercial and operational dashboards leveraged by operational managers, channel/product owners, and vendor partners to manage the business.
Other
- 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 relevant degree.
- Strong communication skills (e.g., verbal, written, and listening) with an ability to communicate clearly and concisely to both internal and external stakeholders.
- Detail-oriented and highly organized, with ability to multi-task and work independently.
- Location: Hybrid in Seattle, WA 98158 (4 days per week required onsite)
