Content Data Structure Specialist

Ancestry; Draper, Northern (UT, KY); On-site; USD 29,000 - 36,000; Full time

Benefits offered by this job

Bonus

Equity

Health benefits

Dental

Vision

Job summary

Ancestry is seeking a Content Data Specialist to structure data for publishing pipelines, transforming raw family history content into standardized formats, and exporting data for external partners. You will also help develop AI-assisted tools to streamline workflows and improve accuracy and efficiency.

The role requires high autonomy and strong proficiency with MySQL, Excel, and Power BI, plus a proactive approach to learning new technologies.

Qualifications

• Excellent data analysis and data quality focus.
• Strong SQL and data modeling skills.
• Experience using AI tooling to automate data workflows.

Responsibilities

• Data Transformation: Gather and convert raw data into standardized formats for internal and external systems.
• Workflow Innovation: Design and implement methods to optimize production workflows.
• Project Oversight: Manage multiple concurrent data collections with milestones and deadlines.
• Technical Troubleshooting: Resolve issues within data files, SQL templates, and database tables.
• AI Integration: Leverage AI tools to streamline tasks and troubleshoot bottlenecks.
• Team Development: Participate in onboarding and training of team members.
• Peer Support: Assist your teammates with questions and issues.

Skills

Data analysis

SQL

AI tooling

Excel

Power BI

Communication

Problem solving

Tools

MySQL

Excel

Power BI

Job description

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, connects everyone with their past so they can discover, preserve, and share their unique family stories. With our unparalleled collection of more than 65 billion records, over 3.5 million subscribers, and over 27 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.

The Content Data Specialist supports Content production by structuring data for use throughout the publishing pipeline. The Data Specialist will work with raw family history content and metadata to prepare the data for importing to a database and structuring according to Content standards. You will also be responsible for exporting data for external partners. An essential part of this role is the development of custom tools with AI assistance to help automate and streamline workflows to improve output and efficiency. The role will require constant and quality communication to ensure success.

What you will do...

• Data Transformation: Gather and convert raw data into standardized formats; transform diverse file types into ingestible assets for internal and external systems.
• Workflow Innovation: Design and implement innovative methods to optimize production workflows and support scalable content growth.
• Project Oversight: Manage multiple concurrent projects, ensuring all milestones and deadlines are met for diverse data collections.
• Technical Troubleshooting: Resolve complex issues within data files, SQL templates, and database tables.
• AI Integration: Leverage AI tools to streamline repetitive tasks, automate workflows, and troubleshoot process-driven bottlenecks.
• Team Development: Participate in the onboarding and training of team members.
• Peer Support: Assist in answering questions and troubleshooting issues the team experiences.

Technical Skills and Qualifications

• High-Level Autonomy: Operates with independence, making decisions and managing deliverables with minimal supervision.
• Continuous Learning: Proactively masters new technical tools and evolving industry requirements without needing formal direction.
• Technical Proficiency: Professional experience leveraging AI to develop custom tools, with deep expertise in MySQL databases, Excel, and Power BI.
• Analytical Rigor: Exceptional analytical skills with a meticulous approach to data accuracy and detail.
• Problem Solving: Proven ability to make critical decisions and troubleshoot technical issues with minimal supervision.
• Adaptive Learning: Ability to rapidly acquire and apply new technical skills and software proficiencies.
• Communication: Excellent interpersonal, verbal, and written communication skills suited for a global team environment.

Nice-to-Have Skills

• Basic exposure to cloud platforms (AWS or GCP).
• Basic proficiency or educational background in Python or Java for data scripting and Git for version control.
• Interest in learning automation, logging, and workflow tools.
• Experience or interest in family history, genealogy, or historical data.

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 hourly range for this position: $21.00-26.00 with eligibility for bonus, equity and comprehensive benefits including health, dental and vision. The actual salary will vary by geographic region and job experience.

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 candidates who live in San Francisco, CA, 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.