Principal Consultant

Domo•American Fork, UT

2d•Onsite

About The Position

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. POSITION SUMMARY This role is required to be in office 5 days a week. 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.

Requirements

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 BigQuery, 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

Nice To Haves

Web Development experience (JS, HTML, CSS) for custom app development is preferred

Responsibilities

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, BigQuery, 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 Workspaces 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)