Senior Data Platform Engineer - Data Management

Who We Are

Oncourse Home Solutions, also operated as American Water Resources, is a trusted home protection provider helping homeowners across the country protect what matters most. We are a $500 million organization backed by private equity firm Apax Partners, serving 2 million customers across 48 states. We partner with 25+ utilities and municipalities (and growing!) to provide customized solutions tailored to any community - delivering real value where people live.

We help homeowners protect the essential systems that keep their homes running - from HVAC, appliances, and electrical to water, sewer, gas lines, and more - so they can avoid the stress and financial impact of unexpected repairs. Our work helps homeowners stay safe, comfortable, and confident in their homes every day.

At Oncourse, our people are what makes that possible. We call ourselves SUPERs - Successful, United, Progressive, Empathetic, and Reliable - because that’s how we show up for our customers and for each other. We invest in our employees through competitive benefits, an inclusive culture, and employee-led resource groups that strengthen connection, community, and belonging across the company.

As an equal opportunity employer, our employment decisions are based on business needs, job requirements and individual qualifications without regard to race, color, religion, age, sex (including pregnancy), sexual orientation, gender identity, national origin, ancestry, marital status, parental status, mental or physical disability, military or veteran status, or any other basis protected by federal, state, or local law. Oncourse Home Solutions is committed to recruiting and retaining talented applicants and to providing all employees with a workplace free from discrimination and/or harassment.

Position Summary

The Senior Data Platform Engineer – Data Management is responsible for Data Management, Data Masking, Data Scrubbing, and overall Non-Production Data handling at Oncourse Home Solutions. The engineer will design, maintain, and operate data scrubbing and masking processes across AWS, Oracle, and Snowflake using enterprise masking and scrubbing tools such as Delphix, K2view, or similar platforms, along with customized masking scripts where needed.

The role also manages end-to-end Production-to-Non-Production refresh pipelines. The engineer also carries operational ownership of AWS database infrastructure (RDS, Aurora, Redshift, DynamoDB) supporting Dev, QA, UAT, and Production environments, and serves as the internal SME for data masking, database management, and AWS data infrastructure.

Located at our office in Naperville, IL. Our office environment is a key driver of our company culture and employee experience, so a regular in-office hybrid model (generally T-TH in office and M & F remote) is required.

Responsibilities include but are not limited to

• Own and administer the enterprise data masking platform (e.g., Delphix, K2View, or equivalent), including installation, upgrades, patching, and license management
• Build and maintain a masking rule library covering PII, PCI, PHI, and other regulated data classifications (SSNs, credit cards, DOB, account numbers, etc.)
• Manage end-to-end DB refresh workflows: snapshot, backup, restore, and mask pipelines from Production to Dev/QA/UAT environments in AWS
• Manage end-to-end DB refresh workflows: snapshot, backup, restore, and mask pipelines from Production to Dev/QA/UAT environments in AWS
• Implement dynamic masking policies that intercept and obfuscate sensitive data at query time for role-based access in non-production environments
• Manage and optimize AWS-managed database services including RDS (PostgreSQL, MySQL, Oracle, SQL Server), Aurora, Redshift, and DynamoDB
• Monitor database performance using CloudWatch, Performance Insights, and RDS Enhanced Monitoring; proactively tune queries and configurations
• Oversee storage scaling, IOPS tuning, and right-sizing exercises to optimize cost and performance
• Automate refresh, masking, and provisioning pipelines using Python, Shell scripting, AWS Lambda, or Step Functions
• Implement event-driven automation for routine DBA tasks (snapshots, alerts, cleanup of stale environments)
• Lead the creation of a Non-Production Data Management framework, ensuring every non-prod environment is provably free of production-sensitive data
• We're Excited if this is You!

Experience and Qualifications of the Role

10 years of experience in Data Engineering and Database Administration, with 5+ years in AWS, 3+ years operating a data masking platform, and a strong automation-first mindset

Administer and own the enterprise data masking platform (Delphix, K2View, or equivalent) — including upgrades, masking job management, and rule library maintenance for PII, PCI, and PHI data classifications

Design and implement static and dynamic masking strategies — bulk masking for DB refreshes and real-time, role-based obfuscation at query time for non-production environments

Manage end-to-end Production-to-Non-Production refresh pipelines — RDS/Aurora snapshot-based backup, restore, and mandatory masking workflows across Dev, QA, and UAT environments in AWS

Administer AWS database services — RDS (PostgreSQL, MySQL, Oracle, SQL Server), Aurora, Redshift, and DynamoDB, including Multi-AZ, read replicas, performance tuning, and cost optimization

Build and maintain Infrastructure-as-Code for all database and data privacy resources using Terraform or CloudFormation, with full CI/CD pipeline integration

Automate database operations — refresh pipelines, environment provisioning, snapshot lifecycle, and masking workflows using Python, AWS Lambda, and Step Functions

Establish and enforce Non-Production Data Management standards — ensuring no production-sensitive data ever reaches lower environments unmasked; own audit evidence and compliance documentation

Ensure regulatory compliance across GDPR, CCPA, HIPAA, and PCI-DSS — partnering with Security, Compliance, and Legal teams to define and enforce data privacy policies

Act as the internal SME for data masking, database management, and AWS data infrastructure — mentoring engineers, influencing best practices, and driving adoption across teams

Education

Bachelor's degree in computer science, Information Technology, Information Systems, or related field required. Equivalent combination of education and demonstrated experience in Data Engineering in AWS cloud on multiple Data Base types will be considered or equivalent work experience required

Certificates, Licenses, Registrations

AWS Certified Database – Specialty

AWS Certified Solutions Architect – Associate

AWS Certified Cloud Practitioner Guide

We offer a compelling total rewards package that includes a competitive base salary and comprehensive benefits to support your total wellbeing.  The base pay range for this position is $118,235 - $157,500 Annual. The specific pay offered will depend on qualifications, experience, education and skill set. The compensation offered may also include an annual performance-based bonus, sales incentive plan or commission target.

Our benefits include, but are not limited to, healthcare, life insurance, paid time off, retirement, commuter benefits, and education reimbursement. Exact compensation may vary based on skills, experience, and location.

Join our SUPER Team and Enjoy Amazing Benefits!

Competitive Compensation: We value your hard work and are proud of our competitive pay for performance philosophy.

Comprehensive Health Coverage: Medical, dental, and vision insurance options, plus paid short-term and long-term disability coverage.

401(k) Plan with 4% Company Match: Secure your future with our robust retirement plan.

Generous Paid Time Off: Take the time you need to recharge and relax.

Education Assistance Program: Invest in your growth and development with our support.

FSA/HSA Options: Flexible spending and health savings accounts to manage your transportation and dependent care expenses.

Employee Wellness: Access to EAP, health, legal, and financial resources to support your overall well-being.

Vibrant Company Culture: Monthly Townhalls, employee recognition programs, and Employee Business Resource Groups (EBRGs) to keep you engaged and connected.

Competencies

Technical Learning - Picks up on technical things quickly; can learn new skills and knowledge; is good at learning new industry, company, product, or technical knowledge; does well in technical courses and seminars.

Problem Solving - Uses rigorous logic and methods to solve difficult problems with effective solutions; probes all fruitful sources for answers; can see hidden problems; is excellent at honest analysis; looks beyond the obvious and doesn't stop at the first answers.

Driving Results-Can be counted on to exceed goals successfully; is constantly and consistently one of the top performers; very bottom-line oriented; steadfastly pushes self and others for results.

Build Effective Processes and Teams -Blends people into teams when needed; creates strong morale and spirit in his/her team; shares wins and successes; fosters open dialogue; lets people finish and be responsible for their work; defines success in terms of the whole team; creates a feeling of belonging in the team.

Intellectual Horsepower -Is bright and intelligent; deals with concepts and complexity comfortably; described as intellectually sharp, capable, and agile.