Senior Associate Data Analyst

Overview

We are looking for an entry-level to early-career Senior Associate Data Analyst to join our team and help scale our data capabilities through advanced reporting, dashboarding, and automation. Working cross-functionally with our strategists and developers, this person will transform raw data from platforms like Google Ads and Facebook into automated, high-impact solutions that drive smarter buying decisions for our diverse client base.

The ideal candidate will bridge the gap between technical data work and digital marketing strategy, helping our team to optimize marketing tech stacks and build seamless data pipelines to improve reporting accuracy. We are seeking a recent graduate or early-career professional with a strong grasp of SQL and Excel.

• Clean and analyze data using SQL to provide the basis for ad-hoc analysis and dashboards.
• Create dashboards accurately representing ad performance in Looker studio
• Troubleshoot "messy" data by developing novel, flexible solutions when working with imperfect tech stacks or unorganized tables.
• Bridge the gap between technical and non-technical teams by explaining concepts like API limitations or SQL logic to strategists and clients.
• Maintain high data integrity by tracking down discrepancies and performing rigorous quality checks.
• Manage competing priorities by balancing immediate client needs with long-term infrastructure and data improvements.
• Partner cross-functionally with developers and strategy teams to ensure data solutions align with overall business goals.

Minimum Qualifications

• 1+ year(s) of professional experience
• Intermediate SQL proficiency, including the ability to join data sources, filter, group, and perform validation checks.
• Advanced spreadsheet skills (Excel/Google Sheets) for data cleaning and reporting.
• Experience on collaborative projects with a proven ability to communicate technical ideas to non-technical audiences.
• Demonstrated ability to prioritize multiple projects simultaneously in a fast-paced environment.

• dbt (data build tool)
• Big Query/Snowflake
• Looker Studio (or similar BI tools like Tableau)
• Python or R
• Git / Command Line
• Technical Writing/Documentation

C+K offers a full benefits package which includes: 100% subsidized Platinum-level healthcare insurance, options for dental and vision insurance, 401k with a guaranteed company 3% contribution, short term disability, flexible spending accounts, transportation benefits, bikeshare membership, high speed Internet reimbursement, paid parental leave, paid time off and several paid holidays. C+K is an equal opportunity employer.

C+K offers employees the opportunity to work remotely, work in the DC office full time, or work out a partial-week, in-office flex schedule. We do not force people to go into the office, it exists as a benefit for those who want an office to go to.

$70k-$80k plus annual bonus