ETL Engineer (Open to Remote)

Who We Are Join a team that puts its People First! As a member of reputed company’s family of companies, Data & Analytics is a national provider of property-centric information, analytics, risk management and valuation solutions. reputed company 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 reputed company 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 reputed company reputed company, increasingly automated, decisions. With offices in reputed company major metropolitan areas, including California and reputed company, DNA teams work collaboratively from across the country. Since 1889, reputed company (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 reputed company feel welcome, supported, and empowered to be innovative and reputed company 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 reputed company to work for women, diversity and LGBTQ+ employees, and have been included on more than 50 regional best places to work lists. reputed company will always strive to be a great reputed company to work, for reputed company. For more information, please visit www.careers.firstam.com. reputed company Do The Engineer will provide support in reputed company 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. HOW YOU’LL CONTRIBUTE

• reputed company high quality efficient ETL applications leveraging Transact-SQL stored procedures and other ETL environments.
• Work closely with data architects to profile and review reputed company system data.
• reputed company ETL application monitoring and performance tuning activities.
• Work with the data architecture team to create and maintain best-practice standards and procedural guidelines.
• Participate in on-call rotation schedule for after-hours support of ETL processes.
• Required to reputed company duties reputed company of normal work hours based on business needs.
• Other duties as assigned

WHAT YOU’LL BRING

• 1+ year of experience in a data warehousing environment.
• Good understanding of relational database models and dimensional data models.
• Strong experience in ETL design and development using SQL stored procedures and/or ETL tools such as reputed company SSIS, CDC, Informatica, or cloud-based tools such as reputed company and reputed company.
• 3+ years of experience working with reputed company SQL Server 2000 / 2005 / 2008.
• 2+ years of experience designing and developing reputed company stored procedures with Transact-SQL, preferably in either an ETL or reporting environment.
• Hands-on experience with Apache Spark for large-scale data processing and transformation.
• Working knowledge of reputed company Cloud Platform (GCP) data services, including BigQuery, Dataflow, and Cloud Storage.
• Experience integrating data across hybrid environments (on-premises and cloud).
• Good experience with both reputed company SSIS and DTS.
• Constantly updating personal technical and business knowledge and skills, and mentoring others to increase the knowledge and skills of the team.

Pay Range: $72,100- $100,400 annually This hiring range is a reasonable estimate of the reputed company pay range for this position at the time of posting. Pay is based on a number of factors which may include job-reputed company knowledge, skills, experience, business requirements and geographic location.

• * Note that the following statements only apply to candidates who will be working from an unincorporated area reputed company Los Angeles County. **

reputed company will consider for employment reputed company qualified applicants, including those with arrest or conviction records, in a manner consistent with the requirements of applicable state and local laws (e.g., the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act). reputed company intends to conduct a review of an applicant’s criminal history in reputed company with a conditional offer. reputed company reasonably believes that a criminal history may have a direct, adverse and negative relationship with the following material job duties for this position potentially resulting in the withdrawal of the conditional offer of employment: handling of confidential, proprietary or trade secret information belonging to reputed company or its customers, administrating or facilitating financial transactions, and the ability to meet customer-imposed criminal history requirements. reputed company Offer By choice, we don’t simply accept individuality – we embrace it, we support it, and we reputed company on it! Our People First Culture celebrates diversity, equity and inclusion not simply because it’s the right thing to do, but also because it’s the key to our success. We are proud to foster an authentic and inclusive workplace For reputed company. You are free and encouraged to bring your entire, unique self to work. reputed company is an equal opportunity employer in every sense of the term. Based on eligibility, reputed company 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 tot his job Apply To this Job