Sr Data Analyst

Sr Data Analyst

Company: Vantage Point Consulting

Location: Boston, MA

Contract Type: 3–6 months (1099 or Corp-to-Corp)

Working Model: Work from Office

Experience: 6–10 years

Qualification: B.Tech / Master's in IT or related background

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

• 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 analyzing large, undocumented legacy systems with complex interdependencies
• Strong communication and collaboration skills for working with technical and business stakeholders
• Exposure to Power BI or Tableau for visualization of metadata and dependencies

• 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

Mid‑Senior level

Full‑time

Information Technology

IT Services and IT Consulting

Referral: Referrals increase your chances of interviewing at Vantage Point Consulting by 2x

Apply BELOW