SyApps is a Technology and Management Consulting Services firm based in Greater Washington area, with focus on solutions in the area of Strategy, Process, Technology and Management support. As a diverse end-to end IT and Management solution Provider, SyApps offers a range of expertise aimed at helping customers re-engineer and re-invent their business to compete successfully in an ever-changing marketplace.
Please visit us at www.syapps.com.
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
Location: Urbana, MD
SyApps LLC is a Winner of the SmartCEO/Grant Thornton Future 50 Award for being recognized as one of 50 fastest growing companies in the Greater Washington Area.