Lead Integration Engineer (ETL Snowflake)

Waltham, MA, US • Posted 3 hours ago • Updated 3 hours ago

Full Time

On-site

USD $70.00 - 85.00 per hour

Fitment

Dice Job Match Score™

🔗 Matching skills to job...

Job Details

Skills

Mergers and Acquisitions
Data Engineering
Decision-making
Software Development
FOCUS
Data Integration
Legacy Systems
Leadership
Privacy
Regulatory Compliance
Integration Architecture
Scalability
Data Profiling
Distribution
Quality Management
Collaboration
Quality Assurance
Data Management
Data Quality
Analytics
Master Data Management
Continuous Improvement
Supervision
Team Leadership
Database
Snow Flake Schema
Microsoft SQL Server
Oracle
Informatica
ApacheBench
IBM InfoSphere DataStage
Datastage
Communication
Microsoft Excel
PPT
Microsoft Visio
Data Mapping
Modeling
Extract
Transform
Load
ELT
API
Workflow
Continuous Integration
Continuous Delivery
Data Governance
Meta-data Management
Scripting
Cloud Computing
Database Architecture
Real-time
Agile
Lean Methodology
Software Development Methodology
SaaS
Salesforce.com
Esri
TCM
DICE

Summary

JOB TITLE: Lead Integration Engineer (ETL Snowflake)
JOB LOCATION: Waltham, MA (1 day a week onsite)
WAGE RANGE*: $70-85/hr. W2
JOB NUMBER: NGGJP00017056
6+ Month Contract to Start

JOB DESCRIPTION:

Waltham 1 x a week and when asked for meetings

The Lead Integration Engineer is a collaborative, hands-on role on the Digital Platform Data Engineering Team responsible for designing sound, scalable, and performant solutions that meet the requirements in a large data volume enterprise, and leading the team responsible for implementation. Solutions and design trade-offs are communicated to business and technical stakeholders for effective decision making.
The Lead Integration Engineer will work on a major IT initiative to enable *** Business Partners by improving how our employees serve our customers today and by creating the platform for tomorrow's growth.

Key Accountabilities

Perform and collaborate on system designs, data solution development, with a focus on data integration pipelines to/from various platforms and/or legacy systems.
Provide day-to-day supervision and leadership of engineering team(s) responsible for implementation.
Ensure integration solutions adhere to data privacy, security, and compliance standards
Define and maintain integration architecture principles, ensuring scalability, security, and performance across platforms.
Updates to integration process data-mappings and data catalogs
Participate in, and/or lead, design and pre-deployment reviews.
Data profiling
Must be comfortable reading/understanding data models.
Design and development of data synchronization processes
Participate in the design/development of integration solutions.
Assist in determining the cross-application data standards, data distribution standards and promote data-driven design
Create database deliverables ensuring quality and traceability to requirements and adherence to all quality management plans and governance standards
Work with the team to ensure that all components work together to meet objectives and performance goals as defined in the requirements. Identify and communicate any cross-area or cross-release issues that may affect other areas of the project
Participate in go-live preparation activities such as QA, dress rehearsals, issue remediation, cutover and go-live aftercare
Participate in data management maturity assessments to identify gaps and pain points for capabilities including data quality, governance, analytics, metadata management, master data management
Seek opportunities for continuous improvement in processes, procedures and systems with regards to data
Supervisory/Interpersonal

Experience Required:

Good team leadership and influencing skills for colleagues, partners / vendors; project sponsors

Qualifications:

7+ years experience in database development (Snowflake, SQLServer, Oracle, etc)
7 years experience designing, coding, and delivering ETL workflows using Matillion (preferred), Informatica, Ab Inito, or DataStage.
Excellent oral and written communication skills.
MS Office (Word, Excel, PPT, Visio, et al).
Experience in data mapping, modeling and working with teams to define integration pipelines.
Experience in a dynamic work environment
Proven ability to work well in a team environment, and be capable of building and maintaining positive relationships with other staff, departments, and customers
Strong understanding of integration patterns (ETL, ELT, API-led, event-driven).
Experience in optimize integration workflows for throughput, latency, and cost efficiency.
Experience with CI/CD pipelines for integration deployments.
Experience with cloud integration platforms
Knowledge of data governance frameworks and metadata management.
Proficiency in scripting languages.
Experience with cloud database architecture is a plus
Experience with Matillion is a plus
Experience with real-time data loads is a plus
Experience with Agile/Lean software development process and practices is a plus
Experience in with SaaS solutions such as Salesforce, ESRI and Workforce is a plus

Other requirements:

Ability to work with cross-functional teams, subject matter experts, and architects

Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities

* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.

#Dice #IND1

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: cxtcml
Position Id: 26-00379
Posted 3 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Sr. Data Engineer - Snowflake

Waltham, Massachusetts

•

Today

JOB TITLE: Sr Data Engineer JOB LOCATION: Waltham, MA WAGE RANGE*: 70.00-74.00 JOB NUMBER: NGGJP00017052 REQUIRED EXPERIENCE: Snowflake is key 3+ years' experience in database development (Snowflake, SQLServer, Oracle, etc) Experience in data mapping, modeling and working with teams to define data models Experience in a dynamic work environment Proven ability to work well in a team environment, and be capable of building and maintaining positive relationships with other staff, departments, an

Full-time

USD 70.00 - 74.00 per hour

Sr Data Engineer (Snowflake SQL)

Waltham, Massachusetts

•

Today

JOB TITLE: Sr Data Engineer (Snowflake SQL) JOB LOCATION: Waltham, MA (1x per week) WAGE RANGE*: 70.00-74.00/hr. W2 (or ) JOB NUMBER: NGGJP00017053 REQUIRED EXPERIENCE: Qualifications: 3+ years' experience in database development (Snowflake, SQLServer, Oracle, etc) Experience in data mapping, modeling and working with teams to define data models Experience in a dynamic work environment Proven ability to work well in a team environment, and be capable of building and maintaining positive rela

Full-time

USD 70.00 - 74.00 per hour

Lead Data Quality Engineer/Data Test Lead (ETL/BI Snowflake & DBT)

Boston, Massachusetts

•

2d ago

We are seeking a highly experienced Data Test Lead with deep expertise in ETL/BI data testing to join our team in Boston. This role demands strong technical proficiency in modern data platforms and validation frameworks, with hands-on implementation experience in Snowflake and DBT environments. The ideal candidate will be detail-oriented, technically strong, and capable of leading end-to-end data validation strategies across complex data pipelines and BI ecosystems. Required QualificationsBoston

Easy Apply

Third Party, Contract

Depends on Experience

Alpha Performance End to End Technical Integration Architect - Vice President

Burlington, Massachusetts

•

Today

Will consider candidates from Burlington MA, Boston MA, Berwyn PA, Clifton, NJ and Stamford CT. Job Description State Street Alpha is the industry's first and only Front-to-Back Platform which provides clients access to the complete investment lifecycle with the power of choice. By streamlining and improving their day-to-day operations through a single open platform, clients are free to focus on innovation and growth. State Street Alpha is looking to bring on an Alpha Platform End to End Soluti

Full-time

USD 110,000.00 - 188,750.00 per year

Search all similar jobs