Sr. Data Engineer

What you'll do:

• Build high-performing cloud data solutions to meet our analytical and BI reporting needs.
• 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 sources of data into our central data warehouse, and moving data out to applications and other 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.
• Partner with teams across the business to understand their needs and develop end-to-end data solutions.
• Collaborate with analysts and data scientists to perform exploratory analysis and troubleshoot issues.
• 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.
• Experience with or knowledge of Agile Software Development methodologies.

What you'll bring:

• 5+ years of development experience with any of the following software languages: Python or Scala, and SQL (we use SQL & Python) 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.
• Hands-on experience in modern Data Analytics architectures encompassing data warehouse, data lake etc. designed and engineered in a cloud environment.

• 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

Data Modeling

• Design schema and data pipelines to extract, transform, and load (ETL) data from various sources into the data warehouse or data lake.
• 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.

*Open to remote candidates*

The pay range for this role is $126,100.00 - $168,150.00

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.

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal work hours and/or responsibilities from time to time, as needed.

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.