Senior Data Solutions Developer

BigCommerce • Austin, TX

2d • Hybrid

About The Position

As Senior Data Solutions Developer you will help lead the evolution of our data-driven decision-making at scale across the company. This role will be responsible for building, maintaining and supporting data warehousing solutions with an emphasis on creating automated and/or algorithmic approaches that reduce or replace manual effort. You will be instrumental in ensuring access to clean, consistent and logical data to stakeholders in a wide variety of roles.

Requirements

• 3-5 years experience in data warehousing, data modeling, and/or analytics preferred
• Advanced SQL skills in both DML and DDL are required
• Experience with database platforms like Snowflake, Redshift, BigQuery or similar
• Intermediate Python skills plus scripting in 1 or 2 other languages (BASH/Python/JavaScript/etc)
• Experience developing and maintaining ETL\ELT processes and common data transformation techniques (e.g. normalization and denormalization, string parsing, primary key generation)
• Familiarity with dimensional data modeling techniques (snowflake and star schemas, fact tables, slowly changing dimensions, periodic snapshot tables, surrogate keys, etc.)
• Exposure to Amazon Web Services or Linux command
• Possess at least a Bachelor’s degree in a quantitative field (economics, statistics, business, computer science) or equivalent experience, advanced degree a plus
• You are motivated by adding business value and driving revenue for the company
• Quantitative mindset and passion for data
• You are a curious problem solver with a growth mindset
• You enjoy interacting and collaborating with technical developers and analysts as well as non-technical business staff throughout the organization
• Able to deal with ambiguity and problem-solve independently
• Self-starter: able to succeed and have an impact with minimal direction
• Ambitious, self-motivated, and goal-oriented
• Excellent time management skills
• Strong communication skills, both verbal and written

Nice To Haves

• Experience with Airflow is a plus

Responsibilities

• Build and maintain scalable scheduled jobs to extract, load and transform data, in addition to troubleshooting and fixing problems with existing data warehouse ELT jobs
• Collaborate closely with internal business stakeholders to gather requirements, coordinate deployments, and meet deadlines
• Develop an understanding of business systems and processes in one or more areas of the business such as Sales, Marketing, Customer Success and finance
• Build and maintain Entity Relationship Diagrams (ERD)
• Transform raw data into highly structured and consistent data sets used by analysts tools to power business insights
• Develop scalable, efficient, and automated processes and data pipelines, in addition to diagnosing and debugging problems with existing structures
• Make recommendations to improve technical systems and infrastructure

Benefits

• variable compensation (such as bonus or commission)
• equity
• benefits in accordance with local policies

What This Job Offers

• Job Type: Full-time
• Career Level: Senior