Data Warehouse Engineer I

| Seattle

Description

 

Blue Nile is looking for a highly motivated, results-oriented Data Warehouse Engineer to join our Data & Analytics team to help solve some hard problems for the business. If you have strong technical skills and love to solve challenging problems to help business make better decisions through collection & organization of data, data analysis and report development, you will have a great time working on this small team. We are looking for a person with strong technical skills and has the ability to learn quickly without the help of a lot of documentation. You will focus on the development of the data warehouse and build solutions that leverage the power of the data warehouse for business benefit. The Data & Analytics team is responsible for enabling reporting and analytics for the entire company. The data warehouse is a strategic asset for the company and powers data, insights, and actions across all business functions.

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.
 

Primary Responsibilities:

  • Develop robust and scalable ETL using tools such as ODI, and programming languages such as SQL and PL/SQL
  • Regularly use SQL for data analysis and discovery, providing summary data for answering adhoc business questions, identifying data inconsistencies, etc.
  • Work with business teams to understand their data needs and provide data & reporting solutions using SQL, Tableau or Microsoft Reporting Services
  • Perform complex data analysis against our OLTP and DW databases to create actionable insights for the business
  • Debug data issues and develop scripts in Oracle SQL & PL/SQL to perform data backfills
  • Use query tuning techniques like optimizer hints, indexes, etc. and work closely with DBA's to ensure optimal performance of ETL
  • Analyze business requirements and develop data sources and extracts in Tableau
  • Build reports in Microsoft Reporting Services that source data from heterogeneous data sources
  • You have to be really strong in SQL as you will be using it on a daily basis - for development, data analysis, debugging data issues, etc.

 

Qualifications:

  • Bachelor’s Degree in Information Technology or Computer Science or equivalent
  • 3-5 years experience working in a data warehouse environment
  • Excellent SQL & PL/SQL skills
  • Demonstrated strength in ETL development and data warehousing
  • Ability to learn quickly and work with minimal supervision
  • Tableau experience is a plus
  • Microsoft Reporting Services experience a plus
  • Oracle Data Integrator (ODI) experience a plus

 

What we offer:

  • Medical, Dental, and Vision Healthcare Coverage, paid by employer
  • 401(k) with Company Match
  • Paid Vacation
  • Competitive Salaries
  • Transportation Allowance
  • Employee Discount
  • Employee Referral Bonus

 

 

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • jQueryLibraries
    • ReactLibraries
    • AngularJSFrameworks
    • Backbone.jsFrameworks
    • SpringFrameworks
    • OracleDatabases
    • ConfluenceManagement
    • JIRAManagement
    • SalesforceCRM

Location

We are located in Seattle’s vibrant Pioneer Square district. We are close to transportation, restaurants, coffee shops and parks.

What are Blue Nile Perks + Benefits

Culture
Partners with Nonprofits
Friends outside of work
Eat lunch together
Daily stand up
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Set aside up to $2,650/year pre-tax to pay for eligible health expenses- including many over-the-counter products.
Disability Insurance
Dental Benefits
Blue Nile pays 100% of the employee premium and a portion of the dependent premium for full time employees on our Health Plans.
Vision Benefits
The vision benefits plan covers 100% for annual eye exams with $130 for glasses and contact lenses.
Health Insurance Benefits
Blue Nile pays 100% of the employee premium and a portion of the dependent premium for full time employees on our Health Plans.
Life Insurance
Employer paid life/AD&D insurance with a $50,000 benefit for each. Supplemental life/AD&D available for employees, spouses, and children
Wellness Programs
Retirement & Stock Options Benefits
401(K)
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
All full-time regular employees receive $100.00 per month to aid with transportation costs. Pre-tax savings are available on bus and ferry passes as well as parking expenses.
Company Outings
Happy Hours
Happy hours are hosted Once per month by our Brewnile Club!
Professional Development Benefits
Cross functional training encouraged
Promote from within

Additional Perks + Benefits

Benefits are effective the first of the month following your date of hire.

More Jobs at Blue Nile7 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Marketing
Data + Analytics
new
Seattle
Finance
new
Seattle
Marketing
new
Seattle
Data + Analytics
new
Seattle
Data + Analytics
new
Seattle