The SQL Developer - SSIS is responsible for applying expert knowledge of ConServe’s application landscape in the development and implementation of Business and IT application improvement initiatives. Under the direction of the Applications Development Manager, the SQL Developer - SSIS 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
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.
High School Diploma or GED
Bachelor's Degree in Information Technology or equivalent combination of education and related experience.
Master’s Degree in Information Technology or equivalent combination of education and related experience preferred.
Five (5) years required, Eight (8) years preferred, of experience in an applications development role.
Three (3) years of experience in ETL development with the SSIS toolset preferred.
Experience writing and troubleshooting complex SQL queries preferred.
Strong experience with MS SQL Server working with a relational database management system as a developer preferred.
Knowledge of SSRS reporting is a plus.
Experience with Data Warehousing is a plus.
Knowledge of C# is a plus.
Knowledge of Cisco TIDAL Workflow scheduler is a plus.
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.
Ability to travel between ConServe’s offices as needed.
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.
Website : http://www.conserve-arm.com