ETL Engineer

Job not on LinkedIn

October 15

🏄 California – Remote

Although this job is listed in California, this company may be open to hiring remote in other states.

💵 $72.1k - $100.4k / year

⏰ Full Time

🟢 Junior

📊 Analytics Engineer

🦅 H1B Visa Sponsor

Apply Now

Receive Emails with Similar Jobs

First American

WebsiteLinkedInAll Job Openings

Real Estate • Finance • Enterprise

First American is a historical company that has been operating since 1889, evolving into a $9 billion organization with over 20,000 employees and more than 700 offices worldwide. The company provides a range of products and services that assist homebuyers, sellers, businesses, and investors in the real estate market. With a strong focus on employee engagement and culture, First American emphasizes innovation, technology, and community involvement, driving transformation within the real estate industry.

10,000+ employees

Founded 1889

🏠 Real Estate

💸 Finance

🏢 Enterprise

📋 Description

• Develop high quality efficient ETL applications leveraging Transact-SQL stored procedures and other ETL environments. • Work closely with data architects to profile and review source system data. • Perform 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 perform duties outside of normal work hours based on business needs.

🎯 Requirements

• 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 Microsoft SSIS, CDC, Informatica, or cloud-based tools such as Snowflake and Databricks. • 3+ years of experience working with Microsoft SQL Server 2000 / 2005 / 2008. • 2+ years of experience designing and developing complex 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 Google 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 Microsoft SSIS and DTS. • Constantly updating personal technical and business knowledge and skills, and mentoring others to increase the knowledge and skills of the team.

🏖️ Benefits

• medical • dental • vision • 401k • PTO/paid sick leave • employee stock purchase plan