Data Engineer Client Data Operations

Royper Royco LLC; Dallas (TX); Hybrid; USD 115,000 - 145,000; Full time

Job summary

Royper Royco LLC seeks a Data Engineer to build and optimize client data pipelines, onboarding new sources and transforming complex files into reliable datasets. You will own production workflows, troubleshoot issues, and develop scalable ingestion using SQL, Python, Spark, Databricks, and AWS.

You will work with analytics, campaign, and technical teams to ensure data quality, security, and timely campaign delivery in a fully remote US role with a Dallas preference.

Qualifications

• 4+ years of hands-on data engineering building and operating production data pipelines.
• Strong SQL and Python with practical Spark or equivalent large-scale processing experience.
• Experience in cloud data environments (Databricks, AWS) and data orchestration.
• Ability to transform inconsistent sources into reliable production feeds and ensure data quality.

Responsibilities

• Onboard client data sources, validate and transform into production-ready datasets.
• Build, maintain, and optimize scalable data pipelines using SQL, Python, Spark.
• Configure scheduled jobs, monitoring, tests, and automated alerts to improve reliability.
• Own Databricks and AWS workflow monitoring, troubleshoot failures and changes.

Skills

SQL

Python

Spark

Databricks

AWS

Data pipelines

SFTP

Git

PII/PHI handling

Tools

Databricks

AWS

Parquet

Job description

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Data Engineer Client Data Operations based in the United States.

The Data Engineer will play a key role in building, maintaining, and optimizing the data infrastructure that supports client marketing campaigns, audience management, and business reporting. This hands‑on position focuses on onboarding new client data, transforming complex and inconsistent source files into reliable production‑ready datasets, and ensuring data pipelines operate efficiently. You will take ownership of production workflows, troubleshoot technical issues, and develop scalable ingestion processes using modern cloud technologies.

Working closely with analytics, campaign, account, and technical teams, you will help ensure data accuracy, security, and seamless campaign delivery. This is an individual contributor role offering significant autonomy and the opportunity to improve operational processes within a growing, data‑driven environment. The position is fully remote across the United States, with a preference for candidates located in the Dallas, Texas area.

Accountabilities:

• Client Data Onboarding: Set up and manage incoming data feeds from client and vendor systems, including SFTP connections and scheduled file deliveries. Analyze source files, identify missing fields, inconsistent formats, and schema changes, and map incoming information into established database structures.
• Data Validation and Processing: Develop validation, identity matching, and data preparation processes, including record‑count reconciliation, LTID assignment, and CASS/NCOA processing when applicable. Ensure data quality before it enters production workflows.
• Pipeline Development: Build, maintain, and optimize scalable data pipelines using SQL, Python, and Spark to support new direct mail and digital marketing clients. Establish reusable data structures and avoid unnecessary one‑off solutions.
• Workflow Automation: Configure scheduled jobs, file monitoring, transformations, testing, and automated alerts to minimize manual intervention and improve pipeline reliability.
• Production Monitoring and Troubleshooting: Own daily monitoring and maintenance of Databricks workflows, AWS jobs, and related data tools. Investigate and resolve pipeline failures, schema changes, expired credentials, broken dependencies, stale data, and vendor‑related issues.
• Campaign and Mail Production: Manage routine audience and direct mail production activities, including data suppression, address hygiene, record reconciliation, quality control, and preparation of files for external vendors, following established approval procedures.
• Operational Documentation: Create and maintain clear documentation covering data sources, transformations, validation processes, outputs, troubleshooting procedures, and recovery workflows.
• Data Security and Compliance: Identify sensitive information and apply approved privacy, access, and data‑handling policies. Escalate ambiguous data governance or privacy questions to the appropriate stakeholders.
• Cross‑Functional Collaboration: Work closely with the Senior Analytics Engineer to provide clean, consistent, well‑documented datasets for downstream modeling, analysis, and reporting.
• Stakeholder Communication: Collaborate with campaign, account management, and technical teams to clarify requirements, resolve data issues, communicate delivery risks, and recommend appropriate solutions.
• Continuous Improvement: Identify opportunities to strengthen pipeline monitoring, automate recurring tasks, improve operational efficiency, and reduce dependency on manual troubleshooting.

Requirements:

• Several years of hands‑on data engineering experience, ideally 4+ years, including building, maintaining, and operating production data pipelines.
• Strong proficiency in SQL and Python, with practical experience using Apache Spark or comparable large‑scale data processing technologies.
• Experience with cloud‑based data engineering environments, particularly Databricks and AWS or equivalent cloud platforms.
• Demonstrated ability to investigate unfamiliar, inconsistent, or poorly documented data sources and transform them into reliable production‑ready feeds.
• Experience with data orchestration, workflow automation, monitoring, schema mapping, file‑based integrations, and pipeline testing.
• Familiarity with version control systems such as Git, access management, operational documentation, and production support practices.
• Strong understanding of data quality principles, including record validation, deduplication, identity matching, reconciliation, and error detection.
• Experience handling personally identifiable information (PII) and protected health information (PHI), with an understanding of privacy and security requirements in regulated environments.
• Excellent analytical and problem‑solving skills, with strong attention to detail and the ability to identify root causes rather than simply address symptoms.
• Ability to work independently, manage competing priorities, and take ownership of production issues in a fast‑paced environment.
• Strong communication skills, including the ability to explain technical challenges and potential solutions to both technical and non‑technical stakeholders.
• Sound professional judgment, particularly when handling sensitive information or situations requiring business‑rule and privacy‑related decisions.

Additional experience considered an advantage:

• Experience with direct mail data processing, digital marketing audience management, and campaign delivery workflows.
• Familiarity with CASS/NCOA, AccuZIP, AccuTrace, USPS tracking, audience deduplication, and suppression processes.
• Previous experience working with healthcare, Medicare, or health plan marketing data.
• Knowledge of SFTP, Amazon S3, Parquet, and client‑facing reporting integrations.
• Experience working with digital marketing data sources and APIs.
• Residence in or around Dallas, Texas, is preferred but not required.
• Competitive annual base salary: $115,000–$145,000, depending on experience and qualifications.
• Fully remote working arrangement within the United States.
• Opportunity to take ownership of critical production systems and data engineering processes.
• Direct involvement in meaningful projects supporting healthcare, financial services, and other complex industries.
• Opportunity to work with modern data technologies, including SQL, Python, Spark, Databricks, and AWS.
• Professional development through hands‑on technical challenges and collaboration with experienced analytics professionals.
• Opportunity to contribute to the development of scalable systems and improve established operational processes.
• Collaborative environment within a growing, performance‑driven team.