SSIS SQL Data Engineer or Data Architect

Tek Leaders Inc
Iselin, New Jersey, USA
Full-time

Lead SSIS / SQL Data Engineer or Data Architect hybrid in NJ.

4 positions.

Minimum 10 years of experience in Data Engineering.

Should be data designing experience.

Skill

Rate out of 10

Years of experience

Design and Development : Build flexible performant and scalable data solutions using Microsoft SQL Server SSIS (SQL Server Integration Services)

ETL and Data Pipelines :

Data Modeling and Architecture :

Performance Tuning and Optimization :

Position Details

Requirement

Creq

No of Positions

Role

Lead SSIS / SQL Data Engineer

Location

Hybrid in NJ

Type of Hire Contract / C2H

C ontract

Duration

Number of Interviews

In person interviews Yes / No

Client Interview Yes / No

No of submission (example not more than 3 resumes)

Timeline for submission

24 hours

Position requirements ( Remote / Hybrid / Fully onsite)

Hybrid in NJ

Job Description

Requirement :

Job Purpose / Summary

The Lead or Architect SQL / SSIS Data Engineer will be responsible for designing developing and maintaining robust data infrastructures ensuring the efficient transformation of raw data into actionable insights.

This role involves working closely business stakeholders and other IT teams to implement data management strategies and solutions.

Key Responsibilities

Design and Development :

Build flexible performant and scalable data solutions using Microsoft SQL Server SSIS (SQL Server Integration Services)

Create complex SQL objects such as tables stored procedures functions views indexes and triggers to facilitate efficient data manipulation and consistency.

ETL and Data Pipelines :

Develop and maintain ETL packages using SSIS to extract data from various sources (e.g. flat files XML files CSV files Access Excel) and load it into data warehouses.

Implement various transformations error handling and event handling techniques in SSIS to ensure efficient package execution.

Data Modeling and Architecture :

Design and develop conceptual logical and physical data models to support analytic data requirements and business intelligence needs.

Translate business needs into data models and database schema based on requirements gathered from business stakeholders.

Performance Tuning and Optimization :

Optimize database performance through query tuning indexing and other optimization techniques.

Ensure data consistency and integrity by implementing data governance and quality control measures.

3 days ago
Related jobs
Promoted
EVOLVE ESOLUTIONS LLC
Jersey City, New Jersey

Data Catalog and Big Data Platform experience. ...

Promoted
eTek IT Services, Inc.
Jersey City, New Jersey

The Data Engineer plays a crucial role in our organization, responsible for designing, developing, and maintaining scalable data pipelines and infrastructure. Bachelor's or Master's degree in Computer Science, Engineering, or related field. This role will have a significant impact on our abi...

Promoted
American Cybersystems
Hoboken, New Jersey

Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, ...

Walmart
Hoboken, New Jersey

Data engineering, database engineering, business intelligence, or business analytics, ETL tools and working with large data sets in the cloud, Master’s degree in Computer Science or related field and 3 years' experience in software engineering, We value candidates with a background in creating inclu...

Emonics LLC
New Jersey, United States

Write complex SQL queries for data extraction and analysis. Please get rating on how many years the candidates have hands one experience on Python coding, SQL and Databricks. Location : New Jersey, Burbank, LA – CA, Woodland, Tx, Orlando, Seattle is highly preferred. Design, build, and maintain end-...

Organon
Jersey City, New Jersey

Organon proudly embraces diversity in all of its manifestations and is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity, or gender expression, national ...

Motion Recruitment
Woodbridge Township, New Jersey

Experience in data analysis, data extraction/manipulation and loading routines using SQL, Teradata, database structures and data warehouses. Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work or consulting experience, training, military ex...

Tiger Analytics
Jersey City, New Jersey

Collaborate with data engineers, analysts, and business users to support data visualization, reporting, and analytics initiatives. Data Architect or similar role, with a strong focus on designing and implementing data solutions using Snowflake. In-depth knowledge of Snowflake architecture, including...

AIT Global
Jersey City, New Jersey

Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages. Formal training or certification on data engineering concepts and 3+ years of applied experience. Produces architecture and design...

Motion Recruitment
Summit, New Jersey

Credit risk is going through a multi-year transformation and is one of the top regulatory deliverables for Corporate Risk technology. Outstanding long-term contract opportunity! A well-known Financial Services Company is looking for a Spark Big Data Engineer in Charlotte, NC (Hybrid). Deliver/suppor...