Fannie Mae

Systems Analyst - AWS, SQL

Posted on: 19 Feb 2021

Herndon, VA

Job Description

Company Description

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.

Job Description

JOB INFORMATION

Design and develop computer applications and systems from existing systems, user needs and specifications, and software design constraints and software capabilities. Use structured methodology to define needs, develop and documenting technical requirements, and define coding specifications. May work with off-the shelf application software, proprietary organization application, or enterprise software which is being modified or customized for a particular report or analytic purpose. Brings to bear both knowledge of computer systems' capabilities and limitations and the business needs of client. May spec out estimated time and resources needed for a project.

KEY JOB FUNCTIONS
* Work with the business unit or other subject matter experts to identify or refine technical requirements for application under development or being revised.
* Document requirements for enhancements for specific application.
* Review and/or contribute content to requirements, design, or test documentation.
* Perform data analysis at various stages of project, in order to assure development of a quality application. Analysis can include requirements development, testing, or user acceptance.
* Contribute to application test plan, and evaluate test results to assist development or test staff.
* Assist project manager in task identification, resource allocations and schedule estimates for staff on assigned project in order to help keep project resourced appropriately and on track. May take lead on small projects or on segment of larger projects.
* Provide business domain and/or technology and/or process expertise and mentoring to others on team. Prepare or contribute to briefings of application owners at pertinent stages of project.

Qualifications

Education Level Required

* Bachelor Degree or Equivalent

Education Level Preferred

* Master or Other Advanced Degree

Area of Study Preferred

* Computer Science

MINIMUM EXPERIENCE

* 8-10 years of related experience

SPECIALIZED KNOWLEDGE & SKILLS

Required Skill:

* Strong data analysis work on AWS data storage services S3, Redshift, Glue, Dynamo DB etc.
* Very strong SQL programming skills
* Hands on experience with Oracle or equivalent RDBMS, SQL client tools such as Toad, Zeppelin notebooks, SQL Plus other SQL clients
* Strong MS Excel/Power-point skills
* Excellent problem-solving skills, strong verbal & written communication skills
* Ability to work independently as well as part of a bigger team

Desired experience:

* Tableau and/or Micro-Strategy reports/analytics experience
* Knowledge and experience with Tibco ESB/Messaging services
* Experience in ServiceNow or equivalent ticketing system
* Knowledge of Financial Products, Risk Management, Portfolio Management will be a plus but not mandatory
* A background in Finance or degree in Finance (Undergrad or Graduate program)
* ITIL, AWS certifications would be good to have

Additional Information

The future is what you make it to be. Discover compelling opportunities at careers.fanniemae.com.

Fannie Mae is an Equal Opportunity Employer, which means we are committed to fostering a diverse and inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, religion, national origin, gender, gender identity, sexual orientation, personal appearance, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation in the application process, email us at careers_mailbox@fanniemae.com.
REF1539B

Fannie Mae

Washington, DC

Federal National Mortgage Association provides a source of liquidity to the mortgage market and supports the availability and affordability of housing in the United States. It securitizes mortgage loans originated by lenders into Fannie Mae mortgage-backed securities (Fannie Mae MBS). The company operates in two segments, Single-Family and Multifamily. The Single-Family segment securitizes and purchases single-family fixed-rate or adjustable-rate, first-lien mortgage loans, or mortgage-related securities backed by these loans; and loans that are insured by Federal Housing Administration, loans guaranteed by the Department of Veterans Affairs and Rural Development Housing and Community Facilities Program of the U.S. Department of Agriculture, manufactured housing mortgage loans, and other mortgage-related securities. This segment also provides single-family mortgage, as well as credit risk and loss management services.

The Multifamily segment securitizes multifamily mortgage loans into Fannie Mae MBS; purchases multifamily mortgage loans; and provides credit enhancement for bonds issued by state and local housing finance authorities to finance multifamily housing. This segment also issues structured MBS backed by Fannie Mae multifamily MBS; buys and sells multifamily agency mortgage-backed securities; and offers delegated underwriting and servicing, as well as multifamily mortgage, and credit risk and loss management services. The company serves mortgage banking companies, savings and loan associations, savings banks, commercial banks, credit unions, community banks, specialty servicers, insurance companies, and state and local housing finance agencies. Federal National Mortgage Association was founded in 1938 and is headquartered in Washington, the District of Columbia.

Similar Jobs