Job Summary:
Intellisoft Technologies is seeking a highly skilled Data Engineer with extensive experience in Fivetran. This role is critical to ensuring seamless data integration and enabling scalable analytics across the organization.
Responsibilities:
โข Design and Build Data Pipelines: Develop and configure end-to-end data pipelines using Fivetran, ensuring efficient extraction, transformation, and loading (ETL) processes.
โข Integration Setup: Connect multiple data sources (APIs, SaaS platforms, databases) to Fivetran and manage schema mapping and transformations.
โข Data Modeling: Collaborate with analytics and BI teams to design optimized data models for reporting and analysis.
โข Performance Optimization: Monitor pipeline performance, troubleshoot issues, and implement improvements for scalability and reliability.
โข Automation & Documentation: Automate workflows and maintain clear documentation for all data processes.
โข Security & Compliance: Ensure data integrity, security, and compliance with organizational and regulatory standards.
Qualifications:
Required:
โข Proven experience with Fivetran (pipeline setup, connectors, transformations).
โข Strong knowledge of SQL and relational databases.
โข Familiarity with cloud data warehouses (Snowflake, BigQuery, Redshift).
โข Experience building ETL/ELT pipelines from scratch.
โข Understanding of data modeling and schema design.
โข Proficiency in Python or other scripting languages for data manipulation.
โข Knowledge of API integrations and RESTful services.
โข Strong problem-solving and analytical skills.
โข Excellent communication and collaboration abilities.
โข Ability to work in a fast-paced, dynamic environment.
Preferred:
โข Experience with dbt for transformations.
โข Background in data governance and observability tools.
โข Exposure to modern data stack technologies.
Company:
Intellisoft Technologies is an information technology company offering big data and clouding solutions. Founded in 1997, the company is headquartered in Irving, USA, with a team of 201-500 employees. The company is currently Growth Stage.