Lead IT System Integration Analyst

12-14 month contract

Philadelphia, PA (HYBRID)

• Looking for someone who has LEAD INTEGRATION and ensured deadlines are being met and data is integrating the way it should be/data is being moved properly.
• Should have experience with SSIS, Oracle PL/SQL, Informatica for ETL processes.
• Financial/accounting data experience is HIGHLY PREFERRED.
• Responsibilities:Designing, developing, maintaining, and supporting new or existing interfaces between the GFF application and a variety of other IT solutions (ERP, POS, Decision Support, etc…)
• Ability to analyze business requirements and architect database and interface designs and build solutions.
• Responsibility for the end-to-end design of application or user interface components which support the data interface process; including screens and interactive mechanisms to validate data.
• Support a growing list of critical interfaces both during and after business hours.
• Establishing or furthering existing monitoring and/or alerting capabilities in the current environment
• Ability to review development work of others to assess ways to improve software performance.
• Participating in workshops and meetings, facilitating and recording business requirements and preparing documentation.
• Coordination with the business analyst and other members of the IT development staff to review and validate requirements and evaluate technical feasibilities.
• Document system design and support.
• Expected to develop time estimates for new or modified work items including constraints, dependencies and other variables under the guidance of the IT team.
• Coordinates with various on-shore / off-shore consulting practices an assimilate needs into several on-going work streams.
• Responsibility for performing code reviews of cross-team members and assisting in matters of standards and governance.
• Developing and maintaining technical documentation on current and future state of information technology systems, applications, interfaces and processes.
• Estimate and establish cost parameters for new development of software, interfaces and process improvements under the guidance of the IT team.
• Will be required to work with a project manager to collapse new project items into individual or comprehensive plans.
• Part time test scenario / case development and execution.
• Will complete work in accordance with corporate established SDLC processes.
• Research and analyze new tools / processes that can help the team become more efficient.
• Support could expand to include code promotion and management processes (Azure DevOps)
• Be an integral part of future implementation project teams for implementing additional functionality in the Global Field Financials project arena.

Qualifications:

• Bachelor's degree in Information Systems, Computer Science or a similar discipline is required coupled with the desire to succeed in an enriching development environment
• Demonstrated skills in the development and maintenance of enterprise-level systems
• 4 years proficiency in technical development experience in a team environment
• 3 years of related experience in systems integration across heterogeneous environments
• SQL Server 2019 or better required and demonstrated expertise in SSIS and other ETL toolsets is required
• 3 years of experience with Oracle 12c or greater
• Demonstrated abilities to analyze and write Data Definition Language (DDL) and Data Manipulation Language (DML) scripts.
• Experience integrating 3rd party APIs.
• Demonstrated experience working with Unicode and international character data sets is preferred
• Leadership in solution design and development and compliance to SDLC & enterprise standards
• Demonstrated experience in collaborating with stakeholders and business process owners is a must
• Ability to create and deliver presentations is essential
• Experience with creation and maintenance of functional and/or technical specifications is required
• Experience with change control processes, code migration and management tools is required (Azure DevOps, TFS, etc)
• Experience with ERP Systems (Oracle, SAP, other) or equivalent demonstrated experience in general business concepts (including general ledger, accounts payable, accounts receivable, fixed assets, purchasing, receiving, inventory) is a plus
• General knowledge and expertise regarding hardware, operating systems, networking and internet concept is expected