Data Engineer Client Data Operations
Dallas, IA - USA
Job Summary
To help were using both a questionnaire and an AI-powered verbal screening tool where you can talk through your experience and how you approach problems. We know... we know... another AI tool in the hiring process. Were not exactly fans of that either but we believe it gives more people an opportunity to show us what they know beyond whats on their résumé.
Were not looking for perfect or rehearsed fact wed much rather hear a genuine imperfect answer than something polished that doesnt really tell us anything. We want to hear about your actual experience and our team will make the hiring decisions not the AI.
Please complete the screening questions as part of your application. Quick Apply or Easy Apply submissions without completed responses may not be considered.
Data Engineer Client Data Operations
Location: Remote (United States; Dallas TX area preferred not required)
We specialize in industries where customer interaction is high-value and high-stakes including healthcare financial services and other regulated or complex environments. Our work connects insight to action using behavioral science and data to inform strategy creative and delivery in ways that drive measurable outcomes for our clients.
Limetree has been recognized multiple times on the Inc. 5000 as well as a national Inc. Best Workplace and holds multiple patents that inform our approach to marketing performance decision-making and execution.
This is a production ownership role. You will be the first person working through data and pipeline failures and as you learn our processes take over the technical execution of routine mail drops. You will work closely with our Senior Analytics Engineer who depends on clean consistent data for downstream analytics and reporting. This is an individual contributor role not a people-management position.
Map incoming data into established schemas and tables identify sensitive fields and apply approved privacy and access rules. Raise ambiguous data or policy questions before moving forward.
Build the validation and matching steps that make data usable including record counts identity matching or LTID assignment and CASS/NCOA processing where relevant.
Document each feed so someone else can understand the inputs transformations checks outputs and what to do when it fails.
Set up scheduled jobs file watchers transformations testing and monitoring so new data streams run with minimal manual intervention.
Improve existing pipelines as source files schemas tools and business requirements change.
Handle schema drift bad source files expired credentials broken dependencies stale data and vendor-tool issues; improve alerts recovery steps and runbooks.
Take ownership of routine audience and mail-drop production including suppressions address hygiene count reconciliation QC and vendor file preparation within established approvals.
Flag risks to scheduled client drops early explain what is affected and recommend a safe path to resolution.
Partner with campaign account and technical colleagues to clarify requirements and resolve issues without making them chase the status of a feed or delivery.
By six months: Own routine new-client ingestion and pipeline maintenance be the first responder for issues and run standard mail drops with documented quality and release checks.
The result: New client data is repeatable and trustworthy; pipeline failures have a clear owner; routine troubleshooting and drop execution no longer depend on a single senior colleague.
Comfort taking a messy or poorly documented source file from first inspection through a reliable production data feed.
Strong attention to detail: you reconcile counts question suspicious data and make fixes that prevent a problem from coming back.
Able to work independently explain technical issues plainly and know when a business rule or privacy question needs an owner to decide.
Production cloud data engineering experience. We currently use Databricks and AWS but value strong AWS-native or comparable experience as our platform evolves.
Experience with orchestration monitoring schema mapping file-based integrations access controls Git testing and operational documentation.
Careful handling of personally identifiable or protected health information in regulated data environments.
Healthcare Medicare or health plan marketing data; SFTP S3 Parquet and client-facing reporting feeds.
Required Experience:
Manager
About Company
Limetree is a behavioral science-led performance marketing agency blending data, psychology, technology, and creative to drive measurable growth and smarter campaign performance.