Back to industry jobs
Senior Data Analyst at Techstyle

Senior Data Analyst

@

Techstyle

Key information

Apply now
Posted on: 
February 15, 2023
Status:
Expired
Views:
0

Summary of the Senior Data Analyst job at Techstyle

Techstyle is hiring a Senior Data Analyst with 3 - 5 years of experience. Based in United States - El Segundo, CA and with In-office ways of working. The expected salary range for this role is $80,555 - $148,500
About Techstyle

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.

Senior Data Analyst job description

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
Senior Data Analyst job requirements

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
What we offer at Techstyle

At TechStyleOS, we believe work and life should fit together! We continue to build a culture of flexibility, to empower you to do your best and put yourself first. Our Total Rewards program rewards employees for their hard work, supporting their health, well-being, families, and ultimately their life journey. Total Rewards at TechStyleOS includes:

  • Hybrid Work Schedule* 
  • Unlimited Paid Time Off* 
  • Summer Fridays* 
  • Healthcare Plans 
  • Employee Discounts 
  • 401k 
  • Annual Bonus Program 
  • Equity Program* 
  • And More 
  • Varied for retail and fulfillment roles

The annual base salary range for this position is from $80,550 to $148,500. The range provided includes the base salary that TechStyleOS expects to pay for the role. Offered base salary will be dependent on factors including the scope and complexity of the role, candidate’s related work experience, subject matter expertise and work location.

Please mention “I found this job at DataAnalyst.com!” in your application, it will help us offer you more opportunities

insertpageurl
Thank you for reporting
Oops! Something went wrong while submitting the form.

Check out other open roles at the company 👉

Techstyle

Techstyle

is hiring

Senior Data Analyst

Website:
Posted on: 
February 26, 2024

About Our Company

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.

Job Description & Responsibilities

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

Requirements

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

What we offer

At TechStyleOS, we believe work and life should fit together! We continue to build a culture of flexibility, to empower you to do your best and put yourself first. Our Total Rewards program rewards employees for their hard work, supporting their health, well-being, families, and ultimately their life journey. Total Rewards at TechStyleOS includes:

  • Hybrid Work Schedule* 
  • Unlimited Paid Time Off* 
  • Summer Fridays* 
  • Healthcare Plans 
  • Employee Discounts 
  • 401k 
  • Annual Bonus Program 
  • Equity Program* 
  • And More 
  • Varied for retail and fulfillment roles

The annual base salary range for this position is from $80,550 to $148,500. The range provided includes the base salary that TechStyleOS expects to pay for the role. Offered base salary will be dependent on factors including the scope and complexity of the role, candidate’s related work experience, subject matter expertise and work location.

Apply now

Featured data analyst job openings

All jobs