SSIS Developer

Position Overview:
All Lines Technology has an immediate opening for an Application Analyst in Pittsburgh! The Application Analyst is responsible for ensuring that IT provides optimized designs, development, and support our client’s business in support of strategic imperatives. The incumbent shall adhere to development, security, and operations (DevSecOps) standards at every phase of development lifecycle. The incumbent is also responsible for providing production maintenance and support, design, and application documentation, and partnering with key business stakeholders, project management, security, and operations team to ensure holistic and successful development, deployment, and support of application.
 
Primary Responsibilities:

• Uses their competencies in business requirements, application administration and performance and provides Application support. Is expected to work at a high level in all phases of hardware, software and application activities providing technical and business support to a defined end user group and monitoring system health, reviewing logs and reports and escalating issues to vendors.
• Provides assistance to analyze, implement, modify and monitor application performance and monitors server applications and performance. Participates in discussions on system requirements and objectives based on business needs and performance goals. Identifies and explains application performance issues. Supports business processing requirements and supports installations and upgrades.
• Uses basic or emerging Technology project management skills to deliver the various corporate initiatives as part of the Technology project team. Uses analytical skills to evaluate business implications of application performance. Participates in the evaluation of the potential of the application platforms to support evolving business needs and growth.
• Communicates with lines of business (LOB) users and Technology and reports issues with reliability and performance of business applications. Interacts with the BA/SA and NE to achieve LOB goals and objectives and uses the performance data to help solve capacity, limitations and performance issues and reports user experiences with system hardware and software. 
• Assists to solve basic business problems with hardware, software and databases. Monitors system to achieve optimum performance and minimize or eliminate down time.  Conducts routine hardware and software audits for proactive approach.
• Acts as a vendor liaison for assigned applications. Follows change control procedures and participates in Change Control meetings. Works with Technology, Project Management Offices, LOB's, vendors and external support personnel, especially while troubleshooting.
• Performs other related duties and projects as assigned.

 
Skills Required to Perform the Primary Responsibilities of this Position:

• • Excellent customer service skills   
  • Ability to use general office equipment   
  • Ability to work and multi-task in a fast paced environment   
  • Excellent organizational, analytical and interpersonal skills   
  • Detail-oriented   
  • Basic business knowledge, understanding of systems life cycle, systems integration, data flows, requirements elicitation, testing, reporting tools and relational database concepts
  • Competent in MS Office applications
  • SQL
  • SQL Store Procedure Development
  • GIT/Version Control
  • ETL Development (SQL Integrations Services (SSIS), or other ETL tool)
  • Databases (SQL, Oracle, MySql)
  • Programming (Web, .Net, Visual Basic, ASP.NET, Javascript)
  • BI (SQL Reporting Services, PowerBI)

 
Licensures/Certifications Required to Perform the Primary Responsibilities of this Position:

• • Systems and Business Analysis classes including requirements elicitation and project management.