Data Architect

United States (Remote)

Full Time Senior-level / Expert
Pantheon logo

Pantheon

Pantheon is the WebOps platform where teams build, host, and manage their websites. Pantheon delivers everything your business needs for digital speed and agility. Learn more.

View all employer listings

Apply now Apply later

Data Architect

Remote

About Pantheon

Pantheon’s WebOps Platform powers the open web, running sites in the cloud for customers including Stitch Fix, Okta, Home Depot, Pernod Ricard and The Barack Obama Foundation. Every day, thousands of developers and marketers create, iterate, and scale websites on the open web to reach billions of people globally. Pantheon’s SaaS model puts large and small web and digital teams in control of increasing the performance of their teams, websites, and marketing programs. Pantheon cloud native software includes governance, security and collaboration tools that make it easy to securely manage a single website or thousands of websites across multiple teams in one platform. The built-in ability to simultaneously create, test, deploy and run live sites with unrivaled hosting speed, scalability and uptime give marketing teams the agility to win in the dynamic world of digital marketing.

With 35% of the web running open-source and significant investments in a $200 billion total addressable market, we are growing aggressively into a huge market opportunity and looking to expand our organization. 

The Role

As a Data Architect, you will play a critical role in designing and implementing our data warehouse which is heavily used across all the data teams in the company. You’ll be responsible for the end-to-end process for our data solutions (Replication, governance, ETL, Integrations, data modeling, semantic layer, data tuning, performance, monitoring, data quality, etc.). This role involves working with major SaaS platforms like Google Big Query, GCS, Snowflake, Salesforce, Netsuite, Zuora and executing a strategy in cross-functional initiatives. It requires experience with a user-oriented approach to problems, focusing on software products and technologies.

Cool Things You’ll Do

  • Design and implement effective data warehouse solutions and models to store and retrieve company data
  • Define and implement optimal governance structures, architectural standards, and compliance processes within the data warehouse to ensure conformance of all technology projects.
  • Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
  • Maintain and develop the enterprise data management tools (data dictionary, data catalog)
  • Work with the data team and the business, to make sure we have all the data points in the data warehouse
  • Coordinate with other team members to reach project milestones and deadlines
  • Work with BI teams on data design and data warehouse best practices
  • Understand the desired business strategy and outcome, and break it down into defined parts, including systems, processes, and functions
  • Lead API strategy: Translate and map business use cases into API architectural designs; apply critical and innovative thinking to technology strategies that further business objectives while keeping in mind performance, reliability, scalability, usability, security, flexibility, and cost
  • Understand and own document artifacts of the data warehouse architecture and interfacing systems including Salesforce, NetSuite, Zuora, Marketing tooling and various data logs.
  • Load new data points into the data warehouse.

What you Bring to the Table

  • 7+ years experience as a data architect
  • Experience in building ontologies and semantic model
  • 3+ years of experience working with Google Big Query
  • 2+ years of experience working with Cloud environments (GCP, AWS, Azure)
  • 2 + years of Data Engineering experience working with both distributed architectures, ETL, EDW, and Big Data technologies
  • Experience working with both structured and unstructured data sources using cloud analytics
  • Experience with DWBI modeling framework is highly regarded
  • Experience with Data Mapping and Modeling
  • Experience with data warehouse ETL build, and design
  • Experience with Google Cloud Storage is a plus
  • Experience with Salesforce is a plus
  • Experience with Looker is a plus
  • Ability to collaborate and communicate effectively across all levels of the organization; experience working effectively on virtual teams
  • Results-oriented with a demonstrated sense of urgency to drive multiple projects to successful completion
  • Demonstrated ability to succeed in driving projects when the approach, challenges, and key objectives start out very unclear

What We Offer

We have all the usual perks and benefits but what we can really offer you is a fantastic work environment powered by an amazing team.

  • Industry competitive compensation and stock option plan
  • Unlimited time off and sick days
  • Full medical coverage (medical, dental, vision)
  • Top-of-line equipment
  • Fun at WordPress and Drupal community events
  • Extra benefits like a stipend for reading books and your work-outs and a whole suite of paid apps for mental as well as physical health and wellbeing
  • Events and activities both team-based and company wide that inspire, educate and cultivate 

Pantheon is an equal opportunity/affirmative action employer and we welcome applications from all backgrounds regardless of race, color, religion, sex, national origin, ancestry, age, marital status, sexual orientation, gender identity, veteran status, disability, or any other classification protected by law.

#LI-Remote

#LI-LT1

Job region(s): Remote/Anywhere North America
Job stats:  2  0  0
  • Share this job via
  • or

Explore more AI/ML/Data Science career opportunities