KBS Solutions LLC is seeking Senior Data Analyst and Data Analyst for an exciting contract opportunity with one of our clients based in Boston, MA.

This project supports the Discovery Phase of a large-scale legacy system modernization initiative — ideal for professionals with strong SQL, data analysis, and reverse-engineering experience.

Duration: 6 Months (High possibility of extension)

About the Role

You’ll play a key role in uncovering and documenting technical and business logic across undocumented enterprise systems with 500+ database tables, 1600+ stored procedures, SSIS packages, Microsoft Access applications, and multiple interdependent systems.

Your work will enable future modernization, migration, and metadata repository development.

Key Skills & Expertise

Expertise in SQL Server (T-SQL), schema design, and stored procedure analysis
Hands-on experience with SSIS and Microsoft Access (queries, forms, reports)
Strong understanding of ETL, data lineage, and dependency analysis
Experience analyzing large, undocumented legacy systems
Proficiency in documentation and metadata management (data dictionaries, lineage diagrams, repositories)
Knowledge of Excel, Power BI, or Tableau for metadata visualization
Excellent communication and stakeholder collaboration skills

Roles & Responsibilities

Perform detailed analysis of SQL Server databases, stored procedures, and functions
Reverse-engineer SSIS packages, Access applications, and legacy ETL workflows
Build and maintain metadata repositories capturing dependencies and transformation rules
Document system dependencies and undocumented business logic
Develop data dictionaries, lineage diagrams, and system inventories
Collaborate with SMEs to validate findings and deliver interactive dashboards
Participate in technical discovery sessions and stakeholder workshops

To Apply: Send your resume to michelle.kurian@kbstechsolutions.com

🔗 Apply Here:Click to Apply

KBS Solutions LLC

Latest Jobs

Senior Data Analyst