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

  • Vantage Point Consulting Inc.
  • Boston, MA

Job Description

Data Engineer/Analyst

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

Wolfgang Puck Worldwide, Inc.

Pastry Sous Chef Job at Wolfgang Puck Worldwide, Inc.

 ...knowledge of classical and modern pastry techniques.Experience with plated desserts, chocolate work, breads, laminated doughs, ice creams, petits fours, and mignardises.Excellent organizational, communication, and leadership skills.Ability to multitask and perform... 

Merit 321

Junior Financial Analyst Job at Merit 321

 ...Position: Junior Financial Analyst Location: Washington DC Clearance Requirement: TOP SECRET (Active) Summary: The Financial Analyst performs complex data modeling and financial analysis. The Financial Analyst gathers, interprets, and evaluates... 

Kaiser Permanente

Perioperative Registered Nurse First Assistant Job at Kaiser Permanente

Kaiser Permanente is seeking an experienced RN First Assist to support surgeons in our Healthcare & Medical Services department. In this perioperative role, youll provide first-assist functions including tissue handling, exposure, hemostasis, suturing, and patient monitoring... 

Oneida Nation

Pediatrician Physician Job at Oneida Nation

 ...application/resume. Medical Doctor degree; Wisconsins Physician License State of Wisconsin and Federal DEA Certification....  ...Plan - Comprehensive coverage with preventive care at no cost, telemedicine, and wellness incentives Onsite Wellness Clinics - Chiropractic... 

VBeyond

Proposal Copy Editor Job at VBeyond

 ...Forms completion Bios - (resumes) Bio project outside of active pursuits Data Library that is updated Skillsets for Copy Editors Soft Skill requirements (team fit/personality requirements) Very flexible Strong Organization skills Attention-to-Detail...