Senior Systems /Data Analyst (SQL/SAS)

Mclean, VA
Jan 19, 2021
Jan 24, 2021
Full Time
Duration: 9 Months Project Info: - Regulatory Reporting FHFA Scorecard - This project is to address data quality issues related to loan data reported by FHFA Technical Must Haves: - SQL, System Analysis, Data Mining experience (Rapid SQL) - SAS is preferred. Soft Skill Must Haves: - Outgoing, Self-Motivated, Excellent Communication - They will need to be able to effectively communicate with developers (technically) and with product owners (business or layman-speak) Description: - Plan or modify procedures to solve complex problems considering equipment capacity and limitations, operating time and form of desired results - Prepare detailed specifications for programs - Provide experienced technical consulting in the definition, design and creation of a database environment - Advise development staff and end-users on databases - Participate in systems testing for project implementations Job Requirements: Duties - Analyze data quality issues: profiling, analyzing, identifying proper data sources using SQL - Move product towards desired end state by gaining an understanding of identified issues and the data environment then analyzing data to recommend a solution to Product Owner, Scrum Master, and developers - Work closely with core Modern Delivery/Agile team members to answer questions related to data analysis - Responsible for ensuring the final analysis product meets customers' expectations and addresses the identified issue - Ability to work independently and assertively with minimal direction to identify root cause of data issues - Strong communication skills to efficiently work with necessary business areas and translate complex data into business language Required - Strong analytical and problem-solving skills - Strong SQL experience - Ability to identify and propose innovative solutions - Excellent communication skills - Demonstrated ability to interact with both business and technical teams to achieve goals - Experience with Microsoft Office - Prior experience in mortgage industry - Data Mining experience - Root cause analysis experience - SPECIFICALLY, Root cause analysis of data quality issues in databases Preferred - Experience working with SAS - Experience working in an Agile environment - Familiarity with SF and/or MF MLIS Regulatory Reporting process As an equal opportunity employer, ICONMA prides itself on creating an employment environment that supports and encourages the abilities of all persons regardless of race, colour, gender, age, sexual orientation, citizenship, or disability.