Company Description
We’re hiring a Workday Prism Data Warehouse Engineer to design, build, and maintain the architecture of our Workday Prism data warehouse, supporting People Analytics and Store Operations. This role will partner closely with stakeholders across HR, Stores, and Digital & Tech to model data, optimize performance, and deliver trusted insights at scale. Ideal candidates bring strong experience in SQL, data modeling, and Workday Prism, along with a passion for scalable architecture, clean data, and impactful reporting.
What Will You Be Doing?
- Data Warehouse Design: Design and develop the architecture of the Workday Prism Data Warehouse, ensuring it integrates data from Workday HCM, external systems, and operational data sources to meet reporting and analytics needs
- Data Modeling: Create and maintain data models that support People Analytics and Store Operations reporting needs, ensuring data integrity, consistency, and scalability across various data sets
- Collaboration with Stakeholders: Work closely with People Analytics, Store Operations, and Digital & Tech teams to understand data requirements and translate them into efficient data warehouse solutions
- Performance Optimization: Monitor and optimize the performance of the Prism data warehouse to handle large datasets, ensuring data queries and reports run efficiently and at scale
- Security and Data Governance: Ensure compliance with data governance policies and collaborate with team members to manage data security, access controls, and user permissions within the data warehouse. Responsible for handling sensitive and confidential data
- Report Development: Support People Analytics and Store Operations with the build and optimization of reports, dashboards, and analytics that utilize data from the Prism data warehouse
- Troubleshooting and Support: Provide ongoing support for data warehouse issues, troubleshoot performance bottlenecks, and resolve data integrity issues
- Continuous Improvement: Identify and implement improvements to the data warehouse architecture, data pipelines, and reporting capabilities to enhance operational efficiency and business decision-making. Keep up with the latest Workday Prism releases and recommend/implement enhancements
What Do You Need To Bring?
- 3+ years of experience in data warehouse design and development
- Experience with Workday Prism, Workday Report Writer, and other Workday tools
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent experience
- Workday HCM and Prism certification preferred
- Expertise in SQL, data modeling, and ETL development
- Proven experience designing and maintaining data warehouses and integrating data from multiple sources
- Experience with cloud platforms such as AWS, Google Cloud, or Microsoft Azure
- Familiarity with data science techniques and tools for predictive analytics and machine learning is preferred
Our Company
Abercrombie & Fitch Co. is a global, digitally led omnichannel specialty retailer of apparel and accessories catering to kids through millennials with assortments curated for their specific lifestyle needs.
The company operates a family of brands, including Abercrombie & Fitch, YPB, abercrombie kids, Hollister and Gilly Hicks, each sharing a commitment to offer products of enduring quality and exceptional comfort that support global customers on their journey to being and becoming who they are. Abercrombie & Fitch Co. operates over 750 stores under these brands across North America, Europe, Asia and the Middle East, as well as the e-commerce sites abercrombie.com, abercrombiekids.com, and hollisterco.com.
At Abercrombie & Fitch Co., we lead with purpose and always put our people first. We’re proud to offer equitable compensation and benefits, including flexibility and competitive Paid Time Off, as well as education and engagement events, including various Associate Resource Groups, volunteer opportunities and additional time off to give back to our global communities.
Benefits & Perks
As an Abercrombie & Fitch Co. (A&F Co.) associate, you’ll be eligible to participate in a variety of benefit programs designed to fit you and your lifestyle. A&F Co. is committed to providing competitive and comprehensive benefits that align with our company’s culture and values, but most importantly – with you! We also provide competitive incentives to reward the commitment our associates have for moving our global business forward:
- Incentive bonus program
- Annual companywide review process
- Flexible spending accounts
- Medical, dental and vision insurance
- Life and disability insurance
- Associate assistance program
- Paid parental and adoption leave
- Access to fertility and adoption benefits through Carrot
- Access to mental health and wellness app, Headspace
- Paid time off and one paid volunteer day per year, allowing you to give back to your community
- Work from anywhere (Mondays and Fridays are “work from anywhere” days for most roles and six work from anywhere weeks per year)
- Seven associate wellness half days per year
- Merchandise discount on all of our brands
- Opportunities for career advancement, we believe in promoting from within
- Access to multiple Associate Resource Groups
- Global team of people who will celebrate you for being YOU!
Job DescriptionQualificationsAdditional Information
ABERCROMBIE & FITCH CO. IS AN EQUAL OPPORTUNITY EMPLOYER
This role allows for remote work across the U.S.. Therefore, in states and cities that require the hourly or salary compensation or pay range to be included in a job posting, the recruiting pay range for this position is $91,000 - $106,000. Factors that may be used to determine your actual salary may include your specific skills, your years of experience, your work location, comparison to other employees in similar or related roles, or market demands. The range may be modified in the future.
Read Full Description