Customer Analytics Engineer

Grasshopper Bank; New York (NY); Remote; USD 120,000 - 160,000; Full time

Job summary

Grasshopper Bank seeks a Customer Analytics Engineer to own data-driven customer lifecycle narratives. You will build scalable data models, pipelines, and semantic layers to illuminate who our clients are and how they engage with digital banking platforms.

You will partner with Marketing, Product, and Finance to translate hypotheses into quantitative dashboards in Tableau and reliable data products powering activation engines such as Braze.

Qualifications

• 2–4+ years in a hybrid data role such as Analytics Engineer, Customer Data Engineer, BI Developer, or Marketing Data Engineer
• Advanced SQL & BigQuery with performance tuning
• Dimensional modeling and event data modeling; dbt experience
• Python for data transformations, API integrations, and orchestration
• Tableau Desktop/Server/Cloud dashboard expertise
• CAC/LTV and cohort analytics understanding
• Strong communication and cross-functional collaboration
• Bachelor’s degree in CS/IS/Data Analytics or equivalent experience

Responsibilities

• Design and maintain Customer 360, C-MDM models and a single source of truth in BigQuery
• Build scalable ELT/ETL pipelines to ingest and enrich data
• Develop analytics-ready models for marketing activation (Braze)
• Create executive dashboards on acquisition, retention, churn, and product penetration
• Partner with Marketing, Product, and Finance to translate hypotheses into quantitative dashboards and data products

Skills

SQL

BigQuery

Data Modeling

Python

dbt

Airflow

Tableau

LTV

Cohort analysis

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Mathematics, Engineering, or equivalent practical experience

Tools

dbt

Airflow

Google Cloud Composer

Job description

Customer Analytics Engineer

Department: Data

Employment Type: Full Time

Location: Remote

Description

Grasshopper Bank is a client-first, digital bank built for the business and innovation economy, with an obsession for providing leading-edge technology, solutions-driven products and superior service through a combination of passionate people and digital resources.

We are a highly experienced team who pride ourselves on diversity of thought and perspective. Nationally chartered, our portfolio of products and services range from VC, PE & Portfolio Companies to SBA Lending, as well as direct SMB and Embedded Banking.

Our entrepreneurial drive allows us to support the growth and success of a wide range of clients at every stage of their business through inclusive partnership. We seek out team members who will enable both our organization and our people to grow and thrive through collaboration and acting with integrity and respect.

Our focus on cross-functional teamwork provides a culture where ideas are valued, accountability is encouraged, and successes are celebrated. We welcome all those searching for the opportunity to contribute to banking innovation that influences and supports the emerging digital world of Financial Services.

Our digital first approach enables our teams the flexibility to work remotely. We have offices in NYC and Boston.

What you'll do:

As a Customer Analytics Engineer, you will operate at the intersection of modern data engineering, customer behavior analytics, and growth enablement. Reporting to the Director of BI & Analytics, you will serve as the technical engine and strategic architect behind our bank-wide Customer 360 and customer lifecycle analytics initiatives.

In this high-impact role, you will move beyond standard descriptive reporting to build the foundational data models, pipelines, and semantic layers that explain who our clients are, how they interact with our digital banking platforms, and what drives long-term customer lifetime value (LTV). You will be responsible for modeling complex customer event streams, digital touchpoints, and transaction histories into analytics-ready models in Google BigQuery, powering executive Tableau reporting and directly activating customer data downstream into marketing and engagement engines (such as Braze).

If you love writing clean, performant SQL/Python transformation logic, unraveling complex customer journeys, and partnering with Product and Marketing leaders to unlock top-line revenue, this role is for you.

• Customer 360 & C-MDM Modeling: Design, build, and optimize scalable dimensional models (Kimball methodology) and One Big Table (OBT) datasets in Google BigQuery that unify core banking records, digital session logs, and touchpoints into a trusted, bank-wide customer master (C-MDM) and single source of truth.
• Identity Resolution, Governance & Attribution: Establish robust customer identity mapping and multi-touch marketing attribution models across diverse platforms, while championing master data management (C-MDM) principles, data quality, and governance across all customer data pipelines.
• Semantic Layer & Master Data Development: Formalize bank-wide customer entities, core segmentations, and Critical Data Elements (CDEs)—such as Active User definitions (DAU/MAU), primary operating account status, feature adoption, and dormancy thresholds—to align business and technical definitions under a unified C-MDM framework.
• Scalable ELT Pipelines: Design, deploy, and maintain resilient ELT/ETL pipelines (using SQL, Python, and orchestration tools) to ingest, clean, and enrich raw customer interaction data, API payloads, and core snapshot tables.
• Downstream Marketing & Activation Sync: Engineer reliable pipelines and reverse-ETL workflows that sync enriched customer traits, behavioral events, and engagement tiers directly into marketing automation platforms (e.g., Braze) and CRM systems to power automated lifecycle campaigns.
• Data Quality & Observability: Implement automated testing, anomaly detection, and schema validation across customer data pipelines to guarantee platform accuracy, uptime, and alerting.
• Customer Journey & Cohort Dashboards: Design and maintain intuitive, executive-ready Tableau dashboards focusing on customer acquisition funnels, retention curves, product penetration, churn indicators, and deposit velocity.
• Storytelling with Data: Translate complex, multi-layered data into clear, actionable narratives that answer the "so what?" for business line leaders and product managers.
• Performance Optimization: Continuously monitor and tune BigQuery queries and Tableau extracts to ensure rapid workbook performance and cost-efficient query processing.
• Strategic Growth Partner: Collaborate closely with Marketing, Product, and Business Line leaders to translate business hypotheses into quantitative frameworks and tracking requirements.
• Data Stewardship & Literacy: Champion data governance best practices, document customer data lineages and KPI definitions in the Data Steward Playbook, and coach end-users on self-service data discovery.

What you need:

• Experience: 2–4+ years of hands‑on experience in a hybrid data role such as Analytics Engineer, Customer Data Engineer, BI Developer, or Marketing Data Engineer. Prior experience in fintech, commercial banking, or digital banking platforms is preferred.
• Advanced SQL & BigQuery: Expert-level SQL skills, including advanced analytical window functions, complex CTEs, array/struct unnesting, and performance tuning within cloud data warehouses (Google BigQuery strongly preferred).
• Dimensional & Event Data Modeling: Strong experience with dimensional modeling, star schemas, and structuring behavioral/event-based data models (hands‑on experience with dbt for modeling transformations and lineage is a strong plus).
• Python & Pipeline Engineering: Demonstrated experience using Python for data transformation, API integrations, and workflow automation. Experience scheduling and orchestrating DAGs using tools like Apache Airflow or Google Cloud Composer is preferred.
• Tableau Expertise: Deep proficiency in Tableau Desktop and Tableau Server/Cloud, including Level of Detail (LOD) expressions, parameters, and thoughtful dashboard UX/UI design principles.
• Customer Analytics Acumen: Strong conceptual understanding of customer lifecycle metrics: Customer Acquisition Cost (CAC), Lifetime Value (LTV), cohort retention, and churn. Familiarity with reverse-ETL workflows or customer data activation is a plus.
• Communication & Collaboration: Proven track record of presenting complex data insights to non-technical stakeholders and driving cross-functional alignment.
• Education: Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Mathematics, Engineering, or equivalent practical experience.