Data Engineer/AnalystExperience: 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 backgroundAbout the RoleWe 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 RequiredStrong 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 dependenciesRoles and ResponsibilitiesPerform 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
...client of Innova Solutions is immediately hiring for aBackground Investigator Position type: Full-time, Contract Duration: 6 months,... ...19348 About the Opportunity We're looking for a Background Investigator, where you'll play a pivotal role in protecting...
...Research Intern The Research Intern is an entry level clinical research position. The Intern will perform a variety of research, database and clerical duties of a routine and technical nature to support clinical trials and assist investigators to organize, gather and...
...Job Description Job Description NOW HIRING: Experienced Handyman Technician / Sales & Estimating Professional Mr. Handyman of West MariettaSmyrna Location: Marietta, Smyrna, and surrounding Cobb County areas, GA Job Type: Full-Time Compensation: Commission...
...Job Description Job Description (Kitchen Managers, Chefs, Seafood Supervisors & Food Production Leaders Welcome to Apply) This role is internally titled Meat Production Supervisor. Are you a Kitchen Manager, Sous Chef, seafood processing supervisor, or food production...
Why we will love youA job at IKEA is so much more than home furnishings. Together, we work to make a better everyday life for the many. It's the perfect fit if youwant to contribute, grow, and share your uniqueness. Join our team and start a better life for yourself....