Lead Solution Architect – Enterprise
| Company | Fivetran |
|---|---|
| Location | Jackson Township, NJ, USA |
| Salary | $190080 – $237600 |
| Type | Full-Time |
| Degrees | |
| Experience Level | Expert or higher |
Requirements
- At least 10 years of experience in a customer-facing role, focusing on helping customers implement and optimize data integration solutions.
- A strong understanding of data integration and replication, with the ability to explain technical concepts clearly to customers.
- Experience with various databases, data warehouses, and operating systems, enabling support for diverse customer environments.
- Proficiency in SQL and command-line scripting to assist with technical setups and troubleshoot issues.
- Familiarity with networking concepts, including SSH tunneling and VPNs, to assist customers in configuring secure data replication solutions.
- Ability to analyze customer challenges and provide database, data warehouse, and networking optimizations to improve system performance.
- Strong verbal and written communication skills, with the ability to engage with customers, provide clear explanations, and collaborate with internal teams.
- A proactive approach to managing multiple tasks and meeting deadlines while maintaining customer satisfaction.
- Proven ability to prioritize and organize tasks to meet customer needs efficiently.
- Familiarity with scripting languages (e.g., Python) to automate processes or resolve issues.
Responsibilities
- Lead the installation and setup of Fivetran connectors (including application, database, file, and event types) for customers, ensuring environments are prepared for replication.
- Prepare environments for replication, including SQL scripting or command-line operations to ensure proper transaction logging, archiving/backup, and table analysis/preparation.
- Configure high-volume database connectors using user interfaces (UIs) and command-line tools to meet customer requirements.
- Collaborate with customer teams to identify, troubleshoot, and resolve issues during implementation.
- Assist with data validation to ensure accurate data replication.
- Analyze and optimize performance to align with customer expectations.
- Offer database and environment tuning to improve overall efficiency.
- Provide training, documentation, and ongoing support to customer teams, enabling them to manage Fivetran’s LDP connectors and data pipelines independently.
Preferred Qualifications
- Experience with Apache Kafka, New Relic, Salesforce, REST APIs
- Experience with Data Lakes such as Amazon S3, Google Cloud Storage and Microsoft ADLS2
- Knowledge of mainframe systems such as IBM iSeries
- SAP
- Docker or Podman