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.