Programmer Analyst (SQL, ETL, Data Warehousing)

Job Title: Programmer Analyst (SQL, ETL, Data Warehousing)

Job Location: Rochester NY 14609

Onsite Requirements:
• ETL
• SQL Server
• Data Warehousing

Job Description:

PURPOSE OF JOB
• Softworld client is looking for a Programmer Analyst to assist with a number of Data Management initiatives. On a day-to-day basis this individual will be working with the company's home grown MES System and their Data Warehouse to expand on the analytics work that is currently being supported.

This department gathers data on everything it takes to develop a new contact lens. It measures things like size, power, etc of the lens.

KEY ACTIVITIES/RESPONSIBILITIES:
• Application and configuration support as well as new component/functionality development and implementation.
• Liaise with user community and other business functions to develop and provide an efficient support service.
• Work with the Data Warehouse to expand on the analytics work that is currently being supported. Take data from Oracle databases and perform ETL into the SQL Server.
• Work multiple tasks with fluctuating priority. Suggest solutions to challenges presented by the DPE staff.
• Write user requirements, functional and design specs. Develop, test, deploy and support new and existing applications or processes.
• Participate with the engineering and operations teams to define plans for integrating, standardizing, scaling and enhancing our products and the services utilized to deploy/install/release those products
• Author reports based on department needs at the time. This includes requirements capture, development, testing and deployment.
• Assist with the ongoing deployment of the MES application in all areas of Contact Lens R&D as one of the sites technical MES leads.
• Troubleshoot the occasional PC software, OS or hardware issue.
• Provide support to Software Quality Assurance representatives during MES validation of change control process.

QUALIFICATIONS/ TRAINING:
• Education: Degree in Computer Science, Computer Engineering or Information Technology Discipline or 4 years hands-on experience with MES application development, testing, support, database architecture, OOO concepts and ETL methodologies

EXPERIENCE:
• Experience: 3-7 years of professional experience including ETL and software development lifecycle. Must be able to do querying, build tables, create objects and stored procedures.
• Special Skills: Familiar with CFR Part 11 requirements, experience with change control requirements. Must be able to develop working relationships with various internal core competencies and work as a team member.
• Helpful, but not required: KepServerEX, any flavor of transactional management systems, previous experience working with controls engineers.
•
• 3rd party and subcontract staffing agencies are not eligible for partnership in this position. 3rd party subcontractors need not apply.

This position requires candidates to be eligible to work in the United States, directly for an employer, without sponsorship now or anytime in the future.
•
•