About The Role
EWC is looking for a motivated Senior Data Engineer to join our growing team of data experts. In this role, you will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross-functional teams. The ideal candidate is an experienced data pipeline builder and engineer who enjoys optimizing data systems and building them from the ground up. The Sr. Data Engineer will support our data analysts/scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.
They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives.A Day In The Life
- Collecting, organizing, managing, and converting raw data into a format that can be easily analyzed by Business Intelligence analysts and data scientists.
- Building and maintaining data pipelines that collect and transport data from various sources to EWC’s data storage systems.
- Using algorithms and programming languages such as SQL and Python to prepare data for analysis.
- Working closely with the management and end-users to understand and address business requirements related to data storage, management, and analysis.
- Creating data analysis tools and developing new data validation methods to ensure data accuracy and completeness.
- Identifying ways to make data more reliable, efficient, and accessible to relevant stakeholders.
- Creating and maintaining the organization’s software and hardware architecture to support efficient and secure data storage and management.
- Conducting research and troubleshooting to address potential problems that may arise in the data storage and management systems.
- Play a key role in designing and crafting a modern Data and Information Delivery and Analytics platform in the cloud to support retail service and product distribution for the US market.
- Create and maintain optimal data pipeline architecture.
- Assemble large, complex data sets that meet functional/non-functional business requirements.
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS ‘big data’ technologies.
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
- Work with stakeholders including the Executive, Operations, FP&A, and Supply Chain teams to assist with data-related technical issues and support their data infrastructure needs.
- Keep our data separated and secure during transmission and at rest.
- Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
- Work with data and analytics experts to strive for greater functionality in our data systems.
What Sets You Apart
- Proven passion and talent for teaching fellow engineers and non-engineers.
- Strong analytic skills related to working with unstructured datasets.
- Adopts EWC values in personal work behaviors, decision making, contributions and interpersonal interactions.
- Helps shape a positive work environment by demonstrating and influencing others to reward performance and value "can do" people, accountability, diversity and inclusion, flexibility, continuous improvement, collaboration, creativity, and fun.
- Experience with commercial data engineering/science solution initiatives.
- Ability to manage a broad range of deliverables with ambiguous task symptomatology while consistently achieving collaborative success with others to accomplish goals.
- Works well in a team environment and takes pride in participating in projects that employ the skills of all team members.
- Ability to learn quickly in a dynamic environment and to troubleshoot issues.
- Business savvy communications skills and concise written communication skills.
- Ability to be self-sufficient and self-driven in a small team.
- Understanding of the current threat and vulnerability landscape.
- Excellent organization and presentation skills.
Education And Experience
- BS in math, economics, engineering or other technical field preferred; advanced degrees a plus.
- 7+ years of professional software development or data engineering experience.
- 5+ years of SQL experience with dimensional data modeling & schema design in relational data warehouses
- 5+ years of experience in ETL/ELT pipeline design, implementation and maintenance with relational databases
- 5+ years of experience with ETL/ELT tools (ideally DBT and Airflow experience)
- Experience designing, building and optimizing ‘big data’ data pipelines, architectures and data sets.
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- Build processes supporting data transformation, data structures, metadata, dependency and workload management.
- Proven ability to architect, implement, and optimize high throughput data pipelines.
- Experience deploying production systems in the cloud (i.e., AWS, Azure).
- Strong communication skills in writing and conversation.
- Experience with tools we use every day:
- Storage: Snowflake, AWS Storage Services (e.g., S3, RDS, Glacier)
- ETL/BI: Astronomer, DBT, Domo, Tableau, PowerBI
- Experience with encryption at rest, including multiple approaches and tradeoffs.
- Comfortable at least manipulating data in Python as preferred language.
- Experience in Retail operations.
*This role is not eligible for visa sponsorship*
European Wax Center is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability status, protected veteran status, or any other characteristic protected by law.This job description is a general description of essential job functions. It is not intended to describe all duties someone in this position may perform. All employees of EWC and operating subsidiaries are expected to perform tasks as assigned by supervisory/management personnel, regardless of job title or routine job duties.
