Senior Data Solutions Developer

At Commerce, our mission is to empower businesses to innovate, grow, and thrive with our open, AI-driven commerce ecosystem. As the parent company of BigCommerce, Feedonomics, and Makeswift, we connect the tools and systems that power growth, enabling businesses to unlock the full potential of their data, deliver seamless and personalized experiences across every channel, and adapt swiftly to an ever-changing market. Simply said, we help businesses confidently solve complex commerce challenges so they can build smarter, adapt faster, and grow on their own terms. If you want to be part of a team of bold builders, sharp thinkers, and technical trailblazers, working together to shape the future of commerce, this is the place for you.

BigCommerce, part of the Commerce brand family, helps merchants increase sales at every stage of their growth. From small startups to mid-market businesses and large enterprises, we provide the leading e-commerce platform. Our customers can then concentrate on what's most important: growing their businesses. We enable our customers to build, innovate, and grow, collectively reshaping the e-commerce industry.

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.

What You’ll Do

• 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

Who You Are

• 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)

• Experience with Airflow is a plus

• 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

• Position located in Austin, TX (2 days onsite a week)

#LI-CB1

#LI-HYBRID

(Pay Transparency Range: $91,000-$154,000)

At Commerce, we believe that celebrating the unique histories, perspectives and abilities of every employee makes a difference for our company, our customers and our community. 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 will ensure that individuals with disabilities are provided reasonable accommodation to participate in the interview process, to perform essential job functions and to receive other benefits and privileges of employment. If you need an accommodation in order to interview at Commerce, please let us know during any of your interactions with our recruiting team.

Learn more about the Commerce team, culture and benefits at https://www.commerce.com/careers/

Commerce, along with many other employers, has become the subject of fraudulent job offers to hopeful prospective job seekers.
Be advised:
Commerce does not offer jobs to individuals who do not go through our formal hiring process.
Commerce will never:

• require payment of recruitment fees from candidates;

• request personally identifiable information through unsanctioned websites or applications;

• attempt to solicit money from you as part of the hiring process or as part of an employment offer;

• solicit money to complete visa requirements as part of a job offer.

If you receive unsolicited offers of employment from Commerce, we urge you to be extremely cautious and avoid engaging or responding.