Domo logo
Domo Verified
Software, Business Intelligence, Data Analytics, Cloud Computing

Senior Technical Consultant

Utah, Utah, United StatesRemoteFull TimeSeniorPosted 1 month agoVisa sponsorship available

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

Domo is seeking a Senior Technical Consultant to join their Client Services team. This role focuses on implementing fault-tolerant, highly scalable solutions using AI and data. The consultant will work with clients to define data requirements, design data models and warehouses, aggregate large datasets, optimize SQL queries, and lead database analysis and build efforts. The ideal candidate has at least 10 years of experience in BI or ETL development, expert SQL skills, familiarity with various database technologies, and advanced Excel skills.

# 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.

POSITION SUMMARY

Working as a member of Domo’s Client Services team, the Senior Technical Consultant will be focused on the implementation of fault tolerant, highly scalable solutions. The successful candidate will have a minimum of 3 years working hands on with data. This individual will join an enthusiastic, fast-paced and dynamic team at Domo. A successful candidate will have demonstrated sustained exceptional performance, innovation, creativity, insight, and good judgment.

KEY RESPONSIBILITIES

  • Works with customers, end-users, technical analyst, and application designers to define the data requirements and structure for Business Intelligence (BI) applications;
  • Designs models for the data warehouse or data mart (data structure, storage, and integration);
  • Works with our team to aggregate large data sets for use within Domo solutions;
  • Develops, designs, and optimizes complex SQL queries;
  • Leads the database analysis, design, and build effort;
  • Designs maps of source system data to data warehouse models;
  • Develop strategies for data acquisitions and integration of the new data into Domo's Data Engine.

JOB REQUIREMENTS

  • 10+ years experience supporting business intelligence systems in a BI or ETL Developer role;
  • Expert SQL skills required;
  • Expertise with Windows and Linux environments;
  • Expertise with at least one of the following database technologies and familiarity with the others: relational, columnar and NoSQL (i.e. MySQL, Oracle, MSSQL, Vertica, mongodb);
  • Understanding of data modeling skills (i.e. conceptual, logical and physical model design - with both traditional 3rd normal form as well as dimensional modeling, such as star and snowflake);
  • Experience dealing with large data sets;
  • Advanced Excel skills, including pivot tables and VBA (Visual Basic for Applications);
  • Goal oriented with strong attention to detail;
  • Proven experience in effectively partnering with business teams to deliver their goals and outcomes;
  • Bachelor's Degree in Information Systems, Statistics, Computer Science or related field preferred OR equivalent professional experience.

Domo is an equal opportunity employer

Sample Domo interview questions

  • 1

    Vertical Order Traversal Perform a vertical order traversal of a binary tree. Input: root = [1,2,3,4,5,6,7] Output: [[4],[2],[1,5,6],[3],[7]] Explanation: Traverses the tree maintaining column indices, seamlessly grouping nodes that share the exact same vertical alignment.

    codingmedium
  • 2

    Reverse Nodes in k-Group Reverse nodes in k-group in a linked list. Input: head = [1,2,3,4,5], k = 3 Output: [3,2,1,4,5] Explanation: The first 3 elements are reversed, while the remaining 2 are left untouched since they don't form a complete group.

    codingmedium
  • 3

    Clone an Undirected Graph Clone an undirected graph. Input: adjList = [[]] Output: [[]] Explanation: Creates a new, deeply cloned graph containing only one single node with zero connected neighbors.

    codingmedium
  • 4

    Implement a Trie Implement a Trie for prefix matching. Input: insert("hello"), startsWith("hel") Output: TRUE Explanation: Traverses the Trie nodes to confirm that the prefix "hel" actively exists within the inserted word "hello".

    codingmedium
  • 5

    Implement String Compression Implement string compression. Input: chars = ["a","b","b","b","b","b","b","b","b","b","b","b","b"] Output: ["a","b","1","2"] Explanation: The letter 'a' appears once (so no number is appended), and 'b' appears 12 times, modifying the array in place to length 4.

    codingmedium

Sign up for a personalized interview prep pack tailored to this role.

Ready to apply?
You'll be redirected to Domo's application page.

Similar roles