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
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