BigCommerce’s mission is to help merchants sell more at every stage of growth, from small startups, to mid-market businesses to large enterprises. We focus on being the best ecommerce platform so our customers can focus on what matters most: growing their businesses.
We are equally passionate about growing our employee’s careers and providing them an incredible experience as we rapidly expand across the globe. We are proud to have been recognized numerous times for our product and workplace culture. We empower our people and customers to build, innovate and grow, so together we can redefine the ecommerce industry.
Lead Data Solutions Developer - Hybrid
Austin, TX
BigCommerce is disrupting the e-commerce industry as the SaaS leader for fast- growing, mid-market businesses. We enable our customers to build intuitive and engaging stores to support every stage of their growth. As Lead 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 processes using a modern tech stack that includes Airflow, Snowflake, and AWS
Establish relationships with key stakeholders and work closely with them in gathering requirements, gaining business context, and completing projects end-to-end
Connect and explore disparate data sources from production systems, business applications and third party data sources
Build and maintain data models, experiments, algorithms and related business and financial reporting logic
Production support required on a rotational basis
Mentor and coach more junior team members
Transform low-value datasets into highly structured and consistent data models for use by analysts, data scientists and reporting tools
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
Responsible for comprehensive reviews of data flows and processes to ensure appropriate controls and procedures are in place and operating effectively
Who You Are
5 - 8 years of technology background are desired, preferably in data/analytics, and at least some programming experience required
Advanced knowledge of SQL, able to optimize queries to make code more performant, experience participating in code review and debugging the code of others
Scripting skills in 1 or 2 languages (BASH/Python/JavaScript)
Experience with Cloud OLAP database platforms such as Snowflake, Redshift, BigQuery
Familiarity with ETL\ELT processes and common data transformation techniques (e.g. normalization and denormalization, string parsing, primary key generation)
Experience with version control software such as Git
Experience with BI tools is a plus, Tableau preferred
Experience pulling data from an API using Python and Airflow (or similar technology)
A broad exposure to business applications like CRM tools, financial reporting systems, marketing automation tools, etc (Salesforce, Zuora, Marketo)
Experience in dimensional data modeling
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
Quantitative mindset and passion for data
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
#LI-AL1
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 BigCommerce, please let us know during any of your interactions with our recruiting team.
Learn more about the BigCommerce team, culture and benefits at https://careers.bigcommerce.com.