Note: The job is a remote job and is open to candidates in USA. Domo is a company specializing in AI and Data Products, and they are seeking a Senior Technical Consultant to join their Client Services team. The role focuses on implementing scalable solutions and requires collaboration with various stakeholders to define data requirements and optimize data processes.

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

Skills

• 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

Company Overview

Company H1B Sponsorship