Programmer Analyst (SQL, ETL, Data Warehousing)

Softworld, a Kelly Company; City of Rochester (NY); On-site; USD 80,000 - 100,000; Full time

Job summary

An innovative firm seeks a Programmer Analyst skilled in SQL, ETL, and Data Warehousing. In this role, you will be instrumental in enhancing data management initiatives, working closely with the company's MES System and Data Warehouse. Your responsibilities will include developing and implementing new functionalities, liaising with users, and expanding analytics capabilities. This position offers a unique opportunity to contribute to critical data projects within a supportive team environment. If you have a passion for data and a solid background in ETL processes, this is the perfect opportunity to make a significant impact in a dynamic setting.

Qualifications

• 3-7 years of experience in ETL and software development lifecycle.
• Degree in Computer Science or equivalent experience required.

Responsibilities

• Support and develop applications for Data Management initiatives.
• Work with Data Warehouse to enhance analytics and ETL processes.

Skills

ETL

SQL

Data Warehousing

Software Development Lifecycle

Querying

Building Tables

Creating Objects

Stored Procedures

CFR Part 11 Compliance

Change Control

Education

Degree in Computer Science

Degree in Computer Engineering

Degree in Information Technology

4 years hands-on experience

Tools

SQL Server

Oracle Databases

KepServerEX

Job description

Programmer Analyst (SQL, ETL, Data Warehousing)

Base Pay Range: $41.00/hr - $51.00/hr

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

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.

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 site's 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.

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.

Seniority Level: Mid-Senior level

Employment Type: Contract

Job Function: Analyst, Information Technology, and Other

Industries: IT Services and IT Consulting, IT System Data Services, and IT System Operations and Maintenance