JOB TITLE: Database Analyst/Programmer
LOCATION: Scranton, PA/NY PREPARED BY:POSITION OVERVIEW:
Experience in Database Coding and Analysis of Microsoft SQL databases is a requirement of this position. Responsibilities will encompass an enterprise wide scope in terms of managing, surfacing and controlling corporate data assets and providing support for data access, data definition and data management. Desirable talents include the ability to work with business analysts to develop and execute data migration plans, administer data management procedures and support and rectify daily operational production issues. Other duties will include working with other groups in the organization to help adhere to proper data standards when creating new products.
Experience with MS SQL Server 2000/2005/2008 preferred.
Technical knowledge of MS SQL Server internals with emphasis on query performance.
Expertise in C# scripting focused on data manipulation and transformation.
Experience in designing and creating complex SSIS based programs is a Plus.
ESSENTIAL DUTIES & RESPONSIBLILITIES:
Create and debug stored procedures in cooperation with application developers.
Enforce and support published data promotion standards.
Create and debug views and SQL functions to support data and application access.
Adhere to corporate ethics policies with regards to confidentiality of information.
Contribute to departmental performance by completing other related duties as assigned.
Reports to Data Management Manager
Works with minimal supervision
Works in close cooperation with other data team members
Works closely with PMO and business teams
EDUCATION AND EXPERIENCE:
Competent to work at a technical level of all phases of data management activities.
Strong problem solving and analytical skills.
Demonstrated proficiency with SQL DB programming
Requires a bachelor's degree with emphasis in computer science or management or equivalent level of experience.
A plus would be experience constructing SSIS packages.
Strong interpersonal, communication and organization skills.
Good written and verbal skills.