Enterprise Data Architect

BigCommerce, a “2024” Best Place to Work” is seeking an Enterprise Data Architect. As the Enterprise Data Architect, you will play a critical role in ensuring BC’s Data and Analytics data strategy is envisioned, developed, and implemented across the enterprise to support our strategic business goals. This position will report to the Senior Director, Data Strategy. The ideal candidate will possess expertise in dimensional data modeling and a strong understanding of data warehousing concepts. The Data Architect will contribute to the planning of the enterprise data strategy roadmap and architecture, working cross-functionally with various teams (i.e. Transformation, Business Applications, Finance Operations, Infrastructure, and IT) to help integrate data solutions. They will deliver results by designing, developing, and optimizing our data warehousing solutions, ensuring efficient and reliable data storage and retrieval for our organization's reporting and analytics needs.

**To be considered an applicant you must reside in the United States**

What You’ll Do

• Establish and maintain data modeling design and architectural standards.  Drive decisions that impact product design, application functionality, and technical operations and processes

• Collaborate with Enterprise Architect and Solution Architects contributing Data architecture design. 

• ​​Evaluate new and current technologies using existing data architecture standards and frameworks and maintain expertise in current and future reporting and warehousing technologies to architect forward-looking solutions for Enterprise Data

• Regularly provides technical guidance to non-technical staff and direction to support the outcomes both the business and technical teams are pursuing

• Simplify complex technical architecture problems and opportunities for communication and influencing of executives, business leaders, operators, and analysts.

• Provide guidance to junior and senior team members around scalability and performance tuning of data warehouse queries and Extract, Load and Transform (ELT) jobs

• Transform low-value datasets into highly structured and consistent data models for use by analysts, data scientists, and reporting tools 

• Develop and maintain dimensional data models to support efficient data storage and retrieval.

• Collaborate with Data Systems Analysts to translate business requirements into data requirements needed to build data solutions, using logical data models, data flow diagrams, and other methods

• Experience with Conceptual, Logical, and Physical data modeling. Ability to clearly describe business entities and related attributes using data management tools 

• Mentor junior team members in data modeling techniques and perform database design and code reviews. 

• Understanding of industry best practices in data warehousing design and development

• Build and maintain a library of documentation including Entity Relationship Diagrams, Data Flow Diagrams, Data lineage

Who You Are

• 10+ years of experience in designing and developing end-to-end data solutions with an emphasis on data architecture, data modeling, and data integration

• Expertise in dimensional data modeling techniques (snowflake and star schemas, fact tables, slowly changing dimensions, periodic snapshot tables, surrogate keys, etc.)

• Possess at least a Bachelor’s degree in a quantitative field (economics, statistics, business, computer science) or equivalent experience, advanced degree a plus

• Required experience in a relational database modeling role using data modeling tools such as or similar to ERwin or ER/Studio

• Expert SQL skills in both DDL and DML

• Advanced Python skills plus scripting in 1 or 2 other languages (BASH/Python/JavaScript/etc) 

• Familiarity with one or more data warehouse platforms such as Snowflake, Redshift, BigQuery or similar.

• Familiarity with one or more Cloud providers such as AWS, Azure, GCP.

• Proven ability to translate business concepts into data models that power meaningful data insights.

• Familiarity in Snowflake advanced concepts like setting up resource monitors, Role-Based Access Controls (RBAC), virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understanding how to use these features is a plus.

• Hands-on practical experience delivering system design, application development, testing, and operational stability

• 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

• Excellent problem-solving, critical thinking, and analytics skills with the ability to work in a cross-functional team.

• Advanced knowledge of architecture, applications, data governance, and technical processes 

• Ability to tackle design and functionality problems independently with little to no oversight

• Ability to evaluate current and emerging technologies to select or recommend the best solutions for the future state architecture

 #LI-GC1

#LI-Remote

INDSP