Data & Research Analyst

The Data & Research Analyst works closely with the Executive Director to develop, manage, and maintain various data-driven processes and applications, including reporting and analysis, data integrity and security to support Columbia College and its units, which serve students in multiple schools including Columbia College and The Fu Foundation School of Engineering and Applied Science. This includes working with large data sets, performing various processes including ETL, and expertly understanding various data sources to effectively perform analysis, assessment, and reporting. The incumbent is an integral member of a team that focuses on data mining, reporting, analysis, research design, implementation and analysis and will participate in implementing the strategic plan for the team to meet larger goals and objectives around analytics and data.

RESPONSIBILITIES:

Work with the Executive Director and partner offices to 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 in Columbia College.
Provide quantitative and qualitative analysis and feedback for research, surveys, and assessments and help facilitate design, execution, and reporting on research findings for use in strategic planning and policy development/implementation across Columbia College. Create framework for forecasting and modeling projects.
Locate and evaluate available source data and 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. Develop procedures, reports, and processes to verify the integrity of information and ensure data security and maintain the quality and integrity of all data used to develop reports by creating processes to clean synchronize and/or update data.
Work with Executive Director and other 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, be available as needed for technical and other support during critical periods, and perform other related duties as assigned.

Minimum Qualifications for Grade

Applicant MUST meet these minimum qualifications to be considered an applicant

Bachelor’s degree or equivalent required. A minimum of two years of related experience, or a combination of education and experience required.

Additional Position-Specific Minimum Qualifications

Applicant MUST meet these minimum qualifications to be considered an applicant

Experience with data and analysis processes such as ETL, Cubes, and Reporting services required. Familiarity with database design, relational database software or equivalent, and student information or related system. Proficiency in MS Office, especially MS Excel and Word required. 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, communication, 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. Must be an innovative and analytical thinker who has the ability to work collaboratively and independently. Excellent attention to detail as well as ability to conceive of the larger picture in relation to strategic planning required. Must have the ability to exercise sound judgment, discretion and tact in a highly confidential professional setting.

**Applications submitted without a resume and cover letter will not be considered**

Special Instructions

Preferred Qualifications

Experience with SQL Server Reporting Services, or other enterprise level reporting tool is preferred. Knowledge of an object-oriented language such as Java, C++, desirable. Knowledge of and experience with both qualitative and quantitative statistical methods in survey, research, or assessments is preferred. Experience with statistical analysis software such as SPSS, R, and Python preferred.

Essential Functions

Additional Essential Functions (Limit to 3950 characters.)

Special Indications

This position works with:
HIPAA Compliance training required

No Response

Participation in Medical Surveillance required

No Response

What type of posting? Is this a waiver request?

Standard Posting

Requisition Open Date

05-15-2018

Requisition Close Date