Senior Analytics Engineer

This is a hands-on, individual contributor role with significant client-facing responsibility. You will run discovery, define requirements, design data models, build ETL pipelines, develop dashboards, and present insights to client stakeholders ranging from analysts to C-suite executives. You will own the end-to-end delivery of analytics engagements and serve as the trusted technical advisor to the clients you work with.

The right candidate is equally comfortable writing SQL and dbt models, leading a workshop with a client’s marketing leadership team, and working through ambiguous data problems independently. You bring strong consulting instincts, deep technical expertise, and the discipline to ship great work in a fast-moving environment.

This role sits within 829’s Analytics & AI practice and reports to the SVP of Analytics & AI.

What You’ll Do

Client Delivery & Consulting (65%)

Lead BI and analytics engagements from discovery through delivery, serving as the primary technical and strategic point of contact for the clients you support.

• Run discovery sessions, stakeholder interviews, and workshops to surface business priorities and translate them into analytics requirements.
• Partner with clients to define project scope, success criteria, deliverables, and timelines.
• Build and maintain trusted advisor relationships with client stakeholders, from in-house analytics teams to executive sponsors.
• Translate business questions into data and analytics solutions that drive decisions.
• Develop dashboards, reports, and analyses using tools like Tableau and Sigma.
• Conduct deep-dive data analysis and present findings to client audiences, including executive readouts, quarterly reviews, and strategic planning sessions.
• Provide ongoing advisory support on measurement strategy, KPI definition, and analytics roadmap planning.
• Manage scope, timeline, quality, and client communication across multiple concurrent engagements.
• Identify expansion opportunities within active accounts and partner with the SVP of Analytics & AI to scope follow-on work.

Technical Architecture & Engineering (35%)

Set the technical direction for client engagements and contribute to practice-wide delivery standards.

• Design and implement data architectures for clients using Snowflake, BigQuery, dbt, and modern data stack tools.
• Build and maintain ETL/ELT pipelines using Python, SQL, and orchestration platforms.
• Drive data architecture recommendations and establish best practices across engagements.
• Develop and refine reusable templates, frameworks, and assets that improve delivery speed and quality across the practice.
• Stay current on tooling, techniques, and AI/ML approaches relevant to client work, and bring those forward into engagements where they create value.

• Bachelor’s degree in Computer Science, Data Science, Engineering, or a related quantitative field.
• 5+ years of experience in BI solution development and implementation, ideally in a consulting or agency environment.
• Demonstrated experience leading client-facing engagements and presenting to executive stakeholders.
• 3+ years of hands-on Python experience, including data manipulation, automation, and pipeline development.
• 4+ years of strong SQL experience, preferably with Snowflake or BigQuery.
• 4+ years of experience building dashboards and reports in modern BI tools (Tableau, Sigma, or similar).
• Working experience with dbt for data transformation and modeling.
• Proven experience designing ETL processes, data models, and BI solution architectures from the ground up.
• Knowledge of AI/ML operations and experience maintaining models in production.
• Strong problem-solving, communication, and project management skills.
• Ability to work independently and deliver results in ambiguous situations.

Nice to Haves:

• Master’s degree in a relevant field.
• Experience with cloud platforms (AWS, Azure, or GCP) and data governance frameworks.
• Certifications in Snowflake, Python, Tableau, dbt, or other relevant BI tools.
• Prior consulting experience on data and analytics projects.
• Familiarity with fast-paced, high-tech environments.

401(k) 4% Match, Health insurance, 401(k) matching, Paid time off, Dental insurance, Flexible spending account, Life insurance, Disability insurance Full-time Remote in United States, * Paid Time Off. Receive generous paid vacation benefits that increase each year you’re with us, 12 Company Holidays, and Summer Fridays from Memorial Day through Labor Day.

• 401K + Match. 401K plan with 4% Safe Harbor employer match after one year of employment and financial literacy services provided through our retirement provider.
• Life Insurance Benefit. No-cost coverage to ensure peace of mind for your family.
• Short Term Disability Benefit. We’ve got you covered if you need to be OOO with an illness or injury that keeps you out of work.
• Healthcare. Choose from several competitive healthcare plans for you and your family with 80% employer coverage for all medical and dental premiums, 100% employer coverage for vision, and the option to participate in the FSA program.
• Commuter Benefits. Allocate pre-tax funds towards your commute to save up to 40% per year in transportation expenses.
• Continuing Education. Access to monthly team-led webinars, exclusive 829-cohort based learning, digital course platforms, and funding opportunities to attend national conferences and events., We determine compensation based on experience, demonstrated skills, and current market conditions at the time of hire to ensure fairness and consistency across roles. Actual compensation will depend on experience and may be adjusted based on skills, qualifications, and alignment with the scope and impact of the role.

829 Studios is a Boston-based integrated digital marketing agency with a mission to propel organizations to unlock their full potential and accomplish their most ambitious goals. We harness the power of logic with magic - a balance of data-driven strategy and brand-focused creative. We partner with diverse organizations across various industries and our client list encompasses venture-backed start-ups, publicly traded companies, non-profits, and more. By committing not only to our growth as a company, but the development of our employees and teams’, we have created a collaborative environment that fosters ingenuity and promotes diversity, equity, inclusion, and belonging values within our community. 829 has been recognized as one of the nation’s top agencies by the Inc. 5000 Fastest-Growing Privately Held Companies, Adweek 100 Fastest-Growing Digital Agencies, Boston Business Journal’s Fast 50 (Massachusetts’ 50 Fastest-Growing Private Companies), HubSpot’s Top Digital Agencies list, and a we are and employee-certified Great Place to Work six years in a row.