Enterprise Data Engineer

Supports the end-to-end vision and implementation of the Baltimore County Public Schools (BCPS) Enterprise Data Warehouse to ensure the delivery of meaningful data analysis reports and visualizations to meet BCPS mission and vision set forth in the systemwide strategic plan. Participates in all aspects of the BCPS Enterprise Data Warehouse including data acquisition data modeling extract/transform/load (ETL) storage security archiving and recovery. Performs other duties as assigned.

EXAMPLES OF DUTIES:

• Collaborates with product owners and stakeholders to plan and define requirements. Translates business requirements into business value and assists in supporting leadership and project managers to establish priorities and meeting timelines.

• Attends meetings and events which may include preparing and delivering presentations in front of a large group.

• Supports the Data Governance Committee by attending meetings acting as a subject matter expert working with workgroups to solve problems providing input into Board of Education Policies and Superintendents Rules and representing the Data Analytics team.

• Follows data warehouse best practices and development processes including conceptual/ logical/physical dimensional data modeling data flow diagrams design scalability for the future ETL architecture source to target mappings automation through ETL and stored procedures data validation quality assurance and monitoring/alerting.

• Participates in data modeling and ETL design review sessions with team members and provides feedback. Approves the release of changes to the production data warehouse. Ensures all data models dictionaries and metadata are maintained.

• Meets regularly with leadership and the project manager to provide input and feedback on project level of effort feasibility timelines issues and project status. Communicates with team members on issues including resolution. Participates in and contributes to daily stand-up and project planning meetings.

• Collaborates daily with developers to ensure data availability and structure meet the needs of the report or data visualization.

• Creates SQL scripts to extract data from the data warehouse to support data analysis or fulfill an ad hoc data request.

• Ensures the stability of the BCPS Enterprise Data Warehouse through monitoring performance tuning disaster recovery planning new installations patching upgrading storage planning issue resolution and collaboration with vendors and the Department of Information Technology. Escalates issues and risks as needed.

• Maintains data security architecture to ensure student and employee data privacy guidelines are met. Works closely with network administrators to define and maintain Windows Active Directory groups used to establish access to business intelligence systems.

• Participates in continuous improvement activities by identifying and analyzing the effectiveness and efficiency of existing processes and develops strategies for improvements.

• Performs other duties as assigned.

MINIMUM QUALIFICATIONS:

Education Training and Experience:

• Graduation from an accredited college with a bachelors degree in Computer Science Information Systems Engineering or related field. One years experience designing architecting and implementing enterprise scale data warehouses data marts ETL architecture and code and SQL code/stored procedures. Experience in K-12 education preferred.

Note: Other combination of applicable education training and experience which provide the knowledge skills and abilities necessary to perform effectively in the position may be considered.

Knowledge Skills and Abilities:

• Knowledge of the infrastructure and architecture required to build and maintain an enterprise data warehouse that integrates multiple disparate data sources on a Microsoft SQL Server platform.
• Knowledge of data visualization tools like Tableau Cognos and Microsoft BI Suite and how the data warehouse supports their solutions.
• Knowledge of information systems and data life-cycle management best practices and methodologies and systems development life cycle (SDLC).
• Skills in ETL using Microsoft SSIS and SQL programming including stored procedures/ views/functions and VB/C# scripting for enhanced automation.
• Knowledge of Kimball dimensional data modeling and master data management. Skill and ability with one or more recognized data modeling tools like ER Studio or ERwin.
• Ability to work on multiple projects simultaneously and adhere to deadlines while working in a fast past environment using agile project management methodologies.
• Ability to work in a team environment and collaborate with other team members.
• Excellent verbal and written communication skills.

PHYSICAL AND ENVIRONMENTAL CONDITIONS:

The work of this position is generally sedentary with occasional walking standing and other limited physical activities.

CONDITIONS OF EMPLOYMENT:

Employees may be required to work beyond their normally scheduled hours with little or no advanced notice.

This document describes the duties and responsibilities of a position or group of positions. It shall not be held to exclude duties not referenced nor limit the right of management to assign work to employees.

Citizenship residency or work VISA in United States required.

BENEFITS:BCPS offers a comprehensive benefits program for eligible employees including options for medical plans dental plans vision life insurance flexible spending accounts disability coverage and 403(b)/457 plans. Other benefits include paid vacation paid holidays sick personal business and bereavement days and flexible leave options such as FMLA sick bank and board approved new hires will attend a benefits meeting upon hire.

Visit the BCPS website for additional information about benefit plans for BCPS employees at class specification defines the types of duties and level of difficulty of work required of positions in this title. It shall not be held to exclude duties not mentioned nor limit the right of management to assign work to employees.

RETIREMENT: Eligible for the Baltimore County Employees Retirement System

GRADE:

Grade 06 - 12 Month OPE Pay Scale

SALARY: $80714 to $127279 (Annual Salary Scale for Exempt 12-Month Employees Represented by BCPSOPE 2025-2026 Effective September 20 2025) Visit the BCPS Office of Payroll website for additional information on pay scales other compensation and leave accruals at COMPENSATION: This position may be eligible for comp time. Visit the BCPS website to review the OPE Master Agreement for additional information at OF EMPLOYMENT: Persons appointed to this classification are designated as Essential-As-Needed Personnel and are required to work when schools and/or offices are closed during adverse weather conditions or any other emergency when contracted and directed to do so.

Employees in this class may be assigned to work nights evenings weekends and/or holidays. Employees are subject to call to duty in emergencies and may be required to work beyond their regularly scheduled hours with little advanced notice.

FLSA Status: Exempt

Application Instructions

Please read and carefully follow the instructions provided below.

• Applicants are required to have a completed application on file for employment with Baltimore County Public Schools (BCPS). Information on your resume and application must match. This information is necessary for salary determination should you receive an offer of employment.
• Professional references must be submitted to complete your application. Examples of professional references include current and former principals supervisors managers mentor teachers and university/college references from colleagues friends community members not be accepted.
• Be sure to account for all periods of employment and unemployment. Failure to complete all fields of the Work Experience section of the application may result in your application not being considered. A resume will not be the only document considered in determining your qualifications for a position.
• You MUST attach your unofficial transcript(s) or license(s) to your application if you are applying for a position as a teacher or position which requires Licensure/Certification.

Pre-Employment Requirements:

• All people employed by the Baltimore County Public Schools regular and temporary are required to be fingerprinted and have a criminal background investigation (per COMAR) completed. The fee charged for fingerprinting is $109.
• Anyone offered employment is required to provide proper identification and documentation of eligibility for employment in the US.
• If you have military experience you will be asked to provide a copy of DD214.
• Official transcripts will be required upon hire and must be sent via escript/clearinghouse from your university.
• Some positions will require employees to undergo a physical examination and/or drug testing.
• All newly hired personnelmustattend aBenefits and Retirement Orientationmeeting.
• Additional job verification will be required for salary credit.

Contact Information
Office of Staffing & Licensure
Phone:
Email: