Subsplash is looking to solve the problem of collecting, extracting, transforming, and correlating business data across their platform to provide better insights and decision-making capabilities for their clients and end-users.
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
- 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)
- Knowledge of a programming language (Go, Python, Javascript)
- Familiar with ELT tools such as DBT, Fivetran, Meltano
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
- 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.
Other
- Bachelor's degree in Computer Science, Mathematics, Statistics, or a related field
- Excellence communication (verbal and written) and interpersonal skills -- the ability to communicate with both business and technical teams
- Strong organizational skills and the ability to learn new technologies quickly
- Must reside in one of the following states: AL, AR, AZ, CO, FL, GA, ID, IA, IN, KS, KY, MO, MI, MN, NC, NM, OK, OH, OR, SC, SD, TN, TX, UT, VA, WA, WY
- Employment with Subsplash is contingent upon satisfactory proof of employee’s right to work in the U.S., as required by law and upon completion of a basic background check
