Data Engineer - Contractual

The Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support data collection, transformation, and storage.

Responsibilities

Examples of Duties:

• Develop and maintain data pipelines: Design, build, and optimize robust ETL (Extract, Transform, Load) processes to collect, process, and store large data sets from the Student Information System (SIS), Enterprise Resource Planning (ERP) System and other similarly complex business systems.
• Develop logical and physical data models to represent business processes, enabling analytics and reporting.
• Create, publish, and maintain interactive dashboards and reports in Power BI, transforming raw data into meaningful insights for business users.
• Automate data solutions using low-code, no-code platforms (Power Platform, Oracle) and SQL Server Integration Services
• Write reusable Python scripts to automate data ingestion, transformation, analysis, and reporting tasks.
• Implement data validation rules, monitor data quality, and ensure adherence to data governance policies.
• Maintain clear and comprehensive documentation for data structures, processes, and reports to ensure knowledge transfer and compliance.
• Provide technical support and training to project sponsors and team members on Power BI reports, dashboards, automated solutions and data sources.
• Keep up with the latest trends, tools, and best practices in data engineering and analytics, proactively suggesting improvements to existing systems.

Qualifications

Knowledge, Skills and Experience:

• Proficiency in SQL for querying, data manipulation, and database design (MS SQL, PostgreSQL, Oracle, or similar).
• Skilled in building and maintaining data solutions and dashboards using Power BI.
• Experience working with low-code, no-code environments preferred.
• Familiarity with data modeling concepts, both relational and dimensional.
• Experience integrating data from multiple sources, APIs, and vendor systems.
• Understanding of ETL concepts and best practices.
• Experience in Python for data automation and scripting (pandas, numpy, etc.).
• Excellent analytical and problem-solving skills with an attention to detail.
• Strong communication skills with the ability to explain complex technical topics to non-technical stakeholders.
• Ability to manage multiple priorities in a fast-paced environment.
• Self-motivated, proactive, and eager to learn new technologies.
• Team player with a collaborative mindset.

Physical and Environmental Conditions:
The work of this class will include travel to schools throughout the system.

FLSA:  Non-Exempt

Salary: $ 46.60 per hour (contractual)

Citizenship, residency or work VISA in United States required

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).  Each time an applicant applies to a job with BCPS, the application must be resubmitted. If an applicant started an application with BCPS in the past and at a later date decides to apply for additional positions, it is the applicant's responsibility to review the entire application and ensure that all data is up to date (for example, the applicant may need to add additional schooling or certifications, an additional work experience, or provide updated references).  The applicant must remember to review the entire application each time for accuracy and submit each time for a new or different vacancy.
• 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.  Applicants should notify their reference proactively to inform them they will receive a form via email through a MAILBOT email address from Baltimore County Public Schools.  Applicants should also inform their reference(s) of the job they are applying to.
• Be sure to account for all periods of employment and unemployment, including student teaching and internship experience, and include names, addresses, and telephone numbers of employers.
• Be sure to answer all criminal background questions. If you answer "yes" to any of the criminal background questions you must provide a written explanation. A criminal offense does not necessarily exclude an applicant from employment with BCPS. Factors such as passage of time since the offense, the nature of the violation, and the extent of rehabilitation will be taken into consideration.

Conditions of Employment:

Pre-Employment Requirements:

• All persons employed by the Baltimore County Public Schools, regular and temporary, are required to be fingerprinted and have a criminal background investigation (State of Maryland, Senate Bill 315, effective October 1, 1986) completed. The fee charged for fingerprinting is $109.00.  An identification card will be issued which must be shown prior to employment.
• Anyone offered employment is required to provide proper identification and documentation of eligibility for employment in the US.