Sr. Data Engineer

First American; California (MO); Remote; USD 126,000 - 169,000; Full time

Job summary

An established industry player is seeking a Senior Data Engineer to enhance their data engineering capabilities. This role involves developing cloud data solutions, optimizing data delivery, and collaborating with cross-functional teams. The ideal candidate will have extensive experience in Python, SQL, and cloud platforms, with a strong focus on data security and compliance. Join a forward-thinking company that values diversity and innovation, providing a collaborative environment where your expertise will drive impactful solutions. If you are passionate about data and eager to make a difference, this opportunity is perfect for you.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

401k

Paid Time Off

Sick Leave

Employee Stock Purchase Plan

Qualifications

• 5+ years of experience in development with Python, SQL, and cloud technologies.
• Hands-on experience with data security and compliance in cloud environments.

Responsibilities

• Build high-performing cloud data solutions for analytics and BI reporting.
• Design and implement scalable data engineering solutions on the cloud.

Skills

Python

SQL

Scala

Cloud Security

Data Warehousing

Data Analytics

Event Streaming

Data Modeling

Agile Methodologies

Tools

Azure

AWS

Apache Kafka

Fivetran

Apache Airflow

Databricks

Snowflake

BigQuery

Spark

Docker

Job description

Who We Are

Join a team that puts its People First! 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 nine 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.

What We Do

First American Trust is seeking a Senior Data Engineer to help develop and grow our data engineering capabilities to enhance the Strategic Product Development Organization. You will help FA Trust's Data Engineering team make real-time decisions based on datasets, facilitate analytics on existing products, and provide insights on potential new opportunities for growth. You will partner with subject matter experts to help solve business problems with data and mentor data engineers and junior data engineers by providing guidance, advice, and support in various facets of data engineering.

What you'll do:

1. Build high-performing cloud data solutions to meet analytical and BI reporting needs.
2. Design, implement, test, deploy, and maintain distributed, stable, secure, and scalable data-intensive engineering solutions and pipelines in support of data and analytics projects on the cloud, including integrating new data sources into our central data warehouse, and moving data out to applications and other destinations.
3. Identify, design, and implement internal process improvements, such as automating manual processes, optimizing data delivery, and re-designing infrastructure for scalability.
4. Build and enhance a shared data lake that powers decision-making and model building.
5. Partner with teams across the business to understand their needs and develop end-to-end data solutions.
6. Collaborate with analysts and data scientists to perform exploratory analysis and troubleshoot issues.
7. Manage and model data using visualization tools to provide the company with a collaborative data analytics platform.
8. Build tools and processes to help make the correct data accessible to the right people.
9. Participate in active rotational support roles for production during or after business hours supporting business continuity.
10. Engage in collaboration and decision-making with other engineers.
11. Experience with or knowledge of Agile Software Development methodologies.

What you'll bring:

1. 5+ years of development experience with languages such as Python or Scala, and SQL, with cloud experience (Azure preferred or AWS).
2. Hands-on data security and cloud security methodologies, including configuration and management to meet compliance and security requirements.
3. Experience creating and maintaining data-intensive distributed solutions involving data warehouses, lakes, and analytics in cloud environments.
4. Experience with modern Data Analytics architectures, including data warehouses and lakes, designed and engineered in cloud settings.
5. Proven experience with Event Streaming Platforms and data pipeline orchestration tools like Apache Kafka, Fivetran, Apache Airflow, or similar.
6. Experience with platforms such as Databricks, Snowflake, BigQuery, Spark, HIVE, Hadoop, Cloudera, or RedShift.
7. Experience developing in containerized environments like Docker, Rancher, or Kubernetes is preferred.

Data Modeling

1. Design schema and data pipelines for ETL processes from various sources into data warehouses or lakes.
2. Create, maintain, and optimize database structures for large data volumes.
3. Evaluate data trends and model data solutions to meet current and future business needs.
4. Implement data cleansing and oversee data quality.
5. Drive development, delivery, and continuous improvement of cloud-based enterprise data warehouse architecture.

*Open to remote candidates*

The pay range for this role is $126,100.00 - $168,150.00. This is an estimate based on various factors including experience, skills, and location.

Disclaimer

The above statements describe the general nature of the work and are not exhaustive. Duties may extend beyond those listed, and work hours may vary as needed.

What We Offer

We embrace diversity, equity, and inclusion, supporting all individuals to bring their full selves to work. First American is an equal opportunity employer.

Note: For candidates working in unincorporated areas within Los Angeles County, additional considerations apply.

We consider all qualified applicants, including those with criminal records, in accordance with applicable laws. We conduct criminal history reviews in connection with offers of employment, considering factors such as the nature of the criminal history and its relevance to job duties.

Our benefits include medical, dental, vision, 401k, PTO, sick leave, and other benefits like an employee stock purchase plan.