close Advantages of 'Apply Now'
'Apply Now' provides you with a fast and easy way to apply to a job and has many benefits over other methods of applying including:
  • Apply to multiple jobs quickly and easily. If you've used the 'Apply Now' process before, we've already saved your information. Just select and preview your resume and optional cover letter and submit.
  • Receive confirmation of submission. With your information automatically sent and saved in our system, we'll make sure your resume gets in the recruiter's HotJobs account and we'll send you a confirmation email.
  • Stay organized in your job search. You can centrally manage your resume activity history online anytime. Keep track of the date, company and position you applied for, and the resume and cover letter you sent.

Data Warehouse ETL Developer: Ancestry.com

Job IDHJ-09139
Company NameAncestry.com
Job CategoryTechnology; Engineering
LocationProvo, UT • Salt Lake City, UT
Position TypeFull-Time, Employee
Experience2-5 Years Experience
Desired Education LevelBachelor's degree
Date PostedOctober 6, 2009 (Reposted Nov 6)
Ancestry.com
View Ancestry.com profile and job listings

DATA WAHREHOUSE ETL DEVELOPER

Ancestry.com Inc. is the world's leading network of family-focused interactive businesses — encompassing Ancestry.com, the Ancestry.com RootsWeb community, Ancestry.com DNA and Ancestry.com Family Tree Maker®, in addition to MyFamily.com, MyCanvas.com and Ancestry magazine. Our mission is to help people discover, preserve and share their family history.

The Ancestry.com website is the world's largest online collection of family history resources. We are a global business with teams on the ground in eight countries with localized web versions available in nine countries. Ancestry.com provides convenient access to billions of historical records, in addition to millions of online family trees, historical photos and stories.

Job Description:
This person will work with Business Intelligence Team to develop enterprise data warehouse and implement key performance indicators and reporting for all business functions. Position will perform analysis, design, programming and testing for presentation, reporting, and data ETL layers of enterprise data warehouse. Looking for individual willing to develop multi-dimensional database modeling skills and interested in implementing business performance measurements.

Key Responsibilities / Performance Requirements:
  • Integration Services
  • Translate user requirements for reporting and analysis into data warehouse deliverables
  • Develop and implement data auditing strategies and processes to ensure data accuracy and integrity
  • Support operation and expansion of data warehouse and reporting environment
  • Oversee ETL metadata management
  • Manage multiple projects in a fast-paced environment
  • Develop reports
  • Build subject area cubes / datamarts / dashboards
  • Assist in construction of enterprise data warehouse
  • Extract and load enterprise data warehouse using cutting edge technology
  • Monitor performance and reliability of load processes
  • Work with business analysts to implement business intelligence solutions
Required Skills:
  • SQL Server 2005
  • SQL Server 2005 Integration Services
  • Data Access and Reporting Tools (Proclarity and MS Reporting Services)
  • Must be very self-motivated
  • Ability to meet deadlines with high attention to detail
Right Candidate will develop/refine skills in: Converting business performance measurement needs into technical solutions OLAP tools and design ETL tools and design Data warehouse Design Datamarts Multidimensional database design Type 1, 2 and 3 slowly changing dimensions Fact Tables Star and Snowflake Schemas MS Analysis Services MS Reporting Services MS DTS Data profiling tools Analytical and root cause analysis skills to provide consistent data integrity Data modeling, data mapping, data integration and extraction.
Interested? Here’s how to apply:
Begin your online application by submitting your resume to resume@ancestry.com. Please reference DATA WAREHOUSE ETL DEVELOPER in the subject field of your e-mail.

Working for Ancestry.com
Ancestry.com is a profitable, growing company with a positive, high-energy environment. Together, our dedicated teams are harnessing the power of technology and using it to simplify the way people connect with their families and their unique legacies. Our work environment is fast-paced and challenging, but also extremely exciting. You’ll work with a team of passionate, engaged individuals. We offer excellent benefits and a competitive compensation package. For additional information regarding our benefits and career information, please visit our website at www.ancestry.com/careers.

Ancestry.com Inc. is interested in you and we are dedicated to building a diverse workforce with equal opportunities for employment.


Tips For A Safe Job Search: Never give your bank account information, credit card or social security number to a prospective employer. Do not accept any offers to cash checks or wire money. Click here to Learn More.

NOTICE: We collect personal information on this site. To learn more about how we use your information, see our Privacy Policy.

About Yahoo! HotJobs | Affiliate Program | Advertise with us