Sr. Data Engineer

ForFutures Financial, Planning, a financial advisory practice of Ameriprise Financial Services LLC; Santa Ana (CA); Remote; USD 126,000 - 169,000; Full time

Job summary

A leading financial advisory practice is seeking a Senior Data Engineer to enhance their data engineering capabilities. The role involves building cloud data solutions, collaborating with teams, and mentoring junior engineers. Candidates should have extensive experience in Python, SQL, and cloud environments, with a focus on data security and analytics.

Qualifications

• 5+ years of development experience with Python or Scala, and SQL.
• Experience creating and maintaining data intensive distributed solutions in a cloud environment.

Responsibilities

• Build high-performing cloud data solutions for analytics and BI reporting.
• Design, implement, test, deploy, and maintain data engineering solutions.
• Collaborate with analysts and data scientists for exploratory analysis.

Skills

Python

SQL

Cloud Security

Data Modeling

Agile Software Development

Tools

Apache Kafka

Fivetran

Apache Airflow

Databricks

Snowflake

BigQuery

Spark

HIVE

Hadoop

Cloudera

RedShift

Job description

Join to apply for the Sr. Data Engineer role at ForFutures Financial, Planning, a financial advisory practice of Ameriprise Financial Services LLC

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 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

1. Build high-performing cloud data solutions to meet our 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 sources of data 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 greater scalability, etc.
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 role 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 Python or Scala, and SQL, with cloud experience (Azure preferred or AWS).
2. Hands-on data security and cloud security methodologies. Experience in configuration and management of data security to meet compliance and CISO security requirements.
3. Experience creating and maintaining data intensive distributed solutions in a cloud environment.
4. Experience in modern Data Analytics architectures in a cloud environment.
5. Proven experience with Event Streaming Platforms and data pipeline orchestration tools like Apache Kafka, Fivetran, Apache Airflow, or similar.
6. Experience with 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.
2. Create, maintain, and optimize database structures for large data volumes.
3. Evaluate data trends and model solutions for current and future needs.
4. Implement data cleansing and oversee data quality.
5. Drive development and 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 and actual pay depends on various factors including experience, skills, and location.