Senior Data Engineer

Join the Front Office Screening BI and Data Warehouse team at RealPage, owning SQL Server reporting, ETL, and data warehouse code in an onsite role in Richardson, TX.

Responsibilities

• Design, develop, and maintain SSIS packages (Visual Studio 2019+) to load transactional and reference data into the reporting warehouse
• Design, build, and enhance SSRS reports (.rdl) with performance in mind
• Write and optimize T-SQL objects including stored procedures, functions, views, and triggers using team SQL object templates and naming conventions
• Investigate and resolve production data and report issues reported via Service Requests and Defects using root cause analysis to deliver durable fixes
• Tune performance across queries and ETL packages using 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 (for example, server moves and connection updates) safely across Dev, QA, and Prod
• Review pull requests in Azure DevOps, enforcing SQL/SSIS standards and protecting downstream report contracts
• Collaborate with QA and BA teams to validate report output against business expectations and historical data
• Maintain auditability and traceability for data, ETL packages, and report changes
• Mentor junior data/report engineers; contribute to internal documentation, templates, and onboarding materials
• Use AI-assisted development tools to accelerate T-SQL authoring, SSIS/SSRS review, report change work, troubleshooting, and test data generation

Requirements

• 7+ years of professional experience building and supporting production Data Warehouse, ETL, and Reporting systems
• Deep hands-on expertise with Microsoft SQL Server and T-SQL, including stored procedures, functions, CTEs, window functions, performance tuning, indexing, and execution plan analysis
• Strong hands-on experience authoring and maintaining SSIS packages in Visual Studio (2017/2019 or later), including control flow, data flow, parameterization, configurations, error handling, and deployment
• Strong experience designing and maintaining SSRS reports (.rdl), including datasets, parameters, expressions, subreports, and rendering for operational and customer-facing use
• Solid relational data modeling skills for OLTP staging and warehouse/reporting structures, including comfort working in a large existing schema with many downstream dependencies
• Experience operating in 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 in Azure DevOps / GitHub
• Strong analytical and root-cause analysis skills for production data issues; ability to interpret complex real-world data and determine the correct outcome
• Hands-on experience with AI-assisted coding, specifically Claude Code, for day-to-day development work including 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, including translating business and compliance requirements into precise data changes

What You’ll Work 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

Technologies

• SQL Server
• T-SQL
• SSIS
• SSRS
• Visual Studio 2017
• Visual Studio 2019
• Azure DevOps
• GitHub
• Redshift
• QuickSight
• SQL Server Management Studio
• Claude Code

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 to cloud data platforms Redshift and QuickSight, and migration patterns from on-prem SQL Server
• Source control hygiene with repos in Azure DevOps or GitHub, including experience setting up CI checks for SQL/SSIS artifacts
• Experience producing and maintaining data lineage and impact analysis for reports and downstream consumers

Location: Richardson, TX (onsite) | Compensation: USD 105,800 - 180,200 per year