Senior Analyst, Loyalty Reporting
Your Role
What You’ll Do
- Write, refine, and optimize advanced SQL queries to support loyalty program reporting and analytics, ensuring accuracy and efficiency.
- Analyze customer and transaction data to generate insights that support loyalty program strategies, performance tracking, and optimization.
- Develop robust reporting frameworks that align with business needs, focusing on loyalty KPIs, program participation, and customer retention metrics.
- Collaborate with cross-functional teams across the organization, including marketing, operations, and finance, to support loyalty program initiatives and decision-making.
- Provide detailed analyses of loyalty program performance, including spend trends, redemption rates, tier movement, and program ROI.
- Ensure data accuracy by conducting validation and troubleshooting across datasets and outputs.
- Identify opportunities for process improvement in loyalty reporting, including automation and standardization of queries.
- Serve as a technical and analytical resource for loyalty reporting, answering data-related questions and guiding stakeholders on best practices.
- Actively support ad-hoc requests for loyalty data and reporting while maintaining tight deadlines and prioritization of tasks.
What You Bring
- Advanced SQL expertise, with demonstrated ability to write and optimize complex queries, including joins, subqueries, and window functions.
- Strong understanding of loyalty program KPIs and metrics, including customer lifetime value, spend analysis, retention rates, and redemption metrics.
- Experience working with large datasets, ensuring data quality and resolving discrepancies effectively.
- Ability to effectively translate business requirements into actionable data queries and insights.
- Strong problem-solving skills and ability to work independently in a fast-paced environment.
- Excellent communication skills, with the ability to clearly present findings and recommendations to non-technical stakeholders.
- Proactive and detail-oriented mindset, with a focus on delivering high-quality work on time.
- Bachelor’s degree in Marketing, Finance, Economics, Mathematics, Computer Science, or a related technical discipline.
- 2+ years of experience as a Data Analyst, SQL Developer, or similar role, with a focus on loyalty program or transactional data analysis.
- 2+ years of advanced SQL experience, including writing and optimizing queries involving joins, CTEs, and window functions.
- Experience with large-scale data environments (e.g., Snowflake, Redshift, BigQuery) is highly preferred.
- Understanding of loyalty program reporting, data structures, and key business metrics.
- Proficiency in Python or a similar language for data manipulation and automation is preferred.
- Strong experience in collaborating across multiple business units and supporting various stakeholders with data-driven insights.
- Experience in the retail or e-commerce industry, specifically in loyalty or customer analytics.
- Familiarity with tools like Tableau, Power BI, or similar visualization platforms for presenting query results (though the primary focus is on writing queries).
- Familiarity with GitHub or similar version control and collaboration platforms is beneficial.
- Experience in working within hybrid or remote environments.
Inclusive Benefits
We offer an inclusive and comprehensive range of benefits to our valued associates, including:
- Medical, Dental, Vision Benefits
- Disability Benefits
- Paid Parental Leave, Paid Family Leave, and Adoption Support
- Paid Time Off
- Retirement Savings Plan (401K) and Life Insurance
- Financial Solutions
- NMG Associates Core Discount of 30%
- Personal and Professional Development Opportunities
For more information, please click “Our Benefits” section on our career site or reference the link here: https://www.neimanmarcusgroup.com/benefits
About Neiman Marcus Group
As one of the largest multi-brand luxury retailers in the U.S., with 3,000+ of the world's most desirable brand partners, we're delivering exceptional products and intelligent services enabled by our investments in data and technology. Through the expertise of our associates, we deliver and scale a personalized luxury experience across our three channels of in-store, eCommerce, and remote selling. Our NMG|Way culture, powered by our people, combines individual talents into a collective strength to make life extraordinary. Our brands include Neiman Marcus and Bergdorf Goodman.
Our legacy of innovation and culture of Belonging guide our roadmap for Revolutionizing Luxury Experiences. As a female-founded, female-majority organization that outpaces the U.S. population in racial and ethnic diversity, our people are at the heart of our progress, and we take great care to protect and empower them.
We are committed to equal employment opportunity regardless of race, color, religion, sex, pregnancy, sexual orientation, gender identity and/or expression, marital status, age, national origin, disability, genetic information, veteran status, or any other status protected by federal, state, or local law.
We are committed to providing reasonable accommodations during our Talent Acquisition process. If you have a disability and need assistance or an accommodation, please email us at ApplicantSupport@NeimanMarcus.com.