Data Engineer

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. At Ancestry DNA we work with massive data sets using multiple technologies and the team is looking for a Data Engineer. You will work directly with Supply Chain Analytics Manager in projects involving analytics for Operations, support data projects related to Ancestry DNA Health product and other data-sets. You will focus on DNA Operation's ETL tool Halo and work with the Data Delivery team which serves cross platform DNA Data. It will directly report to the Enterprise Data Management organization and be part of the greater data and growth Strategy at Ancestry.

What you'll be doing:

• Lead Data Warehousing projects with the Data Delivery Team and support DNA Operations Data
• Scale the warehouse, strategize growth, best practices and refine processes to meet Ancestry's data growth.
• Understand Business, Operations and Analytics requirements for data from many sources
• Develop, deploy, and support real-time automated data streams from numerous sources into the Data lake and data warehouse.
• Develop and implement data auditing strategies and processes to ensure data accuracy and integrity
• Design Data Requirements and work with DNA Operations to provide access to data
• Implement technical solutions to maintain ETL processes and troubleshoot extraction failures
• Be able to work with ambiguous and undefined requirements

Who you are:

• BS degree in Computer Science, IS or related field.
• 3+ years of experience managing Data warehouse and working with Data Platform
• Proficiency in database technologies MySQL (Aurora), MSSQL, S3, Redshift or equivalent
• Experience with Power BI tool solutions (Halo experience will be given priority)
• Meet delivery dates on assigned projects and tasks (this is a solo, Individual Contributor role)
• Have a passion for data and helping the business turn data into information and action
• Expert with data modeling, handling massive data sets and sources (MS SQL Server, mySQL, REST API's)
• Experience with ETL tools (SSIS, Nifi, Pentaho)
• Experience with Cubes
• Worked within the Agile methodology
• Experience with Kafka, Java, Spark, Python

Helping people discover their story is at the heart of ours. Ancestry is the largest provider of family history and personal DNA testing, harnessing a powerful combination of information, science and technology to help people discover their family history and stories that were never possible before. Ancestry's suite of products includes: AncestryDNA, AncestryProGenealogists, Fold3, Newspapers.com , Find a Grave, Archives.com , and Rootsweb. We offer excellent benefits and a great compensation package. For additional information, regarding our benefits and career information, please visit our website at http://ancestry.com/careers #GDSponsored #IND2 #LI-MK1 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. Apply for this job