BI Big Data Engineer

Description
Want to be part of something new and exciting?
The Business Intelligent department is responsible for providing information and insights from our massive data sets. This information enables DoubleDown to understand our business, our players, and our games which will help us grow our business.
DoubleDown is seeking to hire a Big Data Engineer to support our growing workload and to provide additional capabilities to support upcoming games, new API integrations and process optimizations. We utilize many AWS products including RedShift, S3, EC2, and Elasticache to create and manage our state-of-the-art multi-Terabyte Enterprise Data Warehouse solution.
Our team is very-closely knit learning-oriented group who contribute greatly to the studio's success and has the opportunity to develop a wide range of technical and interpersonal skills and interact directly with our customers to deliver solutions that work well and are useful.
Be a key player in building new worlds and experiences at DoubleDown !
Our Seattle studio is the hub for all things creative - think G ame Designers, Artists, Marketers, and more ! L ocated in Seattle's International District , w e are exploring beyond social casino and focusing on creating multiple, all-new casual and mid-core franchises - expanding to create experiences in fun new worlds, developing characters, stories & gameplay! As a leader in the social casino space, we are excited to continue revolutionizing mobile games through constant innovation. Known for our fun and collaborative culture, we move quickly to deliver exciting g ame experiences to all sorts of gamers.
Your XP , Badges and Skill Tree

• Bachelors or Master of Science, in Computer Science or other IT-related major
• 3-5 years of ETL experience in data warehousing or transactional systems
• Proficient in at least one programming language ( Python, Java, Perl, etc.)
• Understanding and implementation experience or coursework with both relational and data warehousing models including star-schema, dimensional design, data mart, and database architecture
• Proficient in development of automated ETL processes (both through the use of automation tools and through manual scripting)
• Proficiency in a UNIX / Linux environment
• Understanding of Big Data mechanics, analytical processing, modeling, and implementation
• Proficiency in SQL, stored procedures, views, and triggers
• Strong problem solving and analytical skills; excellent communication skills

Other Super P ower s and Abilities

• Experience with Amazon Web Services (AWS)
• Experience in one of the reporting tools such as Airflow, Tableau, Talend, Business Objects, etc.

Your Mission
In this high-visibility role reporting to the Manager , Business Intelligence Engineering , the candidate will:

• Create detailed specs for ETL design/development/support and then transform those designs into system capabilities utilizing standard coding tools and processes.
• Work with end users to identify their ad hoc and scripted reporting needs
• Maintain and streamline the existing data flow to improve accuracy and efficiency
• Stay current with technical best practices and industry trends and advise and educate management on their importance
• Instill a strong customer service and business-oriented ethic when working with both the team and end users
• Identify and fix defects and reuse existing software components

New Adventures
By the end of your first year, you will be making major contributions to the EDW as demonstrated by:

• The c reation of rock solid ETL processes and SQL queries that populate the EDW
• Providing s uccessful support of BI analysts and data-hungry people in other parts of DoubleDown with data to support their reporting needs

Rewards and Perks
As our studio transitioned into a hybrid work environment (1 collaboration day per week in the office) the cool things we do for employees have slightly changed. Here is a glance of fun things we do as a studio!

• Take a break and participate in our bi-weekly (sometimes themed) trivia session!
• Stay zen throughout the week by taking advantage of one or more of our virtual yoga classes.
• Hungry? Anticipate monthly snack boxes courtesy of SnackMagic !
• Does your home "office" need some comfort? Take advantage of our office chair lending program!
• Still not comfortable? Schedule a virtual visit from our team of ergonomics assessment professionals.
• Miss seeing your coworkers faces? We also do virtual company events! Here is a snapshot of things we have done this past year :
  • Pride Bingo
  • Wine Tasting & Trivia
  • Escape Room Extravaganza
  • Painting Class
  • Virtual Murder Mystery
  • Virtual Candle Making
  • Story Time with Santa
• Still hungry? Depending on the month, you'll get carefully curated goodie boxes, to feed you and your family!
• Giving back to the community is just as important as giving to our employees. We have sponsored a company match for Juneteenth , hosted a virtual bike challenge benefiting the Boys & Girls Club of King County and partner ed once again with NBCF, and other local organizations.
• As if all of this isn't cool enough, you'll love our benefit package.
  • We offer medical, dental, vision, prescription coverage, maternity/paternity leave, disability protection (short- and long-term) and a 401(k) employer match and both traditional and Roth plans.
  • Not sure where to start with benefits? Health Advocate is here to help navigate benefits with you, like finding a doctor or help answer any medical related questions 24/7!
  • Every team member receives 15 days of vacation, 56 hours of sick time, 4 personal floating holidays, and 9 paid calendar holidays per year.
  • With everything that's going on in the world right now, we've got your back!
    • Between our Employee Assistance Program and our medical provider, you have up to 8 free counseling visits annually.
    • Our Simply Engaged and Rally Wellness Programs provide at home workouts, wellness resources and healthy recipes. Need more motivation? They also reward your healthy habits with gift cards!
    • And finally, to give you peace of mind, InfoArmor provides around the clock identity theft protection.

• Combine all of this with our amazing work/life balance and company-matched retirement options, and you have the dream job!

Looking for another reason we're the best place in Seattle to work? We're committed to our role as an Equal Opportunity Employer - we embrace a diverse mix of voices and create a positive environment where everyone belongs. We don't just accept difference - we celebrate it, we support it, and we thrive on it for the benefit of our employees, our products, and our communities. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. DoubleDown is committed to providing reasonable accommodation to individuals with physical and mental disabilities. If you need help completing your application, let us know! Email us at [email protected] and one of our awesome HR team members will get you everything you need. We look forward to meeting you soon!
To learn about us, please visit us here and watch us here !
To be considered, you must be at least 18 years of age with the ability to successfully pass a security criminal background investigation. You must be legally authorized to work in the United States without visa sponsorship as DoubleDown does not sponsor, renew, or extend immigration visas for this position.
DoubleDown partners with E-Verify, an Internet-based system that allows businesses to determine the eligibility of their employees to work in the United States.
*How we're handling COVID-19*
We are still hiring, so we've adapted our process to keep people safe. All positions at DoubleDown are subject to interviewing & onboarding virtually/remotely. Starting in June 2022, we are transition ing in to a hybrid environment based out of our Seattle, WA studio , where teams are expected to collaborate in the office for a minimum of 1 day per week . In person collaboration is a n important part of making awesome gaming experiences so when it is safe, we look forward to working together both virtually and in person!