Enterprise Data Engineer

Job Description

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.

Responsibilities

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 Superintendent’s 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.
  
  

Qualifications

MINIMUM QUALIFICATIONS:

Education, Training And Experience

• Graduation from an accredited college with a bachelor’s degree in Computer Science, Information Systems, Engineering, or related field. One year’s 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 holiday’s, sick, personal business, and bereavement days, and flexible leave options such as FMLA, sick bank, and board approved leaves. All new hires will attend a benefits meeting upon hire.

Visit the BCPS website for additional information about benefit plans for BCPS employees at https://www.bcps.org/hr/compliance/benefits_and_retirement

This 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: $80,714 to $127,279 (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 www.bcps.org/operations/fiscalservices/payroll .

OTHER COMPENSATION: This position may be eligible for comp time. Visit the BCPS website to review the OPE Master Agreement for additional information at https://www.bcps.org/cms/One.aspx?portalId=2828&pageId=69996497 .

CONDITIONS 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 supervisors. Personal references from colleagues, friends, community members, etc. will 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 personnel must attend a Benefits and Retirement Orientation meeting.
• Additional job verification will be required for salary credit.
  
  

Contact Information

Office of Staffing & Licensure

Phone: 443-809-7872

Email: sstahl@bcps.org

About Us

Baltimore County Public Schools (BCPS) is the 22nd largest school district in the nation and the 3rd largest in Maryland with over 21,000 employees supporting over 111,000 students.  BCPS has 26 Maryland Blue Ribbon Schools of Excellence and 23 National Blue Ribbon schools, 32 magnet schools and 116 magnet programs.

Baltimore County Public Schools is seeking highly effective employees that will inspire, support, and prepare our students for a successful future.  BCPS works to embrace all stakeholders, engage them in authentic collaboration and empower them to be a part of positive change, so our students, staff, and system will excel.  We hope you will join our dynamic community!  Apply to work at BCPS!