ETL Developer

PB consulting

We are seeking an experienced Snowflake Developer with 7–12 years of experience in data engineering, data warehousing, and cloud data platforms. The ideal candidate will have strong hands-on expertise in Snowflake, SQL, ETL/ELT, data modeling, and cloud-based data solutions, with the ability to design and deliver scalable, high-performance data pipelines.

Required Technical Skills

7–12 years of experience in data engineering, data warehousing, or database development.
Strong hands-on experience with Snowflake data platform and architecture.
Advanced proficiency in SQL and experience developing complex queries, stored procedures, views, and database objects.
Strong experience with ETL/ELT development and data pipeline design.
Experience with Snowflake features including warehouses, databases, schemas, stages, streams, tasks, views, and data sharing.
Strong understanding of data modeling, including dimensional modeling, fact/dimension tables, and schema design.
Experience integrating Snowflake with various source systems, APIs, databases, and cloud storage platforms.
Experience with at least one cloud platform, preferably AWS, Azure, or GCP.
Strong knowledge of data performance tuning, query optimization, and warehouse optimization.
Experience with data quality, validation, security, access controls, and governance.
Proficiency with Git and exposure to CI/CD and automated deployment processes.

Roles & Responsibilities

Design, develop, and maintain scalable Snowflake data solutions.
Develop efficient SQL queries, stored procedures, views, and data transformation logic.
Build and maintain reliable ETL/ELT pipelines for batch and real-time data processing.
Develop data models to support analytics, reporting, and business intelligence requirements.
Optimize Snowflake queries, warehouses, storage, and workloads for performance and cost efficiency.
Implement Snowflake Streams and Tasks for incremental and automated data processing.
Integrate Snowflake with enterprise data sources, cloud storage, and downstream applications.
Implement data quality checks, validation processes, and error-handling mechanisms.
Support data security, governance, access management, and compliance requirements.
Troubleshoot data pipeline, SQL, performance, and production issues.
Participate in technical design discussions, code reviews, and architecture decisions.
Develop and maintain technical documentation and data process specifications.
Collaborate with Data Engineers, Data Architects, BI Developers, Data Scientists, and business stakeholders.
Support CI/CD, automated testing, and deployment of Snowflake objects and data pipelines.

Apply

Vacancy posted 2 days ago

Similar jobs that could be interesting for youBased on the ETL Developer in Charlestown, MA vacancy

Front-Office Software Technical Trading Engineers AVP (API, ETL, Java, C#), AVP - Charles River Development
$100k - $167.5k
...technical role and spans XML messaging, Charles River web services API, ETL tool usage, Java and/or C# programming, and database... ...technical initiatives, potentially on multiple tasks simultaneously.Develop with a result-driven approach while maintaining tight schedules....
Suggested
Full time
Temporary work
Work at office
Remote work
Flexible hours
State Street Bank
Boston, MA
3 days ago
Snowflake Python ETL Engineer Data Pipelines & Cloud
Ellenco Estágios e Treinamentos is seeking a Snowflake Python ETL Engineer in Boston, MA for a long-term contract. You design, develop, and maintain scalable data pipelines that load data into Snowflake, collaborating with data engineers, analysts, and business stakeholders...
Suggested
Long term contract
Ellenco Estágios e Treinamentos
Boston, MA
6 days ago
Snowflake python ETL engineer
...Job Details Job Title: Snowflake Python ETL Engineer Location: Boston, MA (Hybrid 3 days onsite 2 days remote per week Duration... ...Snowflake Python ETL Engineer is responsible for designing, developing, and maintaining scalable data pipelines that ingest, transform...
Suggested
Long term contract
Remote work
2 days per week
3 days per week
Cloud Analytics Technologies LLC
Boston, MA
4 days ago
Senior Backend Data Engineer - AWS ETL & Pipelines
...supporting accounting data flows and understanding AWS tools, such as Glue and Lambda. Ideal candidates will have a strong expertise in ETL processes and distributed systems. This contract position offers a chance to contribute significantly in a vibrant IT environment. #J...
Suggested
Contract work
TekValue IT Solutions
Boston, MA
3 days ago
Cloud Data Lake Engineer ETL, Spark & AWS Leader
...data frameworks, ensuring data integrity, scalability, and security in cloud environments. Responsibilities include data lake design, ETL/ELT workflows, and building scalable pipelines using Spark, PySpark, Python, and AWS services. Collaboration with data science,...
Suggested
State Street Corporation
Boston, MA
1 day ago
Senior BI & Data Warehouse Engineer (ETL, Hadoop)
Altorel LLC in Boston is looking for a Data Warehouse Developer/Analyst with expertise in Microsoft BI Stack and substantial data warehousing... ...across business units to develop and enhance data warehouse ETL processes, automate data requests, and improve analytics capabilities...
Altorel LLC
Boston, MA
6 days ago
Senior ETL Developer
...MANAGER NOTES CHPW is seeking a Senior Snowflake ETL Developer to join an enterprise data warehouse modernization initiative focused on migrating legacy SQL Server/SSIS solutions into Snowflake. This is a hands-on development role working on SQL refactoring, ETL pipeline...
Live in
Remote work
Ellenco Estágios e Treinamentos
Boston, MA
1 day ago
ETL Developer
...Title- ETL Developer who is ok doing tickets and production support Duratin-6-12+++ Months Must have P&C and or Reinsurance and Guidewire Hybrid onsite locations below BACKFILL - Hybrid 3 Days onsite: Boston, MA; Charlotte, NC; Colorado Springs,...
RIT Solutions, Inc.
Boston, MA
5 days ago
ETL Developer
...ETL Developer Duration: 6-12 Months Must have P&C and or Reinsurance and Guidewire Hybrid onsite locations below: Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville...
RIT Solutions
Boston, MA
2 days ago
Senior ETL Developer
...We are seeking an experienced ETL Developer with strong expertise in SQL Server, SSIS, Azure Data Factory, data warehousing, data modeling, and BI reporting. The role will focus on developing and maintaining scalable data integration, transformation, and reporting solutions...
2T Consulting
Revere, MA
3 days ago
IoT Data Platform Engineer ETL & ML Readiness
A fast-growing technology firm based in Boston is seeking a Sr. Data Engineer to revolutionize data flows and analytics. Ideal candidates will have extensive experience with Snowflake and SQL, alongside a collaborative mindset to work closely with various teams. This role...
Digi Axess
Boston, MA
2 days ago
Data Management Solutions Engineer - ETL & Identity
...Engineer to join the Data Management team in Massachusetts. You will help implement the Redpoint Customer Engagement Hub (CEH), focusing on ETL, data hygiene, and identity resolution within RPDM, with growth into a SME across the Marketing/Campaign product suite. The role...
Redpoint Global Inc.
Wellesley, MA
3 days ago
(Junior Senior) Software Engineer - Backend/Platform
$90k - $125k
...depend on experience. What You Will Do Build & Ship APIs: Develop and maintain backend APIs and services that power our core... ...Experience with AWS and/or Azure Understanding of data pipelines (ETL; Spark/Databricks is a plus) Experience with Infrastructure as...
Full time
Local area
Flexible hours
Laminar
Somerville, MA
1 day ago
Lead Oracle Engineer
$130k - $200k
...the platforms the firm depends on.Key Responsibilities:Design, develop, and maintain advanced Oracle APEX applications supporting Finance... ..., and long-term maintainability.Maintain and enhance ETL and data pipelines processes that support APEX application, reporting...
Full time
Shift work
Houlihan Lokey
Boston, MA
5 days ago
Security Data Solutions Engineer
$120k - $202.5k
...Infrastructure Teams, and Enterprise Continuity Services, this team develops advanced data platforms, intelligent automation solutions, and... ...& Strong understanding of data engineering concepts including ETL/ELT, streaming pipelines, data lakes, data warehouses, and data...
Full time
Temporary work
Work at office
Local area
Flexible hours
Shift work
2 days per week
State Street Bank
Boston, MA
2 days ago
Oracle APEX Developer
...Position: Oracle APEX Developer Location : Boston, MA (Onsite) Client: Scalexm/State Street Job Summary: The Oracle APEX Developer... ...with data integration and data warehouse concepts, especially ETL processes and reporting. • Technical Skills: oProficiency...
Info Way Solutions
Boston, MA
3 days ago
SQl Developer
...dashboards with pythonExtracting and Loading Data using API'sBuilding ETL processesMust Haves10-15 years of SQL development... ...(e.g., SQL Server databases, web services, flat files).Design, develop and support new/existing data martsTroubleshooting of existing BI...
Remote work
Relocation
RIT Solutions
Boston, MA
4 days ago
Data Analyst/ETL Developer
We are seeking an ETL Developer/Business Liaison. In this role, you will enable digital transformation for our partners in a global delivery model, research on technologies independently, recommend appropriate solutions and give technology-specific best practices and standards...
Work at office
2 days per week
3 days per week
Base One Technologies
Boston, MA
4 days ago
Engineering Manager, Platform
...this position. How You'll Make a Difference: Lead and develop a team of 3–5 engineers spanning data platform, analytics engineering... ...(REST, GraphQL, event streaming), system integrations (ETL/ELT, ERP/CRM connectors, webhooks), or analytics engineering....
Worldwide
Visa sponsorship
ABCorp
Boston, MA
2 days ago
Salesforce Financial Services Cloud Solution Architect
...globally and in North America, we are committed to growing and developing our Salesforce talent, offering continued growth opportunities,... ...integration architecture as well as third-party integration tools and ETL (Such as Mulesoft, Informatica, Jitterbit etc. ) with [8]...
Temporary work
Local area
Slalom
Boston, MA
3 days ago
Senior Software Engineer, Robotics Data Foundation (Cloud)
$220k - $292k
...locations can understand their systems in real-time. Build and develop cloud-native systems that are also edge-compatible: While we... ...Experience with modern lakehouse architectures (Iceberg, Delta Lake), ETL systems (Flyte, Dagster, Airflow, Argo Workflows), and...
Full time
Work experience placement
Immediate start
Anduril
Boston, MA
1 day ago
Senior .NET Developer
...Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.·Proven, hands-on experience developing in a highly scalable database environment (DB2, Oracle and SQL Server)·Proven, hands-on...
Remote work
Samprasoft
Boston, MA
4 days ago
ASP.NET Developer 2 Spots
...skills.Responsibilities:Work on an engineering team to design and develop applications to support the business unitsAssume responsibility... ...environments, ideally SQL ServerStrong experience with classic ETL tools and techniques requiredMust be detail oriented with outstanding...
Work experience placement
The Ceres Group
Boston, MA
4 days ago
Platform Engineer
...automation skills (i.e., UiPath RPA, Client Power, Airflow) Experience with Message Queue technologies (i.e., Kafka, MQ) Knowledge of ETL processes (i.e., Glide) Experience with analytics tools (i.e., Dataiku) Data management expertise (i.e., Snowflake, Data...
Work experience placement
Work at office
Immediate start
Artech
Boston, MA
4 days ago
Sr. Platform Engineer
.... Kubernetes, Redhat OpenShift) o Automation (i.e. UiPath RPA, Microsoft Power, Airflow) o Message Queue (i.e. Kafka, MQ) o ETL (i.e. Glide) o Analytics (i.e. Dataiku) o Data Management (i.e Snowflake, Data Bricks) • Should have sound knowledge on IT Application...
Work experience placement
Trans.eu
Boston, MA
3 days ago
Senior Platform Engineer
...containerization (i.e. Kubernetes, Redhat OpenShift) Automation (i.e. UiPath RPA, Microsoft Power, Airflow) Message Queue (i.e. Kafka, MQ) ETL (i.e. Glide) Analytics (i.e. Dataiku) Data Management (i.e Snowflake, Data Bricks) Should have sound knowledge on IT...
Work experience placement
Work at office
3 days per week
I-Flow
Boston, MA
2 days ago
Senior Solution Engineer, HCLS
$165k - $216.56k
...experience within large-scale Database and/or Data Warehouse technology, ETL, analytics and cloud technologies. For example, Data Lake, Data... ...on-premises and cloud solutions struggle with this, Snowflake developed an innovative product with a new built-for-the-cloud...
Snowflake
Boston, MA
2 days ago
Senior Application Engineer (Legal Technology)
...Experience working with emerging AI and automation technologiesSolid understanding of application and data integrations, including APIs, ETL, and data pipelinesHands on experience with Microsoft SQL, Linux environments, REST APIs, and PowerShell...
Permanent employment
Remote work
Request Technology
Boston, MA
5 days ago
Principal Cloud Engineer
$150k - $240k
...aggregation, and incident response infrastructure. Support for developer teams. Blameless postmortem culture. Current Tech Stack... ...data infrastructure: Data lake storage architectures, Lakehouse, ETL pipeline infrastructure Cost optimization: resource tagging strategies...
TetraScience
Boston, MA
5 days ago
SQL Server Developer
...SQL Server+ Snowflake+ ETL(Abinitio)Location: Boston (Hybrid 3 days onsite)Rate: DOEJob Description:A bachelor's degree or equivalent... ..., policies and system stewardship principles.Ability to develop support materials for to expand overall knowledge sharing throughout...
Georgia IT Inc
Boston, MA
4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to ETL Developer. Be the first to apply!