Freddie Mac

At Freddie Mac, you will do important work to build a better housing finance system and you’ll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation.

Position Overview:

Are you a data modeler who loves new challenges and are interested in modeling for the newest data storage technology? Freddie Mac is at a transitional stage with its data storage to take advantage of cloud computing as well as NoSQL data storage. This position involves working closely with project teams to understand business data requirements and provide data modeling domain expertise. We are seeking a modeler who will translate the requirements into logical and physical data models, and generate the DDL/JSON which will then be used build and modify databases. Project work is done in Waterfall, Agile, and Modern Delivery, and includes traditional databases (i.e. DB2, Oracle), Postgres, Snowflake and NoSQL databases such as MongoDB and Data Lakes.

Our Impact:

We help to ensure the high quality of data required for Freddie Mac to be successful!

Your Impact:

Develop logical and physical data models for Traditional Data Stores and NoSQL

Ensure data objects enforce to defined Freddie Mac standards and standard methodologies

Baseline DDLs

Develop, test, and implement scripts, programs, and related processes to collect, handle, and publish DEV and PROD metadata from data models

Develop DDL implementation/back-out plans

Promote data models into production metadata environments.

Support DDL PROD implementation. Support post-production validation of DDL.

Ability to query and analyze data.

Qualifications:

• 5-7 years of data modeling and metadata management experience.
• Bachelor Degree from an accredited university with coursework in Business, Information Technology, or Engineering preferred or equivalent work experience.
• Experience with both relational, dimensional, and NoSQL data modeling.
• Experience with data management standards and data model practices
• Experience with physical data structure design in DB2, UDB, Oracle, Sybase, SQL Server, Postgres, Snowflake and/or MongoDB using ER/Studio DA or Erwin.
• Experience with querying databases and analyzing data.

High Level Technical Skills

• Experience with query capabilities such as Visual Basic macro development and SQL
• Experience using ClearCase, GIT, Remedy, ER/Studio DA
• Mortgage/finance industry data modeling experience.
• Demonstrable ability to quickly earn the trust of key partners
• Thrives in an environment with changing priorities
• Sound business and technical skill
• Focused and versatile teammate that is comfortable under pressure
• Excellent problem-solving and critical-thinking skills
• Able to navigate through a large corporate environment and ensure appropriate processes are met

Keys to Success in this Role:

• Have a deep understanding of modeling theory and technologies.
• Good communication skills, you will be responsible for interfacing and working with multiple project teams across Freddie Mac.
• Eager to work on multiple projects concurrently, independently and be self-motivated!

Current Freddie Mac employees please apply through the internal career site.

Today, Freddie Mac makes home possible for one in four home borrowers and is one of the largest sources of financing for multifamily housing. Join our smart, creative and dedicated team and you’ll do important work for the housing finance system and make a difference in the lives of others.

We are an equal opportunity employer and value diversity and inclusion at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by applicable law. We will ensure that individuals with differing abilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Notice to External Search Firms: Freddie Mac partners with BountyJobs for contingency search business through outside firms. Resumes received outside the BountyJobs system will be considered unsolicited and Freddie Mac will not be obligated to pay a placement fee. If interested in learning more, please visit www.BountyJobs.com and register with our referral code: MAC.

Time-type:Full time

FLSA Status:Exempt

Freddie Mac offers a comprehensive total rewards package to include competitive compensation and market-leading benefit programs. Information on these benefit programs is available on our Careers site.

This position has an annualized market-based salary range of $111,000 - $167,000 and is eligible to participate in the annual incentive program. The final salary offered will generally fall within this range and is dependent on various factors including but not limited to the responsibilities of the position, experience, skill set, internal pay equity and other relevant qualifications of the applicant.