Senior Data Solutions Developer at BigCommerce

Austin, Texas, United States

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

Ecommerce, SaaSIndustries

Requirements

3-5 years experience in data warehousing, data modeling, and/or analytics preferred
Advanced SQL skills in both DML and DDL 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
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
Enjoys 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

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

Skills

Key technologies and capabilities for this role

ELTData WarehousingETLERDData TransformationScheduled JobsData PipelineTroubleshootingData ModelingAutomation

Questions & Answers

Common questions about this position

What experience level is required for this role?

3-5 years experience in data warehousing, data modeling, and/or analytics is preferred.

What are the key technical skills needed for this position?

Advanced SQL skills in both DML and DDL are required, along with intermediate Python skills and scripting in 1 or 2 other languages. Experience with database platforms like Snowflake, Redshift, or BigQuery, ETL/ELT processes, and dimensional data modeling techniques is also essential.

What is the salary or compensation for this role?

This information is not specified in the job description.

Is this position remote or does it require office work?

This information is not specified in the job description.

What education is required for this role?

A Bachelor’s degree in a quantitative field such as economics or statistics is required.

BigCommerce

E-commerce platform for online store management

About BigCommerce

BigCommerce offers an e-commerce platform that helps businesses create and manage online stores through a subscription service. It provides tools for website building, order management, payment processing, and marketing, along with an App Marketplace for additional integrations. The platform is flexible and scalable, allowing businesses to grow without switching systems, and supports headless commerce for customized storefronts. BigCommerce aims to deliver a comprehensive solution for businesses of all sizes.

Austin, TexasHeadquarters

2009Year Founded

$213.2MTotal Funding

IPOCompany Stage

Consumer Software, Enterprise SoftwareIndustries

1,001-5,000Employees

Benefits

Health Insurance

Paid Vacation

Mental Health Support

Risks

Integration with Yuma.ai raises potential data privacy concerns.

Self-service upgrade tool may cause issues for non-tech-savvy users.

New executive appointments could lead to strategic misalignment with customer expectations.

Differentiation

BigCommerce offers headless commerce, allowing complete control over frontend design.

The platform supports both B2B and B2C e-commerce for over 60,000 brands.

BigCommerce's App Marketplace enhances functionality with third-party apps and integrations.

Upsides

Growing demand for headless commerce boosts BigCommerce's market position.

Partnership with Nuvei enhances global payment solutions for BigCommerce clients.

Expansion in B2B e-commerce creates new opportunities for BigCommerce.

Land your dream remote job 3x faster with AI

Try Jobo Free