Senior Backend Data Engineer: Azure & AI Automation

First American Financial Corporation; United States; Remote; USD 122,000 - 131,000; Full time

Job summary

First American Financial Corporation is seeking a Senior Data Engineer to design, build, and support back-end systems for processing operational data using SQL Server, C#/.NET, Python, and Azure. You will own solutions from design to deployment, investigate root causes, and ensure reliable data flows.

The role requires 5–8 years of backend data processing experience, strong SQL skills, and experience with data integrations and automated pipelines.

Qualifications

• Bachelor's degree in Computer Science or a related field, or an equivalent combination of education and experience.
• Five to eight years of relevant experience developing and supporting back-end applications, database solutions, or automated data processing systems.
• Strong SQL Server and T-SQL development skills, including stored procedures, transactions, indexing, and query performance tuning.
• Hands-on programming experience with C#/.NET or Python, including building and maintaining production applications.
• Experience developing system integrations using REST APIs, authentication, and structured data formats such as JSON.
• Experience building automated data pipelines and managing dependencies, incremental loads, failures, and recovery.
• Understanding of relational data modeling, data integrity, and database concurrency.
• Experience troubleshooting production systems using application logs, database diagnostics, and monitoring tools.
• Ability to work across application development, database engineering, and production operations, including systems with limited documentation.
• Experience with Git, code reviews, automated testing, and continuous integration and deployment.
• Working knowledge of Azure services used for application hosting, data storage, or integration.
• Experience working within an Agile software development lifecycle.
• Strong analytical and problem-solving skills, with attention to data accuracy and operational reliability.
• Clear written and verbal communication skills, including technical documentation.
• Ability to work independently, collaborate across teams, and manage competing priorities.

Responsibilities

• Design, develop, and maintain back-end applications, automated jobs, and data integrations using SQL Server, C#/.NET, and Python.
• Develop and optimize T-SQL stored procedures, database schemas, and data processing logic.
• Build integrations that exchange data through application programming interfaces, databases, and files.
• Develop extract, transform, and load pipelines with data validation, logging, error handling, retry logic, and recovery procedures.
• Design processing workflows that prevent duplicate loads and support safe restarts after failures.
• Investigate issues across application code, SQL databases, scheduled jobs, APIs, and file transfers to identify and resolve root causes.
• Improve database and application performance through execution plan analysis, indexing, concurrency management, and code optimization.
• Maintain and modernize existing systems while building new automation and integrations.
• Write automated tests and reconcile source and target data to verify completeness and accuracy.
• Own changes through impact analysis, implementation, testing, deployment, rollback planning, and production verification.
• Use source control, code reviews, and controlled release practices to maintain code quality and reduce deployment risk.
• Translate business requirements into technical designs and document system dependencies, configuration, and support procedures.
• Use AI-assisted development tools where appropriate for development, troubleshooting, testing, and documentation. Review and validate generated output.
• Support production systems outside normal work hours when business needs require it.

Skills

SQL Server

T-SQL

C#/.NET

Python

REST APIs

Data pipelines

Relational data modeling

Troubleshooting

Git

Azure

Agile

CI/CD

Education

Bachelors in CS or related field

Tools

Git

Azure

Job description

First American Financial Corporation is seeking a Senior Data Engineer to design, build, and support back-end systems for processing operational data using SQL Server, C#/.NET, Python, and Azure. You will own solutions from design to deployment, investigate root causes, and ensure reliable data flows.

The role requires 5–8 years of backend data processing experience, strong SQL skills, and experience with data integrations and automated pipelines.