Business Requirements and Testing Analyst

Location: McLean, VA


Responsibilities include:
• Become the subject matter expert on the business domain. Plays a key role in influencing the stakeholders regarding various strategies, solving problems and decision-making. (Negotiation, building stronger partnerships, business savviness – working with different type of clients).
• Work with end users to build and maintain the terms and definitions for business information and data sets so that they can be organized in business context for easier reporting and analytics.
• Work with business stakeholders to ensure that the business contexts, sub-domains within are consistent with data management best practices and standards.
• Work with technology partners to ensure that the business requirements are understood, and technical solutions are designed and implemented to support desired business functionality.
• Collaborate with team members and interact across organizational lines to meet business objectives.
• Gather business and system requirements for data movement and controls, develop and document mappings and rules. Handle requirements document.
• Capture requirements for R&D and exploratory analysis to understand requirements and data.
• Establish good partnership with Data Architecture team to ensure that the data model is designed to meet the business needs.
• Functional expertise with a technical background.
• Solid understanding of business & systems needs and detail requirements to ensure business requirements are translated correctly.
• Engaged with developing SIT/User Acceptance test cases and data sets. Collaborate and support SIT/UAT testing throughout the project.
• Develop test cases, test scripts and perform sit/user acceptance testing for data application projects.
• Gather and document Business Operational Readiness Review document.
• Facilitate requirements meetings and influence decisions.
• Works on issues of diverse scope where analysis of situation or data requires evaluation of a variety of factors, including an understanding of current data management trends.
• Have experience manipulating and analyzing large datasets including using statistical software.
• Devise solutions that are innovative, thorough, and practicable.
• Works under minimal direction. Independently resolves and develops approach to solutions.
• Analyze large datasets (Structured and Unstructured data – XMLs, JSONs, PDFs) using big data platform.
• Under minimal supervision, perform design and operation effectiveness testing of IDEA data sources
• Document test execution, ensuring that all appropriate risks are identified and documented.
• Contribute to a team of experienced and junior staff that executes testing activities
• Perform IDEA testing per plan and complete follow-ups to ensure that they are completed timely and aligned with the corporate testing standards
• Prepare test reports that identify and communicate issues and recommendations where necessary
• Assist with the development and maintenance of detailed procedures that document test plans and scripts
• Partnering with appropriate groups within IDEA and SF Risk users to ensure timely and appropriate corrective actions are implemented
• Providing senior management with timely status updates and communication of issues
• Assist with management reporting related to testing activities
• Would be required to engage using Python, PySpark, PIG, HIVE scripts to filter/map/aggregate data.
• Must be able to handle multiple priorities and meet deadlines.
Qualifications
• Bachelor’s degree in Business Administration, Computer Science, Data Analytics, Information Systems, Finance or a related discipline or equivalent work experience.
• 5 plus years of experience in people management
• 8 plus years of experience as Business/Data Analyst and overall dynamic experience supporting divisional / enterprise data driven initiatives.
• 8 plus years of data analysis experience, with a combination of business and technical skills.
• 8 plus years of SQL programming experience.
• 8 plus years of SAS/Python or similar programming experience.
• 5 or more years of Testing experience within the financial services industry
• 4 plus years of experience working with Pyspark, Hadoop, JSON, XML and CSV files.
• 4 plus years of data mart/database/ETL experience.
• Experience handling multiple projects under a program management.
• Experience in Agile software development environments.
• Strong quantitative, analytical, and problem-solving skills
• Strong knowledge of Data Platforms such as Databases, Non-SQL Data Repositories, Big Data.
• Experience documenting business processes and functions
• Ability to analyze and assess the adequacy of test scenarios and identify opportunities for test script improvements
• Experience with test automation tools
• Experience with test and defect tracking tools
• Excellent verbal and written communication skills
• Ability to think critically and logically to perform data analysis.
• Ability to develop effective relationships across the firm, including with senior leaders
• Proactive self-starter with good people skills and a strong work-ethic


Preferred Skills
• Knowledge of secondary mortgage market and Freddie Mac’s business
• Understanding of Loan Origination, securitization, and/or middle and back office functions
• Foundational knowledge on AWS Data Platforms, Artificial Intelligence and Machine Learning.
• Experience working with Version One or JIRA or similar tool.
• Proficiency in excel and powerpoint required