Principal Consultant

Overview

Company Overview Domo's AI and Data Products Platform lets people channel AI and data into innovative uses that deliver a measurable impact. Anyone can use Domo to prepare, analyze, visualize, automate, and build data products that are amplified by AI.

A Principal Consultant (PC) acts as a strategic architect, partnering with Account Executives (AE) and Customer Success Managers (CSM) to drive business transformation. This role requires a hybrid of executive-level business acumen and deep technical fluency. You will design end-to-end ecosystems—connecting core systems (Snowflake, Databricks, GCP) via Domo, optimizing data pipelines with Magic ETL, and implementing next-generation AI solutions to enable customers to maximize the value of the platform.

• Identify technical risks to contract renewals and proactively spot areas for architectural expansion within customer accounts;
• Translate abstract business friction into concrete technical roadmaps and design scalable solutions for identified risks and opportunities;
• Data Pipeline Architecture:
  Architect and build robust data ingestion strategies using native Connectors, Cloud Amplifiers, and Federated Data adapters for seamless integration with external CDWs (Snowflake, Databricks, Big Query, Redshift);
• Transformation Engineering:
  Design and optimize complex data transformation logic using Magic ETL and SQL Dataflows to turn raw data into high-performance analytics assets;
• AI & Agentic Workflows:
  Lead the implementation of AI-driven solutions, utilizing concepts like Agent Orchestration and Model Context Protocol (MCP) to automate business actions based on data triggers;
• Advanced Analytics:
  Utilize Jupyter Work spaces to develop Python/R scripts for predictive modeling, statistical analysis, and data science workflows directly within the platform;
• Interact with customers at all levels—from technical analysts to C-Suite executives—to define data requirements and justify the ROI of technical initiatives;
• Guide the customer through the implementation lifecycle, enabling them to maintain solutions through training and working sessions;
• Design efficient schemas for data warehouses and data marts, prioritizing query performance and logical data models;
• Develop, debug, and optimize complex SQL queries to aggregate large data sets for use within Domo solutions;
• Troubleshoot complex data lineage issues across the full stack (Source System → Cloud Storage → Domo → Dashboard).

• Bachelor's Degree in Information Systems, Computer Science, Data Science, or related field (or equivalent elite professional experience);
• High Business Acumen:
  Ability to solve ambiguous business problems and translate high-level business needs into precise technical solutions;
• 3+ years of experience working with relational databases and Cloud Data Warehouses (Snowflake, Databricks, Google Big Query, or Redshift);
• Deep proficiency in SQL (Recursive CTEs, Window Functions) and ETL/ELT best practices (specifically Magic ETL experience is a strong plus);
• Familiarity with AI Architecture, including Agentic workflows, RAG, and LLM integration;
• Proficiency in scripting languages (Python, R) specifically within notebook environments like Jupyter;
• Ability to skillfully communicate and negotiate with both business and technical audiences;
• Ability to quickly develop expert-level understanding of complex software systems and API connectivity;
• Web Development experience (JS, HTML, CSS) for custom app development is preferred.

Domo is an equal opportunity employer