Working as a member of Blue Moon Digital, Inc.’s BI Team, the ETL Developer & Data Modeler will be focused on the implementation of fault tolerant, highly scalable solutions. The successful candidate will have a minimum of 5 years working hands-on with data. This individual will join an enthusiastic, fast-paced and dynamic team at Blue Moon Digital. A successful candidate will have demonstrated sustained exceptional performance, innovation, creativity, insight, and good judgment. They will work with stakeholders, Business Analysts, and other resources to refine requirements, create or modify technical programs, and execute data models.

RESPONSIBILITIES:

• ETL architecture, development, test, documentation and support of data sources
• Perform source system analysis, data profiling, and design mapping logic between source systems and the data warehouse
• Create data extraction, cleansing and load programs to move data from source systems to the data warehouse
• 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 Blue Moon Digital, Inc. and Domo’s 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:

• Bachelor's Degree in in Information Systems, Statistics, Computer Science or related field preferred or equivalent professional experience
• 5+ years of 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
• Proven experience in effectively partnering with business teams to deliver their goals and outcomes
• Excellent problem-solving skills and creativity
• Ability to think outside the box, adapt quickly and learn while ‘on the go’
• Experience working with APIs
• Experience working with Web Technologies (Javascript, Html, CSS)
• Experience with scripting technologies (Java, Python,R, etc.)
• Excellent oral and written communication skills, and comfort presenting to everyone from entry-level employees to senior vice presidents a must
• Experience with a wide variety of business data (Marketing, Finance, Operations, etc)
• Experience with Large ERP systems (SAP, Oracle JD Edwards, Microsoft Dynamics, NetSuite, etc)