Enterprise Integrations Analyst*

Description

We are seeking a hands-on Senior Snowflake / Data Engineer with deep expertise in building scalable, reliable, and high-performance data platforms using Snowflake and AWS.The ideal candidate has strong experience designing production-grade data pipelines, developing complex transformations, modeling enterprise data, optimizing Snowflake workloads, and integrating data from systems such as Salesforce, APIs, SaaS platforms, and AWS services.This role will be responsible for building the data foundation that powers analytics, operational workflows, enterprise integrations, reporting, and AI applications.

What You'll Do

Snowflake Engineering

• Design, build, and maintain scalable data solutions on Snowflake

• Develop databases, schemas, tables, views, secure views, stages, and other Snowflake objects

• Build production-grade SQL and Snowpark-based transformations

• Implement Snowflake Streams, Tasks, Dynamic Tables, Snowpipe, and related capabilities

• Design incremental processing and change-data-capture patterns

• Optimize Snowflake queries, warehouses, clustering strategies, and storage patterns

• Monitor and optimize Snowflake compute consumption and platform costs

• Implement secure data-sharing and access patterns

Data Pipeline Development

• Build robust ETL/ELT pipelines for structured and semi-structured data

• Develop batch, incremental, near-real-time, and event-driven ingestion pipelines

• Integrate data from Salesforce, REST APIs, SaaS applications, AWS, databases, and file-based sources

• Implement reusable ingestion and transformation frameworks

• Build pipelines capable of handling schema evolution, late-arriving data, retries, and replay

• Develop reconciliation processes to ensure source-to-target completeness and accuracy

• Build orchestration workflows with appropriate dependency and failure management

Data Modeling

• Design scalable analytical and operational data models

• Build dimensional models, fact and dimension tables, data marts, and curated datasets

• Translate complex source-system structures into standardized enterprise data models

• Establish consistent definitions for core business entities and metrics

• Design data layers that support analytics, reporting, operational applications, and AI workloads

• Balance performance, usability, maintainability, and storage efficiency in data-model design

Salesforce Data Integration

• Build reliable pipelines ingesting Salesforce objects and related data into Snowflake

• Work with Salesforce APIs, Bulk API, Change Data Capture, and Platform Events where appropriate

• Handle Salesforce relationships, custom objects, schema changes, and large-volume datasets

• Build incremental and CDC-based synchronization patterns

• Implement reconciliation and data-quality controls between Salesforce and Snowflake

AWS Integration

• Build data pipelines using AWS services such as S3, Lambda, SQS, SNS, EventBridge, and related technologies

• Design secure data movement between AWS and Snowflake

• Build event-driven ingestion and processing workflows

• Manage file-based ingestion, staging, and archival patterns

• Implement appropriate IAM, encryption, secrets management, and access controls

Data Quality & Observability

• Implement automated data-quality validation and testing

• Build monitoring for pipeline freshness, completeness, accuracy, and failures

• Implement logging, metrics, alerts, and operational dashboards

• Establish source-to-target reconciliation processes

• Investigate and resolve production data incidents

• Identify upstream and downstream impacts of data changes

Performance & Cost Optimization

• Analyze query profiles and optimize expensive Snowflake workloads

• Optimize warehouse sizing, auto-suspend, auto-resume, and workload isolation

• Improve SQL performance and data-processing efficiency

• Monitor storage and compute consumption

• Identify opportunities to reduce pipeline runtime and infrastructure cost

Engineering Excellence

• Write clean, reusable, testable, and maintainable code

• Participate in architecture and code reviews

• Build automated testing into data pipelines

• Maintain technical documentation, data mappings, and runbooks

• Contribute to CI/CD and automated deployment practices

• Mentor other Data Engineers and help establish engineering standards

What You'll Bring

• 5+ years of data engineering experience
• 3+ years of strong hands-on Snowflake experience
• Advanced SQL skills, including complex transformations and query optimization
• Strong Python skills for data processing, automation, and API integrations
• Experience building production-grade ETL/ELT pipelines
• Experience integrating Snowflake with AWS
• Experience ingesting data from Salesforce or similar enterprise SaaS platforms
• Strong understanding of dimensional modeling and modern data architecture
• Experience with incremental processing, CDC, and data reconciliation
• Experience implementing data-quality and monitoring frameworks
• Experience with Git, CI/CD, and software engineering best practices

Nice-to-Have

• Experience with Snowpark
• Experience with Snowflake Cortex
• Experience with Streams, Tasks, Dynamic Tables, Snowpipe, and secure data sharing
• Experience with Salesforce Bulk API, CDC, and Platform Events
• Experience with AWS Lambda, S3, SQS, SNS, EventBridge, and Glue
• Experience with dbt or similar transformation frameworks
• Experience with Airflow, Dagster, Prefect, or similar orchestration platforms
• Experience with Terraform or infrastructure-as-code
• Experience supporting AI/ML and RAG workloads from Snowflake
• Snowflake certifications are a plus

What We Offer

• Enjoy flexible paid time off options for enhanced work-life balance.
• Comprehensive health insurance tailored for you.
• Employee assistance programs cover mental health, legal, financial, wellness, and behaviour areas to ensure your overall well-being.
• Complimentary CalmApp subscription for you and your loved ones, because mental wellness matters.
• Energetic work environment with a hybrid work style, providing the balance you need.
• Benefit from our family leave program, which grows with your tenure at Meltwater.
• Thrive within our inclusive community and seize ongoing professional development opportunities to elevate your career.

About Meltwater

At Meltwater, we believe that when you have the right people in the right environment, great things happen. Our best-in-class technology empowers our 27,000 customers around the world to make better business decisions through data. But we can’t do that without our global team of developers, innovators, problem-solvers, and high-performers who embrace challenges and find new solutions for our customers.Our award-winning global culture drives everything we do and creates an environment where our employees can make an impact, learn every day, feel a sense of belonging, and celebrate each other’s successes along the way. We are innovators at the core who see the potential in people, ideas and technologies. Together, we challenge ourselves to go big, be bold, and build best-in-class solutions for our customers.We’re proud of our diverse team of 2,200+ employees in 50 locations across 25 countries around the world. No matter where you are, you’ll work with people who care about your success and get the support you need to unlock new heights in your career.

We are Meltwater. Inspired by innovation, powered by people.

Where You'll Work: Hyderabad

Equal Opportunity Employer

Meltwater is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind: At Meltwater, we are dedicated to fostering an inclusive and diverse workplace where every employee feels valued, respected, and empowered. We are committed to the principle of equal employment opportunity and strive to provide a work environment that is free from discrimination and harassment. All employment decisions at Meltwater are made based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, marital status, veteran status, or any other status protected by the applicable laws and regulations. Meltwater does not tolerate discrimination or harassment of any kind, and we actively promote a culture of respect, fairness, and inclusivity. We encourage applicants of all backgrounds, experiences, and abilities to apply and join us in our mission to drive innovation and make a positive impact in the world. We may use AI to assist in aspects of our hiring process, such as reviewing candidate information, capturing interview notes, and supporting interview activities. These tools are used only to assist our team through increased efficiencies. Every output continues to be reviewed by humans, and all hiring decisions are made by humans. We remain committed to evaluating candidates fairly, consistently, and in compliance with all applicable laws