Data Engineer II
| Company | Subsplash |
|---|---|
| Location | New Mexico, USA, Washington, USA, Kansas, USA, Oregon, USA, Iowa, USA, Wyoming, USA, Texas, USA, Florida, USA, South Carolina, USA, South Dakota, USA, Georgia, USA, Arizona, USA, Tennessee, USA, Virginia, USA, Arkansas, USA, Minnesota, USA, Colorado, USA, Utah, USA, Kentucky, USA, North Carolina, USA, Oklahoma, USA, Missouri, USA, Ohio, USA, Michigan, USA, Alabama, USA, United States, Idaho, USA |
| Salary | $120000 – $138000 |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Mid Level, Senior |
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