Sr. Analyst, Programmer - SQL/ETL (BBBH6184) Albany, New York

Salary: USD90000 - USD90000 per year


Tailwind Associates, an EOE, has an opportunity with our client in Latham, NY for a Sr. Analyst, Programmer- SQL/ETL

 

 

Job Description:

The Programmer/Analyst will analyze & evaluate technical options to meet business objectives provide recommendations (build or buy). Design, develop and test, implement & support computer programs. Create system & operating documentation as required. Provide guidance to other developers and lead development initiatives as assigned. 

Essential Responsibilities: 
• Evaluate requests for new programs or existing program enhancements to determine feasibility, cost, time required, and compatibility with current systems and provide recommendations. 
• Define development standards and methodologies for best practices; lead others in the compliance of these practices. 
• Aid in the evaluation and implementation of vendor selected applications. 
• Aid in the support of vendor applications - communicate and assist in maintaining updated versions. 
• Identify, recommend and implement new technologies and/or upgrades as they become available. 
• Create technical design specifications. 
• Document data specifications and data relationships. Design forms, flowcharts and diagrams as required describing program flow and communication. 
• Design, develop, test, implement and support new and existing applications using the selected primary programming language and utilities. 
• Create supporting user and technical documentation to describe program specifications, installation, operations, development logic, coding and corrections. 
• Design program controls and system manual controls, including business logic, business rules and all other functions relating to the data and business logic tiers. 
• Provide guidance & support to programmer analysts. 
• Provide technical assistance and training. 
• Provide necessary support to ensure applications are operational at all times, implement monitoring as needed. 
• Consult with users to identify current procedures and clarify program objectives and provide technical support. 
• Prepare test specifications and evaluate test models, use the test network to test program functions and evaluate test results. Debug complex programs.

Education: 
• B.S. degree in Computer Science or equivalent experience preferred 

Experience & Background: 
• 6-10 years of related experience 
• Knowledge of the C# programming language a plus 
• Visual Studio 2005 and beyond. 
• Knowledge of iSeries RPG, COBOL and CLP a plus. 
• Source Control (Vault, CVS, Visual Source Safe, TFS) 
• Strong knowledge SQL Server Integration Services (SSIS) 
• Strong knowledge in T-SQL programming and database design 
• Windows-based and Web-based development and tools. 
• Data communications and local area networks. 
• Experience with enterprise ETL solutions a plus 
• Knowledge of Distribution, Retail, Inventory Control, and Store Systems (POS) a plus 
• Knowledge of Financial, Medical, Insurance and Optical Systems a plus. 

All qualified applicants will receive consideration for employment without regard to race, creed, color, religion, national origin, sexual orientation, gender identity, disability, sex or age.