About Careertakes

👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, a full-service marketing and creative firm.

Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.

---

What You’ll Do

Confidential Client is seeking a hands-on Data Analyst to build and maintain client-facing reporting and to support Adobe Experience Platform (AEP) work that feeds those reports. You will spend most of your time in a cloud data warehouse writing and optimizing SQL, assembling recurring client reports, and ensuring data quality between AEP and Snowflake. You’ll also carry out AEP configuration tasks to spec and help monitor data flows. This is a hybrid role requiring at least two days per week on-site in Alexandria, VA.

• Build and maintain dashboards and reporting views in Snowflake that reflect agreed metric definitions and visual designs.
• Write, test, and optimize SQL queries, views, and transformations that feed dashboards and recurring reports.
• Monitor scheduled data refreshes, investigate data gaps or late-arriving records, and escalate issues to the team.
• Assemble recurring and ad hoc client reports: pull numbers, build charts/tables, reconcile with sources, and prepare drafts for senior review.
• Run data quality checks between AEP and Snowflake; investigate and document discrepancies in counts and metrics.
• Execute AEP configuration tasks to written specifications: create/update datasets and XDM schema fields, build audience segments, and set up source connections/destinations with senior guidance.
• Assist with testing and monitoring of activation and data flows (AEP → Snowflake), confirming audiences activate and data lands on schedule.
• Apply privacy controls and governance: label data usage, honor consent/access rules, minimize PII exposure, and escalate any privacy concerns.
• Document queries, views, dashboard logic, run books, and reporting procedures; keep trackers current for the team and the client.

---

Required Qualifications

• 2+ years of professional experience in analytics, business intelligence, data engineering, marketing technology, or web development.
• Strong SQL skills and hands-on experience querying a cloud data warehouse (Snowflake preferred; BigQuery/Redshift acceptable).
• Demonstrated experience building dashboards/reports and presenting data clearly for non-technical stakeholders.
• Attention to detail and discipline to reconcile and QA data across systems.
• Exposure to Adobe Experience Platform or a comparable enterprise customer data platform; willingness to perform configuration work to standards set by the team.
• Working understanding of PII handling and data privacy basics, including consent and access control.
• Excellent oral and written communication skills; proactive about asking questions and flagging issues early.
• Bachelor’s degree in marketing, communications, computer science, math, or a related field (or equivalent work experience).
• Ability to obtain a U.S. government security clearance.

---

Preferred Qualifications

• Hands-on Adobe Experience Platform experience (XDM schemas, audience segmentation, destination setup).
• Advanced Snowflake experience; familiarity with Snowpark or containerized deployments.
• Proficiency with JavaScript/TypeScript and React for data-driven interfaces.
• Experience with charting/visualization libraries (Recharts, D3, Highcharts, Plotly).
• Familiarity with Python and/or dbt for transformations and pipelines.
• Adobe Experience Platform certifications or coursework toward certification.
• Exposure to website data collection and tag management (Adobe Launch, Tealium, GTM) or adjacent Adobe tools (Journey Optimizer, Campaign, Analytics).
• Experience in an agency or client-services setting, or with government/public sector/nonprofit clients handling sensitive data.

---

Supervisory Responsibilities

This position has no direct reports but includes mentorship responsibilities: you will be expected to mentor junior teammates and lead by example. The role reports to the Director, Customer Data & Marketing Technology, and receives day-to-day direction from senior members of the engagement team.

---

Work Environment & Physical Requirements

Prolonged periods sitting at a desk and working on a computer. Hybrid schedule with at least two days per week on site in Alexandria, VA.

---

Compensation & Benefits

The base salary range for this position is $64,400 to $96,600 (USD). The budgeted starting salary is expected to be in the lower half of that range. Individual compensation will vary based on experience, skills, qualifications, internal equity, and business needs.

Full-time employees are eligible for comprehensive health and wellness benefits, 401(k) employer contributions and matching, and other benefits.

---

Additional Information

• Applicants must be authorized to work for any employer in the United States. The client is currently unable to sponsor or transfer sponsorship of an employment visa.
• Candidates must be able to obtain and maintain a U.S. government security clearance.
• The work involves sensitive and personally identifiable information; strong adherence to privacy and governance standards is required.
• Confidential Client is committed to inclusive hiring. If you require accommodation during the application or interview process because of a disability, please notify the recruiter or Careertakes.

---

Equal Opportunity & Hiring Transparency

Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.

If you have questions about how your data is used, please contact us directly.