ABOUT US
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 2024 -2029 Strategic Plan, please visit our website and our careers page. Join our award-winning workforce and make a difference in the lives of our students!
ABOUT THE APPLICATION PROCESS
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 application guide includes detailed instructions to assist you. Once your application has been submitted, you will not be able to add documentation or make any changes.
Please note that application submission will be available only through 11:59 PM on the date prior to the indicated end date. If no end date is indicated, the posting will remain open indefinitely.
Job Posting End Date:
07-20-2026Reminder: Current permanent and temporary employees must apply through the Jobs Hub in Workday, not the external career site.
DESCRIPTION
Under the direction of the Coordinator, Data Warehouse (DW) and Reporting, the Analyst II, Data Reporting will use SQL queries, spreadsheets and other tools to translate complex business rules and regulatory requirements into clear, accurate SQL-based reporting tailored to stakeholder needs. This role will be responsible for 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.
MINIMUM QUALIFICATIONS
A combination of education and experience may be considered.
Education:
Bachelor’s degree from an accredited college or university.
Experience:
At least five (5) years of experience in data extraction and reporting, using SQL queries, spreadsheets and other tools to manipulate data.
PREFERRED QUALIFICATIONS
The ideal candidate for this role will also possess a combination of the additional qualifications below. If you don’t meet every one of the preferred qualifications, we still encourage you to apply, as we welcome applications from candidates with diverse backgrounds and experiences.
Bachelor’s degree from an accredited university in Information Technology, Educational Technology, or a related field.
At least seven (7) years of experience in data extraction and reporting, using SQL queries, spreadsheets and other tools to manipulate data
Experience working with student data systems in a preK-12 or college/university setting.
Experience using Snowflake and/or MS SQL Server.
Experience working with business intelligence and data visualization tools, such as Power BI or Tableau.
ESSENTIAL POSITION RESPONSIBILITIES
The below list is a summary of the functions of the job, not an exhaustive or comprehensive list of all possible job responsibilities, tasks, and duties.
Establishes and applies analytical data frameworks that unify system data and stakeholder inputs for reporting and analysis.
Leverages enterprise SQL queries and other tools to create data reports.
Performs data quality assurance, troubleshoots data issues in real-time, and diagnoses the root causes.
Support the development and execution of projects, project plans, and team activities.
Communicates changes and progress to stakeholders and team members, following internal procedures.
Organizes and manages several tasks or projects with concurrent time-sensitive deadlines.
Ensure that quality assurance procedures and best practices are followed.
Works collaboratively and cross-functionally with stakeholders to ensure data consistency, integrity, and accurate generation for reporting and analytics of information.
Clearly communicates technical concepts to both technical and non-technical audiences.
ESSENTIAL KNOWLEDGE, SKILLS, AND ABILITIES
The below list is a summary of the knowledge, skills, and abilities required for success in this position, not an exhaustive or comprehensive list.
Knowledge
Working knowledge of FERPA and COMAR regulations.
Knowledge of analysis tools such as Power BI.
Knowledge of database structures and MS SQL Server.
Knowledge of cloud data warehousing environments (e.g., Snowflake).
Knowledge of data management principles, database concepts, reporting tools, and statistical analysis techniques.
Skills
Translate complex business rules and regulatory requirements into clear, accurate SQL-based reporting tailored to stakeholder needs.
Build advanced queries, joins, and data transformations for reporting and analytics.
Skilled in analyzing data and identifying inconsistencies or operational issues.
Expertise in Microsoft Excel, including advanced functionality.
Abilities
Analytical and problem-solving capabilities in complex data environments.
Ability to think critically and logically when managing multiple tasks and workflows.
Ability to perform duties requiring significant attention to detail and high level of accuracy.
Ability to interpret and apply policies, regulations, and procedures related to student data and data confidentiality.
ADDITIONAL REQUIREMENTS
Working Hours
The duty day for this position is 8 hours including a one hour duty-free lunch.
SELECTION CRITERIA
Applicants who meet the minimum qualifications will be included in further evaluation. Interviews will be limited to those applicants who, in addition to meeting the basic requirements, have experience and education which most closely match the position qualifications and the needs of the school system.
Applicants may be required to complete a skills assessment prior to or during the interview process.
EMPLOYMENT INFORMATION
Compensation
This is a 12-month per year position in the Howard County Education Association, Educational Support Professionals (HCEA-ESP) employee unit. The current salary range for this position is Grade 26 on the Technical Central Office and School Based salary scale, $102,370 - $154,260. Step placement will be in accordance with 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.
Telework Program
This position requires work onsite and is also eligible for a hybrid 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.
Retirement
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 elect membership. The annual contribution to the pension plan will be 7% of an employee’s annual salary.
Benefits
HCPSS offers a comprehensive benefits package for eligible employees. Information about additional benefits such as paid time off can be found in the negotiated agreement for employees in this bargaining unit.
Pre-Employment Requirements
Professional references will be contacted prior to any offer of employment. Recommended candidates will be required to provide references from current and recent supervisors.
All employees, regular and temporary, must be fingerprinted, have a criminal background investigation completed, and successfully complete the Maryland Employment History Review, pursuant to Section 6-113.2 of the Education Article, Annotated Code of Maryland. In addition, some positions will require completion of a physical examination and/or drug testing.
Anyone offered employment is required to provide proper identification and documentation of eligibility for employment in the United States. HCPSS participates in E-Verify and does not offer employee sponsorship.
For questions regarding this posting, please contact Philip Wentt ([email protected]) OR [email protected].
EQUAL OPPORTUNITY EMPLOYER
To request an accommodation during the application or interview process due to a documented disability, please email [email protected].
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.