Senior Data Engineer - Scale Data Pipelines & Analytics

First American; Fort Mill (SC); On-site; USD 122,000 - 131,000; Full time

Benefits offered by this job

Health, dental, vision

401k

Paid time off

Employee stock purchase plan

Job summary

First American is hiring a Senior Data Engineer in Fort Mill, SC to develop and deploy innovative big data platforms for advanced analytics. You will support data initiatives, design scalable architectures, and collaborate with data scientists, analysts, and software teams to ensure reliable data delivery and high-quality solutions.

The role requires 5–8 years of experience, strong SQL/T-SQL skills, ETL and data warehousing expertise, and proficiency in cloud technologies.

Qualifications

• Bachelor's degree in Computer Science/related field or equivalent.
• 5-8 years of directly related experience.
• Experience with Agile SDLC.
• Proficient with SQL and T-SQL.
• Working experience building data/ETL pipelines and data warehouses.
• Demonstrated expertise in data modeling, database maintenance, monitoring and performance tuning on SQL Server, MongoDB or other NoSQL databases.
• Exceptional analytical skills analyzing large and complex data sets.
• Perform thorough testing and data validation to ensure the accuracy of data transformations.
• Strong written and verbal communication skills, with precise documentation.
• Self-driven team player with ability to work independently and multi-task.

Responsibilities

• Viewed as a data expert; drives innovation and plays a key role in the department.
• Identify, design, and implement internal process improvements: automate manual processes, optimize data delivery, re-design infrastructure for greater scalability.
• Design, develop, code, test, and document architectures and applications.
• Work closely with team members and cross-functional teams to ensure design/architecture/deliverables support business requirements and align with best-practices.
• Troubleshoot and resolve a wide range of data issues.
• Makes innovative recommendations to improve data reliability, efficiency and quality.
• Required to perform duties outside of normal work hours based on business needs.

Skills

SQL/T-SQL

Data warehousing

ETL pipelines

NoSQL databases

Data modeling

Performance tuning

Data validation

Cloud computing

Agile SDLC

Documentation

Education

Bachelor's degree in CS or related field

Tools

SQL Server

MongoDB

ETL tools

Job description

First American is hiring a Senior Data Engineer in Fort Mill, SC to develop and deploy innovative big data platforms for advanced analytics. You will support data initiatives, design scalable architectures, and collaborate with data scientists, analysts, and software teams to ensure reliable data delivery and high-quality solutions.

The role requires 5–8 years of experience, strong SQL/T-SQL skills, ETL and data warehousing expertise, and proficiency in cloud technologies.