RealPage

Senior Data Engineer

RealPage$105K — $180K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 7+ years in Data Warehouse, ETL, and Reporting systems support.
  • Expertise in Microsoft SQL Server and T-SQL performance tuning.
  • Experience with SSIS packages in Visual Studio (2017/2019) including control flow and error handling.
  • Strong skills in designing and maintaining SSRS reports for operational use.
  • Solid relational data modeling skills and ability to work with complex schemas.
  • Experience in regulated environments with compliance and auditing requirements.
  • Proficient in ticket-driven Kanban delivery and PR-based change management.

Responsibilities

  • Design and maintain SSIS packages for data loading.
  • Enhance SSRS reports focusing on performance.
  • Optimize T-SQL stored procedures and functions per team standards.
  • Resolve production data issues through thorough root cause analysis.
  • Tune performance for queries and ETL processes.
  • Evolve relational schemas to accommodate new reporting needs.
  • Manage changes across development, QA, and production environments.
  • Review pull requests and enforce SQL/SSIS standards.

Benefits

  • Opportunities for mentoring junior engineers.
  • Collaborative work environment with QA and BAs for validation.
  • Access to AI-assisted development tools to enhance productivity.
Full Job Description
Overview

RealPage is hiring a Senior Data Engineer to join theFront Office - Screening BI and Data Warehouse team. This role owns the SQL Serverbased reporting, ETL, and data warehouse codebase that powers screening operations, billing, compliance, and customer-facing reports across the Screening business. You will design andmaintaina large SSIS/SSRS/T-SQL platform, deliver new reports and ETL jobs in response to business and customer requests, and uphold the data quality and audit standards asrequired.

You will be the technical SME and will work with the product owner for changes that flow through user stories, service requests, and defects.

Responsibilities
  • Design, develop, and maintain SSIS packages (Visual Studio 2019+) that load transactional and reference data into the reporting warehouse.

  • Design, build and enhance SSRS reports (.rdl) keeping in mind the performance.

  • Write and optimize T-SQL stored procedures, functions, views, triggers following the teams SQL object templates and naming conventions.

  • Diagnose and resolve production data and report issues raised via Service Requests and Defects; perform root cause analysis and deliver durable fixes, not just patches.

  • Tune query and package performance: indexing strategy, execution plan analysis, batching, partitioning, and ETL throughput.

  • Model and evolve relational schemas (dimensions, fact tables, staging, source-of-truth structures) to support new reporting needs without breaking existing consumers.

  • Manage environment and configuration changes (e.g., server moves, connection updates) safely across Dev, QA, and Prod tiers.

  • Reviewpullrequests in Azure DevOps; enforce SQL/SSIS standards and protect downstream report contracts.

  • Partner with QA and BAs tovalidatereport output against business expectations and historical data.

  • Maintain auditability and traceability of data, ETL packages, and report changes.

  • Mentor junior data/reportengineers;contribute to internal documentation, templates, and onboarding material.

  • Leverage AI-assisted development tools to accelerate T-SQL authoring, SSIS package review, report changes, troubleshooting, and test data generation.

Qualifications

Required

  • 7+ years of professional experience building and supportingproductionData Warehouse, ETL, and Reporting systems.

  • Deep hands-onexpertisewithMicrosoft SQL ServerandT-SQL: stored procedures, functions, CTEs, window functions, performance tuning, indexing, and execution plan analysis.

  • Strong experience authoring and maintainingSSIS packagesin Visual Studio (2017/2019 or later) control flow, data flow, parameterization, configurations, error handling, and deployment.

  • Strong experience designing and maintainingSSRS reports(.rdl) datasets, parameters, expressions,subreports, andrenderingfor operational and customer-facing use.

  • Solid relational data modeling skills for OLTP staging and warehouse/reporting structures; comfort working in a large existing schema with many downstream dependencies.

  • Experienceoperatingin a regulated environment with change control, segregation of duties, and audit evidence requirements.

  • Comfort with ticket-driven Kanban delivery (Service Requests, Defects, User Stories) and PR-based change management inAzure DevOps / GitHub.

  • Strong analytical and root-causeanalysisskills for production data issues; ability to readcomplexreal-world data and reasonaboutwhat the right answer should be.

  • Hands-on experience with AI-assisted coding, specificallyClaude Code, for day-to-day development work authoring and reviewing T-SQL, navigating large SSIS/SSRS codebases, generating and validating test data, drafting documentation, and troubleshooting production issues.

  • Strong written and verbal communication; able to translate business and compliance requirements into precise data changes.

Preferred

  • Familiarity with the consumer screening, tenant screening, or financial services billing domain.

  • Experience with SSAS, Power BI, or other reporting/analytics layers built on top of SQL Server.

  • Experience with SQL Server Agent jobs, scheduling, modern SQL tooling, and operational monitoring of ETL/report workloads.

  • Exposure tocloud dataplatformsRedshift,QuickSight, and migration patterns from on-prem SQL Server.

  • Source control hygiene with repos in Azure DevOps or GitHub. Experiencesetting up CI checks for SQL/SSIS artifacts.

  • Experience producing andmaintainingdata lineage andimpactanalysis for reports and downstream consumers.

WhatYoullWork In

  • Languages / platforms:T-SQL, SQL Server, SSIS, SSRS, Redshift

  • Tooling:Visual Studio 2019 or later, SQL Server Management Studio

  • Source control & delivery:Azure DevOps / GitHub, PR-based reviews

Pay RangeUSD $105,800.00 - USD $180,200.00 /Yr.

About RealPage

RealPage is a provider of software and data analytics to the real estate industry. The company's platform enables property owners and managers to manage their properties, including leasing, accounting, and maintenance, among other services. RealPage's clients include property owners, managers, and investors. The company was founded in 1998 and is headquartered in Richardson, Texas.
Learn more about RealPage
Size
1 employees
Market Cap
$9 billion
Industry
Net Income
$46.3 million
Founded
1998
5 Year Trend
+19.8%
Revenue
$1.1 billion
NASDAQ

Similar Jobs

More Jobs at RealPage

More Information Technology Jobs

Find similar Senior Data Engineer jobs: