Data Engineering Intern - REMOTE

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

Job summary

First American, a leader in real estate data products, is offering an internship within its Data Engineering team. The role focuses on migrating data workloads from Azure to Google Cloud Platform (GCP) and on building scalable ETL workflows in cloud-native environments.

You will contribute to data validation, documentation, and collaboration with product engineering to ensure seamless integration of data services across enterprise-scale pipelines.

Qualifications

• Strong SQL skills
• Python for data engineering and transformation
• Experience with Pandas and NumPy
• Understanding of ML concepts: regression, classification, clustering
• Ability to build/train/evaluate ML models with Scikit-learn
• Data visualization with Matplotlib/Seaborn
• Understanding of statistics, probability, ML basics
• Experience with ETL and ETL tools; familiarity with GCP/Azure
• Familiarity with cloud platforms (Azure/GCP)
• Understanding of distributed data processing and version control

Responsibilities

• Assisting in migrating data pipelines from Azure to GCP
• Designing, building, and testing ETL workflows in cloud environments
• Refactoring data transformation processes for scalability and performance
• Supporting data validation, reconciliation, and quality assurance
• Contributing to technical documentation and diagrams
• Collaborating with product engineering teams to ensure integration of data services
• Participating in code reviews and version control workflows

Skills

SQL

Python

Pandas/NumPy

ML concepts

Scikit-learn

Data visualization

ETL processes

GitHub

Data warehousing

Cloud basics

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

First American builds and delivers industry-leading real estate data products, including solutions such as the National Title Plant and National Starter Exchange. These platforms power critical title, settlement, underwriting, and risk decisions across the real estate ecosystem. The Data Engineering team designs, builds, and maintains large-scale data platforms that support these external, customer-facing products. The team works with modern cloud technologies to ensure scalable, secure, and high-performance data processing pipelines that enable real-time and batch analytics at enterprise scale. This internship will support First American’s cloud modernization initiatives, with a focus on migrating data engineering workloads from Azure to Google Cloud Platform (GCP). The intern will contribute to ETL development, data pipeline optimization, and platform modernization efforts that directly support First American’s national data products.

Key Activities

• Assisting in the migration of data pipelines from Azure-based infrastructure to GCP
• Designing, building, and testing ETL workflows in cloud-native environments
• Refactoring and optimizing existing data transformation processes for scalability and performance
• Supporting data validation, reconciliation, and quality assurance efforts
• Contributing to technical documentation and architectural diagrams
• Collaborating with product engineering teams to ensure seamless integration of data services
• Participating in code reviews and version control workflows

Target Skillset

• Strong SQL skills
• Python for data engineering and transformation
• Experience with data manipulation using Pandas and NumPy
• Understanding basic machine learning concepts, including regression, classification, Clustering, model evaluation, and overfitting
• Ability to build, train, and evaluate ML models using tools like Scikit-learn
• Familiarity with data visualization tools such as Matplotlib or Seaborn
• Understanding of basic statistics, probability, and machine learning concepts (regression and classification)
• Experience with data cleaning, preprocessing, and exploratory data analysis (EDA) to understand patterns and trends
• Knowledge of ETL processes and experience with ETL tools such as Informatica; familiarity with GCP tools (e.g., Big Query, Dataflow, Cloud Composer, Cloud Storage) is an added advantage
• Familiarity with cloud platforms (Azure and/or GCP preferred)
• Understanding of distributed data processing concepts
• Experience with version control (e.g., GitHub)
• Knowledge of data warehousing concepts and data modeling
• Strong problem-solving and analytical skills

$40.00 - $45.00 hourly

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. Note that the following statements only apply to candidates who will be working from an unincorporated area within Los Angeles County. **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 Offer

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