Data Analyst, Supply Chain
SEPHORA · Maryland Park, MD · 1 mo ago
Information Technology$82k–$92k/yrFull-time
We need to output HTML fragment with sections: About the role? The posting includes "Belong to Something Beautiful" intro, then "Planning and Engineering, Supply Chain Systems Your Role At Sephora As a Data Analyst...". We need to use for section headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections with real content.
We need to extract content.
First, remove boilerplate: Job ID, Location Name, Address, Job Type, Position Type, Job Function, Work Location, etc. Also remove EEO etc. Also remove application instructions (none). Remove duplicated lines.
We need to preserve substantive info: The role description, responsibilities, requirements, qualifications, skills, benefits, pay.
Let's parse.
Intro: "Belong to Something Beautiful At Sephora, beauty is about feeling seen, valued, and empowered, individually and collectively. It is connecting deeply with others, celebrating diversity and inclusivity, unlocking your potential, and making a difference every day. Together, we belong to something beautiful."
That's about company culture; could be "About the role"? Actually "About the role" maybe includes description of role and company. We'll treat as "About the role".
Then "Planning and Engineering, Supply Chain Systems Your Role At Sephora As a Data Analyst, DC Planning and Engineering you will be responsible for supporting our DC network to identify datasets, build and maintain report platforms, and provide assistance to data end users. Reporting to the Manager, Logistics Financial Planning and Analytics, you will utilize a thorough knowledge of the DC systems and SQL data with operational processes to ensure DC Operations Teams are educated on their key performance indicators. In Addition, You Will Leverage Logistics end-to-end Operational Process knowledge and automated systems knowledge (WMS, WES, WCS, etc.) to assist with data collection and analysisUtilize SQL to assist with building data and reportsSupport a basic understanding of WMS/WES system configurations for configuration responsibilitiesProvide data and reports to support all Distribution Centers in the Sephora DC NetworkParticipate in Development and Reporting Platform data validations to ensure they meet reporting specifications and expectationsAssemble large, complex sets of data that meet non-functional and functional business requirementsCollaborate to identify, design and implement internal process improvements including re-designing data and reports for greater scalability, optimizing data delivery, and automating manual processesBuild analytical tools to utilize data sources and provide actionable insights with key business performance metrics including operational efficiencyPartner with stakeholders including Engineering, Operations, and Leadership teams to assist with data-related technical issuesDemonstrate the ability to work effectively both individually and within teamsSelf-management and task prioritization capabilitiesDemonstrate the ability to meet multiple deadlines in a multitasking and fast paced environmentPossess strong written and verbal communications skillsTravel to other Distribution Centers to support initiatives (estimated 3 times per year)Demonstrate our Sephora values of Passion for Client Service, Innovation, Expertise, Balance, Respect for All, Teamwork, and Initiative"
That's a big block of responsibilities and also some requirements. We need to separate into sections: Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule.
Let's extract responsibilities: tasks like "supporting our DC network to identify datasets, build and maintain report platforms, and provide assistance to data end users", "utilize a thorough knowledge of the DC systems and SQL data with operational processes to ensure DC Operations Teams are educated on their key performance indicators", "leverage Logistics end-to-end Operational Process knowledge and automated systems knowledge (WMS, WES, WCS, etc.) to assist with data collection and analysis", "Utilize SQL to assist with building data and reports", "Support a basic understanding of WMS/WES system configurations for configuration responsibilities", "Provide data and reports to support all Distribution Centers in the Sephora DC Network", "Participate in Development and Reporting Platform data validations to ensure they meet reporting specifications and expectations", "Assemble large, complex sets of data that meet non-functional and functional business requirements", "Collaborate to identify, design and implement internal process improvements including re-designing data and reports for greater scalability, optimizing data delivery, and automating manual processes", "Build analytical tools to utilize data sources and provide actionable insights with key business performance metrics including operational efficiency", "Partner with stakeholders including Engineering, Operations, and Leadership teams to assist with data-related technical issues", "Demonstrate the ability to work effectively both individually and within teams", "Self-management and task prioritization capabilities", "Demonstrate the ability to meet multiple deadlines in a multitasking and fast paced environment", "Possess strong written and verbal communications skills", "Travel to other Distribution Centers to support initiatives (estimated 3 times per year)", "Demonstrate our Sephora values of Passion for Client Service, Innovation, Expertise, Balance, Respect for All, Teamwork, and Initiative".
Now requirements/qualifications: "We’re Excited About You If You Have 4+ years of technical data experience with DC systems and data exports, and reportingExperience with, and knowledge in, the following:Oracle data bot mining (scripting and data execution)Oracle SQL/SQL and WMS/WES/WCS system table structures w/LextEditInterfaces with Order Management and Middleware SystemsThoughtSpotA working knowledge of DC operational practices and procedures, and a full understanding of Supply Chain and WMS/WCS/WES data and conceptsExperience working with Dotcom and Retail DC Systems and OperationsProven experience working directly and collaboratively with IT, DC Operations, and Leadership, building effecting relationships with personnel at all levels"
Also maybe "Self-management and task prioritization capabilities" etc are skills.
We'll create sections:
- About the role: include the intro paragraph(s) about belonging to something beautiful and maybe the role overview.
- Responsibilities: list bullet points from responsibilities.
- Requirements: list bullet points from required experience (4+ years, Oracle data bot mining, Oracle SQL, WMS/WES/WCS system table structures, Interfaces with Order Management and Middleware Systems, ThoughtSpot, working knowledge of DC operational practices, full understanding of Supply Chain and WMS/WCS/WES data and concepts, experience with Dotcom and Retail DC Systems and Operations, proven experience working directly and collaboratively with IT, DC Operations, Leadership).
- Qualifications: maybe overlapping; but we can treat Requirements as qualifications. However we need to decide: The instruction says use headings for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We can include both Requirements and Qualifications if distinct. But we can combine if not distinct. However we have "Requirements" (years of experience, specific technical knowledge) and "Qualifications" maybe education? Not given. Could omit Qualifications if no specific content. Better to omit if no real content.
- Skills: list skills like strong written and verbal communication, self-management, task prioritization, ability to meet multiple deadlines, work individually/within teams, travel, demonstrate Sephora values.
- Benefits: list from "What You’ll Get" and "Rewards As Unique As You": health (medical, dental, vision), disability and life insurance fully covered, competitive 401k with 4% match, FSA and HSA programs, Student Debt Retirement plan, paid time off, sick paid time off, protected leave, development programs, tuition reimbursement, mentorship, 30% discount on merchandise/services, free product or gratis, flash sale discounts on LVMH brand products, free mental health and financial coaching resources with 24/7 access to Modern Health and Financial Finesse, volunteer and donation matching.
- Pay: "The annual base salary range for this position is $82,000.00 - $92,000.00." Also mention bonuses eligibility.
- Schedule: Not mentioned; maybe travel 3 times per year but not schedule. No explicit schedule. So we omit Schedule section.
Now produce HTML.
We need to wrap each section:
preserving the exact phrasing maybe.
Let's extract each responsibility sentence exactly as appears (though some are concatenated without spaces). We need to parse the block.
Original responsibilities block after "In Addition, You Will" seems to have missing spaces. Let's rewrite with proper spacing based on context.
Original text:
"In Addition, You Will Leverage Logistics end-to-end Operational Process knowledge and automated systems knowledge (WMS, WES, WCS, etc.) to assist with data collection and analysisUtilize SQL to assist with building data and reportsSupport a basic understanding of WMS/WES system configurations for configuration responsibilitiesProvide data and reports to support all Distribution Centers in the Sephora DC NetworkParticipate in Development and Reporting Platform data validations to ensure they meet reporting specifications and expectationsAssemble large, complex sets of data that meet non-functional and functional business requirementsCollaborate to identify, design and implement internal process improvements including re-designing data and reports for greater scalability, optimizing data delivery, and automating manual processesBuild analytical tools to utilize data sources and provide actionable insights with key business performance metrics including operational efficiencyPartner with stakeholders including Engineering, Operations, and Leadership teams to assist with data-related technical issuesDemonstrate the ability to work effectively both individually and within teamsSelf-management and task prioritization capabilitiesDemonstrate the ability to meet multiple deadlines in a multitasking and fast paced environmentPossess strong written and verbal communications skillsTravel to other Distribution Centers to support initiatives (estimated 3 times per year)Demonstrate our Sephora values of Passion for Client Service, Innovation, Expertise, Balance, Respect for All, Teamwork, and Initiative"
We need to split into sensible sentences. Let's manually insert spaces where needed:
- Leverage Logistics end-to-end Operational Process knowledge and automated systems knowledge (WMS, WES, WCS, etc.) to assist with data collection and analysis.
- Utilize SQL to assist with building data and reports.
- Support a basic understanding of WMS/WES system configurations for configuration responsibilities.
- Provide data and reports to support all Distribution Centers in the Sephora DC Network.
- Participate in Development and Reporting Platform data validations to ensure they meet reporting specifications and expectations.
- Assemble large, complex sets of data that meet non-functional and functional business requirements.
- Collaborate to identify, design and implement internal process improvements including re-designing data and reports for greater scalability, optimizing data delivery, and automating manual processes.
- Build analytical tools to utilize data sources and provide actionable insights with key business performance metrics including operational efficiency.
- Partner with stakeholders including Engineering, Operations, and Leadership teams to assist with data-related technical issues.
- Demonstrate the ability to work effectively both individually and within teams.
- Self-management and task prioritization capabilities.
- Demonstrate the ability to meet multiple deadlines in a multitasking and fast paced environment.
- Possess strong written and verbal communications skills.
- Travel to other Distribution Centers to support initiatives (estimated 3 times per year).
- Demonstrate our Sephora values of Passion for Client
for section headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections with real content.
We need to extract content.
First, remove boilerplate: Job ID, Location Name, Address, Job Type, Position Type, Job Function, Work Location, etc. Also remove EEO etc. Also remove application instructions (none). Remove duplicated lines.
We need to preserve substantive info: The role description, responsibilities, requirements, qualifications, skills, benefits, pay.
Let's parse.
Intro: "Belong to Something Beautiful At Sephora, beauty is about feeling seen, valued, and empowered, individually and collectively. It is connecting deeply with others, celebrating diversity and inclusivity, unlocking your potential, and making a difference every day. Together, we belong to something beautiful."
That's about company culture; could be "About the role"? Actually "About the role" maybe includes description of role and company. We'll treat as "About the role".
Then "Planning and Engineering, Supply Chain Systems Your Role At Sephora As a Data Analyst, DC Planning and Engineering you will be responsible for supporting our DC network to identify datasets, build and maintain report platforms, and provide assistance to data end users. Reporting to the Manager, Logistics Financial Planning and Analytics, you will utilize a thorough knowledge of the DC systems and SQL data with operational processes to ensure DC Operations Teams are educated on their key performance indicators. In Addition, You Will Leverage Logistics end-to-end Operational Process knowledge and automated systems knowledge (WMS, WES, WCS, etc.) to assist with data collection and analysisUtilize SQL to assist with building data and reportsSupport a basic understanding of WMS/WES system configurations for configuration responsibilitiesProvide data and reports to support all Distribution Centers in the Sephora DC NetworkParticipate in Development and Reporting Platform data validations to ensure they meet reporting specifications and expectationsAssemble large, complex sets of data that meet non-functional and functional business requirementsCollaborate to identify, design and implement internal process improvements including re-designing data and reports for greater scalability, optimizing data delivery, and automating manual processesBuild analytical tools to utilize data sources and provide actionable insights with key business performance metrics including operational efficiencyPartner with stakeholders including Engineering, Operations, and Leadership teams to assist with data-related technical issuesDemonstrate the ability to work effectively both individually and within teamsSelf-management and task prioritization capabilitiesDemonstrate the ability to meet multiple deadlines in a multitasking and fast paced environmentPossess strong written and verbal communications skillsTravel to other Distribution Centers to support initiatives (estimated 3 times per year)Demonstrate our Sephora values of Passion for Client Service, Innovation, Expertise, Balance, Respect for All, Teamwork, and Initiative"
That's a big block of responsibilities and also some requirements. We need to separate into sections: Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule.
Let's extract responsibilities: tasks like "supporting our DC network to identify datasets, build and maintain report platforms, and provide assistance to data end users", "utilize a thorough knowledge of the DC systems and SQL data with operational processes to ensure DC Operations Teams are educated on their key performance indicators", "leverage Logistics end-to-end Operational Process knowledge and automated systems knowledge (WMS, WES, WCS, etc.) to assist with data collection and analysis", "Utilize SQL to assist with building data and reports", "Support a basic understanding of WMS/WES system configurations for configuration responsibilities", "Provide data and reports to support all Distribution Centers in the Sephora DC Network", "Participate in Development and Reporting Platform data validations to ensure they meet reporting specifications and expectations", "Assemble large, complex sets of data that meet non-functional and functional business requirements", "Collaborate to identify, design and implement internal process improvements including re-designing data and reports for greater scalability, optimizing data delivery, and automating manual processes", "Build analytical tools to utilize data sources and provide actionable insights with key business performance metrics including operational efficiency", "Partner with stakeholders including Engineering, Operations, and Leadership teams to assist with data-related technical issues", "Demonstrate the ability to work effectively both individually and within teams", "Self-management and task prioritization capabilities", "Demonstrate the ability to meet multiple deadlines in a multitasking and fast paced environment", "Possess strong written and verbal communications skills", "Travel to other Distribution Centers to support initiatives (estimated 3 times per year)", "Demonstrate our Sephora values of Passion for Client Service, Innovation, Expertise, Balance, Respect for All, Teamwork, and Initiative".
Now requirements/qualifications: "We’re Excited About You If You Have 4+ years of technical data experience with DC systems and data exports, and reportingExperience with, and knowledge in, the following:Oracle data bot mining (scripting and data execution)Oracle SQL/SQL and WMS/WES/WCS system table structures w/LextEditInterfaces with Order Management and Middleware SystemsThoughtSpotA working knowledge of DC operational practices and procedures, and a full understanding of Supply Chain and WMS/WCS/WES data and conceptsExperience working with Dotcom and Retail DC Systems and OperationsProven experience working directly and collaboratively with IT, DC Operations, and Leadership, building effecting relationships with personnel at all levels"
Also maybe "Self-management and task prioritization capabilities" etc are skills.
We'll create sections:
- About the role: include the intro paragraph(s) about belonging to something beautiful and maybe the role overview.
- Responsibilities: list bullet points from responsibilities.
- Requirements: list bullet points from required experience (4+ years, Oracle data bot mining, Oracle SQL, WMS/WES/WCS system table structures, Interfaces with Order Management and Middleware Systems, ThoughtSpot, working knowledge of DC operational practices, full understanding of Supply Chain and WMS/WCS/WES data and concepts, experience with Dotcom and Retail DC Systems and Operations, proven experience working directly and collaboratively with IT, DC Operations, Leadership).
- Qualifications: maybe overlapping; but we can treat Requirements as qualifications. However we need to decide: The instruction says use headings for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We can include both Requirements and Qualifications if distinct. But we can combine if not distinct. However we have "Requirements" (years of experience, specific technical knowledge) and "Qualifications" maybe education? Not given. Could omit Qualifications if no specific content. Better to omit if no real content.
- Skills: list skills like strong written and verbal communication, self-management, task prioritization, ability to meet multiple deadlines, work individually/within teams, travel, demonstrate Sephora values.
- Benefits: list from "What You’ll Get" and "Rewards As Unique As You": health (medical, dental, vision), disability and life insurance fully covered, competitive 401k with 4% match, FSA and HSA programs, Student Debt Retirement plan, paid time off, sick paid time off, protected leave, development programs, tuition reimbursement, mentorship, 30% discount on merchandise/services, free product or gratis, flash sale discounts on LVMH brand products, free mental health and financial coaching resources with 24/7 access to Modern Health and Financial Finesse, volunteer and donation matching.
- Pay: "The annual base salary range for this position is $82,000.00 - $92,000.00." Also mention bonuses eligibility.
- Schedule: Not mentioned; maybe travel 3 times per year but not schedule. No explicit schedule. So we omit Schedule section.
Now produce HTML.
We need to wrap each section: About the role
then
...
. For lists:- ...