Snowflake Administrator

Snowflake DBA (Elastic Operations) 

phData works exclusively in the realm of data and machine learning. By partnering with the biggest cloud data platforms (Snowflake, AWS, dbt, Fivetran), we’re able to help the world’s largest companies solve their toughest challenges.

Our work is challenging and our standards are high, but we invest heavily in our employees, starting with a 2-4 week bootcamp to ensure your success. Plus, you’ll get to work with the brightest minds in the industry and the best in class platforms on the market. And, because the data and ML industry is changing rapidly, you will always have the opportunity to learn - whether that’s a new technology, diving deeper into your preferred stack, or picking up an entirely new skill set.

Even though we're growing extremely fast, we maintain a casual, exciting work environment. We hire top performers and allow you the autonomy to deliver results. Our award winning workplace fosters learning, creativity, teamwork and diversity.

• 2022 Snowflake Partner of the Year
• 2022 Best Places to Work
• Best Places to Work (2017, 2018, 2019, 2020, 2021)
• Inc. 5000 Fastest Growing US Companies (2019, 2020, 2021)
• Minneapolis/St. Paul Business Journal’s Fast 50 (2021)
• Snowflake Elite, Snowpark Accelerated & Snowflake Partner of the Year (2020 & 2021)

Fueled by talented Data Scientists, Engineers, Architects, and innovative thought leaders, phData is shaping the future of data. We're looking for Solutions Architects to join our Elastic Platform Operations team to serve as hands-on technical leaders to help customers operate and manage their next generation cloud data platforms.

Responsibilities:

• Operate and manage modern data platforms - from streaming, to data lakes, to analytics, and beyond across a progressively evolving technical stack.
• Demonstrate clear ownership of multiple simultaneous customer accounts across a variety of technical stacks and act as a technical leader. 
• Proactively identify and articulate best practices and improvements to customers on how to best leverage their Cloud Data Platform. 
• Skillfully navigate complex customer environments and build Epics, Stories, and Tasks in order to mature and improve our customer’s data platform.  Delegate to and coach Engineers and ensure successful and timely delivery of these Epics.
• Provide thought leadership by recommending the right technologies and approaches to maturing and solving problems to help ensure performance, security, scalability, and user satisfaction.
• Continually hunt for ways to automate and optimize existing processes.

Required Experience:

• Strong communication skills in English
• Strong working knowledge of SQL and the ability to write, debug, and optimize SQL queries
• Extensive experience in providing architectural guidance and operational support across a large user base for a cloud-native data warehouse (Snowflake and/or Redshift)
• Expertise with cloud-native data technologies in AWS or Azure
• Production support experience in large enterprise environment supporting cloud data platforms and a variety of cloud data technologies (AWS Services/S3, Aurora Athena Redshift, Sagemaker, Azure DevOps/SQL, Azure Data Factory, etc.....
• Proven experience learning new technology stacks and training team members
• Professional track record of creating, challenging, and improving processes and procedures
• Strong troubleshooting and performance tuning skills including database administration
• Create and deliver detailed presentations
• Client-facing written and verbal communication skills and experience

Preferred Experience: 

• Production / database administration experience and certifications in core data platforms such as Snowflake, AWS, Azure, GCP, Hadoop, or Databricks
• Production experience working with Cloud and Distributed Data Storage technologies such as S3, ADLS, HDFS, GCS, Kudu, ElasticSearch/Solr, Cassandra or other NoSQL storage systems
• Production experience working with Data integration technologies such as Spark, Kafka, event/streaming, Streamsets, Matillion, Fivetran, HVR, NiFi, AWS Data Migration Services, Azure DataFactory Google DataProc or others
• Production experience working with Workflow Management and Orchestration such as Airflow, AWS Managed Airflow, Luigi, NiFi
• Working experience with infrastructure as code using Terraform or Cloud Formation
• Strong expertise of scripting language to automate repetitive tasks (preferred Python)
• Well versed with continuous integration and deployment frameworks with hands-on experience using CI/CD tools like Bitbucket, Github, Flyway, Liquibase
• Experience as a technical team lead
• Bachelor's degree in Computer Science or a related field 

Ideal opportunity if you enjoy…

• Seeing the big picture. You recognize that data challenges are multifaceted, and you understand the technical, business, operational, and human issues at play. 
• Fast-paced operations work. You get energized by working across multiple projects and customers at once as requirements and situations evolve. 
• Solving complex problems. You’re eager to take on big issues that have stumped some of the world’s biggest companies. 
• Venturing boldly into uncharted territory. When facing a problem you haven’t seen before, you enjoy the challenge of navigating through rocky terrain to build an ideal solution. 
• Working across technology stacks and organizational silos. You’ve seen what happens when people get stuck in one platform, application, or way of thinking. You can integrate disparate functions and technologies to make your solutions work.    
• Thinking on your feet. You don’t get rattled by the unexpected. You quickly assess the situation and formulate a plan of action.
• Following up and following through. Not only can you envision the solution, you can break it into actionable steps and keep pushing toward the final outcome, no matter what gets in the way. 
• Managing the human side. You’ve got the presence and poise to work confidently and respectfully with your teammates, your customers, and more—even when it’s time for difficult conversations.
• Collaborating with others. Being yourself. You value an environment where it’s safe to ask questions, take calculated risks, and be authentic. You support your teammates and expect others to do the same. 

Why phData? We offer:

• Remote-First Work Environment - Work 100% Remote
• Casual, award-winning small-business work environment
• Collaborative culture that prizes autonomy, creativity, and transparency
• Competitive comp, excellent benefits, generous PTO plan plus 10 Holidays (and other cool perks)
• Accelerated learning and professional development through advanced training and certifications

#LI-DNI