Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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)
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • ReactLibraries
    • Ruby on RailsFrameworks
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • SketchDesign
    • AsanaManagement
    • ConfluenceManagement
    • MavenlinkManagement
    • WordpressCMS
    • HubSpotCRM
    • SalesforceCRM

Location

We love being in the heart of Downtown Denver! One block off of historic Larimer Square, we have easy access to public transportation and restaurants.

An Insider's view of Blue Moon Digital, Inc. (now MERGE)

What are some social events your company does?

As a recent Colorado transplant, one thing I love about Blue Moon is that our culture is very social. Whether it's a team happy hour, holiday bake-off, networking event, or a random afternoon walk, there are always opportunities to get to know the people you work with. When my coworkers are also my friends, it makes me enjoy my work that much more.

Sara

Paid Social Strategist

How do you collaborate with other teams in the company?

It is BMDi's objective to look at our clients' accounts from a holistic perspective. I work closely with each marketing channel to meet client goals and learn about the available platforms and tools to improve our clients' digital strategy. I also work with our Tech/Data team to collaborate on useful data visualizations for our clients.

Mihana

Account Manager

How has your career grown since starting at the company?

My career at Blue Moon Digital started over 7 years ago fresh out of college as a coordinator, and have since moved all the way up to a manager. I’ve had mentors teach me everything there is to know about Paid Search and digital marketing. They’ve fostered my growth and allowed me to succeed on my own, and it's been a great journey!

Matt

Paid Search Manager

How do your team's ideas influence the company's direction?

Being in the digital industry, it is imperative that we create an environment of innovation. The best ideas come from our staff. We are always listening to new ideas, evaluating new technologies, looking for better ways. Our culture encourages the staff to have a growth mindset and learn new things to further themselves and further our company.

Cindy

CEO

What are Blue Moon Digital, Inc. (now MERGE) Perks + Benefits

Blue Moon Digital, Inc. (now MERGE) Benefits Overview

Matching 401(k)
Unlimited PTO
Health, dental, and vision insurance
HealthiestYou Coverage (Nutrition, Back Care, Mental Health, and Doctor Specialist Telehealth)
Life insurance
Home Office / Transportation stipend
Health & Wellness fund
Scholarship funds
Remote Work / WFH

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Team workouts
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Sabbatical
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Stocked Kitchen
Happy Hours
Pet Friendly
BMDi likes to bring their furry 4-legged friends to the office on an occasional Friday!
Fitness Subsidies
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Continuing Education stipend
Customized development tracks
More Jobs at Blue Moon Digital, Inc. (now MERGE)7 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Marketing
Developer
new
Denver
Marketing
new
Remote
Marketing
new
Denver
Data + Analytics
new
Remote
Data + Analytics
new
Denver
Marketing
new
Denver
Marketing
new
Denver
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Blue Moon Digital, Inc. (now MERGE)'s full profileSee more Blue Moon Digital, Inc. (now MERGE) jobs