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:

The Senior Data Modeler will be part of the Freddie Mac's Enterprise Risk Management Technologies Team within Enterprise Business Technology Office. This team is responsible for partnering with the Enterprise Risk and Compliance organizations to define strategies, roadmaps, objectives, and deliver capabilities that transform the businesses. This role will be responsible for supporting our organization’s data-driven initiatives, collaborating with business partners and multi-discipline technology teams, and designing and implementing data modeling solutions! This position requires strong experience in data analysis, modeling and architecture with ability to translate complex technical issues into easily understood communications that will influence executive audiences with varied technical backgrounds and capabilities.

Our Impact:Delivery of Enterprise Risk Management solutions and data to optimally assess and track all risks, issues, controls, and compliance.Delivery and support of solutions for common Enterprise Risk Management (ERM) data platform to enable effective ERM data analytics and reportingAdoption of FHFA comprehensive Regulatory Reporting modifications and resolution of outstanding data quality issuesModel data to deliver reports and provide business with information and data needed to drive efficiency t and support self-service analyticsArchitect data integrations between ERM and other systemsPresent historical data clearly to facilitate strategic decisionsYour Impact:Business requirements gathering and solutioning in alignment with enterprise business data strategyArchitecting and documenting data warehouse solutions using data modelingDesigning and delivering reports using data visualization, analytics, and BI reporting tools like Tableau, Micro Strategy, Alteryx, Power BI, etc.Following reporting development life cycleMeeting business objectivesAbility to validate data to ensure completeness and accuracyQualifications:Bachelor’s degree in computer science, information technology or related field5-8 years’ experience in a logical/physical data modeling, data architecture, data analysis, and data management roleExperience with data modeling tools like ERwin, ER/Studio or Power DesignerExperience with different query languages such as PL/SQL, T-SQL, and ANSI SQLBroad understanding of structured, semi-structured, and unstructured data and message formats (such as XML, JSON, etc.)Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, SQL Server, MySQL, and AWS cloud databasesKnowledge of data warehousing and business intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data martsRisk and GRC products experience preferredKeys to Success in this Role:Ability to operate as a self-motivated, pro-active, and result-driven problem solver with excellent analytical and interpersonal skillsQuick learner of new technologies, tools, concepts and ability to translate them to challenge the status quoExcellent problem-solving skills and attention to detailEffective communication and interpersonal skillsAbility to work independently and in a team environment

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.

CA Applicants:  Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

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 $114,000 - $170,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.