Solution Consultant - Professional Services at FIVETRAN

Posted on: 05/26/2022

Location: (ON-SITE)

full time

Original Source

Tags: gcp azure s3 sql python oracle kafka apache unix aws

From Fivetran’s founding until now, our mission has remained the same: to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonical and ready to query, with no engineering or maintenance required. We’re proud that more organizations continue to leverage our technology every day to become truly data-driven. The Professional Services team at Fivetran is growing and you have the opportunity to join a function that is building from the ground up. The approaches, methodologies, working practices and team culture that we put in place now will be the template for what is to come, so if you are excited about having a hand in steering the approach of a critical function within the organisation then this may be the role for you! **About the Role** Fivetran High Volume data replication connectors have been implemented across many of the world's largest enterprises. As an HVR Consultant in the Professional Services team at Fivetran, you will be responsible for facilitating the installation, configuration and ongoing maintenance of Fivetran’s High Volume connectors through your expertise in a variety of databases and operating systems and your past experience in the data integration and replication industry. Working directly with customer stakeholders, you will define requirements and work to facilitate an architecture and integration that fulfills those requirements. Along the way, you will facilitate the optimisation of the implementation through performance tuning, offer best-practice advice on source and target setup & use your analytical skills to technically troubleshoot issues. In a small percentage of cases, you will be provided with access to the customers’ environment in order to install and configure certain components of the HVR architecture. To this end, you will have experience of working both with the CLI and interfaces to facilitate the optimal implementation of software applications. An essential part of the role of the Solutions Consultant will be enabling customers to take responsibility for the installation once it has been tested and is ready for deployment into a Production environment. To this end, you should feel comfortable in producing enablement collateral and training teams to adopt what may be a new software application. Finally, you will not be working alone; your role will encompass interactions not only with customer stakeholders but also with a wide range of internal stakeholders, including Account Executives, Customer Success Managers, Solution Architects, Customer Support Engineers, Product Managers and Software Engineers. Therefore, you’ll be comfortable liaising with both technical and non-technical stakeholders triaging on a wide range of **Technologies You’ll Use** * Fivetran * HVR * OnPremise and cloud databases, including:: + SAP HANA + Oracle + Microsoft SQL Server + IBM db2 * OnPremise and cloud data warehouses, including:: + Snowflake + BigQuery + Redshift * Operating systems, including: + Windows + Linux + Unix * AWS, GCP or Azure environments and services * git **What You’ll Do** * Provide best-practice consultancy to enable the design, implementation and launch of Fivetran’s High Volume connectors (Fivetran HVA & HVR); this consultancy will cover: + Working with customers to understand their current architecture + Designing a future-state solution that is optimized for their use-cases + Providing steps to preparing environments for replication, including best-practice approaches to installation and configuration of HVR components and customer-owned systems * Get hands-on with installation of Fivetran’s High Volume connectors (Fivetran HVA & HVR), which will include: + Preparing environments for replication, which may involve SQL scripting or command-line operations to enable full transaction logging, archiving/backup and table analysis/preparation + Configuring Fivetran High Volume connectors through a mix of UIs and command-line operations * Work with customer teams to troubleshoot and resolve issues during implementation, which will include: + Data validation + Performance analysis + Database and environment tuning * Enable customer teams to adopt and take ownership of Fivetran’s High Volume connectors through training and documentation **Skills We’re Looking For** * A breadth of experience in the data integration and data replication space * Experience in a broad range of database, data warehouse and operating systems * DBA/database administration experience * Advanced SQL knowledge * Advanced command-line knowledge, including scripting with the command-line * Advanced knowledge of networking approaches, including SSH tunneling and VPNs * Advanced logical and analytical abilities to help solve problems and provide optimisations to databases, data warehouses, environments & networking approaches * Excellent verbal and written communication skills and an ability to effectively collaborate with customers and cross-functional internal stakeholders * Resourceful, self-motivated and able to successfully complete multiple competing projects under tight deadlines for a range of customers * Strong prioritization and organizational skills * DBA **Nice-to-Haves** * Experience with data streaming services such as Apache Kafka * Experience with data lakes such as Amazon S3, Google Cloud Storage and Microsoft ADLS2 * Knowledge of mainframe systems such as IBM iSeries * Experience with a non-CLI scripting language such as Python We’re honored to be [valued at over $5.6 billion](https://fivetran.com/blog/hvr-acquisition-series-d), but more importantly, we’re proud of our [core values of Get Stuck In, Do the Right Thing, and One Team, One Dream](https://fivetran.com/culture). To learn more about Fivetran’s culture and what it’s like to be part of the team, [click here](https://www.youtube.com/watch?v=YTDAsvIYOkw) and enjoy our video. To learn more about our candidate privacy policy, you can [read our statement here](https://fivetran.com/candidate-privacy).