[Hiring] Senior Data Analyst @DEPT®

Role Description

As a Senior Data Analyst, you will transform raw data into trusted, well-modeled datasets using dbt, then design, build, and validate the customizable dashboard templates on top of them. You'll work closely with product, client-facing teams, and engineering to turn client use cases into reliable, well-built dashboards.

What You’ll Do:

• Gather and document client dashboard use cases with relationship managers and client-facing teams, and translate them into clear reporting requirements.
• Build and maintain data models in dbt, transforming raw source data into staging, intermediate, and reporting layers that power dashboards.
• Design the reporting layer to support client-specific configuration.
• Implement data quality tests, validation checks, and monitoring in the transformation layer.
• Design, build, and test reusable dashboard templates with a configurable layer for client-specific needs.
• Support with demos, requirements capture, and follow-up analysis.
• Validate data accuracy and visual consistency between legacy and migrated dashboards.
• Document models, templates, and configuration clearly and consistently, including dbt model documentation and lineage.
• Track delivery risks, dependencies, and priorities, and communicate status to program leadership.

Qualifications

• 5+ years as a Data Analyst, BI Analyst, Analytics Engineer, or similar role
• 2+ years building production dashboards in an enterprise BI platform
• 2+ years of hands-on dbt experience (models, tests, macros, documentation)
• Advanced SQL, including performance tuning on large datasets
• Proven experience modeling raw, unprepared data for reporting and analytics (e.g., dimensional modeling, star schemas)
• Experience with Git-based version control and code review workflows
• Experience with a cloud data warehouse
• Experience gathering requirements from non-technical and client stakeholders
• Strong documentation habits
• Clear communication, including with senior stakeholders
• Ability to deliver independently in a fast-paced environment with minimal ramp-up

Requirements

• The anticipated hourly range for this position is $50 hourly.
• Rate is based on a range of factors that include relevant experience, expertise, and organizational impact.
• This is based on a 40-hour workweek and leveling.
• Keep in mind, we're flexible.

Benefits

• DEPT® is an equal opportunity employer (EOE).
• We believe our work is its best when our people feel safe and free to be themselves.
• We’re committed to an inclusive and barrier-free recruitment and selection process and workplace.
• DEPT® participates in E-Verify.
• We are a B Corp-certified company passionate about purpose-driven work.

Company Description

DEPT® is a pioneering technology and marketing services company that creates integrated end-to-end digital experiences for brands such as Google, KFC, Philips, Audi, Twitch, Patagonia, eBay and more. Its team of 2,500+ digital specialists across 30+ locations on 5 continents delivers pioneering work on a global scale with a boutique culture.