Lead Business Systems Analyst - Database Management (Remote)

Davita Inc.; Town of Texas (WI); Remote; USD 99,000 - 133,000; Full time

Job summary

A leading company seeks a qualified Lead BSA responsible for database design and management. In this role, you'll implement database solutions, optimize performance, and collaborate with developers to ensure data accuracy and integrity. The position offers a competitive salary within the specified range and a supportive work environment focused on diversity and inclusion.

Benefits

Comprehensive benefits package

401k

Employee stock purchase plan

Qualifications

• Experience in database design and modeling.
• Ability to write complex SQL queries and optimize performance.
• Familiarity with ETL processes and data integration tools.

Responsibilities

• Design and implement relational database structures and stored procedures.
• Develop and optimize complex SQL queries for reporting.
• Monitor and provide guidance to ensure data quality and performance.

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 blends software development with database architecture and performance optimization.

Key Responsibilities:

1. Design and implement relational database structures, stored procedures, views, and functions.
2. Develop and optimize complex SQL queries for reporting use.
3. Collaborate with application developers and product managers to integrate backend data solutions.
4. Provide guidance for creating effective ETL processes for data ingestion and transformation.
5. Monitor and provide guidance to the DBA team to tune database performance, including indexing and query optimization.
6. Ensure data quality, consistency, and security across environments.
7. Document database schemas, processes, and best practices.
8. 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 ETL processes to move and transform data between systems; work with tools like SSIS, Informatica, or custom scripts.
• Performance Tuning: Analyze slow-running queries, optimize them, monitor database performance, and suggest improvements.
• Data Quality & Integrity: Implement validation rules and constraints, ensure data consistency across systems.
• Collaboration: Work with application developers, data analysts, and DevOps teams; support BI and reporting needs.

The pay range for this role is $99,675.00 - $132,875.00.

This hiring range is an estimate of the base pay at the time of posting. Pay depends on factors like knowledge, skills, experience, business needs, and location.

Disclaimer

The statements describe the general nature and level of work performed by personnel in this role. They are not exhaustive of all responsibilities, duties, and skills. Personnel may be required to perform duties outside their normal hours or responsibilities as needed.

What We Offer

We embrace individuality and support diversity, equity, and inclusion, which are key to our success. We foster an inclusive workplace for all. You are encouraged to bring your full, unique self to work. First American is an equal opportunity employer. Eligible employees may receive a comprehensive benefits package, including medical, dental, vision, 401k, PTO, sick leave, and other benefits like an employee stock purchase plan.