Information Technology Business Analyst

Open for only W2/No third party vendors

USC or GC only

Job Title : IT Business Analyst Senior

Locations:. : Hybrid - Tuesday through Thursday - McLean, VA

Job Description:

Must Have Qualifications: Must have a strong analytical mindset, be comfortable taking the initiative, and be a proactive problem solver. The ideal candidate would be a quick learner who is motivated to hit the ground running. A solid understanding of querying and/or databases is required - to the extent that they must able to apply their own experience and knowledge to work with business and/or technical needs. Prior experience working with developers and/or technical teams is required. Must be proficient with MS Office Suite (specifically Excel, PowerPoint, and/or Word). Excellent written and verbal communication is key. Demonstrated experience collaborating and communicating effectively across various business areas, levels of experience and technical literacies is required.

Notes:

This a loan origination / loan processing application project

Team is using Mongo. For querying / databases they need to understand the concepts and understand how things work. They won’t be doing DB queries themselves

Must be able to use excel, create spread sheets, use excel functions like V Lookup and present findings as needed

Mortgage / Fintech industry is highly preferred but not required

Scoring, credit policy, market activities, support application underwriting space are some of the day-to-day activities.

Job Duties:

• Assists the Product Owner by updating mapping documents, business models and communicating with stakeholders regarding prioritized user-stories and write acceptance criteria in conjunction with product team for each sprint, making sure each story aligns to our Objectives and Key Results.

• Analyze complex data sets in JSON and XML formats to identify trends, patterns, and insights that drive business strategy and decision-making.

• Collaborate with stakeholders to gather and document business requirements, ensuring alignment between business needs and technical solutions.

• Develop and maintain organized data repositories, ensuring data integrity and accessibility for analysis.

• Identify opportunities for process improvement and efficiency enhancements, proposing actionable solutions based on data analysis.

• Manage multiple projects simultaneously, prioritizing tasks and deadlines to ensure timely completion of deliverables.

• Maintain clear and concise mapping documentation of analysis processes, methodologies, and findings for future reference.

• Enjoys troubleshooting a product/data questions.

• Works as a facilitator in meetings to bring tech and non-tech partners together to innovate and tackle problems • Use applications in various Non-production environments to test and demo product features • Understands and proactively utilizes Modern Delivery practices. Actively participates in all agile ceremonies (stand-ups, planning, refinement sessions, demo’s, etc.) • Actively uses and is passionate about available technology to help build product. Applications include JIRA, Excel for pivot tables/data analytics, Word, PowerPoint, Project, Visio Justinmind wireframes • Understands/quickly learns the basic tenets of credit and underwriting technology at Freddie Mac • Works with technical delivery team members and Single-Family Operations to define technical requirements in acceptable criteria • Comfortable being responsible to create Business Operational Readiness documentation to support all releases.

Qualifications:

• 5-7 years of financial services work experience, preferably combined with agile software development • Bachelor's degree or equivalent work experience • Mortgage related experience preferred, and moderate to strong MS Office and Excel data analytics skills • Experience working with and using Agile/Scrum methodology with active participation in Agile ceremonies. Certification from Scaled Agile Framework (SAFe) or Scrum Alliance preferred but not required • Strong presentation skills, including ability to facilitate meetings and work across Product teams • Comfortable learning, using and updating change control documentation per Change Management policies, procedures & processes • Support team in development process by working to define and test requirements based on product knowledge • Strong proficiency in data entities in context of SQL, JSON/XSD schemas, numeric, strings, enumerated, date and timestamps.

• Ability to understand and document Data Relationships ( such as one to many, many to many etc.),cardinalities of relationships, primary unique keys, constraints for data attributes of different types, understanding of NULL data, defaulting of data • Basic querying data skill in both relational and NoSQL databases (preferably Mongo DB) using database UI Client applications (e.g. Rapid SQL or any other, Compass for MongoDB database or similar). Perform as an active contributor throughout Product development by supporting both the Product Owner and developers • Ability to partner across the Freddie Mac organization to support Product team goals