Supply Chain Analyst (SQL) - Ancestry (DNA Operations)

  • Ancestry
  • Aug 30, 2021

Job Description

About Ancestry:
When you join Ancestry, you join a human-centered company where every person’s story is important. We believe that by discovering the struggles and triumphs of our past, we can foster deeper bonds and more meaningful connections among families and communities. Our talented team of scientists, engineers, genealogists, historians, and storytellers is dedicated to empowering customers around the world from all backgrounds on their journeys of personal discovery.

With more than 27+ billion digitized global historical records, 100 million family trees, and 18 million people in our growing AncestryDNA database, Ancestry helps customers discover their family story and gain a new level of understanding about their lives. Passionate about dedicating your work to enriching people’s lives? You belong at Ancestry.

Ancestry is seeking a Supply Chain Analyst within Supply Chain Analytics team supporting DNA Operations. This role will report to the Supply Chain Analytics Manager and provide analytical support to the operations, program, product, and engineering teams within the DNA Operations Organization. The analytics team is responsible for providing visibility into the mechanics of the end-to-end supply chain, ensuring any issues are identified quickly, identifying areas for improvement, and driving strategy by facilitating data driven decision making. This will include building and maintaining business reporting, performing ad-hoc analysis utilizing cross functional datasets, and presenting information/recommendations to management. This position will also be working with the SCM data warehouse and help govern data and processes involved.

This will be a data intensive role that requires a strong analytical and technical skill set.  It will also be important to be able to communicate clearly via verbal presentation as well as visualization/reporting.

What You Will Do:

  • Ability to use complex data systems and mine data sources to identify trends
  • Understand business, operations and analytics requirements for data from a multitude of sources.
  • Independently identify, quantify, and solve problems in datasets, regardless of source
  • Specify and implement data quality metrics
  • Build predictive models that help predict impacts of supply chain decisions made
  • Keep cross-functional teams informed of progress and developments through proactive updates and reports
  • Identify KPI’s and collaborate with the team to develop reporting around metrics.
  • Ability to communicate recommended solutions and findings to the leadership team
  • Develop and maintain reports using SQL
  • Statistical analysis in support of the development of Models.
  • Visualize data in an intuitive and actionable way

  • Who You Are:

  • BS required – Information Systems, Business Analytics, Economics, Supply Chain, Finance, or similar
  • Experience in an internet, technology, and/or hard goods business is preferred
  • 2+ years of workplace experience with SQL, and Tableau is a plus
  • Strong Excel skills (advanced formulas, pivot tables, modelling)
  • Advanced Statistical knowledge is a must
  • Must understand relational databases and be comfortable writing queries while optimizing system performance
  • Must be self-driven and be able to work in ambiguous work environments 
  • Accountable for meeting delivery dates on assigned projects and tasks
  • Excellent written and verbal communication abilities
  • Ability to work collaboratively with both internal and external implementation teams

  • Additional Information:
    Ancestry is an Equal Opportunity Employer that makes employment decisions without regard to race, color, religious creed, national origin, ancestry, sex, pregnancy, sexual orientation, gender, gender identity, gender expression, age, mental or physical disability, medical condition, military or veteran status, citizenship, marital status, genetic information, or any other characteristic protected by applicable law. In addition, Ancestry will provide reasonable accommodations for qualified individuals with disabilities.

    All job offers are contingent on a background check screen that complies with applicable law.  For San Francisco office candidates, pursuant to the San Francisco Fair Chance Ordinance, Ancestry will consider for employment qualified applicants with arrest and conviction records.  

    Ancestry is not accepting unsolicited assistance from search firms for this employment opportunity. All resumes submitted by search firms to any employee at Ancestry via-email, the Internet or in any form and/or method without a valid written search agreement in place for this position will be deemed the sole property of Ancestry. No fee will be paid in the event the candidate is hired by Ancestry as a result of the referral or through other means.