DEFTeam Solutions Pvt Ltd is hiring: Sr. Data Analyst in Boston

We are seeking highly skilled Data Engineers/Analysts 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.

Experience

• Experience: 6-10 years (Sr Data Analyst - 2 positions)
• Location: Boston
• Working Mode: It is work from office.
• Client Name: State of MA
• Qualification: BTech /Masters in IT or related background

Job Type: Contract

Pay: $65.00 – $70.00 per hour

Work Location: In person