Enterprise Data Engineer

Overview

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

• 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 work groups 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.

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 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…