Sr Data Analyst Job at Vantage Point Consulting in Boston

Overview

Join to apply for the Sr Data Analyst role at Vantage Point Consulting

Experience & Location

Experience: 6–10 years
Location: Boston, MA

Contract & Working Model

Contract Type: 3–6 months (1099 or Corp-to-Corp)
Working Model: Work from Office

Qualification

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

About the Role

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.

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

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

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function

Information Technology