Oh Snap!
This job is no longer active - but you can still view the details below.

Senior Data Warehouse Engineer

| Bellevue
Senior Data Warehouse Engineer 
Bellevue, WA
 
We are looking for a senior data warehouse engineer with a well rounded software development background and proficiencies in ETL processes, and data warehouse operations.
The Tools and Data team is responsible for the design and operation of our data warehouse services, processes, and infrastructure overseeing all ETL processes and frameworks. The successful candidate will be a well-rounded data warehouse engineer with a strong expertise in experience SQL query performance tuning, data warehouse design and modeling. Python experience is also important as it is the primary programming language of choice. Strong communication skills and working with internal customers and peers is a must.
Qualifications
  • A minimum of 5+ years of professional experience in software development and data warehouse management
  • Strong understanding of SQL fundamentals, including warehousing contexts and/or other complex environments, relational or NoSQL databases engines such as SQL Server, MySQL, Postgres
  • Deep expertise in data warehousing, dimensional modeling and the ability to bring best practices with regard to data management, ETL, API integrations, and data governance
  • 3+ years of Python programming experience
  • Knowledge and experience working with networking, business intelligence, and data visualization are a plus
  • Strong problem-solving and analytical skills
  • Experience with AWS or GCP is preferred
  • Bachelor's Degree in Computer Science or equivalent preferred
  • Work in an agile work environment experience including working from a ticket system like Jira or similar,and collaborating through a distributed version control system like Github or similar.
Responsibilities
  • Create deploy, and automate ETL and data integration processes into an Enterprise Data Warehouse using Python and BigQuery
  • Act as a key Data Warehouse SME within the data services team to drive successful adoption of best practices, standardization of data provision to the data warehouse, and proactive management of data refresh and accuracy
  • Develop and Engineer under a full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operational management. This will include participating on on-call rotation.
  • Design and implement formal data warehouse testing strategies and plans including unit testing, functional testing, integration testing, performance testing, and validation testing.
  • Participate in data warehouse health monitoring and performance optimizations as well as quality documentation. 
 
A few things to know about us:
  • Donuts offers a highly competitive compensation package and a friendly, collaborative culture that values employee engagement and ongoing career development. Donuts also offers some great perks such as weekly catered lunches, a fully stocked kitchen including coffee, snacks and drinks, and lots of social activities. 
  • Donuts is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex, age, national origin, veteran status, marital status, sexual orientation, gender identity, disability or any other category prohibited by local, state or federal law. This policy applies to all aspects of employment, including recruitment, placement, promotion, transfer, demotion, compensation, benefits, social and recreational activities and termination.
 
Read Full Job Description

Location

Our brand new office is located right in the center of it all in downtown Bellevue! Our beautiful space is close to literally everything...really!!

An Insider's view of Donuts Inc.

What are some social events your company does?

At Donuts we work hard & when it's time, we like to play hard too. There are a myriad of social activities that bring us together to get to know each other outside of the conference room. Fun Fridays, rolling up our sleeves to help at a food bank, teaming up w/colleagues in our annual Hackathon, or competing in a ping pong tourney!

Rob Toledo

Sr. Director, Marketing

How do you collaborate with other teams in the company?

Donuts has a great culture of people that work together as an organization which I believe promotes no barriers to accessibility. People are treated with respect, trust and kindness and work as one team.

Serina Ness

VP, Controller

How does the company support your career growth?

At Donuts, you work alongside high caliber people who are experts at what they do. I've grown immensely by working with individuals and teams across the company. The deep experience your coworkers bring to the table is invaluable to both individual and company growth.

Shannon O'Donald

Product Marketing Manager

How do you empower your team to be more creative?

To use a baseball analogy, I find the best hitters and try not to tell them how to swing.

Alvaro Alvarez

EVP, General Counsel & Secretary

What unique initiatives do you have that encourage innovation?

Donuts Hackathon! We develop many cool ideas and solutions and it's both fun and professionally rewarding. The BI, Sales, and Registry Support team are currently working on a project that was initiated from last year's Hackathon.

Angela Deng

Project Manager, Operations

What are Donuts Inc. Perks + Benefits

Culture
Volunteer in local community
Donuts.gives allows employees to volunteer and donate together to benefit local charities like Food Lifeline, Mary's Place and Hopelink.
Friends outside of work
Eat lunch together
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Highly diverse management team
Unconscious bias training
Donuts values diversity and we respect each others differences.
Mean gender pay gap below 10%
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Donuts employees may contribute up to the IRS limits annually.
Disability Insurance
Short and long term disability benefits provides 60% of your salary
Dental Benefits
We offer Delta Dental benefits: 100% of diagnostic and preventative costs are covered and after a $50 deductible, 90% of basic services are covered.
Vision Benefits
After a $10 co-pay the VSP vision benefits plan covers 100% for annual eye exams and offers $130 for frames or contact lenses.
Health Insurance Benefits
Donuts offers different Health Insurance Plans, and will help you to choose the best fit for you!
Life Insurance
Donuts Life insurance is equal to 2 times an employee's annual salary (up to $500k)
Wellness Programs
Onsite Gym
Team workouts
On site Yoga for all Donuts. Namaste!
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Donuts matches employee contributions dollar for dollar up to $5,000 each year
Company Equity
We are all growing this company together, so we provide options for all!
Performance Bonus
Everyone at all levels are in the same bonus plan. We win and or learn as a team!
Child Care & Parental Leave Benefits
Generous Parental Leave
We provide 12 weeks of paid parental leave for the primary caretaker. Donuts also provides 8 weeks of paid leave for the secondary caretaker.
Flexible Work Schedule
Whatever it takes to get your job done. Each team has it's own needs, so check in with your manager, but we are a tech company and we are nothing if not agile
Remote Work Program
Just check in with your manager, we are humans and we get that working from home is sometimes necessary!
Family Medical Leave
Donuts meets and fare often exceeds the minimum federal guidelines for FMLA
Company sponsored family events
The company that plays together stays together
Vacation & Time Off Benefits
Generous PTO
Donuts employees are encouraged to take time off to recharge. We offer 20 days PTO each year. Employees may rollover up to 200 hours into the next year.
Paid Holidays
Paid Sick Days
Donuts Employees receive 5 days per year of paid sick leave.
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Donuts offers two large scale functions for employees and their families each year and departments tend to have a couple of outings on their own as well.
Game Room
Take a break and stretch out in our game room...we offer two ping pong tables, and a Mini-Golf course!
Stocked Kitchen
You want to be at Donuts when the zombie apocalypse occurs. Our snacks are top of the line; you will not go hungry on our watch!
Some Meals Provided
Donuts provides lunch and employees (including the CEO) sit together and catch up. It is not the only day we get the benefit of a free lunch, but it is a scheduled day we gather.
Happy Hours
It's always five o'clock somewhere right?
Parking
We offer employees Free on-site parking.
Professional Development Benefits
Job Training & Conferences
Donuts offers job training and the ability to attend conferences (nothing like heading to Vegas in July)!
Tuition Reimbursement
Our tuition reimbursement plan offers $1,500 to each employee to further their professional education.
Diversity Program
Lunch and learns
Every month Donuts offers everyone a free lunch (with a side of learning).
Promote from within
Continuing Education stipend
Donuts offers $1,500 annually for employees who wish to continue their professional education.
Paid industry certifications
Professional certifications means our employees are gaining knowledge, so yes we love supporting this!
More Jobs at Donuts Inc.3 open jobs
All Jobs
Dev + Engineer
HR
Sales
Developer
new
Bellevue