Sr. Data Engineer- SSIS

14 hours ago

Boston, Massachusetts, United States DEFTeam Solutions Pvt Ltd Full time $70,000 - $140,000 per year

Looking for US Citizens or GC holder in Boston Metropolitan area (No sponsorships available).

We are seeking experienced Data Engineers and Analysts to support the discovery phase of a legacy system modernization program. The selected candidates will play a key role in analysing existing systems, documenting technical and business logic, and building a structured metadata repository to support future migration and transformation initiatives.

Skills required:

· Basic to intermediate knowledge of SQL Server (T-SQL), schema design, and stored procedure analysis.

· Hands-on experience with SSIS package analysis and reverse engineering.

· Proficiency in Microsoft Access (queries, forms, reports, and linked tables).

· Strong understanding of ETL concepts, data lineage, and dependency analysis.

· Experience in documentation and metadata management, including data dictionaries, lineage diagrams, and metadata repositories.

· Ability to design searchable and quarriable outputs using Excel, metadata tables, or lightweight dashboards.

· Proven ability to analyze complex, undocumented legacy systems and uncover hidden interdependencies.

· Excellent communication and collaboration skills for working with cross-functional stakeholders.

· Exposure to Power BI or Tableau for visualization of metadata and dependencies.

Roles and Responsibilities:

· Perform detailed analysis and documentation of SQL Server databases, stored procedures, views, triggers, and functions.

· Reverse-engineer Access applications, SSIS packages, and legacy ETL workflows to identify logic, dependencies, and data flows.

· Design and maintain metadata repository tables to capture discovered information, dependencies, and transformation rules.

· Document application and system interdependencies, highlighting undocumented business logic.

· Create data dictionaries, dependency mappings, lineage diagrams, and system inventories.

· Collaborate with subject matter experts (SMEs) and stakeholders to validate findings and capture undocumented rules.

· Deliver searchable and navigable documentation or dashboards for technical and business review.

· Participate in interviews, workshops, and technical discovery sessions to gather requirements and insights.

· Ensure all deliverables are version-controlled, indexed, and reusable for future modernization teams.

Exp: 8-12 years ( Sr Data Engineer- 3 positions)

Location: Boston Metropolitan area.

Initial contract is for 6 months on 1099 basis. There is a probability of extension of contract or absorbed by the DEFTeam based on the performance of the candidates.

Working Model-Initial onsite for 3 months later on hybrid depending upon the performance and client approvals

Client Name: State of MA

Qualification: BTech /Masters in IT or related background

For more details about the organization pls logon to

Job Type: Contract

Pay: $ $70.00 per hour

Application Question(s):

  • What is your total experience?
  • Are you A US Citizen/ Green card holder
  • Currently on which visa type
  • Are you okay with 1099 contract?
  • Are you okay with WFO for first three months?
  • Are you strong on SSIS?, How will you rate yourself out of 10

Work Location: In person

  • Sr. Data Engineer

    4 days ago

    Boston, Massachusetts, United States MFS Investment Management Full time $95,500 - $137,500

    At MFS, you will find a culture that supports you in doing what you do best. Our employees work together to reach better outcomes, favoring the strongest idea over the strongest individual. We put people first and demonstrate care and compassion for our community and each other. Because what we do matters – to us as valued professionals and to the millions...

  • Data Analyst

    3 days ago

    Boston, Massachusetts, United States Vantage Point Consulting Inc. Full time $90,000 - $120,000 per year

    Job Title: Data AnalystLocation: Boston, MADuration: 12 Months+Job Description:We are seeking highly skilled Data Engineers/Analysts to support the Discovery Phase of a large-scale legacy system modernization project.The role involves analysing undocumented enterprise systems containing 500+ database tables, 1600+ stored procedures, legacy SSIS packages,...

  • Sr Data Engineer

    5 days ago

    Boston, Massachusetts, United States Quantiphi Full time $150,000 - $250,000 per year

    While technology is the heart of our business, a global and diverse culture is the heart of our success. We love our people and we take pride in catering them to a culture built on transparency, diversity, integrity, learning and growth. If working in an environment that encourages you to innovate and excel, not just in professional but personal life,...

  • Sr QA Engineer, CAPA

    5 days ago

    Boston, Massachusetts, United States Foundation Medicine Full time $80,000 - $120,000 per year

    About The JobThe Sr QA Engineer (CAPA) plays a critical role in maintaining and improving Foundation Medicine's quality systems. The role conducts day to day administration of the CAPA process, coordinating the review, documentation and retention of quality records. The Sr QA Engineer, CAPA exercises considerable latitude to prioritize daily activities in a...

  • Sr. Data Architect- HR Data

    9 hours ago

    Boston, Massachusetts, United States TEK NINJAS Full time $90,000 - $160,000 per year

    Job Title: Sr. Data Architect- HR Data & AnalyticsLocation: Boston – Hybrid (4 days from office)Duration: MonthsNotes: Snowflake, ETL / ELT, HRIS, SQL, Python.Role OverviewThe Data Architect will play a key role in designing and implementing the enterprise HR data architecture to analytics, KPIs, and reporting initiatives. This role involves translating...

  • Sr Staff Data Engineer

    18 hours ago

    Boston, Massachusetts, United States GE Aerospace Full time $127,900 - $170,500

    Job Description SummaryResponsible for leading the requirements, design, development, and implementation of data engineering and analytics solutions to support cybersecurity initiatives. Will be supporting data analysts, solution architects, data engineers and product managers to deliver data analytical and reporting solutions. This role involves working...

  • Sr Database Engineer Oracle SQL/PLSQL

    4 days ago

    Boston, Massachusetts, United States Compunnel Inc. Full time $120,000 - $200,000 per year

    Position Title: Sr Database Engineer Oracle SQL/PLSQLPrimary Location:Boston, MALocal profilesManager's top asks:-Database Developer, - (wants high level Sr/Principal)** " Oracle & Snowflake a must " **** " Goldengate - so its good if they knew conceptually at least. " **10+ years of hands-on experience with Oracle SQL and PLSQL, including performance...

  • Sr. Digital Product Designer

    4 days ago

    Boston, Massachusetts, United States NTT DATA North America Full time $120,000 - $180,000 per year

    At NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees have been key factors in our company's growth and market presence. By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA and for the people who work...

  • Sr. Kinaxis Engineer

    3 days ago

    Boston, Massachusetts, United States Boston Beer Full time $91,800 - $156,000

    We are currently hiring a Sr. Kinaxis Engineer in Boston, MA, Hybrid*The Sr. Engineer for Kinaxis will be responsible for Kinaxis Rapid Response system administration and support designing, developing, and implementing innovative supply chain solutions using the Rapid Response platform. This position requires significant coordination and strong collaboration...

  • Sr Director of Engineering

    3 days ago

    Boston, Massachusetts, United States Hasbro Full time $172,900 - $259,000 per year

    At Hasbro, our mission is to entertain and connect generations of fans through the wonder of storytelling and exhilaration of play. We're looking for adventurous and curious people who want to explore, experiment, and innovate to come up with the best ideas. Our culture has inspired our diverse team of highly skilled, highly creative, and highly committed...