Sr. Data Modeler

At Fannie Mae, the inspiring work we do helps make a home a possibility for millions of homeowners and renters. Every day offers compelling opportunities to impact the future of the housing industry while being part of a collaborative team thriving in an energizing environment. Here, you will grow your career and help create access to affordable housing finance.

Job Description

As a valued colleague on our team, you will contribute to developing data infrastructure and pipelines to capture, integrate, organize, and centralize data while testing and ensuring the data is readily accessible and in a usable state, including quality assurance.

THE IMPACT YOU WILL MAKE 
 

The Sr. Data Modeler role will offer you the flexibility to make each day your own, while working alongside people who care so that you can deliver on the following responsibilities: 

•  Competitive Logical Data modeler with experience in ER Studio and Magic Draw tools 

•  Semantic Modeling and Knowledge Graph experience is highly desired 

• As a valued colleague on our team, you will contribute to developing data infrastructure and pipelines to capture, integrate, organize, and centralize data while testing and ensuring the data is readily accessible and in a usable state, including quality assurance. 

• Identify customer needs and intended use of requested data in the development of database requirements and support the planning and engineering of enterprise databases. 

• Maintain comprehensive knowledge of database technologies, complex coding languages, and computer system skills. 

• Support the integration of data into readily available formats while maintaining existing structures and govern their use according to business requirements. 

• Analyze new data sources and monitor the performance, scalability, and security of data. 

• Create an initial analysis and deliver the user interface (UI) to the customer to enable further analysis. 

THE EXPERIENCE YOU BRING TO THE TEAM 

Desired Experiences 

• Bachelor degree or equivalent 

• 5+ years 

• Semantic Modeling 

• Knowledge Graph 

 

Skills

• Product Development including designing products, developing product roadmaps, translating design requirements, prototyping, etc. 

•  Experience helping an organization to plan and manage change in effort to meet strategic objectives

• Product Testing including testing and evaluating software, usability testing, UAT, and using relevant product testing technology

• Experience in the process of analyzing data to identify trends or relationships to inform conclusions about the data

• Business Insight including advising, designing business models, interpreting customer and market insights, forecasting, benchmarking, etc.

• Risk Assessment and Management including evaluating and designing controls, conducting impact assessments, identifying control gaps, remediating risk, etc.

• Experience monitoring and managing operation systems (OS), and staying current on patches, upgrades, and other elements of the OS

• Skilled in documentation and database reporting for the purposes of analysis, data discovery, and decision-making with the use of relevant software such as  Excel, or SSRS

• Skilled in creating and managing databases with the use of relevant software such as relational database and graph databases

• Skilled in discovering patterns in large data sets with the use of relevant software such as Oracle Data Mining or Informatica

• Adept at managing project plans, resources, and people to ensure successful project completion

• Communication skills including communicating in writing or verbally, copywriting, planning and distributing communication, etc.

• Skilled in the graphical representation of information in the form of a charts, diagrams, pictures, and dashboards with programs and tools such as Excel, Tableau, or Power BI 

​

Tools

• Skilled in AWS Database products such as Neptune, RDS, Redshift, or Aurora 

• Skilled in JSON 

• Skilled in ER Studio and Magic Draw 

• Skilled in Oracle PL SQL

• Skilled in Jenkins

• Skilled in XML

• Skilled in AWS Analytics such as Athena, EMR, or Glue

• Experience using JIRA

• Skilled in Oracle Database

• Skilled in TOAD SQL database management tool

• Experience using APIs for developing or programming software

• Skilled in SQL 

Qualifications

Data Modeling

Education:

Bachelor's Level Degree (Required)

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

For most roles, employees are encouraged to work onsite on a regular basis at their designated office location. In-office work cadence is determined by your manager. Proximity within a reasonable commute to your designated office location is preferred unless the job is noted as open to remote.

Fannie Mae is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, religion, sex, national origin, disability, age, sexual orientation, gender identity/gender expression, marital or parental status, or any other protected factor. Fannie Mae is committed to providing reasonable accommodations to qualified individuals with disabilities who are employees or applicants for employment, unless to do so would cause undue hardship to the company. If you need assistance using our online system and/or you need a reasonable accommodation related to the hiring/application process, please complete this form.

The hiring range for this role is set forth below. Final salaries will generally vary within that range based on factors that include but are not limited to, skill set, depth of experience, certifications, and other relevant qualifications. This position is eligible to participate in a Fannie Mae incentive program (subject to the terms of the program). As part of our comprehensive benefits package, Fannie Mae offers a broad range of Health, Life, Voluntary Lifestyle, and other benefits and perks that enhance an employee's physical, mental, emotional, and financial well-being. See more here.

Requisition compensation:

121000

to

158000