ETL Engineer (Open to Remote) at First American

Santa Ana, California, United States

Apply Now

Not SpecifiedCompensation

Mid-level (3 to 4 years)Experience Level

Full TimeJob Type

UnknownVisa

Real Estate, Data Analytics, Financial ServicesIndustries

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

Responsibilities

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
Other duties as assigned

Skills

ETL

Data Warehouse

Data Mapping

Data Integration

SQL

Data Development

Data Testing

First American

Provides title insurance and real estate services

About First American

First American provides title insurance, specialty insurance, and various real estate-related services. Their title insurance protects homebuyers and property owners from potential ownership disputes and financial losses related to real estate transactions. The company offers a platform called myFirstAm®, which allows users to access property information, manage orders, and streamline the closing process from any device. Unlike many competitors, First American has a vast database of property data, with over 5.5 billion document images, making it a leading provider of real estate data solutions. The company's goal is to facilitate smooth real estate transactions while ensuring that clients' investments are protected.

Santa Ana, CaliforniaHeadquarters

1889Year Founded

$800.2MTotal Funding

VENTURE_UNKNOWNCompany Stage

Financial Services, Real EstateIndustries

10,001+Employees

Benefits

401k matching

Health, vision, dental insurance

Professional development

Risks

Data breach allegations could harm First American's reputation and lead to legal issues.

Integration of Mother Lode may face challenges and financial risks.

Dependence on digital transformation poses risks if technology advances rapidly.

Differentiation

First American offers comprehensive title insurance and settlement services nationwide.

The company provides a vast database of over 5.5 billion document images.

First American's digital platform, myFirstAm®, enhances real estate transaction efficiency.

Upsides

Acquisition of Mother Lode expands First American's market share in California.

Docutech purchase boosts First American's digital mortgage revenue by 38%.

Growing fintech trends align with First American's digital transformation strategy.

Land your dream remote job 3x faster with AI

Try Jobo Free