Data Warehouse Programmer Analyst

Technology | Seattle, WA, United States

Blue Nile is looking for a highly motivated Data Warehouse Programmer Analyst with the right blend of business and technical experience to join our Data & Analytics team. You will be part of a small team responsible for maintaining and enhancing our data warehouse and enabling reporting and analytics for the entire company. This team is responsible for all aspects of our warehouse, ETL, and reporting environment. This position offers a unique opportunity to engage at both a strategic level working with senior management driving business intelligence solutions and at the tactical level working with business users and other teams within technology. You will have the opportunity to work on a wide breadth of technologies and systems.

Blue Nile is the largest online retailer of certified diamonds, engagement rings and fine jewelry. Our standards are amongst the highest of all jewelers. We provide a superior customer experience, extraordinary value and industry leading product quality and style. We obsess about our customers and are passionate about providing each customer with an amazing experience.

Our corporate offices are located in Seattle’s vibrant Pioneer Square district, home to the latest wave of internet startups and packed with restaurants and entertainment including Century Link and Safeco fields. We are close to transportation, the waterfront, and parks.  Our dress code favors jeans and our facilities include bike racks and showers.

  • Maintain and enhance the Data Warehouse environment for the company; contribute in all phases such as identifying data and reporting needs; designing data warehouse models; creating source to target mappings; developing ETL routines; creating reports; performing complex data analysis; data governance; establishing standards; etc
  • Work on projects to implement data warehousing and business intelligence solutions to help drive better decisions within a fast-paced environment
  • Work with other teams within technology and subject matter experts to ensure software design includes anchors for analytics
  • Contribute in the design of new data structures and dimensional models in the data warehouse as source systems evolve
  • Continuously pursue and master new business intelligence skills to help increase the analytical “IQ” of the organization
  • Perform ad hoc reporting against our production database and analytic data warehouse.
  • Create reports and analysis cubes

  • 5+ years experience in data warehousing
  • Experience applying business intelligence and analytics solutions to meet needs of business teams
  • Bachelor’s Degree in Information Technology or Computer Science or equivalent education/experience
  • Excellent SQL & PL/SQL skills (coding by hand; proficient at using analytic functions)
  • Solid understanding of data: how to organize it, how to model it, how to distill insights from it, and how to visualize it
  • Ability to work directly with end users to ensure results meet their needs
  • Intellectual curiosity; ability to draw connections and understand the “why” as well as the “what” in the data
  • Proven record of good judgment in solving problems and handling challenges
  • Strong communication skills and desire to work in cross-functional groups
  • Oracle Data Integrator (ODI) experience a plus
  • Microsoft Reporting Services experience a plus

What we offer:
  • Medical, Dental, and Vision Healthcare Coverage
  • 401(k) with Company Match
  • Paid Vacation
  • Competitive Salaries
  • Transportation Allowance
  • Employee Discount
  • Employee Referral Bonus
  • Fitness Center Discount