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