4-5 years of experience in data analysis, processing, or ETL work.
Proficient in Python for data cleaning and automation, with pandas experience preferred.
Strong SQL skills, including multi-table joins and queries on large datasets.
Experience handling large files with millions of records and reconciling counts.
Detail-oriented with a commitment to quality control in work.
Ability to write clearly for documentation and communicate findings to non-technical audiences.
Bachelor's degree in a quantitative field; Master's preferred.
Responsibilities
Run end-to-end targeting for assigned clients, from data intake to results delivery.
Act as the primary analytics contact for clients, addressing data questions and risks.
Present campaign results and strategic recommendations to clients.
Design and size test and control groups for clear campaign outcomes.
Write and maintain Python scripts and SQL queries for data processing.
Apply selection criteria and suppressions to build mail files accurately.
Ensure data quality by reconciling record counts and investigating discrepancies.
Benefits
Opportunity to work directly with clients and influence campaign strategies.
Use of AI-assisted tools to enhance coding and documentation efficiency.
Hands-on experience with large datasets and advanced data processing techniques.
Collaborative environment with data scientists for model preparation and implementation.
Focus on continuous improvement and automation of manual processes.
Full Job Description
Job Summary: Sayker is hiring a hands-on Business Analyst to build and run the data processes behind our clients' direct mail campaigns. You will write Python and SQL that turn raw files into mail-ready audiences: cleaning and matching records, applying selection rules and suppressions, scoring prospects and checking every file before it goes to print. You will report directly to Sayker's Managing Director.
You will run targeting for your own clients and present the results to them. Each campaign is a chance to automate a manual step, tighten a quality check or make a process repeatable. You will use AI-assisted tools to write and review code faster, and you will be the person who checks that the output is right.
Responsibilities:
Own client programs
Run targeting end to end for a set of assigned clients: from the brief and data intake through selection, file delivery and results.
Be the day-to-day analytics contact for those clients. Explain selection logic, answer data questions and flag risks before they affect a mail date.
Present campaign results and recommendations to clients, including what to test next.
Design test and control groups and size them so each campaign produces a clear answer.
Build and run campaign data processes
Write and maintain Python (pandas) scripts and SQL queries that load, clean, match and transform client and third-party data.
Apply client selection criteria, segmentation rules and suppressions (do-not-mail, existing customers, prior responders, compliance screens) to build each mail file.
Deduplicate and household records so each home or business receives the right number of pieces.
Prepare final files to print and postal specifications, with test and control groups set up so results can be measured.
Protect data quality
Reconcile record counts at every step, investigate discrepancies and fix the root cause.
Build and follow quality-control checklists so every file is checked the same way before it ships.
Document workflows, business rules and QC steps so any campaign can be rerun or handed off.
Analyze and improve
Match campaign responses back to the mailed file and report response rates by segment, model score and test cell.
Support Sayker's data scientists with data preparation for response and risk models, and put model scores into production selections.
Find manual steps worth automating and build the tools to remove them.
Use company-approved AI tools to speed up coding, debugging and documentation, while checking their output and following our data security rules.
Qualifications:
At least 4-5 years of professional experience in data analysis, data processing or ETL work.
Working Python for data cleaning and automation; pandas experience preferred.
Strong SQL: multi-table joins, aggregations, window functions and queries on large tables.
Experience processing large files (millions of records) and reconciling counts between steps.
Care with detail: you check your own work before anyone else has to.
Clear writing for documentation and for explaining findings to non-technical colleagues.
Bachelor's degree in a quantitative field (math, statistics, computer science, economics, data science), or equivalent experience. Master's degree preferred.
Nice to have:
Direct mail, database marketing or list processing experience (merge/purge, suppressions, list selection).
Exposure to credit bureau or other regulated consumer data, and the controls that come with it.
Experience in financial services, lending, insurance or healthcare marketing.
Familiarity with cloud data tools (Snowflake, AWS, Databricks), Alteryx, or BI tools (Tableau, Power BI).
Basic statistics for test design: control groups, sample sizes, confidence intervals.