Senior Data Engineer: SQL Server DW & ETL Architect

RealPage, Inc.; Richardson (TX); On-site; USD 106,000 - 180,000; Full time

Job summary

RealPage, Inc. is building out its Front Office Screening BI and Data Warehouse capabilities. This Senior Data Engineer will own SQL Server-based reporting, ETL, and data warehouse code, ensuring reports are reliable and performant.

Onsite in Richardson, TX, you’ll collaborate with QA and BAs to validate outputs, respond to tickets, and evolve warehouse structures while using AI-assisted tools to accelerate SQL development and debugging.

Qualifications

• 7+ years of professional experience in Data Warehouse, ETL, and Reporting systems.
• Deep hands-on expertise with Microsoft SQL Server and T-SQL, including performance tuning and indexing.
• Strong hands-on experience authoring and maintaining SSIS packages in Visual Studio 2017/2019+ with deployment.
• Strong experience maintaining SSRS reports (rdl) including datasets, parameters, and rendering.
• Solid relational data modeling skills for OLTP staging and warehouse structures, with experience in large schemas.

Responsibilities

• Design, develop, and maintain SSIS packages and load data into the reporting warehouse.
• Design, build, and enhance SSRS reports with performance focus.
• Write and optimize T-SQL including stored procedures, functions, views, and triggers.
• Diagnose and resolve production data and report issues, perform root-cause analysis.
• Tune query and package performance via indexing, execution plans, batching, and partitioning.
• Model and evolve relational schemas to support new reporting needs without breaking downstream consumers.
• Manage environment changes across Dev, QA, and Prod (server moves, connections).
• Review PRs in Azure DevOps and GitHub, enforcing SQL and SSIS standards.

Skills

SQL Server

T-SQL

SSIS

SSRS

Azure DevOps

GitHub

Redshift

Claude Code

Data Modeling

ETL

Reporting

Performance tuning

Root cause analysis

AI-assisted coding

Tools

Visual Studio 2017/2019+

SQL Server Management Studio

Job description

RealPage, Inc. is building out its Front Office Screening BI and Data Warehouse capabilities. This Senior Data Engineer will own SQL Server-based reporting, ETL, and data warehouse code, ensuring reports are reliable and performant.

Onsite in Richardson, TX, you’ll collaborate with QA and BAs to validate outputs, respond to tickets, and evolve warehouse structures while using AI-assisted tools to accelerate SQL development and debugging.