Principal Consulting Architect - US

About the role

As a Principal Consulting Architect, your mission is to do what it takes to help our customers rapidly obtain value from the Dremio platform after the sale.  This can include hands-on work to install, size, and tune the software, work with customer’s IT and Data Engineers to connect Dremio to customers’ data sources, create custom integrations and product extensions when needed, and perform training to Customers’ IT, data engineers, data scientists, and end users on how to best use Dremio for their unique workflows.

Drawing on your deep technical expertise of Dremio and the data/analytics ecosystem, as well as exceptional communication skills, you will listen, advise, and enable your assigned customers in maintaining a reliable Dremio cluster and facilitating their successful development of Dremio solutions through exceptional high-touch interactions with the customer developers and administrators.

What you’ll be doing

• Application Architecture: tailor reference architectures to provide performance, resilient, scalable, secure, distributed architectures which can exceed SLAs and are easily maintained.
• Data Modeling: design and test data models which are pragmatic, performant, and scalable.
• Application Implementation: show the customer how to write robust and scalable data access code that correctly utilizes drivers.
• Infrastructure: help the customer select on-premise hardware or cloud instance types based on workload and capacity assessments.
• Production Operations: help the customer deploy, configure, secure, maintain, monitor, scale, troubleshoot, test and tune Enterprise clusters.
• Instructive Consulting: in response to customer questions, provide ad-hoc instruction that is shaped by the customer’s specific environment, requirements and constraints.
• Steer conversations architecturally by embedding yourself into the customer account to avoid pitfalls and keep the customer on track to deliver solutions according to prescribed best practices. This will require you to have up-to-date knowledge of the customer’s internal roadmap for Dremio and will include hosting regular office hours sessions and performing technical reviews, PRD reviews, environment reviews, script reviews as the roadmap executes and evolves.
• Identifying Needs: bring in the sales team when the customer will benefit from a services or license purchase / expansion.
• A Team Effort: collaborate with other roles in Dremio Technical Support, Pre-Sales, Sales, etc. to ensure our customer is successful.

What we’re looking for

• 10+ years experience providing trusted advisor-level service in a Professional Services capacity
• Lifetime learner, self-motivated with the ability to multi-task during high-pressure situations
• In-depth, current, hands-on knowledge of ANSI SQL, particularly advanced SQL techniques used in analytic contexts, is a must.
• Data architecture, data modeling, warehousing concepts.  Deep understanding of data architectures that support reporting and analytics use cases.
• Performance techniques for accelerating Reporting / Dashboarding use cases (OLAP, Materialized Views, etc)
• Docker and Kubernetes configuration and troubleshooting, including Helm charts, storage options, logging, and basic kubectl CLI (AKS / EKS / OpenShift)
• Authentication and security configuration and tuning (LDAP, Kerberos, SSL/TLS, second priority: SSO/OAuth/OIDC, Ranger/Sentry)
• Python scripting and interactions with REST APIs
• Linux, including application installation, scripting, basic command line
• Experience with ETL concepts, techniques, pipelines, tools, challenges
• Cloud technologies (AWS/Azure/GCP)
• Cloud performance considerations
• Hive / Trino / Spark / etc
• Excellent written and verbal communication skills
• Ability to present on technical topics to various levels within the enterprise
• Ability to travel up to 30%

 Bonus points if you have

• dbt experience
• BI Tool experience (Power BI / Tableau etc)

What we offer

• Medical, dental and vision insurance 
• 401(k) Plan
• Short term / long term disability and life insurance
• Pre-IPO stock options
• Flexible PTO
• 16 hours of volunteer time off
• 12 company paid holidays, including Juneteenth
• Remote work options
• Monthly “Get Stuff Done” (GSD) Days
• Paid parental leave
• Employee Assistance Program (EAP)
• Quarterly swag surprise

**Certain benefits are only allowed to full-time Dremio employees and may not be the same across all locations.

#LI-remote #LI-EH1