Baltimore County Public Schools · 5 hours ago
Enterprise Data Engineer
Towson, MD
Full-time
Onsite
Entry Level
$81K/yr - $127K/yr
1+ years expBaltimore County Public Schools (BCPS) is the 22nd largest school district in the nation, seeking to implement an Enterprise Data Warehouse to enhance data analysis and reporting. The Enterprise Data Engineer will support the development and maintenance of data systems, ensuring data integrity and security while collaborating with stakeholders to meet business requirements.
EducationPrimary EducationSecondary Education
No H1B
Responsibilities
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
Qualification
Required
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
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
Citizenship, residency or work VISA in United States required
Preferred
Experience in K-12 education
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.
Eligible for the Baltimore County Employees’ Retirement System
Company
Baltimore County Public Schools
Baltimore County Public Schools is a public school that specializes in primary and secondary education.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Christine Faya
Executive Administrative Assitant CFO
Christopher Hartlove
Chief Financial Officer
Recent News
Company data provided by crunchbase