Data Engineer II

Summary

Join Subsplash as a Data Engineer II and play a pivotal role in our data infrastructure. You will be responsible for the collection, extraction, transformation, and correlation of business data across the Subsplash platform. This involves operating and maintaining our data warehousing environment, building and maintaining ETL pipelines, and ensuring data quality and security. You will collaborate with various teams to provide data-driven insights and optimize data systems. The ideal candidate possesses 2+ years of experience in a similar role, strong SQL skills, and experience with data warehousing and ETL pipelines. Subsplash offers a competitive salary, comprehensive benefits, and a remote-first work environment.

Requirements

• 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

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

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

Benefits

• Generous Paid Time Off (Accrual rate of 15 days for the first year and then 20 vacation days per year beginning on your 1 year anniversary)
• Medical Coverage
• Dental Coverage
• Vision Coverage
• Short and long term disability and life insurance all free of charge
• Competitive Compensation
• 401k Matching
• Professional Development
• Top of the Line Equipment
• Referral Program
• Parental Leave
• Family-Friendly Culture
• The chance to work side-by-side with thought leaders in emerging tech