Data Engineer

Motive

14d

About The Position

As a Data Engineer on our BI team, you’ll be a key player in Motive’s growth, delivering the data infrastructure for the AI era. You’ll act as the essential link between complex data and key business domains, delivering the high-quality datasets and semantic models that drive global strategy. This is an exciting opportunity to implement cutting-edge tooling, leverage AI to enhance your workflow, and master a modern data stack in a fast-evolving environment.
This is the perfect role for a "jack of all trades" data practitioner. You’ll design data models, build robust pipelines, manage DevOps and automated systems, and implement AI-driven data tooling. You’ll even get your hands dirty building dashboards and performing deep-dive analysis. If you love working full-stack and owning the entire data lifecycle, you’ll love this role.

Requirements

• 6+ years of experience in Analytics Engineering, Data Engineering, or a similar role.
• Deep expertise in SQL and developing complex data models for analytical purposes (e.g., dimensional modeling).
• Hands-on experience with:
• Data Warehousing: High proficiency in Snowflake (preferred) and experience with Open Table Formats like Iceberg.
• Data Transformation: dbt
• Orchestration & ETL: Airflow, Fivetran, Airbyte
• Cloud Platform: AWS
• Programming/Ingestion: Python
• Infrastructure as Code: Terraform
• AI-Augmented Development: Proficiency using AI coding assistants (Cursor, Copilot, or Claude) to accelerate development and automate routine tasks.
• A strong analytical mindset with a proven ability to solve ambiguous business problems with data.
• Excellent communication skills and experience working cross-functionally.
• Self-starter with the ability to self-project manage work
• A user focus with the ability to understand how a data consumer will use the data products you build

Nice To Haves

• Experience building semantic models for natural language querying
• Direct experience with advanced Snowflake features (e.g., Snowpark, Cortex AI).
• Experience building visualizations and dashboards in tools like Tableau, Retool, or Thoughtspot.

Responsibilities

• Collaborate & Strategize: Partner closely with business stakeholders to understand their challenges and design end-to-end architecture that solves complex business problems.
• Build & Maintain Data Models: Design, develop, and own robust, efficient, and scalable data models in Snowflake and Iceberg using dbt and advanced SQL.
• Orchestrate & Automate: Build and manage reliable data pipelines and CI/CD workflows using tools like Airflow, Python, and Terraform to ensure data is fresh, trustworthy, and infrastructure is version-controlled.
• Champion Data Quality: Implement rigorous testing, documentation, and data governance practices to maintain a single source of truth.
• Enable Analytics & Workflows: Act as the Product Owner and Tech Lead for your data domains, taking responsibility for the end-to-end data product delivery– from raw ingestion to data models enabling analytics and data apps in tools like Tableau and Retool.
• Innovate with AI: Help us build our next-generation data infrastructure by integrating AI capabilities (like Snowflake Cortex AI) to democratize analytics and empower the business.
• Architect Observability: Implement monitoring and alerting frameworks (e.g., dbt packages or Monte Carlo monitors) to proactively catch "silent" data failures before stakeholders do.

Benefits

• Motive offers benefits including health, pharmacy, optical and dental care benefits, paid time off, sick time off, short term and long term disability coverage, life insurance as well as 401k contribution (all benefits are subject to eligibility requirements). Learn more about our benefits by visiting Motive Perks & Benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 1-10 employees