Analytics Engineer

Crexi; California (MO); On-site; USD 123,000 - 160,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Collaborative culture

Flexible team structure

Job summary

Crexi is seeking an Analytics Engineer to manage data models, define KPIs, and ensure the reliability of data across the company. This role requires a Bachelor's degree in an analytical field and 2-5 years of experience in analytics engineering or a related role. You will work with teams to instrument event tracking, develop dbt models, and maintain dashboards. The position offers a competitive salary range of $123,000 to $160,000 per year in California, along with equity and healthcare benefits.

Qualifications

• 2-5 years of experience in analytics engineering, data engineering, or a data analyst role.
• Strong SQL skills with experience writing complex queries.
• Hands-on experience with dbt including writing models, tests, and documentation.

Responsibilities

• Define and instrument company-level KPIs in partnership with Finance and Sales.
• Develop dbt models and maintain Sigma dashboards.
• Manage ETL processes and ensure data compliance.

Skills

SQL

Data modeling

Analytics engineering

Experience with dbt

BI tools

Education

Bachelor's degree in an analytical field

Tools

Snowflake

Fivetran

Mixpanel

Sigma

Job description

Crexi is reimagining commercial real estate with an AI-powered platform built to deliver smarter, more efficient solutions at every stage of the deal lifecycle. From real-time data and market insights generated by Crexi Intelligence, to targeted property marketing and seamless deal management through Crexi PRO, and a transparent, time-bound bidding experience with Crexi Auction— Crexi enables users to evaluate opportunities, maximize exposure, and close with speed and confidence. To date, Crexi has facilitated over $1 trillion in transactions, 8.6 billion square feet leased, and supports a growing community of more than 2 million monthly active users.

Crexi’s mission is to catalyze the next generation of commercial real estate through three core pillars: Access, Innovation, and Connection. Crexi’s platform democratizes CRE by providing unprecedented access to market insights and opportunities, accelerates CRE dealmaking with purpose-built technology that enhances speed and transparency; and empowers CRE professionals with a centralized platform designed for real-time collaboration and success.

About This Role:

The Analytics Engineer owns the data models, KPI definitions, and trusted datasets that power decisions across the company. This role sits on the Internal Data Products team and is responsible for translating business logic into well-tested, version-controlled dbt models in Snowflake. You will work closely with Product, Sales, Finance, and Marketing to define what we measure, how we measure it, and ensure the data is reliable enough for stakeholders to act on without asking questions.

What You’ll Do:

• Defines and instruments company-level and product-level KPIs in partnership with Finance, Product, and Sales.
• Owns and develops the core dbt models: builds, tests, and documents staging, intermediate, and mart models that serve as the single source of truth for business metrics.
• Builds and maintains Sigma dashboards and self-service datasets that stakeholders use without analyst intervention.
• Designs and manages ETL and Reverse ETL syncs (Fivetran) that push curated data into Salesforce, HubSpot, and Iterable.
• Partners with Product and Engineering to instrument event tracking (Mixpanel), define behavioral metrics, and run multivariate tests that inform product decisions.
• Contributes to entity resolution efforts: helps build canonical account and contact models in Snowflake that downstream systems reference.
• Works cross-functionally with Sales, Marketing, Finance, and Customer Success to translate business questions into modeled, governed data.
• Proactively identifies data quality issues, builds dbt tests and alerts, and improves pipeline reliability.
• Builds and implements AI-powered workflows for internal data products, including automated reporting agents, LLM-driven data validation, and natural-language interfaces to warehouse data.
• Ensures compliance with data privacy and security regulations and maintains ethical data handling practices.
• Identifies opportunities to improve data-driven decision-making and proposes solutions

Who You Are:

• Bachelor’s degree in an analytical field (e.g. Economics, Finance, Mathematics, Statistics, Computer Science).
• 2–5 years of experience in analytics engineering, data engineering, or a data analyst role that included dbt and data modeling.
• Strong SQL skills with experience writing complex queries in Snowflake or a comparable cloud data warehouse; hands‑on experience with dbt (Core or Cloud), including writing models, tests, and documentation.
• Experience with a BI tool such as Sigma, Looker, or Tableau, and familiarity with product analytics platforms (Mixpanel, Amplitude) and event-based data.

Why Crexi?

• Rapidly growing startup with a dynamic work environment
• Flexible team structure with the ability to progress in career
• Health, Dental, and Vision insurance
• Collaborative culture and numerous team activities

The California base pay range for this position is $123,000 to $160,000 per year with eligibility for generous commissions, equity, and healthcare insurance. The total compensation package offered to a successful candidate will depend on several factors, which may include, but are not limited to, the type and length of experience applicable to the role and within the industry, job‑related skills, job level, and geographic location. Commercial Real Estate Exchange, Inc (“Crexi”) is a multi-state employer, and this salary range may not reflect positions that work in other states.

Crexi is an EEO Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Crexi will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.