ESSENTIAL DUTIES AND RESPONSIBILITIES
To be effective, an individual must be able to perform each job duty successfully.
Assesses business requirements, develops functional specifications, and develops data related solutions.
Writes and maintains stored procedures, functions, or queries meant to assist the organization in accessing and analyzing business data.
Develops standard and custom reports using SQL Server Reporting Services.
Develops and implements ETL functions and processes for incoming and outgoing data transfer.
Documents workflow, enhancements, and QA processes.
KNOWLEDGE, SKILLS, and ABILITIES
The requirements listed are representative of the knowledge, skills, and/or abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.
Minimum 5 years experienceMSSQL.
Minimum 5 years experience ETL using SSIS, SSRS and Kimball method.
Working knowledge of .NET 4.0 and above, XML and Json.
Financial institution experience a plus.
MSSQL DBA experience a plus.
Four-year college degree or equivalent
Has no supervisory/ managerial responsibility
PHYSICAL ABILITIES / WORKING CONDITIONS
Ability to talk, sit, and hear consistently. Ability to stand, walk, and use hands to handle or reach occasionally
Close vision (clear vision at 20 inches or less) Distant vision (clear vision at 20 feet or more)
Color vision (ability to identify and distinguish colors)
Weight Lifted or Force Exerted
Ability to lift up to 10 pounds occasionally