IT Data Analyst
Job Description
Martinsburg, WV onsite role supporting institutional data reporting, grant analytics, and business intelligence development.
Responsibilities
- Act as the primary data analyst for the Title III C5 Grant, ensuring timely and accurate reporting of grant objectives, performance measures, and compliance requirements.
- Collect, validate, analyze, and report data needed for federal, state, institutional, accreditation, and grant-funded programs.
- Partner with grant leadership, project directors, and administrative departments to collect, validate, analyze, and report Title III C5 Grant data.
- Build, maintain, and automate recurring reports, dashboards, and data visualizations for college leadership and stakeholders.
- Support planning, development, implementation, and ongoing maintenance of the College’s data warehouse and business intelligence environment.
- Develop and maintain SQL queries, data extracts, and automated reporting workflows from enterprise systems and institutional databases.
- Provide Institutional Research support for enrollment, retention, persistence, graduation, transfer, workforce, and student success reporting.
- Extract, transform, validate, and analyze data from multiple information systems and databases.
- Monitor data quality and integrity, and recommend improvements to data collection, reporting, and business processes.
- Assist with development and implementation of data governance standards, reporting procedures, and data documentation.
- Support federal, state, accreditation, and compliance reporting, including IPEDS and other higher education reporting initiatives.
- Create and maintain interactive dashboards and visualizations for executive leadership, academic departments, and operational units.
- Support analytics for strategic planning, institutional effectiveness, enrollment management, and performance measurement initiatives.
- Create and maintain documentation for data definitions, reporting procedures, business rules, and governance standards.
- Work with Information Technology staff to improve data integration, reporting capabilities, and access to reliable information.
- Support departments with ad hoc reporting requests, data analysis projects, and operational assessments.
- Prepare reports and presentations for college leadership, committees, accreditation teams, grant sponsors, and external stakeholders.
- Maintain confidentiality and security of sensitive institutional, employee, and student information in line with applicable laws, regulations, and College policies.
- Serve on assigned committees and task forces; complete other duties as assigned.
- Perform work to support the College’s Vision, Mission, and Values, including the commitment to student success.
Requirements
- Bachelor’s Degree in Data Analytics, Information Systems, Computer Science, Statistics, Mathematics, Business Analytics, Institutional Research, Higher Education Administration, or a related field (required).
- Master’s Degree in a related field (preferred).
- 2 years of experience in data analysis, institutional research, business intelligence, database administration, reporting, or a related field (required).
- Experience writing and maintaining SQL queries and working with relational databases (required).
- Experience with data warehousing, business intelligence platforms, dashboard development, or data integration projects (preferred).
- Experience in higher education, institutional research, grant reporting, or regulatory compliance reporting (preferred).
- Proficiency in Microsoft Excel (advanced functions, pivot tables, data analysis, and reporting tools).
- Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Strong analytical and problem-solving skills; ability to interpret complex data and communicate findings clearly.
- Ability to develop and maintain reports, dashboards, automated reporting processes, and data visualizations.
- Knowledge of data warehouse concepts, data integration processes, and business intelligence methodologies.
- Experience developing dashboards and visualizations using Power BI, Tableau, SSRS, or similar reporting platforms (knowledge listed as required/preferred within the requirements).
- Knowledge of statistical analysis methods and data visualization best practices.
- Understanding of higher education reporting requirements, including IPEDS, accreditation reporting, and institutional effectiveness measures.
- Knowledge of enterprise resource planning and student information systems, including Banner or similar platforms.
- Ability to manage multiple projects, meet deadlines, and work in an environment of changing priorities.
- Ability to maintain confidentiality and handle sensitive information appropriately.
- Demonstrated ability to work independently with minimal supervision.
- Demonstrated ability to collaborate with faculty, staff, administrators, and external stakeholders.
- Ability to translate technical and analytical information into meaningful reports and recommendations for non-technical audiences.
- Ability to prepare and deliver presentations and communicate technical information to a variety of audiences.
- Required to work full 37.5 hours per week.
- Must support and promote the College’s mission, vision, values, and commitment to student success.
Technologies
- SQL
- Microsoft Excel
- Power BI
- Tableau
- SSRS
- IPEDS
- Banner
- Data warehouse
- Business intelligence
Compensation
- USD 65,000 - 70,000 per year
PEIA Insurance
- Preferred Provider Benefit plan (PPB) offered by the WV Public Employees Insurance Agency (PEIA) for employees and dependents.
- Employee premiums depend on annual base salary, coverage type (single or family), and the plan selected.
- Tobacco-free insureds receive a preferred monthly premium rate.
- Coverage is effective the first of the month following the month of enrollment.
- Premiums are taken on a pre-tax basis.
- Four PEIA PPB Plans are available.
- Active members receive basic term life insurance ($10,000) at no cost and may purchase optional life insurance through MetLife with pre-tax earnings.
- MOUNTAINEER FLEXIBLE BENEFITS PLANS are sponsored by PEIA and administered by Fringe Benefits Management Company.
- Flexible Spending Accounts (FSA) for eligible medical and dependent care expenses (tax-free/IRS approved).
- Sun Life Dental Insurance with 4 plan options.
- Vision Care via Humana/Eye Med with two plan options.
- Health Savings Account (HSA) available for eligible employees on a high deductible health plan; available on a pre-tax basis.
- Limited-use Medical FSA for employees who want to take advantage of an HSA while maintaining FSA tax savings.
- Long-term disability income plans.
- Short-term disability income plan: weekly benefit is 70% of pre-disability, reduced by deductible income; 30-day waiting period; maximum weekly benefits $750; minimum benefit $15.
- Group Legal Plan.
- Basic retirement: tax-sheltered 401(a) Defined Contribution Plan with 6% contribution and 6% match by Blue Ridge CTC.
- Long Term Disability (The Standard): 60% of Basic Monthly Earnings up to a $6,000 maximum.