This job has expired, please see additional jobs below
Risk System Development Senior
Freddie Mac
Mc Lean, VA, United States
Job Details - this job has expired, please see similar jobs below
Position Overview
You responsibilities will fall into four primary categories:
ETL
• Cleanse, analyze, and develop ETL scripts to load large datasets into relational databases, and understand re-usability, parametrization, workflow design, etc.
• Maintain and manage technical meta data and documentation for data warehousing and ETL processes.
• Perform overall ETL solution design and creation of design specifications to implement changes.
• Provide timely, relevant, robust analyses to support capacity risk related business decisions.
• Develop, relatively quickly, a deep understanding of relevant data, systems and business background.
• Design appropriate analytical approaches for variety of business questions or scenarios presented.
• Participate in the development of an analytical framework containing data preparation, code and reporting to support baseline and ad-hoc analyses.
• Maintain collaborative working relationships with internal clients.
• Receive assignments in the form of analytics deliverables and determine how to manage task and priorities to meet schedules and goals.
• Often must lead a cooperative effort among members of the team. Manage the coordination of the activities of R&D dept.
• Lead the implementation of new data consumption capabilities to meet business needs.
• Develop and maintain a data consumption strategy inclusive of a multi-year roadmap.
• Provide timely, relevant, robust analysis to support credit-capacity initiatives.
• Manipulate and analyze large datasets (structured and unstructured data) using Big Data tools, Python, ETL tools etc.
• Present ideas and recommendations to management.
Database
• Maintain a strong knowledge of database concepts with working knowledge on SQL and Stored Procedures.
• Write, troubleshoot, and optimize SQL code and design (stored procedures, functions, views, triggers, indexes, constraints).
• Maintain an understanding of logical & physical data design, tables, normalization techniques, relationships, primary & foreign keys, and data types.
Automation/Production Support
• Participate in Requirements Analysis, design Applications based on System Requirements and Architecture, prototype if necessary, develop, unit test and deploy applications.
Analytical
• Independently determine and develop approach to solutions, while working under limited direction.
• Collaborate with team members and manage multiple priorities and meet deadlines.
• Demonstrate a constant and quick learning ability and be flexible to adapt to the new developing technologies.
Qualifications
• Degree in Statistics, Economics, Finance, Mathematics, Computer Science, Data Science or related field with 8-10 years of related experience
• 5+ years of data analysis experience, with a combination of business and technical skills. Experience analyzing and manipulating large data sets
• 5+ years of experience in Python, R, Big Data tools and technologies.
• 3-4 years of experience in ETL tools and technologies.
• Strong background in processing large volumes and variety of data (structured and unstructured data, XMLS, JSONs, PDFs).
• Self-motivated, pro-active, and results-driven problem solver
• Proven quantitative, analytical and problem-solving skills
• Strong oral and written communications skills
• Excellent SAS and SQL programming skills
• Must be able to manage multiple priorities, meet deadlines, identify and escalate issues appropriately to the management
• Strong leadership aptitude, ability to engage and influence internal and external stakeholders
• Excellent problem solving skills and the ability to handle pressure situations without compromising on quality
Preferred Skills
• Agile development methodology experience
• Experience with ParAccel/Matrix/Vertica
• Understanding of the secondary mortgage industry, experience with Freddie Mac and/or Fannie Mae
• Mortgage industry experience or financial/credit analysis
• Detail oriented and excellent organization skills
• Familiarity with project planning, risk management activities
• Experience working with JSON, XML and unstructured data
• Experience with columnar databases
• Experience with Unix Shell script, Autosys, Stored Procedures, Complex SQLs tuning, data replication between databases
Key to success in this role:
• A positive attitude towards learning
• Intellectual agility and interpersonal flexibility
• Strong consultation and communication skills
• Drive for execution and Innovation
• Ability to work with and collaborate across the team
• Deep curiosity to learn about new technologies and ways to do things better
Top 3 Personal Competencies to possess
• Customer Focus – Personally engage with customers to learn their needs. Deliver prompt and high quality customer service.
• Drive for execution – Treat obstacles as challenges to overcome, not excuses. Be accountable for strong individual and team performance
• Growth and Development – Know or learn what is needed to deliver results and successfully compete
Closing Statement
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.