Senior Data Engineer (Remote in CA)

Who We AreJoin a team that puts its People First! As a member of the First American family of companies, First American Trust is a federal savings bank that has provided banking, wealth management, and trust solutions on a national, full-service basis for more than five decades. 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 ten 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 DoFirst 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 the datasets, facilitate analytics on existing products, and provide insights on potential new opportunities for growth. You will partner with subject matter experts to help us solve business problems with data. You will mentor data engineers and junior data engineers by providing guidance, advice, and support in various facets of data engineering.

What You'll Do:

• Build high-performing cloud data solutions to meet our analytical and BI reporting needs.
• Design, build, and operate secure, scalable cloud data pipelines that support analytics and data products.
• Integrate new data sources into the central data warehouse and deliver curated data to applications and other downstream destinations.
• Identify, design, and implement internal process improvements, such as automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability, etc.
• Build and enhance a shared data lake that powers decision-making and model building.
• Implement data governance best practices across pipelines and datasets, including data quality checks, metadata management, lineage, and access controls.
• Partner with teams across the business to understand their needs and develop end-to-end data solutions.
• Collaborate with analysts to perform exploratory analysis and troubleshoot issues.
• Coach and develop the team by providing hands-on mentorship to engineers, lead code and design reviews, create training/onboarding content, and run knowledge-sharing sessions.
• Manage and model data using visualization tools to provide the company with a collaborative data analytics platform.
• Build tools and processes to help make the correct data accessible to the right people.
• Participate in active rotational support role for production during or after business hours supporting business continuity.
• Engage in collaboration and decision making with other engineers.
• Lead presentations regularly for stakeholders.

What You'll Bring:

• 5+ years of development experience with any of the following software languages: Python and SQL with cloud experience (Azure preferred or AWS).
• Hands-on data security and cloud security methodologies. Experience in configuration and management of data security to meet compliance and CISO security requirements.
• Experience creating and maintaining data intensive distributed solutions (especially involving data warehouse, data lake, data analytics) in a cloud environment.
• Proven experience with relational and non-relational databases (e.g., PostgreSQL, Oracle, Azure Cosmos DB, MongoDB), including schema design, indexing, query optimization, and operational management in a cloud environment.
• Hands-on experience in modern Data Analytics architectures encompassing data warehouse, data lake etc. designed and engineered in a cloud environment.
• Demonstrated experience applying data governance best practices, including data quality validation, cataloging/metadata, lineage, and role-based access controls.
• Hands-on expertise with LLMs and generative AI workflows. Familiarity with AI governance and privacy-preserving techniques.
• Proven professional working experience in Event Streaming Platforms and data pipeline orchestration tools like Apache Kafka, Fivetran, Apache Airflow, or similar tools
• Proven professional working experience in any of the following: Databricks, Snowflake, BigQuery, Spark in any flavor, HIVE, Hadoop, Cloudera or RedShift.
• Experience developing in a containerized local environment like Docker, Rancher, or Kubernetes preferred
• Experience with or knowledge of Agile Software Development methodologies.

Data Modeling

• Design schema and data pipelines to ingest, standardize, and deliver data from various sources into the data warehouse or data lake using ETL/ELT patterns.
• Create, maintain, and optimize database structures to efficiently store and retrieve large volumes of data.
• Evaluate data trends and model simple to complex data solutions that meet day-to-day business demand and plan for future business and technological growth.
• Implement data cleansing processes and oversee data quality to maintain accuracy. 
• Function as a key member of the team to drive development, delivery, and continuous improvement of the cloud-based enterprise data warehouse architecture.

Pay Range: $129,300.00 - $172,300.00 Annually
This hiring range is a reasonable estimate of the base pay range for this position at the time of posting. Pay is based on a number of factors which may include job-related knowledge, skills, experience, business requirements and geographic location.

First American will consider for employment all 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).

First American intends to conduct a review of an applicant’s criminal history in connection with a conditional offer. First American 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 First American or its customers, administrating or facilitating financial transactions, and the ability to meet customer-imposed criminal history requirements.

What We OfferBy choice, we don’t simply accept individuality – we embrace it, we support it, and we thrive 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 All. You are free and encouraged to bring your entire, unique self to work. First American is an equal opportunity employer in every sense of the term.

Based on eligibility, First American offers a comprehensive benefits package including medical, dental, vision, 401k, PTO/paid sick leave and other great benefits like an employee stock purchase plan.