Business Systems Analyst (Data & Integration) - 3714999

Lighthouse Technology Services•Buffalo, NY
•Hybrid

About The Position

Lighthouse Technology Services is partnering with a client to hire a Business Systems Analyst focused on data and integration. The position is a 12+ month contract, based in Buffalo, NY, with a hybrid work arrangement. The worker will be a W2 employee of Lighthouse Technology Services; C2C and subcontracting arrangements will not be considered. The analyst leads moderately complex to complex projects from proposal through post-implementation, gathers business requirements and translates them into technical specifications, and performs SQL- and Python-based data analysis to validate functional designs and system integrity. The role also supports integration, conversion, and acquisition-related work through data mapping and documentation of system design, data flows, and architecture. The position serves as test coordinator across applications on large initiatives, coordinating UAT and testing, preparing and executing test plans and cases, and working with cross-functional teams to develop test scripts and resolve issues. The analyst collaborates with vendors and stakeholders, provides implementation guidance, estimates project timelines and phases, and monitors specifications and change requests to keep work in scope and compliant with regulatory standards.

Requirements

  • At least 5 years of experience as a Business Systems Analyst or in a similar role involving technical requirements analysis.
  • Strong proficiency in SQL and Python for technical data analysis and automated validation.
  • Ability to perform moderately complex data research and analysis to ensure design accuracy.
  • Experience with data mapping for system integration, conversion, or acquisition projects.
  • Understanding of system design, data flows, and architecture documentation.
  • Experience leading moderately complex to complex projects with cross-functional coordination.
  • Strong test planning and UAT coordination skills, including test case development and execution.
  • Excellent verbal and written communication skills, with the ability to present to all levels of management.

Nice To Haves

  • Experience with banking acquisition methodology or system conversions is strongly preferred.

Responsibilities

  • Lead moderately complex to complex projects from proposal through post-implementation as a functional or project lead.
  • Facilitate requirements-gathering sessions with business stakeholders and translate needs into technical specifications.
  • Conduct SQL- and Python-based data analysis to validate functional design accuracy and system integrity.
  • Participate in and document data mapping for integration, conversion, and acquisition-related projects.
  • Serve as Test Coordinator across multiple applications on large initiatives, managing UAT and testing coordination.
  • Build functional specifications, test plans, and test cases; execute testing and ensure timely issue resolution.
  • Collaborate with vendors to understand project functionality and provide implementation guidance.
  • Serve as a subject matter expert on how applications are affected by enterprise-wide initiatives and product changes.
  • Coordinate and provide estimates, including timelines and project phases, for assigned projects and components.
  • Monitor specifications and change requests to keep projects in scope and compliant with regulatory standards.
  • Document system design, data flows, and architecture for integration and conversion work.
  • Work with cross-functional testing teams to develop test scripts based on functional specifications.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service