Associate Technical Lead at Integrate | Torre

Associate Technical Lead

You'll architect robust data pipelines, driving B2B marketing success and revenue generation.
Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time

Legal agreement: Employment

Provide your expected compensation while applying
location_on
Remote (for India residents)
Match
skeleton-gauges
You have opted out of job matches in .
To undo this, go to the 'Skills and Interests' section of your preferences.
Review preferences
Posted 5 months ago

Requirements and responsibilities


About IntegrateIntegrate is a leading B2B SaaS platform that helps enterprise marketing teams drive pipeline and revenue by generating and governing high-quality, compliant leads across channelsSnowflake DevelopmentDesign, develop, and maintain SQL-based ETL pipelines in SnowflakeCreate and manage Snowpipes for real-time data ingestion from AWS S3Build and orchestrate Snowflake Tasks for data processing workflowsDevelop and optimize data models, including dimensional models and rollup tables for BI consumptionManage multiple Snowflake databases, schemas, and warehouses across different environments (staging, production)Optimize Snowflake queries and data warehouse performance for cost and efficiencyImplement data quality checks and monitoring within Snowflake pipelinesMaintain documentation for data dictionaries and pipeline workflowsData Integration & InfrastructureIntegrate AWS services (S3, SNS, Event Notifications) with Snowflake for automated data ingestionBuild and maintain Kafka consumers for real-time streaming data processingDevelop data pipelines that handle multiple data sources and formats (JSON, CSV, Parquet)Implement data deduplication, flattening, and transformation logicEnsure data pipeline reliability, error handling, and recovery mechanismsCollaborate with cross-functional teams to understand data requirementsSoftware DevelopmentDevelop and maintain .NET/C# services that interact with Snowflake using Snowflake.Data clientWork with version control (Git) and follow software development best practicesParticipate in code reviews and contribute to improving code qualityWrite clear documentation and maintain technical documentation for data pipelineBasic Qualifications6+ years of hands-on experienceTechnical SkillsSnowflakeSnowflake SQL and advanced query optimizationSnowpipes for automated data ingestionTasks for workflow orchestrationSnowflake Stages, File Formats, and data loading best practicesData modeling (dimensional modeling, star/snowflake schemas)Snowflake warehouses and compute optimizationProgramming LanguagesStrong proficiency in Python (pandas, numpy, pyspark)SQL expertise (advanced queries, window functions, CTEs)Cloud & InfrastructureExperience with AWS (S3, SNS, IAM, Event Notifications)Understanding of cloud data architecture patternsData TechnologiesExperience with Kafka or other streaming platformsKnowledge of data warehousing concepts and best practicesUnderstanding of ETL/ELT patternsSoft SkillsStrong problem-solving and analytical thinkingExcellent communication skills for collaborating with stakeholdersAttention to detail and commitment to data qualityAbility to work independently and as part of a teamProactive approach to identifying and solving issuesExperience with PySpark for large-scale data processingKnowledge of Salesforce, Jira, or other SaaS platform APIsExperience with BI tools (Looker, Tableau, Power BI)Understanding of data governance and data quality frameworksExperience working in agile development environmentsExperience with .NET/C#
Optionally, you can add more information later (benefits, pre-screening questions, etc.)
check_circle

Payment confirmed

A member of the Torre team will contact you shortly

In the meantime, continue adding information to your job opening.