ETL/SSIS Developer/Application Analyst

**This is a Hybrid position based out of the Fairport, New York Office**

Position Summary:

The ETL/SSIS Developer is responsible for applying expert knowledge of ConServe’s application landscape in the development and implementation of Business and IT application improvement initiatives. Actively supports all aspects of project activity through the System Development Life Cycle. This individual also provides coaching and mentoring to enhance the capabilities of all team members.

Essential Duties & Responsibilities:

• Enhances staff accomplishments and competence by providing technical and procedural mentoring / guidance for less experienced team members.
• Takes the time to understand business drivers / challenges, recommending technical solutions to solve business problems and improve end user experience.
• Creates, enhances and maintains custom and COTS applications.
• Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner.
• Develops relationships with business counterparts, facilitating and collaborating on the resolution of business issues.
• Contributes to team effort by keeping peers and management informed of potential changes that could impact daily operations, staffing needs, schedules or work deliverables.
• Quality control of application system functionality to ensure data integrity and system synergy with all peripheral devices.
• Provide guidance and support the end users in their efforts to become more proficient in the use of the applications.
• Generate Ad-hoc reports as needed.
• Provides reference documentation by writing and maintaining functional and technical specifications.
• Maintains system and programming guidelines by adhering to the software development lifecycle.
• Protects operations by keeping information confidential.
• Adherence to ConServe’s Professional Practices Management System (PPMS), Code of Conduct, and Compliance Program.

Education:

• High School Diploma or GED
• Bachelor’s Degree in Information Technology or related field or equivalent combinationof education and related experience.

Skills/ Requirements:

• Five (5) years of experience in an applications development or configuration management role.
• ETL/SSIS experience strongly preferred.
• C# console application and .NET development experience preferred
• Strong SQL experience creating and maintaining stored procedures preferred
• Experience with Cisco Tidal or other similar automated scheduling tools preferred
• Demonstrated ability to work independently and multitask with limited supervision contributing as a team player.
• Excellent interpersonal, verbal and written communication skills, with the ability to communicate technical problems to non-technical audiences.
• Experience handling multiple changing priorities and meeting deadlines in a professional manner.
• Solid experience with Microsoft Office suite of products.
• Must be able to provide on-call support on a rotating basis.
• Must be able to work remote in a home office environment and travel to ConServe’s offices as needed.
• The ability to telework. A teleworker is defined as an employee who works for ConServe from a home, or other remote office, for all of the regularly scheduled work week. A teleworker uses telecommunication technologies, including, but not limited to, soft telephones, virtual facsimiles, computers, electronic mail, and remote Internet connections to access work remotely on a pre-determined basis
• A secure internet connection
• A private work area in which work activities can be conducted
• U.S. Citizenship or lawful Permanent Resident alien with three or more years as a permanent resident in the United States.
• Ability to obtain and maintain Government Security Clearance
• No conflicts of interest with ConServe or our Clients.

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

• The employee must occasionally lift or move up to 25 pounds and occasionally lift or move up to 100 pounds with assistance.
• Ability to sit or remain sedentary for up to 8 hours per day, except for periodic breaks pursuant to applicable law.
• Must occasionally be able to bend, move, climb and lie down in awkward positions.
• Ability to type on a computer for eight (8) hours.
• While performing the duties of this job, the employee is required to use and reach with hands, walk, stoop, kneel, crouch, stand, see and hear.
• Ability to listen and talk frequently throughout the day.

Reasonable accommodations may be made to the extent required under applicable law to enable individuals with disabilities to perform the essential functions of this position.