Data Engineer

About Ancestry:
When you join Ancestry, you join a human-centered company where every person’s story is important. Ancestry®, the global leader in family history, empowers journeys of personal discovery to enrich lives. With our unparalleled collection of more than 40 billion records, over 3 million subscribers and over 23 million people in our growing DNA network, customers can discover their family story and gain a new level of understanding about their lives. Over the past 40 years, we’ve built trusted relationships with millions of people who have chosen us as the platform for discovering, preserving and sharing the most important information about themselves and their families.

We are committed to our location flexible work approach, allowing you to choose to work in the nearest office, from your home, or a hybrid of both (subject to location restrictions and roles that are required to be in the office- see the full list of eligible US locations HERE). We will continue to hire and promote beyond the boundaries of our office locations, to enable broadened possibilities for employee diversity.

Together, we work every day to foster a work environment that's inclusive as well as diverse, and where our people can be themselves. Every idea and perspective is valued so that our products and services reflect the global and diverse clients we serve. 

Ancestry encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants. Passionate about dedicating your work to enriching people’s lives? Join the curious.

We are seeking a Data Engineer to join our Commercial Analytics organization. Reporting to our Senior Manager of Martech & Platform Management, you will focus on development of ingesting data across the organization to process, transform, and deliver to our internal and external stakeholders.

What you will do…

• Work with large datasets, performing data cleansing, transformation, and loading (ETL) processes.

• Practice good coding techniques including writing unit and integration tests, doing commits and pull requests (Git), etc.

• Collaborate with cross-functional teams (engineering, analysts, marketing, etc.) to understand data requirements to develop scalable, resilient, and  maintainable ETL solutions that meet business needs.

• Work with internal and external stakeholders to identify and define data requirements, design solutions, and ensure timely delivery

• Participate in an on-call rotation to ensure pipelines are successful and data meets quality requirements

• Assist in monitoring the performance of data pipelines and systems, identifying and resolving issues.

• Ensure data quality, consistency, and integrity by developing and maintaining automated data validation processes.

• Help document data flows, pipelines, and systems for internal knowledge sharing.

• Ensure ETL pipelines meet quality standards and data quality requirements

• Stay up-to-date with industry best practices, tools, and technologies related to data engineering.

Who you are…

• 3+ years of experience as a data engineer, with specific experience in developing ETL pipelines

• Knowledge of data engineering concepts, such as ETL processes, data pipelines, and data warehousing

• 3+ years of industry experience programming in Java, Python and SQL (or related languages)

• Experience with version control tools such as Git. 

• Experience working with data orchestration tools such as Apache Nifi, Apache Airflow.

• Experience using data warehouse platforms such as Amazon Redshift, 

• Working knowledge of data visualization tools such as Tableau. 

• Familiarity with agile software development

• Excellent written and verbal communication skills

• Bachelors or 4-year degree in Computer Science (or related degree) or equivalent industry experience

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 competitive compensation package. For additional information, regarding our benefits and career information, please visit our website at http://ancestry.com/careers

As a signatory of the ParityPledge in Support of Women and the ParityPledge in Support of People of Color, Ancestry values pay transparency and pay equity. We are pleased to share the base salary range for this position: $70,560 - $85,000 with eligibility for bonus, equity and comprehensive benefits including health, dental and vision. The actual salary will vary by geographic region and job experience. We will share detailed compensation data for a specific location during the recruiting process. Read more about our benefits HERE.

*Note: Disclosure as required by sb19-085(8-5-20) and sb1162(1-1-23) 

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.