Data Engineer II

Data Engineer II

About Subsplash

Subsplash is an exciting award-winning team of 280+ mission-driven people who are committed to our core values of humility, innovation, and excellence. Since being founded in 2005, we have pioneered the market with the first ever church mobile app. 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 14,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 a Data Engineer, you will be responsible for all things related to the collection, extraction, transformation, and correlation of business data across the Subsplash platform. You will report to the Site Reliability Engineering Manager. You will be an expert on our production data sources, and how to administer and tune data systems to optimize for performance. You will also work regularly with our data warehousing/data lake environments to help provide our business analysis and intelligence team with data marts. Data collection, extraction, and transformation is often achieved through Python code development and maintenance. In a remote-first, distributed team environment, you will work well with other team members to deliver working data engineering solutions early and often.

Top 3 Key Outcomes in Year 1

1. Work with the lead Data Engineer to assume primary responsibilities for operating and monitoring Extract-Load-Transform (ELT) data pipelines, routine ELT pipeline add/change tasks, and continual improvement. Success in this outcome will be measured by the capacity freed up for the senior data Engineer.
2. Serve as a point of escalation for any questions related to SQL query performance or optimization of Subsplash data systems. This may include analysis of slow query reports and execution plans or other questions from software engineers.
3. Enable product teams, business analysis teams, and other stakeholders to integrate data into the Snowflake data warehouse system, and then access and analyze their data via Sigma, and/or Tableau.
4. Work with Data Engineering and Site Reliability Engineering (SRE) to continually improve observability and proactive alerting for Extract-Load-Transform (ELT) data pipelines.

Key Responsibilities:

• Operate and maintain Subsplash data warehousing environment, consisting of DBT, Python, Terraform, AWS DMS, Snowpipe, and related ELT tools, functioning in an AWS Kubernetes infrastructure, and maintaining in GitLab SCM and CI/CD.
• Ensure PII and other sensitive data are 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 production data stores
• Assist in building and maintaining data visualizations, both internal-facing and customer-facing
• Collaborate with business analysts, product managers, and software engineers to build and verify hypotheses related to business intelligence

 Qualifications 

• 2+ 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
• Comfortable with ambiguity in requirements and able to be a self-starter
• 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)
• Familiar with ELT tools such as DBT, Fivetran, Meltano
• Data Science experience (e.g. machine learning, artificial intelligence)
• Bachelor's degree in Computer Science, Mathematics, Statistics, or a related field