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

Key technologies and capabilities for this role

ETLData WarehouseData MappingData IntegrationSQLData DevelopmentData Testing

Questions & Answers

Common questions about this position

Is this ETL Engineer position remote-friendly?

Yes, the position is open to remote work.

What experience is required for this ETL Engineer role?

Candidates need 1+ year of experience in a data warehousing environment, a good understanding of relational database models and dimensional data models, and 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 like Snowflake and Databricks, plus 3+ years of experience.

What does the ETL Engineer do on a daily basis?

The role involves developing high quality efficient ETL applications using Transact-SQL stored procedures and other ETL environments, working closely with data architects to profile source data, performing ETL monitoring and performance tuning, creating best-practice standards, participating in on-call rotation, and performing duties outside normal hours as needed.

What is the company culture like at First American?

First American has a people-first culture that fosters an inclusive environment where employees feel welcome, supported, and empowered to innovate, with accolades including the Fortune 100 Best Companies to Work For for ten years and awards for diversity.

What is the salary for this ETL Engineer position?

This information is not specified in the job description.

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