Data Analyst
Job Description
Reingold Inc is hiring a Data Analyst to support client reporting and hands-on work related to Adobe Experience Platform (AEP). This hybrid role in Alexandria, VA focuses on building client-facing dashboards and recurring reports using Snowflake and SQL, while also contributing to AEP configuration and maintaining privacy and governance standards across systems.
Role focus
- Develop reporting that helps clients track progress against business goals.
- Support the connection between AEP data and Snowflake reporting datasets.
- Apply privacy standards through data labels and governance policies, including consent and access rules.
Responsibilities
- Build and maintain client-facing dashboards in Snowflake using team-provided designs, metric definitions, and specifications.
- Write, test, and maintain SQL for the reporting layer, including queries, views, and transformations in Snowflake; tune for performance as data volumes grow.
- Maintain Snowflake datasets containing AEP profile, audience, and engagement data by monitoring scheduled refreshes, checking for gaps or late-arriving data, and flagging issues to the team.
- Assemble recurring and ad hoc client reports by pulling and organizing numbers, building charts and tables, reconciling against source data, and preparing drafts for senior review.
- Run data quality checks between AEP and Snowflake, investigate discrepancies in counts and metrics, and document findings for the team.
- Complete assigned AEP configuration tasks to written specifications, including creating and updating datasets and XDM schema fields, building audience segments, and setting up source connections and destinations with senior guidance.
- Assist with testing and monitoring data flows between AEP and Snowflake to confirm audiences activate as expected and data lands on schedule.
- Follow engagement privacy standards in every task by applying data usage labels and governance policies, honoring consent and access rules, and minimizing exposure of PII; escalate items that appear out of step.
- Document queries, views, dashboard logic, and reporting procedures, and keep run books and trackers current for the team and the client.
Requirements
- 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; experience with BigQuery, Redshift, or another cloud warehouse welcome.
- Demonstrated experience building dashboards, reports, or data visualizations used by non-technical stakeholders, with an instinct for presenting numbers clearly.
- Attention to detail for reconciling and QA across systems, including catching numbers that do not look right before a client does.
- Exposure to Adobe Experience Platform or a comparable enterprise customer data platform, with willingness to perform configuration work to standards and specifications set by others.
- Working knowledge of PII handling and data privacy basics, including consent and access control, and the discipline to follow established standards.
- Excellent oral and written communication skills and a drive for results that includes asking questions and flagging issues early.
- Bachelor’s degree in marketing, communications, computer science, math, or a similar field (or equivalent work experience).
- Ability to obtain a U.S. government clearance.
Technologies
- Snowflake, SQL
- Adobe Experience Platform (AEP), Adobe Experience Platform XDM schemas and XDM schema fields
- BigQuery, Redshift, Snowpark, Snowpark Container Services
- JavaScript/TypeScript, React, Recharts, D3, Highcharts, Plotly, Python
- dbt
- Adobe Launch, Data Collection, Tealium IQ, Google Tag Manager
- Adobe Journey Optimizer, Adobe Campaign, Adobe Analytics/CJA
- Adobe certification in Experience Platform (Business Practitioner or Developer)
Compensation and eligibility
- Salary range: $64,400 to $96,600 per year (company pay range low to high).
- Budgeted starting salary is in the lower half of the range.
- Individual compensation varies based on experience, skills, qualifications, internal equity, and business needs.
Benefits
- Comprehensive health and wellness benefits for full-time employees.
- 401(k) employer contributions and matching.
- Other benefits.
Supervisory responsibilities
- No direct reports, but the role is expected to mentor junior teammates, lead by example, and influence.
- Reports to the Director, Customer Data & Marketing Technology, with day-to-day direction from senior members of the engagement team.
Work environment
- Prolonged periods sitting at a desk and working on a computer.
Additional information
- Reingold is committed to equal opportunity for individuals of all abilities.
- Reingold maintains a workplace free of drugs and alcohol.
- Applicants must have authorization to work in the United States.
- Reingold is unable to sponsor or take over sponsorship of an employment visa.
- Candidates must be able to obtain and maintain a U.S. government security clearance.
Location: Alexandria, VA (hybrid)
Experience level: 2 years minimum