Job Details

The intern will be working in both the Corporate Data warehouse (CDW) development team and the Data Modeling team. 

• The CDW’S development team builds and maintains a centralized corporate data platform which extracts data from disparate data sources residing within Freddie Mac's transaction processing and end-user systems.  This data is used for decision support, management reporting, ad-hoc and trend analysis, modeling and data mining purposes.
• The Data Modeling team defines and analyzes data requirements across all of Freddie Mac’s IT application projects.  The team takes these requirements and builds models that are standard, consistent, and predictable.  These models ultimately become the databases used for applications.

The intern will perform a variety of tasks including data analysis, writing documentation, and project coordination.

Job Functions (What will the employee do over the next 16 weeks; create, capture, verify, submit, design, analyze, develop, etc.  Is the work baseline, project or a mixture)

1. Verify that that the data models in production are consistent with the data models in the ER Studio tool.  This will include creating a schedule to complete this work and preparing the environment.
2. Analyze and suggest database storage availability for non-production environments for the Corporate Data Warehouse.
3. Review existing SharePoint sites and design a new SharePoint site for both teams.
4. Develop and keep project schedules and issue/risk logs up to date in Planview or MS Project.

Basic Requirements (required skills ex. MS Access, Java, SQL

1. MS Office Suite
2. SharePoint
3. SQL
4. Strong writing skills

Preferred Skills (skills that would be beneficial but not required to do the job)

1. Planview
2. ER Studio