Sr. Data Engineer

2 weeks ago

Boston, Massachusetts, United States DEFTeam Solutions Pvt Ltd Full time $145,600 - $218,400 per year

We are seeking highly skilled Data Engineers to support the Discovery Phase of a large-scale legacy system modernization project. The role involves analyzing undocumented enterprise systems containing 500+ database tables, 1600+ stored procedures, legacy SSIS packages, Microsoft Access applications, and multiple interdependent systems. The selected candidate will play a critical role in extracting technical and business knowledge, documenting findings, and populating a metadata repository to enable future modernization and migration efforts.

Skills required:

  • Strong expertise in SQL Server (T-SQL), schema design, and stored procedure analysis.
  • Hands-on experience with SSIS package analysis and reverse engineering.
  • Experience with Microsoft Access (queries, forms, reports, linked tables).
  • Knowledge of ETL concepts, data lineage, and dependency analysis.
  • Strong documentation and metadata management skills (data dictionaries, lineage diagrams, metadata repositories).
  • Ability to design searchable, queryable outputs using Excel, metadata tables, or lightweight dashboards.
  • Experience analysing large, undocumented legacy systems with complex interdependencies.
  • Strong communication and collaboration skills for working with technical and business stakeholders.
  • exposure to Power BI / Tableau for visualization of metadata and dependencies.
  • Roles and Responsibilities:
  • Perform detailed discovery and analysis of SQL Server databases, stored procedures, views, triggers, and functions.
  • Reverse engineer SSIS packages, Access applications, and legacy ETL workflows to understand logic, dependencies, and data flows.
  • Build and maintain metadata repository tables to capture discovered information about objects, dependencies, and transformation rules.
  • Document application and system dependencies, identifying hidden or undocumented business logic.
  • Develop data dictionaries, dependency mappings, lineage diagrams, and system inventories.
  • Work with SMEs and stakeholders to validate discovered information and capture undocumented business rules.
  • Deliver searchable, navigable documentation and dashboards (not static reports) for MassDOT review and audit
  • Contribute to stakeholder interviews, workshops, and technical discovery sessions.
  • Ensure deliverables are version-controlled, indexed, and reusable by client teams.
  • Exp: 6-10 years ( Sr Data Engineer- 2 positions)
  • Location: Boston;
  • It's a contract position for 6months+ on 1099 or Corp to Corp ;
  • Working Model-It is work from office.
  • Client Name: State of MA
  • Qualification: BTech /Masters in IT or related background

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 WFO?
  • Are you strong on SQL?, How will you rate yourself out of 10
  • 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...

  • Sr. Data Engineer- SSIS

    8 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...

  • Sr Data Engineer

    4 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

    4 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

    3 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

    12 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...