ETL/SSIS Developer / App Analyst II

ConServe; Village of Fairport (NY); Hybrid; USD 70,000 - 85,000; Full time

Job summary

ConServe is seeking an Applications Analyst II in Fairport, NY for a hybrid role. You will support the application landscape, contribute to IT projects, and ensure data integrity across systems.

The role blends development, testing, and end-user enablement in a long-term contract-to-hire setting. The ideal candidate has 3+ years in applications development, ETL/SSIS, and .NET/C#, with strong SQL and scheduling tool experience.

Qualifications

• 3+ years in applications development or configuration software role.
• ETL/SSIS experience strongly preferred.
• C# console app and .NET development experience preferred.
• Strong SQL experience with stored procedures preferred.
• Experience with Cisco Tidal or other scheduling tools preferred.
• Ability to multitask and work independently.
• Good verbal and interpersonal skills.
• On-call support availability.

Responsibilities

• Recommends technical solutions to reported problems and selects optimal options.
• Troubleshoots production issues and implements timely resolutions.
• Engages project sponsors to understand business concerns and proposals.
• Creates, enhances and maintains custom and COTS applications.
• Plans, develops, tests and installs systems solutions for new business lines.
• Mentors and cross-trains team members on IT processes.

Skills

ETL/SSIS experience

C#/.NET development

SQL stored procedures

Multitasking

Independence

Communication

Education

High School Diploma or GED

Bachelor's Degree in IT or related field

Tools

Cisco Tidal

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Applications Analyst II

Contract Fairport, NY, US

30+ days ago Requisition ID: 2495

Salary Range: $70,000.00 To $85,000.00 Annually

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

The ETL/SSIS Developer/Application Analyst is responsible for providing direct support to ConServe’s application landscape in addition to developing and implementing Business and IT application improvement initiatives/projects. Under the direction of the Applications Development Manager, the ETL/SSIS Developer actively supports all aspects of the projects from start to finish with a particular emphasis on program development, quality testing and end user enablement. This is a long-term Contract to Hire position.

• Recommends technical solutions to reported problems, identifying pros and cons of each solution.
• Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner.
• Engages project sponsors to understand business concerns / objectives and collaboratively identify and implement solutions.
• Creates, enhances and maintains custom and COTS applications.
• Plan, develop, test and install systems solutions to enable new business lines and/or departments as well as special Client requests.
• Recognizes, raises awareness to and implements improvements in IT keep-it-running activities.
• Mentors and cross-trains team members on IT keep it running processes, ensuring supportability across the team.
• Train users on the new/modified applications.
• Quality control of application system functionality to ensure data integrity and system synergy with all peripheral devices.
• Confirms software solutions by conducting tests and modifying code and/or configuration.
• 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.
• Other duties as assigned

Education:

• High School Diploma or GED
• Bachelor's Degree in Information Technology or related field or equivalent combination of education and related experience.

Skills/ Requirements:

• Three+ (3) years of experience in an applications development or configuration software 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
• Ability to multitask.
• Ability to act independently to resolve problems.
• Good verbal communication skills and interpersonal skills.
• Must show a sense of urgency, being able to perform and multitask under pressure.
• 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
• 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, stop, 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.

MISSION STATEMENT: ConServe is dedicated to satisfying the needs of our Clients in a manner consistent with improving the human condition, and that will foster the development of long term mutually beneficial relationships with our Clients, our Employees, our Suppliers and Business Partners and the Community as a whole.

Disclaimer: The above job description is not a contractual or binding document; it is provided as a guide to the types of duties required to be undertaken. Duties may vary from time to time and this description is subject to review. Modifications will be made as needed to support changes in the business climate and requirements.

Continental Service Group, Inc., d/b/a ConServe endeavors to make www.conserve-arm.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact our Recruiting Department at: 585-421-1000 and press 7 or by emailing: [e-mail] .

Qualified applicants will receive consideration for employment regardless of age, race, color, religion, national origin, sex, sexual orientation, gender, gender identity/expression, genetic disposition, genetic markers/carrier status, disability, creed, veteran status, military status, status as a victim of domestic violence, marital status, familial status, pregnancy, childbirth and related medical conditions, and disability, conviction (limited) or other legally protected status.