Lead Business Systems Analyst - Database Management (Remote)

First American Financial; United States; Remote; USD 99,000 - 133,000; Full time

Job summary

A leading company in the real estate and mortgage industry is seeking a Lead Business Systems Analyst for Database Management. This remote position includes responsibilities such as database design, complex SQL development, and collaborating with application developers. The successful candidate will ensure data quality, consistency, and security, while also optimizing database performance to support business processes.

Benefits

Medical, dental, and vision insurance

401k plan

Paid time off

Employee stock purchase plan

Qualifications

• 5+ years experience in database management and software development.
• Proficient in SQL, T-SQL, and PL/SQL.
• Experience with ETL processes and data quality assurance.

Responsibilities

• Design and implement relational database structures and optimize SQL queries.
• Develop ETL processes and support data integration between systems.
• Monitor database performance and ensure data integrity.

Skills

Problem Solving

Attention to Detail

Communication

Collaboration

Documentation

Tools

SQL Server

PostgreSQL

Oracle

Snowflake

SSMS

pgAdmin

Job description

Lead Business Systems Analyst - Database Management (Remote)

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

A Lead BSA in the context of Database Management is responsible for designing, and working with the Technical team to implement designed solution and monitor and ensure the proper maintenance of the databases that support reporting replicated databased and business processes. This role blends software development with database architecture and performance optimization.

Key Responsibilities:

• Design and implement relational database structures, stored procedures, views, and functions.
• Develop and optimize complex SQL queries for reporting use.
• Collaborate with application developers and product managers to integrate backend data solutions.
• Provide guidance for create effective ETL processes for data ingestion and transformation.
• Monitor and Provided guidance to DBA Team to tune database performance, including indexing and query optimization.
• Ensure data quality, consistency, and security across environments.
• Document database schemas, processes, and best practices.
• Support data migration, backup, and recovery strategies.

Tools & Technologies Knowledge:

• Databases: SQL Server, PostgreSQL, Oracle, Snowflake
• Languages: SQL, T-SQL, PL/SQL, Python, JavaScript
• Tools: SSMS, pgAdmin

Why It Matters

Diagnosing data issues and designing efficient solutions.

Ensuring data accuracy and integrity.

Explaining technical concepts to non-technical stakeholders.

Working with developers, analysts, and business users.

Writing clear documentation for procedures, schemas, and logic.

Preferred Skills

Problem Solving

Attention to Detail

Communication

Collaboration

Documentation

Key Responsibilities of a Lead BSA:

Database Design & Modeling

• Create and maintain logical and physical data models.
• Define relationships, constraints, and indexing strategies.

SQL Development

• Write complex SQL queries, stored procedures, functions, triggers, and views.
• Optimize queries for performance and scalability.

ETL & Data Integration

• Develop Extract, Transform, Load (ETL) processes to move and transform data between systems.
• Work with tools like SSIS, Informatica, or custom scripts.

Performance Tuning

• Analyze slow-running queries and optimize them.
• Monitor database performance and suggest improvements (e.g., indexing, partitioning).

Data Quality & Integrity

• Implement validation rules and constraints.
• Ensure data consistency across systems.

Collaboration

• Work closely with application developers, data analysts, and DevOps teams.
• Support business intelligence and reporting needs.

The pay range for this role is $99,675.00 - $132,875.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.

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.

About the company

In June 2010, First American Financial Corporation was established when First American split its businesses to create First American Financial Corporation which provides title and settlement services to the real estate and mortgage industry, and CoreLo...

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at [e-mail] or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at [e-mail] or 407-000-0000.