Data & Research Analyst

Position Summary

The Data and Research Analyst develops, manages, and maintains various data-driven processes and applications for reporting and analysis related to academic and curricular reporting for Columbia College. The Analyst supports data integrity and data security, while working with large data sets and performing various processes utilizing ETL. The incumbent will work with various data sources to perform analysis, assessment, and reporting. As an integral member of the team, the analyst will assist with data mining, research design, and strategic goals and objectives around analytics and data.

Responsibilities

• Create, maintain, and document innovative, user-friendly front-end reporting tools and platforms that provide point-and-click ability to produce reports for operational and analysis needs. Build and maintain databases and automate data processes, including ETL, SQL, stored procedures, SSRS, SSIS, etc., for in-house and third-party databases. Create and provide ad-hoc reports and datasets in response to requests from various departments.
• Provide quantitative and qualitative analysis and feedback for research, surveys, and assessments; help facilitate design, execution, and reporting on research findings for use in strategic planning and policy development/implementation. Create framework for forecasting and modeling projects.
• Research and evaluate available sources of data to extract, clean, and manipulate datasets for use. Facilitate processes that translate data into actionable insights in order to solve problems, provide insight, and optimize operational processes and improve efficiency.
• Work with partner offices across the University on survey design and implementation
• Collaborate with team members to plan short- and long-term projects, and participate in implementing strategic initiatives around research, forecasting, analysis, and reporting.
• Work on special projects as deemed relevant and be available as needed for technical and other support during critical periods.
• Other related duties as assigned.

Minimum Qualifications

• Bachelor's degree or equivalent required.
• A minimum of 2 years of experience, or combination of education and experience.
• The ability to work with a high degree of independence and accountability as a member of a cohesive team.
• Excellent verbal and written communications skills.
• Proficiency in SQL and query and reporting analysis tools including ETL, cubes, and reporting services.
• Familiarity with relational database design.
• Proficiency with the Microsoft Office Suite, especially Excel.
• Ability to prioritize and manage multiple tasks under short and changing deadlines, while ensuring timely and accurate execution.
• Proven ability to create project plans and successfully complete projects.
• Excellent analytical, organizational, and interpersonal skills required; ability to analyze and interpret complex data sets, make findings relevant, and explain data and technology to a general (non-technical) audience.
• Act as an analytical thinker with the ability to work collaboratively and independently.
• Must have the ability to exercise sound judgement, discretion and tact in a highly confidential professional setting.

Preferred Qualifications

• Experience with SQL Server Reporting Services (SSRS) or other enterprise-level reporting tool is preferred.
• Knowledge of an object-oriented language such as Python or R.
• Experience with both qualitative and quantitative statistical methods in survey design, research, or assessments is preferred.
• Experience using student information systems (SIS) and/or high-level enterprise resource planning (ERP) systems.