Work with the team and departmental managers to create a prioritized list of reporting needs within Infrastructure
Elicit and analyze needs and translate / document information into reporting requirements
Import and build small databases for data mining
Acquire data from primary and / or secondary data sources and maintain databases
Use statistical methods to interpret data, analyze results, and provide ongoing reporting
Use data to create models that depict trends in portfolio financials and operational effectiveness
Run database queries in order to support data validation within reports
Filter and “clean” data to locate and correct code problems
Identify and recommend new ways to meet the Infrastructure reporting
Facilitate meetings to review data findings and metrics
Develop and update documentation to support new / changes to procedures
Develop, generate, maintain and monitor reports and files
Consolidate and create monthly decks providing operational metrics and key messages
Works under significant supervision of a Manager

1 year of Data Analyst experience with a Bachelor’s degree or equivalent transferable experience through coursework, internships or work experience.
Strong business and technology aptitude with a willingness to learn and understand business and software solutions.
Excellent verbal and written communications; ability to communicate and present requirements and issues clearly and concisely
Proficient with elaborate / complex MS Excel spreadsheets (e.g. formulas, pivot tables, graphs, etc.) or Access Database
Ability to build strong partnerships and to work collaboratively with all business and IT areas.
Highly motivated with strong organizational, analytical, and problem solving skills.
Strong communication and documentation skills.
Ability to effectively prioritize and execute tasks in a high-pressure environment.
Financial knowledge and aptitude
Ability to effectively use Microsoft Office products to drive data analytics and reporting.

Data Analyst Intern

Key skills