Senior Data Engineer

Richardson, TX, US • Posted 3 days ago • Updated 11 hours ago
Full Time
On-site
USD $105,800.00 - 180,200.00 per year
Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

  • Recruiting
  • Front Office
  • Business Intelligence
  • Data Quality
  • Reference Data
  • Dimensional Modeling
  • Management
  • Quality Assurance
  • Mentorship
  • Onboarding
  • Data Warehouse
  • Stored Procedures
  • Performance Tuning
  • Control Flow
  • Data Flow
  • Customer Facing
  • Entity Relationship Model
  • OLTP
  • Warehouse
  • Change Control
  • Auditing
  • Kanban
  • User Stories
  • Change Management
  • Analytical Skill
  • Root Cause Analysis
  • Artificial Intelligence
  • Technical Drafting
  • Documentation
  • Communication
  • Regulatory Compliance
  • Screening
  • Financial Services
  • Billing
  • Microsoft SSAS
  • Microsoft Power BI
  • Analytics
  • Scheduling
  • Extract
  • Transform
  • Load
  • Reporting
  • Cloud Computing
  • Migration
  • Continuous Integration
  • SQL
  • Impact Analysis
  • Transact-SQL
  • Microsoft SQL Server
  • Microsoft SSIS
  • Microsoft SSRS
  • Amazon Redshift
  • Microsoft Visual Studio
  • Microsoft SQL Server DBA
  • Version Control
  • Microsoft Azure
  • DevOps
  • GitHub
  • Public Relations

Summary

Overview

RealPage is hiring a Senior Data Engineer to join the Front Office - Screening BI and Data Warehouse team. This role owns the SQL Server-based reporting, ETL, and data warehouse codebase that powers screening operations, billing, compliance, and customer-facing reports across the Screening business. You will design and maintain a 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 as required.

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 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.

  • Partner with QA and BAs to validate report output against business expectations and historical data.

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

  • Mentor junior data/report engineers; 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 supporting production Data Warehouse, ETL, and Reporting systems.

  • 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.

  • 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 read complex real-world data and reason about what the right answer should be.

  • Hands-on experience with 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.

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, QuickSight, and migration patterns from on-prem SQL Server.

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

  • Experience producing and maintaining data lineage and impact analysis for reports and downstream consumers.

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

Pay Range

USD $105,800.00 - USD $180,200.00 /Yr.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10111244
  • Position Id: 17bc35bf10a4db3cf42de1ddcaad3974
  • Posted 3 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Plano, Texas

Today

Full-time

Frisco, Texas

Today

Full-time

USD 85,910.00 - 162,890.00 per year

Fort Worth, Texas

Today

Easy Apply

Full-time

$60 - $75 per hour

Dallas, Texas

Today

Full-time

USD 110,800.00 - 166,200.00 per year

Search all similar jobs