Principal Consulting Architect

Summary

Join Dremio as a Principal Consulting Architect to help customers quickly realize the value of the Dremio platform. You will provide hands-on assistance with installation, configuration, and optimization, collaborate with customer IT and data engineers, develop custom integrations, and deliver training. Leverage your extensive technical expertise in Dremio and the data/analytics ecosystem, along with excellent communication skills, to guide customers in maintaining reliable Dremio clusters and building successful solutions. You will actively participate in the customer's development process, offering architectural guidance and conducting regular reviews. Identify opportunities for additional services or license purchases and collaborate with other Dremio teams to ensure customer success. This role requires deep technical skills and strong communication abilities to work effectively with various stakeholders.

Requirements

• 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%

Responsibilities

• 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

Preferred Qualifications

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

Benefits

• 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