Data Analyst

Experience: 4-7 yearsLocation: Boston, MAContract Type: 3–6 months (1099 or Corp-to-Corp)Working Model: Work from OfficeQualification: B.Tech / Master's in IT or a related backgroundAbout The RoleWe 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 over 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 RequiredStrong expertise in SQL Server (T-SQL), schema design, and stored procedure analysisHands-on experience with SSIS package analysis and reverse engineeringExperience with Microsoft Access (queries, forms, reports, linked tables)Knowledge of ETL concepts, data lineage, and dependency analysisStrong documentation and metadata management skills (data dictionaries, lineage diagrams, metadata repositories)Ability to design searchable, queryable outputs using Excel, metadata tables, or lightweight dashboardsExperience analyzing large, undocumented legacy systems with complex interdependenciesStrong communication and collaboration skills for working with technical and business stakeholdersExposure to Power BI or Tableau for visualization of metadata and dependenciesRoles And ResponsibilitiesPerform detailed discovery and analysis of SQL Server databases, stored procedures, views, triggers, and functionsReverse engineer SSIS packages, Access applications, and legacy ETL workflows to understand logic, dependencies, and data flowsBuild and maintain metadata repository tables to capture discovered information about objects, dependencies, and transformation rulesDocument application and system dependencies, identifying hidden or undocumented business logicDevelop data dictionaries, dependency mappings, lineage diagrams, and system inventoriesWork with SMEs and stakeholders to validate discovered information and capture undocumented business rulesDeliver searchable, navigable documentation and dashboards (not static reports) for MassDOT review and auditContribute to stakeholder interviews, workshops, and technical discovery sessionsEnsure deliverables are version-controlled, indexed, and reusable by client teams