Lead Business Systems Analyst - Database Management (Remote)

Davita Inc.; Irving (TX); Remote; USD 99,000 - 133,000; Full time

Job summary

Une entreprise de premier plan recherche un Lead BSA pour diriger des projets de gestion de bases de données. Ce rôle combine le développement logiciel et l'architecture de bases de données. Le candidat idéal aura une forte capacité d'analyse et de résolution de problèmes, ainsi qu'une expérience en conception de bases de données et déploiement de solutions ETL. En tant que membre de notre équipe, vous encouragerez une culture d'inclusion et d'innovation, tout en soutenant diverses initiatives de reporting et de qualité des données.

Benefits

Comprehensive benefits package

Medical, dental, vision coverage

401k plan

PTO/paid sick leave

Employee stock purchase plan

Qualifications

• Compétences en SQL, T-SQL, PL/SQL, Python et JavaScript requis.
• Capacité à créer et maintenir des modèles de données.
• Expérience en développement de processus ETL.

Responsibilities

• Concevoir et optimiser des structures de bases de données.
• Développer et optimiser des requêtes SQL complexes.
• Collaborer avec les développeurs pour intégrer des solutions de données.

Skills

Problem Solving

Attention to Detail

Communication

Collaboration

Documentation

Tools

SQL Server

PostgreSQL

Oracle

Snowflake

SSMS

pgAdmin

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

A Lead BSA in the context of Database Management is responsible for designing, working with the Technical team to implement designed solutions, and monitoring and ensuring the proper maintenance of databases that support reporting, replicated databases, and business processes. This role combines 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 creating effective ETL processes for data ingestion and transformation.
• Monitor and guide the 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 job-related knowledge, skills, experience, business requirements, and geographic location.

Disclaimer

The above statements describe the general nature and level of work performed by people assigned to this classification. They are not exhaustive. 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

We embrace individuality and support diversity, equity, and inclusion as key to our success. Our People First Culture celebrates diversity and fosters an inclusive workplace for all. We encourage you to bring your entire, unique self to work. First American is an equal opportunity employer. Based on eligibility, we offer a comprehensive benefits package including medical, dental, vision, 401k, PTO/paid sick leave, and other benefits like an employee stock purchase plan.