BI ETL Developer

BI ETL Developer

Remote

About Pantheon

Pantheon is the only WebOps platform built from the ground up for agility. We help our customers win, where the digital experience starts and matters most - their websites. We empower teams of developers, marketers, and IT professionals to focus on delivering business results while Pantheon handles uptime, performance, scalability, and security. We are the fastest growing Drupal and WordPress platform in the world, powering over 285,000 sites and serving billions of pages every month.  Happy customers include some of the most recognized names in high tech, higher education, and NGOs, such as Patch, Apigee, UC Berkeley, Arizona State University, and the United Nations.

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 sales organization. 

Pantheon’s core company values are Trust, Teamwork, Passion, and Customers First. At Pantheon, we work hard and play harder, valuing individuality, humor, and balance. We're enthusiastic participants in several open-source communities and have real relationships with many of our most active customers. If all of this sounds interesting to you, read on!

The Role

You are an experienced BI ETL Developer that is open to work remotely. Your expertise will enhance the stability of ETLs and help us continue to deliver more data to our internal customers. 

Cool Things You'll Do

• Manage all data ETLs within the organization and perform special data loads and backfills as needed
• Support our growing analytics team by documenting the core qualities of each data source in terms of the capabilities (various ways data can be pulled from the source) and the implementation (what is actually being downloaded).
• Onboarding new data sources that are not supported by existing ETL tools and using ETL tools for others.

What You Bring to the Table

• Knowledge of a variety of ETL tools and services such as Airflow, Trifacta, Fivetran, Informatica, Dataflow
• Experience working with, managing, and maintaining ETLs for dynamic/automated data systems as data changes.
• Experience with using scripting to manage data in a variety of environments such as moving data between cloud storage buckets, migrating data between various types of relationship database systems, etc. 
• Desire to work on a new project and participate in the design and documentation activities related to the creation of new infrastructure.

Bonus Points for

• Strong experience in SQL, Python, Bash
• Experience working on new “greenfield” projects
• Experience being the point of contact for Analytics teams

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. Visa Sponsorship is not available at this time. 

#LI-Remote

#LI-LP1