Hiring: Senior Data Engineer Company: Realpage Location: Richardson, TX Job Posted Time: 2026-09-10 12:09:37 Target Skills & Keywords : Azure DevOps, Change Management, Data Warehouse, ETL, GitHub, Kanban, Redshift, Root Cause Analysis, SQL, SQL Server, T-SQL About the job Experience: •7+ years of professional experience building and supporting production Data Warehouse, ETL, and Reporting systems. Required Skills: •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 team’s 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. •Review pull requests in Azure DevOps; enforce SQL/SSIS standards and protect downstream report contracts. Qualifications: •Deep hands-on expertise with Microsoft SQL Server and T-SQL : stored procedures, functions, CTEs, window functions, performance tuning, indexing, and execution plan analysis. •Strong experience authoring and maintaining SSIS packages in Visual Studio (2017/2019 or later) — control flow, data flow, parameterization, configurations, error handling, and deployment. •Strong experience designing and maintaining SSRS reports (.rdl) — datasets, parameters, expressions, subreports, and rendering for 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. •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 read complex real-world data and reason about what the right answer should be. •Applied hands-on capability in AI-assisted coding, specifically Claude 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. •Operational familiarity with the consumer screening, tenant screening, or financial services billing domain. •Exposure to cloud data platforms Redshift, QuickSight, and migration patterns from on-prem SQL Server. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!