Data Integration Specialist
1 day ago
New York
Role: FiveTran Administrator / Data Integration Engineer Location: Lebanon, NJ – 08833 or New York, NY - 10010 Duration: Permanent/Full Time (FTE) Note: “This job requires working onsite in the office five days a week”. Required Qualifications: • 5–7 years of experience working with enterprise data platforms and data integration tools, • Hands-on experience administering Fivetran in a production enterprise environment, • Strong experience with cloud data platforms such as:, • Databricks, • Amazon Redshift, • Experience integrating with SaaS systems (Salesforce, Workday, SAP, NetSuite, etc.), • Strong SQL skills and understanding of data warehousing concepts, • Experience with cloud platforms (AWS/Azure/GCP), • Understanding of data governance, access control, and compliance frameworks, • Experience handling service requests and managing ingestion SLAs Preferred Qualifications: • Experience with dbt, Airflow, or other orchestration tools, • Exposure to data quality tools and observability platforms, • Experience building reusable ingestion frameworks or data onboarding accelerators, • Knowledge of DevOps/CI-CD practices for data pipelines, • Experience supporting AI/ML and advanced analytics use cases Key Competencies: • Strong problem-solving and troubleshooting skills, • Excellent stakeholder communication, • Process-oriented with strong documentation skills, • Enterprise mindset with focus on scalability and governance Roles & Responsibilities: FiveTran Administration & Connector Management: • Configure, deploy, and manage Fivetran connectors across diverse source systems (ERP, CRM, SaaS, databases, APIs, flat files, etc.), • Establish and maintain connectors to ensure reliable and timely ingestion into Databricks, Redshift, and other enterprise data platforms, • Monitor connector health, sync performance, and data freshness SLAs, • Troubleshoot ingestion failures and proactively resolve data sync issues Enterprise Data Ingestion & Operations: • Ensure all service requests for business data ingestion are fulfilled within defined SLAs, • Validate data integrity, completeness, and reconciliation post-ingestion, • Coordinate with data engineering, analytics, and business teams to onboard new data sources, • Optimize ingestion pipelines for performance and cost efficiency Self-Service Ingestion Framework: • Design and implement a scalable self-service data ingestion framework using Fivetran, • Establish standardized onboarding templates, governance controls, and automation processes, • Develop documentation and enablement materials for business and analytics users, • Implement access controls, RBAC, and data governance best practices Data Platform Integration: • Work closely with Databricks and Redshift teams to ensure proper schema management and data modeling alignment, • Support downstream transformations (dbt/Spark/SQL pipelines), • Collaborate on data quality monitoring and observability frameworks Governance, Security & Compliance: • Ensure data ingestion adheres to enterprise security standards and compliance pol icies, • Implement encryption, credential management, and secure connectivity best practices, • Maintain audit trails and operational documentation