About the Role
As a Senior Data Solutions Developer, you will lead the evolution of data-driven decision-making at scale across the company. This role is responsible for building, maintaining, and supporting data warehousing solutions with an emphasis on creating automated or algorithmic approaches to reduce manual effort. You will ensure stakeholders have access to clean, consistent, and logical data.
Responsibilities
- Build and maintain scalable scheduled jobs to extract, load, and transform data.
- Troubleshoot and fix 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 areas 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 analyst tools to power business insights.
- Develop scalable, efficient, and automated processes and data pipelines.
- Diagnose and debug problems with existing data structures.
- Make recommendations to improve technical systems and infrastructure.
Requirements
- 3-5 years of 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 line.
- Possess at least a Bachelor’s degree in a quantitative field (economics, statistics, business, computer science) or equivalent experience; advanced degree a plus.
- Motivated by adding business value and driving revenue for the company.
- Quantitative mindset and passion for data.
- Curious problem solver with a growth mindset.
- Enjoy interacting and collaborating with technical developers and analysts as well as non-technical business staff.
- 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.
Skills
- Data Warehousing
- Data Modeling
- Analytics
- SQL (DML, DDL)
- Snowflake
- Redshift
- BigQuery
- Python
- BASH scripting
- JavaScript scripting
- ETL/ELT processes
- Data transformation techniques
- Dimensional data modeling
- Amazon Web Services
- Linux command line
Location
- Austin, TX metro area
Work Type
- Hybrid
Experience Level
- Senior
Education Level
- Bachelor's degree in a quantitative field or equivalent experience
- Advanced degree a plus
Salary/Compensations
- $111,000 - $167,000.00
Benefits
- Variable compensation (such as bonus or commission)
- Equity
- Benefits in accordance with local policies
About the Company
- Commerce is the parent company of BigCommerce, Feedonomics, and Makeswift, operating an open, AI-driven commerce ecosystem.
- Our mission is to empower businesses to innovate, grow, and thrive by connecting tools and systems that power growth.
- We enable businesses to unlock the full potential of their data, deliver seamless and personalized experiences across every channel, and adapt swiftly to market changes.
- We believe in harnessing AI responsibly to unlock new possibilities.
- BigCommerce provides the leading e-commerce platform for merchants of all sizes, enabling them to increase sales and concentrate on business growth.
- We are a group of clever, committed, curious people, unleashing talent and striving at the edge of what’s possible.
Equal Opportunity
- We are an equal opportunity employer and the inclusive atmosphere we build together will make room for every person to contribute, grow and thrive.
- We are committed to creating an inclusive and accessible hiring experience for all candidates.
- If you require accommodations or adjustments at any stage of the recruitment process, please let us know and we will work with you to meet your needs.
