Application Dev Analyst-F32805d

Syapps Urbana , MD 21704

Posted 4 months ago

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.

Description

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

Travel: No

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.


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Security Engineer II

Fannie Mae Corp

Posted 4 days ago

VIEW JOBS 11/18/2018 12:00:00 AM 2019-02-16T00:00 THE COMPANY Fannie Mae provides reliable, large-scale access to affordable mortgage credit in communities across our nation. We are the leading source of funding for housing in America, which means more people can buy or rent a home. We are focused on sustaining the housing recovery, improving our company, and leading change to make housing better. Join our diverse, high-performing team and make a difference as we work together to enable access to a good home. For more information about Fannie Mae, visit http://www.fanniemae.com/progress JOB INFORMATION Design and implement systems and procedures to sustain the security, integrity, and availability of the organization's data. Assess risk of exposure of proprietary data through weaknesses in platforms, access procedures, and forms of access to the organization's systems and the data contained in them. Track security violations and identify trends or exposures that could be addressed by additional training, technical measures, or use of application tools to enhance security. May participate in simulated attacks or security violations to assess the organization's data security measures. KEY JOB FUNCTIONS * Contribute towards documentation and our knowledge share, suggesting KB articles and enhancements to our baselines, runbooks, guides, setups and configurations. * Expert at assessing non-standard client requests. If current capability doesn't exist or is not effective, able to precisely articulate request, analyze options, and determine feasibility through detailed knowledge of service and technology. Capable of proposing and driving implementation of capability. * Owns lifecycle maintenance of all InfoSec products and applications – Patch, License, certs, software updates and upgrades. * Audit tickets for quality and accuracy while ensuring tickets and communication to customers follows SLA guidelines. * Communicate effectively with variety of internal customer contacts to include technical contacts and executive contacts. * Must own and drive improvements to training and changes to SME model. * Responsible for baseline metrics and overall improvement of the service. * Capable of handling a variety of priorities and deliverables in an operational, interruption driven environment with minimal guidance or supervision. * Act as mentor and train junior engineers on processes, subject matter and soft skills. * Participate and run proof of concept builds for Security Solutions and configurations. * Engagement with vendors for system operation, detailed design, and best practices evaluation regarding project initiatives and escalated incidents or problems. * Examine and/or test new methodologies or tools that could be adopted to enhance security of platforms, infrastructure, or access to data. * Conduct platform or operating system vulnerability scans that assess exposure of system to attacks or hacking. Monitor Security Operations pager and respond to issues of potential viral activity, spam, phishing, etc. * Investigate events or incidents of apparent security breaches and report to appropriate authorities using corporate procedures. * May plan and/or conduct tests of the core infrastructure and the contingency environment for critical business applications to ensure business continuity in the event of a computer security incident. * Aggregate metrics of operation of security controls, as well as apparent attacks, breaches, and other pertinent data; track trends and prepare for periodic security reports. * Participate in projects designed to test defenses against hacking, denial of service, spam, break-ins, or similar attacks. May provide guidance to infrastructure or application staff participating in exercise. EDUCATION * Bachelor's Degree or equivalent required. * In lieu of a degree, combination of education and a minimum of 5 to 6 years of related work experience. MINIMUM EXPERIENCE * 4 years of related experience. SPECIALIZED KNOWLEDGE & SKILLS * 5 to 10 years of related work experience. * Experience with focusing stakeholders, assessing root cause of issues and making time sensitive recommendations. * Strong experience conducting various projects and customer engagement to manage the delivery of service and expectations. Experience designing, integrating, and optimizing security solutions. * Experience building and administering related alerting and monitoring systems. * Capable of systems-level debugging and troubleshooting. * Knowledge of network architecture, protocols, and standards. * Ability to script or code in at least one language. (BASH, C#, PowerShell, Python preferred). * Contribute towards documentation and our knowledge share, suggesting KB articles and enhancements to our baselines, runbooks, guides, setups and configurations. * Expert at assessing non-standard client request. * Strong capability of handling a variety of priorities and deliverables in an operational, interruption driven environment with minimal guidance or supervision. * Experience working with collaborative teams. * Strong problem solving and analytic skills. * Strong interpersonal and communication skills. * Strong documentation, multi-tasking, and time management skills. EMPLOYMENT As a condition of employment with Fannie Mae, any successful job applicant will be required to pass a pre-employment drug screen and to successfully complete a background investigation. Fannie Mae is an Equal Opportunity Employer. Fannie Mae Corp Urbana MD

Application Dev Analyst-F32805d

Syapps