Senior Data Solutions Developer at BigCommerce

Austin, Texas, United States

BigCommerce Logo
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

ELT
Data Warehousing
ETL
ERD
Data Transformation
Scheduled Jobs
Data Pipeline
Troubleshooting
Data Modeling
Automation

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