Position Overview

The Data Engineer is a member of the Data Science & Digital Solutions team and is responsible for providing technical support for the big data environment. The Data Engineer is available to assist the Data Architects to provide production databases that offer the highest reliability and performance possible. The Data Engineer is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future needs. The Data Engineer will work with various groups within Digital Innovation to provide technical guidance during all phases of the database related development process.

Roles and Responsibilities

• Develops and maintains databases, tables, stored procedures, functions, triggers and views within SQL Server.
• Works with the Data Architects to design, build, maintain and administer the SQL database environments for LCPS; work with multiple large clustered and non-clustered environments.
• Ensures optimal performance of the database environment; identifies, troubleshoots and resolves issues.
• Implements ETL (extract, transform, load) processes.
• Is the subject matter expert for database related projects and initiatives; remains current with emerging technologies and suggest adoption when appropriate.
• Documents the database structures, infrastructure, and management.
• Creates and builds numerous reports and data extracts that can be utilized for the import and export of data.
• Continues to learn and stay current on all aspects of SQL Server.

Qualifications

• Bachelor's Degree in Technology field
• Microsoft Certified SQL Server DBA or Developer preferred
• Strong understanding of database structures, theories, principles, and practices
• Microsoft SQL Server experience in building and maintaining databases, tables, views, stored procedures, indexes, and triggers
• Experience with data management and data processing flowcharting techniques
• Knowledge of reporting and query tools and practices
• Technical documentation skills
• Self-motivated and directed, with keen attention to detail
• Able to prioritize and execute tasks in a high-pressure environment
• Good interpersonal, written, and oral communication skills

Physical Requirements

While performing the duties of this job, the employee is regularly talking, expressing or exchanging ideas by means of the spoken word. The employee must convey detailed or important spoken instructions to other workers accurately, loudly, or quickly. The employee must possess normal cognitive abilities including the ability to learn, recall and apply certain practices and policies. Frequently sitting and/or remaining in a stationary position for long periods of time. Exerting up to 25 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects.

Telework Disclosure

Employees who perform the responsibilities of the above position have been identified as having the potential to telework. Telework is defined as completing one's duties and responsibilities at a site other than one's assigned duty location. In order to be eligible for telework privileges, an employee must have demonstrated consistent, positive performance and have the support and approval of their direct supervisor. In addition, these employees must have reliable high-speed internet and a designated workspace that allows them privacy while completing sensitive and confidential work. Employees who are non-exempt and are teleworking will work their required scheduled hours and gain approval from their supervisor if they work more than 8 hours a day or more than 40 hours in a workweek. Teleworking privileges can be amended, changed, or revoked based upon the performance of the employee, as well as the needs of Loudoun County Public Schools.

FLSA Status: Exempt

Months/Days/Hours: 12 months, 248 days, 8 hours per day

Reports to: Supervisor, Data Science & Digital Solutions

Telework Eligible: Yes

Primary Location:
Enterprise Solutions Office
Salary Range:
Copy Link - view: https://www.lcps.org/Page/228782 / Universal Level 14
Shift Type:
Full-Time