Sr. Programmer Analyst - SSIS

CooperVision; Village of Victor (NY); On-site; USD 121,000 - 162,000; Full time

Job summary

CooperVision is seeking a Sr. Programmer Analyst - SSIS to support data integration for their global supply chain planning application. The role entails developing SSIS programs, analyzing user requirements, and ensuring high-quality service delivery. Ideal candidates will possess a strong background in SSIS and data integration, along with excellent communication skills.

Qualifications

• 8+ years experience in SSIS.
• Familiarity with ERP systems is a plus.
• Proven analytical and problem-solving skills.

Responsibilities

• Analyze user requests for new systems and recommend actions.
• Design and implement new systems based on specified requirements.
• Develop documentation and train users on new systems.

Skills

Microsoft SQL Server Integration Services (SSIS)

Data integration

Software development life cycle

Excellent written communication

Excellent time management

Education

Bachelor’s degree in computer science

Tools

Microsoft Office

Microsoft Project

Job description

Join to apply for the Sr. Programmer Analyst - SSIS role at CooperVision

1 day ago Be among the first 25 applicants

Join to apply for the Sr. Programmer Analyst - SSIS role at CooperVision

Direct message the job poster from CooperVision

Job Description

Develop SQL Server Integration Services (SSIS) programs to support the data integration of a global supply chain planning application from o9 Solutions with multiple ERP and operations IT applications. The position requires knowledge of enterprise integration architecture, integration technologies including SQL Server Integration Services (SSIS); and an understanding of the functional business processes and data integration best practices with cloud-hosted applications.

Job Description

Develop SQL Server Integration Services (SSIS) programs to support the data integration of a global supply chain planning application from o9 Solutions with multiple ERP and operations IT applications. The position requires knowledge of enterprise integration architecture, integration technologies including SQL Server Integration Services (SSIS); and an understanding of the functional business processes and data integration best practices with cloud-hosted applications.

Responsibilities

• Analyze requests from users for new systems, new programs, program changes, etc. and recommend necessary action
• Design new systems and modifications to existing systems to meet user requirements.
• Write new or modify existing programs according to specified systems designs.
• Test new or modified programs to ensure that they conform to design. Develop test data for use in program testing
• Write documentation of system changes in conformance with department standards
• Write any necessary user documentation (report descriptions, user procedures, operations procedures)
• Train users in operation of new or modified systems.
• Aid in preparation of time and cost estimates for program development.
• Analyze requests and write program specs for Jr. Programmers and contractors.
• Provide programming support on-site or by phone as required for all shifts
• Maintain awareness of technological developments in computer hardware and software systems
• Provide timely and concise summaries of project status to manager
  
  
  

Project Execution

• Communicates and applies project standards.
• Consistently delivers high-quality services to the user community.
• Plan and lead testing, implementation, training, support and documentation activities for local projects
• Assist other developers – internal and external – through provision of functional specifications and technical walk through.
  
  
  

CooperVision’s management team is committed to the development of and implementation of the quality management system and maintaining its effectiveness by communicating to the organization the importance of meeting customer as well as statutory and regulatory requirements.

Travel Requirements:

• 10% or less
  
  
  

Qualifications

Knowledge, Skills and Abilities:

• Microsoft SQL Server Integration Services (SSIS) knowledge and demonstrated experience required.
• Familiarity with project deployment model, use of project and package parameters, and Integration Services Catalog (including Environments) preferred.
• Knowledge of designing and developing data transformation solutions using a variety of SSIS components (Data Flow Task, Data Flow transform tasks, Data Flow containers, Foreach Loop containers, Script components using C#).
• Reviews user requirements for new applications or enhancements to existing applications and performs analysis, design, development, testing, installation, and training related to the application developed.
• Software development life cycle (Waterfall & Agile like methods) and software quality assurance best practices and methodologies.
• Familiarity with building SQL database objects (tables, views, stored procedures).
• Other desirable skills Include:
• Excellent written, oral, and interpersonal communication skills.
• Excellent time management
• Highly self-motivated, self-directed, and attentive to detail.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Extensive experience working in a team-oriented, collaborative environment
• Ability to produce exceptional quality output
  
  

Work Environment:

• Normal office environment.
• Sedentary to light physical effort necessary to perform the job.
• Extensive contact with employees and external business partners and vendors
  
  
  

Experience:

• 8 or more years of experience in designing, developing, implementing systems using Microsoft SQL Server Integration Services (SSIS)
• Five years of experience in System Design preferably in an ERP environment
• Experience with Oracle E-business Suite (EBS), Baan/Infor, o9 Solutions preferred, but not required
• Must be proficient with Microsoft Office and Microsoft Project
• Knowledge of supply chain and operations (manufacturing, packaging and warehousing) is preferred, but not required.
  
  
  

Education:

• Bachelor’s degree in computer science, Information Technology, Engineering, or related experience.
  
  
  

We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.

For U.S. locations that require disclosure of compensation, the starting base pay for this role is between $121,394 and $161,859 per year and may include cost of living adjustments. The actual base pay includes many factors and is subject to change and modification in the future. This position may also be eligible for other types of compensation and benefits.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Medical Equipment Manufacturing

Referrals increase your chances of interviewing at CooperVision by 2x

Sign in to set job alerts for “Senior Programming Analyst” roles.

Rochester, NY $102,890.67-$139,637.34 1 month ago

Victor, NY $125,000.00-$180,000.00 2 weeks ago

Rochester, New York Metropolitan Area $90,000.00-$110,000.00 19 hours ago

Rochester, NY $90,200.00-$167,400.00 1 day ago

Rochester, NY $123,900.00-$167,700.00 2 weeks ago

Senior Software Developer M/F (H/F) - SAFRAN TRUSTED 4D INC

Rochester, NY $144,768.00-$209,109.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.