<p><b>ABOUT US</b></p><p>The Howard County Public School System (HCPSS) is one of the leading school systems in Maryland and the nation. To learn more about us and our <a target="_blank" href="https://www.hcpss.org/strategic-plan/"><u>2024 -2029 Strategic Plan</u></a>, please visit our <a target="_blank" href="https://www.hcpss.org/"><u>website</u></a> and our <a target="_blank" href="https://www.hcpss.org/employment/"><u>careers page</u></a>. Join our award-winning workforce and make a difference in the lives of our students!</p><p></p><p><b>ABOUT THE APPLICATION PROCESS</b></p><p>Before you begin, please read the job posting below carefully including the Application Requirements specific to this position. Be sure your application reflects experience and education required to meet the minimum and any preferred qualifications listed. Our<a target="_blank" href="https://docs.google.com/document/d/1IIElHty1X0qSi1tV8IXnv-m7NRPlcs4w/edit?usp=sharing&ouid=114346570689287937853&rtpof=true&sd=true"><span style="color:#0000ff"><u> application guide</u></span></a> includes detailed instructions to assist you. <span class="emphasis"><b>Once your application has been submitted, you will not be able to add documentation or make any changes.</b></span> </p><p></p><p style="text-align:inherit"></p><p style="text-align:left"><span><span>Please note that application submission will be available only through 11:59 PM <span class="emphasis"><b>on the date </b></span><b><span class="emphasis"><b>p</b>rior to</span></b> the indicated end date. </span></span> <span>If no end date is indicated, the posting will remain open indefinitely</span><span>.</span></p><p style="text-align:inherit"></p><p style="text-align:inherit"></p><p style="text-align:left">Job Posting End Date:</p><p style="text-align:inherit"></p>07-20-2026<p></p><p><span class="emphasis"><b><b>Reminder: Current permanent </b><b>and temporary </b><b>employees must apply through the </b><i>Jobs Hub</i><b> in Workday, not the external career site.</b></b> </span></p><p></p><p></p><p style="text-align:inherit"></p><p style="text-align:inherit"></p><div><p><u><span>DESCRIPTION</span></u><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>Under the direction of the Coordinator, Data Warehouse (DW) and Reporting, the Analyst II, Data Reporting will use SQL queries, </span><span>spreadsheets</span><span> and other tools to translate complex business rules and regulatory requirements into clear, </span><span>accurate</span><span> SQL-based reporting tailored to stakeholder needs. This role will </span><span>be responsible for</span><span> pulling data from data systems for state, federal, and internal reporting and ensuring quality assurance. This role will play a significant role in data-based decision making by school system leaders.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><u><span>MINIMUM QUALIFICATIONS</span></u><span> </span></p></div><div><div><p><span> </span></p></div><div><p><b><span>A combination of education and experience may be considered.</span></b><span> </span></p></div><div><p><span> </span></p></div><div><p><b><span>Education:</span></b><span> </span></p></div><div><ul><li><p><span><span>Bachelor’s degree from an accredited<span> </span></span><span>college or<span> </span></span><span>university.</span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div><div><p><b><span>Experience:</span></b><span> </span></p></div><div><ul><li><p><span><span>At least five (5) years of experience in data extraction and reporting, using SQL queries, </span><span>spreadsheets</span><span> and other tools to manipulate data.</span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div></div><div><div><p><u><span>PREFERRED QUALIFICATIONS</span></u><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>The ideal candidate for this role will also<span> </span></span><span>possess</span><span><span> </span>a combination of the<span> </span></span><span>additional</span><span><span> </span>qualifications below. If you<span> </span></span><span>don’t</span><span><span> </span>meet every one of the preferred qualifications, we still encourage you to apply, as we welcome applications from candidates with diverse backgrounds and experiences.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><ul><li><p><span><span>Bachelor’s degree from an accredited university in Information Technology, Educational Technology, or a related field. </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>At least seven (7) years of experience in data extraction and reporting, using SQL queries, </span><span>spreadsheets</span><span> and other tools to manipulate data </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Experience working with student data systems in a preK-12 or college/university setting. </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Experience using Snowflake</span><span><span> </span>and/or</span><span><span> </span>MS</span><span><span> </span></span><span>SQ</span><span>L Server</span><span>.</span><span> </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Experience working with business intelligence and data visualization tools, such as Power BI or Tablea</span><span>u.</span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div><div><p><u><span>ESSENTIAL POSITION RESPONSIBILITIES</span></u><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>The<span> </span></span><span>below list</span><span><span> </span>is a summary of the functions of the job, not an exhaustive or comprehensive list of all<span> </span></span><span>possible job</span><span><span> </span>responsibilities, tasks, and duties.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><ul><li><p><span><span>Establishes and applies analytical data frameworks that unify system data and stakeholder inputs for reporting and analysis.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Leverages enterprise SQL queries and other tools to create data reports.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Performs<span> </span></span><span>data</span><span><span> </span>quality assurance</span><span>,</span><span><span> </span>troubleshoots data issues </span></span><span><span>in real-time</span><span>,</span><span><span> </span>and diagnoses the root cause</span><span>s</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Support the development and execution of projects, project plans, and team</span><span><span> </span></span><span>activities. </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Communicates</span><span> changes and progress</span><span><span> </span>to<span> </span></span><span>stakeholde</span><span>rs</span><span><span> </span>and</span><span><span> </span>team members,</span><span><span> </span>following<span> </span></span><span>internal<span> </span></span><span>pro</span><span>cedures</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Organizes and manages several tasks or projects with concurrent time-sensitive deadlines</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Ensure th</span><span>at</span><span><span> </span>quality assurance procedures and best practices are followed.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Works collaboratively and cross-functionally with stakeholders to ensure data consistency, integrity, and </span><span>accurate</span><span> generation for reporting and analytics of information. </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Clearly communicates technical concepts to both technical and non-technical audiences.</span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div></div><div><div><p><u><span>ESSENTIAL KNOWLEDGE, SKILLS, AND ABILITIES</span></u><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>The below list is a summary of the knowledge, skills, and abilities<span> </span></span><span>required</span><span><span> </span>for success in this position, not an exhaustive or comprehensive list.</span><span> </span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><b><span>Knowledge</span></b><span> </span></p></div><div><ul><li><p><span><span>Working knowledge of FERPA and COMAR regulations</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Knowledge of analysis tools such as Power BI</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Knowledge of database structures and<span> </span></span><span>MS<span> </span></span><span>SQL Server</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Knowledge of cloud data warehousing environments (e.g., Snowflake)</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Knowledge of data management principles, database concepts, reporting tools, and statistical analysis techniques</span><span>. </span></span><span><span><span> </span></span></span><span> </span></p></li></ul></div><div><p><b><span>Skills</span></b><span> </span></p></div><div><ul><li><p><span><span>Translate complex business rules and regulatory requirements into clear, </span><span>accurate</span><span> SQL-based reporting tailored to stakeholder needs</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Build advanced queries, joins, and data transformations for reporting and analytics</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Skilled in analyzing data and </span><span>identifying</span><span> inconsistencies or operational issues</span><span>. </span></span><span><span><span> </span></span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Expertise</span><span> in Microsoft Excel, including advanced functionality</span><span>.</span></span><span> </span></p></li></ul></div><div><p><b><span>Abilities</span></b><span> </span></p></div><div><ul><li><p><span><span>Analytical and problem-solving capabilities in complex data<span> </span></span><span>environments.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Ability to think critically and logically when managing multiple tasks and workflows</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Ability to perform duties requiring significant attention to detail and </span><span>high level</span><span> of<span> </span></span><span>accuracy</span><span>.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Ability to interpret and apply policies, regulations, and procedures related to student data and data confidentiality</span><span>. </span></span><span><span><span> </span></span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div><div><p><span> </span></p></div><div><p><u><span>ADDITIONAL</span><span><span> </span>REQUIREMENTS</span></u><span><span> </span></span><span> </span></p></div></div><div><div><p><span> </span></p></div><div><p><b><span>Working Hours</span></b><span> </span></p></div><div><ul><li><p><span><span>The duty day for this position is<span> </span></span><span>8</span><span> hours including a<span> </span></span><span>one hour</span><span><span> </span></span><span>duty-free lunch. </span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div><div><p><u><span>SELECTION<span> </span></span><span>CRITERIA</span></u><span> </span></p></div></div><div><p><span> </span></p></div><div><p><span><span>Applicants who meet the minimum qualifications will be included in further evaluation.<span> </span></span><span>Interviews will be limited to those applicants who, in addition to meeting the basic requirements, have experience and education which most closely match the<span> </span></span><span>position</span><span><span> </span>qualifications and the needs of the school system. </span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><b><span>Ap</span><span>plicants m</span><span>ay<span> </span></span><span>be required</span><span><span> </span>to co</span><span>mplete a sk</span><span>ills assessment prior to or during the interview process.</span></b><span> </span></p></div><div><p><span> </span></p></div><div><p><u><span>EMPLOYMENT INFORMATION</span></u><span> </span></p></div><div><p><span> </span></p></div><div><p><b><span>Compensation</span></b><span> </span></p></div><div><p><span><span>This is a<span> </span></span><span>12</span><span>-month per year position in the Howard County Education Association, Educational Support Professionals (HCEA-ESP) employee unit. The<span> </span></span></span><a href="https://www.hcpss.org/employment/agreements-and-salaries/" target="_blank"><u><span>current salary range</span></u></a><span><span><span> </span>for this position is Grade 2</span><span>6</span><span><span> </span>on the Technical Central Office and School Based salary scale, $</span><span>102,370</span><span><span> </span>- $</span><span>154,260</span><span>. Step placement will be<span> </span></span><span>in accordance with</span><span><span> </span>the salary procedures of the Howard County Public School System and the HCEA-ESP Master Agreement which considers relevant prior experience. Under the Fair Labor Standards Act, this position is exempt from overtime. </span><span> </span></span><span> </span></p></div><div><p><span><span> </span></span><span> </span></p></div><div><p><b><span>Telework Program</span></b><span> </span></p></div><div><p><span><span>This position requires work onsite and is also eligible for a </span></span><b><span>hybrid </span></b><span><span>telework schedule after the first 60 duty days. Telework schedules will be determined by the department and/or supervisor. Telework during the probationary period will be subject to approval and based on the needs of the department and the school system. </span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><b><span>Retirement</span></b><span> </span></p></div><div><p><span><span>Membership in the Maryland State Retirement Agency (MSRA) pension plan is a mandatory condition of employment for all employees who meet the eligibility and membership criteria defined in the State Personnel and Pensions Article and the Code of Maryland Regulations (COMAR). A qualifying employee cannot reject membership, nor can an ineligible employee<span> </span></span><span>elect</span><span><span> </span>membership.<span> </span></span><span>The annual</span><span><span> </span>contribution to the pension plan will be 7% of an employee’s annual salary</span><span>. </span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><b><span>Benefits</span></b><span> </span></p></div><div><p><span><span>HCPSS offers a<span> </span></span></span><a href="https://www.hcpss.org/employees/benefits/" target="_blank"><u><span>comprehensive benefits package</span></u></a><span><span><span> </span>for eligible employees.</span><span><span> </span></span><span>Information about<span> </span></span><span>additional</span><span><span> </span>benefits such as paid time off can be found in the<span> </span></span></span><a href="https://www.hcpss.org/employment/agreements-and-salaries/" target="_blank"><u><span>negotiated agreement</span></u></a><span><span><span> </span>for employees in this bargaining unit.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><b><span>Pre-Employment</span><span><span> </span>Requirements</span></b><span> </span></p></div><div><p><span><span>Professional references will be contacted prior to any offer<span> </span></span><span>of</span><span><span> </span>employment. Recommended candidates will<span> </span></span><span>be<span> </span></span><span>required</span><span><span> </span>to<span> </span></span><span>provide references from current and recent supervisors.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>A</span><span>ll employees, regular and temporary, must be fingerprinted, have a criminal background investigation completed, and successfully complete the Maryland Employment History Review,<span> </span></span><span>pursuant to</span><span><span> </span>Section 6-113.2 of the Education Article, Annotated Code of Maryland.</span><span><span> </span></span><span>In addition, s</span><span>ome positions will require<span> </span></span><span>completion of a physical examination and/or drug testing</span><span>.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><span><span>Anyone offered employment is<span> </span></span><span>required</span><span><span> </span>to provide proper identification and documentation of eligibility for employment in the United States. HCPSS<span> </span></span><span>participates in E-Verify and<span> </span></span><span>does not offer employee sponsorship.</span></span><span> </span></p></div><div><p><span> </span></p></div><div><p><b><span>For questions<span> </span></span><span>regarding</span><span><span> </span>this<span> </span></span><span>posting</span><span>, please contact<span> </span></span><span>Philip Wentt<span> </span></span><span>(</span><span>philip_wentt@gmail.com</span><span>)</span><span><span> </span>OR<span> </span></span></b><a href="mailto:humanresources@hcpss.org" target="_blank"><u><span>humanresources@hcpss.org</span></u></a><span><span>.</span></span><span> </span></p></div><p style="text-align:inherit"></p><p style="text-align:inherit"></p><p style="text-align:inherit"></p><p style="text-align:inherit"></p><p><b><b>EQUAL OPPORTUNITY EMPLOYER</b></b></p><p><span>To request an accommodation during the application or interview process due to a documented disability, please email </span><a href="mailto:humanresources@hcpss.org" target="_blank"><u>humanresources@hcpss.org</u></a><span>.</span></p><p><br /><span>HCPSS celebrates diversity and is committed to creating an inclusive environment for all employees and applicants and prohibits discrimination, harassment, and retaliation of any kind. HCPSS is committed to the principle of equal employment opportunity for all employees in providing them with a work environment free of discrimination and harassment. All employment decisions at HCPSS are based on organizational needs, job requirements and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, veteran status or present military service, family medical history or genetic information, family or parental status, or any other characteristic protected by federal, state or local laws.</span></p><p></p>