TechStyleOS is the globally integrated Operations and Services provider behind some of the fastest growing online fashion brands in history, including Fabletics, Savage X Fenty, JustFab, ShoeDazzle, and FabKids. With capabilities spanning technology, data science, supply chain management, fulfillment, customer service, and more, we help brands launch, scale and grow—across product categories and geographically. From predictive analytics to data-driven marketing and attribution, our unique approach is powered by our proprietary, end-to-end tech platform that enables the brands we serve to deliver a level of personalization, value, and satisfaction that are unrivaled in the fashion industry.

TechStyleOS is looking for a Sr. Data Analyst to join our team.

How Do You Fit In? 

As the Sr. Data Analyst you will be responsible for preparing data and analysis for teams across a data-driven organization, contributing to sound business decision-making. In addition, the Analyst will be partnering with our entire Data Analytics organization and cross functional product and technical teams to ensure that our data is accurate. They will also be working with business users to facilitate understanding of the data and business insights. The right candidate would be detail-oriented, incredibly curious, and technically capable with a deep desire to become expert in our systems and data structures. This role is critical to keep data flowing seamlessly to fuel our data-driven culture.

This position will report to the Director, Data Analytics. 

What You Will Be Doing

• Conceptualize, build and maintain pre-aggregated datasets, reports and other analytical products (70%)
• Collaborate with business stakeholders to understand business problems and build/automate analytics products such as:
• Dimensional models for new subject areas using an analytical lens
• Well architected (re-usable, scalable) aggregate tables that meet current and future reporting needs in the EDW
• Intuitive and actionable dashboards and data visualizations for data-driven decision-making using presentation layer BI tools like Tableau, SSRS etc.,
• Develop a deep understanding of the Snowflake EDW, dimensional models and ETL business logic
• Become a subject matter expert in TFG’s upstream source systems over time
• Translate data and insights into a meaningful story to drive strategy, action, and decision-making at an executive level
• Work closely with the Data Platforms team to determine the best strategy for process scheduling and follow best practices set by the team
• Collaborate with members of the Data platforms team (data analytics and engineers) for successful delivery of key initiatives (20%)
• Participate in or lead brainstorming/whiteboarding sessions with the team for complex data analytics problems and other decisions that require team input
• Participate in the Data Platforms team’s agile process in the capacity of an individual contributor or analytics project lead (if applicable)
• Utilize GIT for collaborative SQL development, peer review and deployment to production
• Documentation (10%)
• Translate business requirements into technical requirements using best-in-class tools and methods like pseudo-code, control flow charts, entity relationship diagrams, process flows, system architecture diagrams/topologies etc
• Maintain technical documentation in Confluence and other highly detailed EDW/reporting documentation in the Data Catalog

What Can You Bring

• B.A./B.S. in a STEM field preferred
• Expert SQL skills, particularly in an analytics / reporting capacity. Significant experience creating and maintaining DW and reporting processes
• Advanced Data modeling skills (hands-on experience + theoretical understanding)
• Implementing star-schemas/snowflake-schemas
• Slowly changing dimensions
• Advanced SQL skills required
• Primary/foreign keys, indexes (when to use them)
• Joins and unions 
• Tables and Views (How are they different? Pros and cons of using)
• Be able to describe differences between DML/DDL statements
• Window functions
• Scalar and aggregate functions
• 4+ years of experience in creating and managing reporting and analytics processes for large Data Warehouses and analytics applications
• 1 year experience with python or another scripting language and comfort working in linux-based python development
• Nice to have strong command of git (1+ year)
• Soft-skills and other traits
• Self-directed, passionate, curious and a high performing individual who seeks to deliver excellent results (without external pressure)
• Must be an expert communicator that can partner with technical and non-technical stakeholders
• Enjoys building processes that are clean, organized, reliable, and efficient
• High performing individual who is motivated by making an impact to the business using their technical skills (rather than being motivated to master their technical prowess alone)

Where We Are

• This role will be based in our El Segundo Headquarters