Sr ETL Engineer (Remote)
About the position
Join a team that puts its People First! As a member of First American’s family of companies, Data & Analytics is a national provider of property-centric information, analytics, risk management and valuation solutions. First American maintains and curates the industry’s largest property and ownership dataset with over 7 billion document images. Our major platforms and products include: DataTree®, FraudGuard®, RegsData™, TaxSource™ and ACI®. The First American Data & Analytics division boasts more than 20 patents and remains at the forefront of innovation - leveraging technology and data to deliver best-in-class decisioning solutions. Fueled by our industry-leading data and using our technology and proprietary process, our solutions provide lenders, real estate and title companies with actionable insights - enabling them to make better, increasingly automated, decisions. With offices in all major metropolitan areas, including California and New York, DNA teams work collaboratively from across the country. Since 1889, First American (NYSE: FAF) has held an unwavering belief in its people. They are passionate about what they do, and we are equally passionate about fostering an environment where all feel welcome, supported, and empowered to be innovative and reach their full potential. Our inclusive, people-first culture has earned our company numerous accolades, including being named to the Fortune 100 Best Companies to Work For® list for ten consecutive years. We have also earned awards as a best place to work for women, diversity and LGBTQ+ employees, and have been included on more than 50 regional best places to work lists. First American will always strive to be a great place to work, for all. For more information, please visit www.careers.firstam.com. The Engineer will provide support in all aspects of the design, mapping, development, and testing of data movement for a data warehouse environment, with emphasis on the Extract-Transform-Load (ETL) process.
Responsibilities
• Devises/modifies processes to maintain high quality efficient ETL processes and applications moving large volumes of data.
• Designs, codes, tests, debug, and document those processes.
• Prepare detailed specifications from which processes will be written, designed, coded, tested and debugged.
• May consult with users and develop business relationships and integrate activities with other IT departments to ensure successful implementation
• Monitor and report to management on the status of project efforts, anticipating/identifying issues that inhibit the attainment of project goals and implementing corrective actions.
• Contribute to technical and system architectural planning and the development of innovative solutions for the business
• Required to perform duties outside of normal work hours based on business needs.
• Other duties as assigned
Requirements
• Bachelor's Degree or equivalent combination of education and experience
• Typically 5-7 years of directly related experience
• Previous supervisory experience is must
• 5+ years experience in a data warehousing environment
• Solid understanding of relational database models and dimensional data models
• Strong experience in ETL design and development experience working with SQL stored procedures and/or ETL tools such as Microsoft SSIS and Informatica
• 5+ years experience working with Microsoft SQL Server 2000 / 2005 / 2008
• 3+ years experience designing and developing complex stored procedures with Transact-SQL preferably in either an ETL or reporting environment
• Extensive experience with both Microsoft SSIS and DTS
• Constantly updating personal technical and business knowledge and skills
Nice-to-haves
• Experience working with distributed team is preferred
Benefits
• Based on eligibility, First American offers a comprehensive benefits package including medical, dental, vision, 401k, PTO/paid sick leave and other great benefits like an employee stock purchase plan.
Apply Now
Apply Now
Join a team that puts its People First! As a member of First American’s family of companies, Data & Analytics is a national provider of property-centric information, analytics, risk management and valuation solutions. First American maintains and curates the industry’s largest property and ownership dataset with over 7 billion document images. Our major platforms and products include: DataTree®, FraudGuard®, RegsData™, TaxSource™ and ACI®. The First American Data & Analytics division boasts more than 20 patents and remains at the forefront of innovation - leveraging technology and data to deliver best-in-class decisioning solutions. Fueled by our industry-leading data and using our technology and proprietary process, our solutions provide lenders, real estate and title companies with actionable insights - enabling them to make better, increasingly automated, decisions. With offices in all major metropolitan areas, including California and New York, DNA teams work collaboratively from across the country. Since 1889, First American (NYSE: FAF) has held an unwavering belief in its people. They are passionate about what they do, and we are equally passionate about fostering an environment where all feel welcome, supported, and empowered to be innovative and reach their full potential. Our inclusive, people-first culture has earned our company numerous accolades, including being named to the Fortune 100 Best Companies to Work For® list for ten consecutive years. We have also earned awards as a best place to work for women, diversity and LGBTQ+ employees, and have been included on more than 50 regional best places to work lists. First American will always strive to be a great place to work, for all. For more information, please visit www.careers.firstam.com. The Engineer will provide support in all aspects of the design, mapping, development, and testing of data movement for a data warehouse environment, with emphasis on the Extract-Transform-Load (ETL) process.
Responsibilities
• Devises/modifies processes to maintain high quality efficient ETL processes and applications moving large volumes of data.
• Designs, codes, tests, debug, and document those processes.
• Prepare detailed specifications from which processes will be written, designed, coded, tested and debugged.
• May consult with users and develop business relationships and integrate activities with other IT departments to ensure successful implementation
• Monitor and report to management on the status of project efforts, anticipating/identifying issues that inhibit the attainment of project goals and implementing corrective actions.
• Contribute to technical and system architectural planning and the development of innovative solutions for the business
• Required to perform duties outside of normal work hours based on business needs.
• Other duties as assigned
Requirements
• Bachelor's Degree or equivalent combination of education and experience
• Typically 5-7 years of directly related experience
• Previous supervisory experience is must
• 5+ years experience in a data warehousing environment
• Solid understanding of relational database models and dimensional data models
• Strong experience in ETL design and development experience working with SQL stored procedures and/or ETL tools such as Microsoft SSIS and Informatica
• 5+ years experience working with Microsoft SQL Server 2000 / 2005 / 2008
• 3+ years experience designing and developing complex stored procedures with Transact-SQL preferably in either an ETL or reporting environment
• Extensive experience with both Microsoft SSIS and DTS
• Constantly updating personal technical and business knowledge and skills
Nice-to-haves
• Experience working with distributed team is preferred
Benefits
• Based on eligibility, First American offers a comprehensive benefits package including medical, dental, vision, 401k, PTO/paid sick leave and other great benefits like an employee stock purchase plan.
Apply Now
Apply Now