Data Engineer III at Subsplash

| Remote
Sorry, this job was removed at 1:10 p.m. (PST) on Wednesday, October 21, 2020
Find out who's hiring in Seattle.
See all Data + Analytics jobs in Seattle
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Data Engineer III 

About Subsplash

Based in Seattle, Subsplash is an exciting award-winning team of 150+ mission-driven people who are committed to our core values of humility, innovation, and excellence. Founded in 2005, we pioneered the market with the first-ever church mobile app. Since then, we’ve been working together to build The Ultimate Engagement Platform™ for churches, Christian ministries, non-profits, and businesses around the world. We find excitement in serving our 12,000+ clients, creating impactful products, and delighting the 40 million real people who use our platform every day. Subsplash has won awards for best mobile experience, been voted top 100 Washington's Best Workplaces by the Puget Sound Business Journal, created some of the most downloaded apps of all time, and built enterprise software for world-class brands like XBOX, Microsoft, Samsung, Expedia, and Cisco; yet, at the end of the day, we love making a lasting impact and a difference in our world.

Working at Subsplash is more than just a job; we are a team of people who are courageous, inventive, and passionate about doing meaningful work every day. Don’t take our word for it—head to Glassdoor and see for yourself!

About the Team

The Engineering Team is responsible for building and running all the products that Subsplash offers. We are a super-star team of software engineering, QA, and site reliability professionals creating polished experiences for our clients and end-users. The Engineering Team is responsible for the entire user experience including: Mobile Apps (end-user facing), Subsplash Giving, the Subsplash Dashboard CMS (client-facing), Web App, TV App, backend data feeds, analytics, SnapPages (website builder) and more. We serve thousands of clients, millions of end-users, and billions of individual app impressions.

About the Role

As the Sr. Data Engineer you will report to the Site Reliability Engineering Manager. You will be responsible for all things related to bits at rest within the Subsplash platform. You will be an expert on our production data sources, how to tweak and tune to optimize them for performance, and you will also be responsible for our data warehousing/data lake environment, and help provide our business analysts team with the necessary tools and information to generate internal-facing business intelligence reports. Additionally, you will help prepare data stores and data visualizations for customer and end-user facing components of our product offerings.

Top 3 Key Outcomes in Year 1

  1. Establish, operationalize and socialize a new data warehousing environment that will be the backbone of our data processing going forward: both for internal metrics as well as customer-facing metrics.
  2. Work with our Site Reliability Engineers to establish reliable and scalable processes for populating/re-hydrating our data warehouse/data lakes from production systems
  3. Help our Site Reliability Engineers maintain and optimize our production application data stores by recommending and implementing performance tuning

Your Priorities 

  • Build and maintain our data warehouse environment
  • Ensure our data warehouse schema design is optimized for scale and performance against our business intelligence and customer reporting requirements
  • Ensure PII and other sensitive data is properly handled within and while being transformed and brought into the data warehouse
  • Build and maintain our ETL pipelines from production data stores into the data warehouse
  • Monitor and optimize our production data stores
  • Assist in building and maintaining data visualizations, both internal-facing and customer-facing
  • Collaborate with business analysts, product manager, and software engineers to build and verify hypothesis related to business intelligence

Qualifications

  • 5+ years of experience as a Data Engineer or in a similar role
  • Experience with data modeling, data warehousing, and building ETL pipelines
  • Extremely comfortable with SQL
  • Excellent analytical abilities
  • Experience maintaining large scale data warehousing environments that are designed for both internal and external customers
  • Comfortable with ambiguity in requirements and able to be a self-starter
  • Knowledge and direct experience using business intelligence reporting tools (preferably Tableau)
  • Excellence communication (verbal and written) and interpersonal skills -- the ability to communicate with both business and technical teams
  • Experience working with Snowflake or similar data platforms (i.e. AWS Redshift, BigQuery)
  • Strong knowledge of relational databases (e.g. MySQL, MariaDB, PostgreSQL, Aurora) and document-oriented databases (e.g. MongoDB, DynamoDB)
  • Strong organizational skills and the ability to learn new technologies quickly

Preferred Qualifications

  • Knowledge of a programming language (Go, Python, Javascript, bash)
  • Strong data modeling skills
  • Familiarity with statistical models and data mining algorithms
  • Data Science experience (e.g. machine learning, artificial intelligence)
  • Bachelor's degree in Computer Science, Mathematics, Statistics or related field

Benefits

Generous Paid Time Off, Medical Coverage, Dental Coverage, Vision Coverage, 401k (with employer match), Free Smoothies and Snacks, Optional Work-from-home Thursdays, Public Transportation Subsidy. 

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
    • GolangLanguages
    • JavascriptLanguages
    • PHPLanguages
    • SwiftLanguages
    • ReactLibraries
    • RedisDatabases

Location

Subsplash is located in the Interbay neighborhood along major bus-lines with just a short walk to other neighborhoods & local food in Seattle!

An Insider's view of Subsplash

What’s the vibe like in the office?

We celebrate victories, support each other like family, & are all working toward a common goal. Open communication spreads excitement throughout the company as we hit milestones, share innovative ideas & strive for excellence. There is a thread of positivity & kindness in all that we do which sets us apart and allows for the best work-life balance!

Aly

Creative Director

What kinds of technical challenges do you and your team face?

On the Product Team, we have the unique opportunity to build high performant software that supports thousands of unique iOS and Android apps and the millions of end-users who use them. We face the daily challenge of building systems, APIs, and user interfaces that emphasize performance, versatility, and clarity to bring delight to all our clients.

Matt

Software Engineer

How has your career grown since starting at the company?

I’ve experienced tremendous growth in product management experience and skills, from business models to learning SQL to running beta tests. I’ve also had the opportunity to take on formal authority, moving from an ‘IC’ role to a manager of five fantastic employees, while building informal influence throughout a rapidly growing company.

Erick

Director of Agile Management Office

What are some things you learned at the company?

Subsplash has taught me how to listen & prioritize. Through conversations with prospective clients, I've learned how to ask intentional questions & listen well. As I juggle tasks, I've learned to better manage my time with competing priorities. From a platform standpoint, the learning never ends with the constant innovation I witness every day!

Kasey

Ministry Consultant II

What are Subsplash Perks + Benefits

Subsplash Benefits Overview

At Subsplash, our benefits + perks are designed to bring delight to our employees and their families! Each employee receives a generous amount of vacation (work hard, play hard) but we also want our team members to feel rested and refreshed every day of the week, that's why we offer flexible work from home opportunities (The perfect time to work in your sweatpants. Just saying.).

We strive to offer the best healthcare at the lowest cost possible and we offer a variety of plans to best suit the individual's personal and family needs.

We frequently have company-wide catered lunches, events, team-building activities and not to mention a healthy serving of spontaneous parties. On top of that, we keep our kitchen stocked with yummy munchies, healthy fuel, and the freezer is always packed with all the smoothie makings you could ever need.

Culture
Volunteer in local community
Partners with Nonprofits
Subsplash has partnered with various non-profits in the city of Seattle such as the Union Gospel Mission and Urban Impact
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
Pair programming
Diversity
Diversity Employee Resource Groups
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Subsplash's short term disability is covered at 100% with salary continuance. Full-time employees can be rest assured that Subsplash has got them fully covered in times of need.
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Subsplash offers $50,000 of Life and AD&D coverage for all full-time employees. Employees are also able to purchase up to $300,000 supplemental coverage at a very low cost.
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
We offer Work-From-Home Thursdays to all employees.
Family Medical Leave
Return-to-work program post parental leave
Company sponsored family events
Acme co. sponsors family oriented events Quarterly.
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
We call it "creative professional". That means we dress casual and bring our own unique style and spunk to what we wear every day; jeans and sandals are totally acceptable!
Commuter Benefits
Company Outings
Stocked Kitchen
Unlimited munchies (including guacamole. Enough said.), coffee from a local Seattle roaster, tea, fruits and vegetables, all the smoothie ingredients you could ever need, and so much more!
Some Meals Provided
We provide monthly catered lunches
Happy Hours
Parking
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Acme Co. hosts lunch and learn meetings once per quarter.
Promote from within
More Jobs at Subsplash3 open jobs
All Jobs
Design + UX
Dev + Engineer
Sales
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Subsplash's full profileSee more Subsplash jobs