Application Development Analyst (ETL, SQL Server)

Location: Urbana, VA


The ideal candidate manages, executes, monitors, and validates production transactions/activities to ensure accuracy and adherence to guidelines and mitigation of operational risk. In this role the incumbent will be responsible for the following: 

Monitor, analyze and accurately execute medium to high complexity transactions to support business operations 
Work across business units to improve monitoring, discover issues, mitigate risk and deliver better value to the customer 
Identify, appropriately escalate, and evaluate solutions for operating gaps or other potential adverse conditions that could pose risk to the control environment. 
Identify and resolve customer transaction reporting, processing, accounting and control issues. 
Analyze data, research issues, work through exceptions, and resolve discrepancies under limited guidance of leadership (as required). 
Report on common sources of technical issues or questions and make recommendations for fixes and enhancements 

Requirements: 
2+ years’ experience with SQL Server database 
Ability to write high performing complex queries 
2+ years’ experience in and knowledge of performing extract, transform and load (ETL) processes using SSIS 
Experience in and knowledge of database design, conversions 
Writing database ETL jobs in SSIS from Multiple data sources 
Experience with optimizing and tuning queries 
Assist in coordinating software releases 
Must have enterprise, full development life cycle experience 
Excellent organizational and problem solving skills 
Excellent verbal and written communication skills 
Ability to perform Data Analysis 
Experience in automating jobs and providing operational support

Database knowledge is huge for this role. Need someone with hands on experience in SQL server environment, be able to maintain ETL jobs, handle database related issues, be able to pull data from different databases/ sources ( Excel, Oracle, Access, etc.), experience with production support, data analysis -- Mortgage industry is a nice to have but not required