Data and Research Analyst - Springfield Technical Community College

GENERAL STATEMENT OF DUTIES:

Under the supervision of the Director of Institutional Research, the Data and Research Analyst supports decision-makers at all levels of the College, and through careful listening and interpretation, determines appropriate data for analysis, resulting in the accurate and timely provision of information. The analyst communicates and presents findings to various stakeholders and audiences throughout the College.

The Data and Research Analyst also performs data collection and analysis and contributes to the production of mandatory reports for the US Department of Education and the Massachusetts Department of Higher Education, as well as grant-related reporting.

JOB DESCRIPTION:

• Produce mandatory reports and submissions (e.g., HEIRS, IPEDS, Perkins CTE, Gainful Employment, SUCCESS, etc.) as assigned.
• Coordinate internal enrollment reporting and develop dashboard solutions with Tableau to track KPIs for various audiences.
• Collaborate closely with administrative and academic departments to ensure a common understanding of data requirements and data definitions.
• Build and maintain reporting solutions per requirements, to include managing, updating and maintaining the Institutional Research Data Mart and Custom Tables at regular intervals.
• Write simple to complex queries in Microsoft ACCESS or SQL Server Management Studio for data extraction, analysis, and management.
• Access relational databases and create/maintain documentation.
• Respond to recurring and ad hoc information requests from administrative offices and academic schools and departments.
• Perform other related duties as assigned and work flexible hours when necessary.

REQUIREMENTS:

• Bachelor's degree required.
• 2-3 years of relevant experience in data analysis, preferably in higher education.
• Knowledge of descriptive and inferential statistics and software (e.g., SPSS, R, SAS).
• Design and development experience with Business Intelligence tools including dashboards (e.g., Business Objects, Tableau, PowerBI).
• Familiarity with Colleague component architecture (data tables, fields) or similar ERP system and ability to quickly learn Colleague.
• Working understanding of key institutional business practices and reporting metrics.
• Microsoft Office Suite skills, including Excel and Access.
• Demonstrated ability to interpret specifications and design solutions.
• Strong project management Skills.
• Enthusiasm for problem solving; demonstrated ability to create effective solutions to complex tasks.
• Ability to communicate effectively with stakeholders at various stages of data fluency.

PREFERRED QUALIFICATIONS:

• Master's degree.
• 3-5 years of relevant experience in data analysis, preferably in higher education.
• Experience working in a community college.
• Extensive SQL experience (SSRS, SSIS).
• MS Office Suite mastery including MS Access and VBA experience.
• Experience creating systems and quality assurance documentation.

EQUIVALENCY STATEMENT:

Applicants who do not meet the qualifications as stated above are encouraged to put in writing precisely how their background and experience have prepared them with the equivalent combination of education, training and experience required for the responsibilities of this position.

WORKING CONDITIONS/PHYSICAL DEMANDS:

Working in an office setting. The noise level in the work environment is usually quiet. While performing the duties of this job, some movement is required in the office. The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery etc. Operates a computer and multiple technologies.

Salary: $68,000-$73,000, dependent on experience and qualifications
Benefits: Yes
Union: Non-Unit Professional (NUP)
Grant Funded: No
Closing Date: Open until filled

All candidates must have legal authorization to work in the United States. Springfield Technical Community College is not sponsoring H1B Visa.

INFORMATION AWARENESS SECURITY TRAINING:

Candidates for employment should be aware that all STCC employees are required to complete Information Awareness Security Training within thirty days of their orientation date and annually thereafter.