Data Analyst Job at Vantage Point Consulting Inc., Boston, MA

cFFZR2RJNWh0NkZqNGtmSTlYSzJnNlU5SFE9PQ==
  • Vantage Point Consulting Inc.
  • Boston, MA

Job Description

Experience: 4-7 years
Location: Boston, MA
Contract Type: 3-6 months (1099 or Corp-to-Corp)
Working Model: Work from Office
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

Job Tags

Contract work, Work at office

Similar Jobs

HouseSitter.com

House Sitter Wanted - Earn $185/Day As A House Sitter In Casper, Wy Flexible Hours & Great Pay! Apply Now! Job at HouseSitter.com

Hello!I'm Pastor Randy, and I'm a homeowner in Glendale, Arizona, searching for a reliable house sitter to help maintain my home while I'm away. If you're interested in a fulfilling and well-compensated opportunity, I invite you to read on.The primary responsibilities...

Sephora

Store Manager Job at Sephora

Sephora is seeking a Store Manager for its West Acres Mall location in Fargo, USA. This role involves leading store operations, developing a high-performing team, and enhancing client experiences in a dynamic retail environment. The position offers a competitive salary,... 

CyberCoders

Corporate Finance Attorney - Senior Associate/Partner Job at CyberCoders

 ...Job Description Job Description Corporate Finance Attorney - Senior Associate/Partner Established (45+ Years) Premier Firm Seeking Corporate Finance Attorney for Corporate Finance in Philadelphia, PA An established firm based in Philadelphia, PA with over 4... 

Abacus

Yard Jockey (Checker) Job at Abacus

Yard Checker Abacus Corporation is a family-owned staffing leader with 80+ years of experience, providing modern workforce solutions nationwide. With a supportive culture and over 25,000 employees, we offer long-term jobs, competitive pay, benefits, and real growth ...

Wellstar Health Systems, Inc.

Respiratory Therapist Resource/Educator KH Job at Wellstar Health Systems, Inc.

 ...emotional, and developmental, psychosocial, and patient/family education needs when providing care to the patient. The resource...  ...working relationship with the Medical staff and Respiratory Care Leadership. Resource also serves as a reference/support person to the staff...