Analyst, Process Modeling & Tools

Freddie Mac
McLean, VA
Oct 11, 2019
Nov 09, 2019
Full Time
Does the phrase 'extract, transform and load' make you smile because you love aggregating data from multiple sources? Can you recite the generally accepted definition of data quality on demand? Can you carry on a conversation about the benefits of data profiling? If you understand how data lineage techniques can help organizations avoid potential liabilities, we want you on our growing team!

In this role you will interact on a regular basis with Technology to manage data integration updates to the Enterprise Operations owned technology platform such as ARIS, Denodo, Fusion RM etc. That information is leveraged to provides insight into operational risks and the operational health of Freddie Mac's mission-critical business processes. Through your regular touchpoints with technology and the Business resiliency teams you will help ensure that Freddie Mac continues functioning in the event of a crisis by setting and maintaining high data quality standards across the Enterprise Operations (EO) tool ecosystem.
  • Support all ARIS (Software AG Product for Business Process Modeling) & OASIS (Internally developed data service platform using Denodo and Micro Strategy) along with data integration interface requirements
  • Responsible for ARIS data quality
  • Closely work with and support objectives / priorities set by Tech Lead / Manager for EO Tools management to ensure the ARIS, OASIS strategic roadmaps are aligned to corporate priorities
  • Build / Modify process models for all critical process as needed by various business leads.
  • Help design and deliver analytical reports for practitioners and management
  • Identifies potential new data sources both on the ingestion and help develop interface definitions or transformation requirements
  • Provide requirements to IT for new OASIS data interfaces
  • Communicate data quality findings with interactive data visualizations
  • Maintain a repository of the reports you prepare that is centrally accessible to Enterprise Operations management
  • Support any data integration transformation and reporting requirements as assigned


  • Have at least 3+ years related experience
  • Bachelor's degree in Management Information Systems, Finance, Accounting or related study
  • Ability to interact professionally with a diverse group - executives, managers, and subject matter experts
  • Expertise in querying, analyzing, reconciling and testing complex relational data
  • 2+ years of experience in data architecture, data modeling, and/or data integration
  • Strong understanding of data quality techniques
  • Expertise in querying, analyzing, reconciling and testing complex relational data
  • Proficiency in Microsoft Office, MicroStrategy or other Business Intelligence tools.
  • Must have strong working knowledge on Software AG's ARIS (Process modeling) tool set / Data virtualization services such as Denodo.

Keys to Success in this Role
  • Strong analytical skills
  • Good inter personal skills
  • Team player
  • Out of the box thinking

Top 3 Personal Competencies to Possesses
  • Partnership: Build trust and strong partnerships through my own and my team's actions
  • Drive for Execution: Be accountable for strong individual and team performance
  • Customer Focus (Internal and External): Personally engage with customers to learn their needs

Preferred Skills

Preferred Skills
  • Financial Services and/or mortgage industry experience is preferred
  • Background in graphic design a plus
  • Background in user experience design a plus
  • Basic understand of Fusion RM is a plus

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. Freddie Mac is an equal opportunity and top diversity employer. EOE, M/F/D/V.

Similar jobs