Program Coordinator II - Office of Strategic Planning and Research - State of Massachusetts

*Program Coordinator II Duties*– Office of Strategic Planning and Research – Data Analytics Unit: The Program Coordinator II position will be part of the Data Analytics Unit (DAU), reporting to the Program Coordinator III and Director of Data Analytics Unit, within the Office of Strategic Planning and Research. The Program Coordinator II will supervise a Program Coordinator I. The Office of Strategic Planning and Research, composed of the Data Analytics Unit (DAU) and Research and Planning Division,provides statistics, research, and evaluation results to guide planning, management and decision-making strategies for effective prison operations, policies, legislation, and services. The DAU serves as a knowledge hub, supporting incarcerated individual data, analytics projects, information requests, research, and publicly available mandated data reports and briefs, conducts analytics projects and creates Tableau dashboard reporting systems for Massachusetts Department of Correction (MA DOC). The Program Coordinator II is responsible for conducting and designing data projects to include data preparation, data auditing, report writing, advanced data analysis, and dashboard review, development, and management. The Program Coordinator II will be able to adhere to unit procedures and processes to meet high standards for data organization, auditing, quality, and security. The Program Coordinator II performs on-demand report generation, ad-hoc queries, and analytic tasks. Writing and revising basic SQL queries to extract raw data using SQL software is an integral part of this position. Candidates will possess the ability to assess, analyze and meet needs of stakeholder requests to create data sets. This position requires high-level experience with TOAD, SQL, TOAD for Data Point, or another data query and extract tool, and experience with Tableau Dashboard Technology. The Program Coordinator II will be responsible for the supervision of staff to include mentoring and review of work produced, oversee and monitor assigned unit activities to ensure effective operations, compliance with established standards, determine progress and effectiveness. Candidates will possess the ability to train staff in database queries, performance measures, and data analysis. Performs other duties as required. This position requires the ability to complete independent work and contribute to team-based work, and the ability to balance multiple and competing priorities and deadlines. We are looking for a team-oriented specialist with data collection and analysis experience, able to present business intelligence findings. Ability to adapt to fast paced, evolving requirements, including learning new applications and new software systems is integral part of being on this team. Prompt communication via email and organizational skills are fundamental for success in this position. Experience in and knowledge of criminal justice, social and data sciences or a related field is advantageous. This position is hybrid-remote eligible. *Preferred Qualifications:* Supervising and/or Project Management Skills.Experience with statistical software to include TOAD, SQL and Tableau Dashboards. Skilled in SQL, data query and extract tools, querying relational databases. Experience collecting, auditing, organizing, and processing large quantities of data for analysis. Experience within Excel and techniques in charts, graphs, and pivot tables. Self-motivated with the ability to work independently and collaboratively is essential. Ability to adapt to fast paced, evolving requirements, including learning new applications and new software systems. Strong judgment, analytic reasoning, critical thinking, and problem-solving skills. Experience and/or degree in Criminal Justice, Sociology or related field is preferred. *Comments:* This is a Civil Service position. Please note that salaries for union positions are determined according to the provisions of the respective collective bargaining agreement. Applicants must have no felony convictions, to include any actions defined in 5 U.S.C. 301; U.S.C. 509, 510; 42 U.S.C. 15601-15609. The Massachusetts Department of Correction shall not hire anyone who may have direct contact with offenders, who has engaged in sexual abuse in a prison or other institution as defined in 42 U.S.C. 1997; or has been convicted of engaging or attempting to engage in sexual activity in the community facilitated by force, overt or implied threats of force or coercion, or if the victim did not consent or was unable to consent or refuse, or has been civilly or administratively adjudicated to have engaged in the activity described in the above paragraph. The agency shall consider any incidents of sexual harassment in determining whether to hire anyone who may have contact with offenders or residents. The DOC urges bi-lingual applicants to apply. First consideration will be given to those applicants that apply within the first 14 days. MINIMUM ENTRANCE REQUIREMENTS: Applicants must have at least (A) three years of full time, or equivalent part-time, professional, administrative or managerial experience in business administration, business management or public administration the major duties of which involved program management, program administration, program coordination, program planning and/or program analysis, or (B) any equivalent combination of the required experience and the substitutions below. Substitutions: I. A Bachelor's degree with a major in business administration, business management or public administration may be substituted for a maximum of two years of the-required experience.* II. A Graduate degree with a major in business administration, business management or public administration may be substituted for the required experience.* III. A Bachelor's or higher degree with a major other than in business administration, business management or public administration may be substituted for a maximum of one year of the required experience.* *Education toward such a degree will be prorated on the basis of the proportion of the requirements actually completed. _*Comprehensive Benefits*_ When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future. Want the specifics? Explore our Employee Benefits and Rewards! *An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.* The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law. Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements. We encourage individuals who believe they have the skills necessary to thrive to apply for this role. Job: Administrative Services* Organization: Department of Correction* Title: *Program Coordinator II - Office of Strategic Planning and Research * Location: *Massachusetts-Milford-50 Maple Street* Requisition ID: *240009GA*