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 data base architecture, data intergrations and system 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 development process.

Roles and Responsibilities

• Supports data-operations for LCPS production applications
• Works with the team to design, build, maintain and administer database environments; works with multiple large clustered and non-clustered environments
• Ensures optimal performance of the database environment; identifies, troubleshoots and resolves issues
• Is the subject matter expert for projects and initiatives that require data integrations
• Assembles large, complex data sets that meet business requirements
• Maintains high quality documentation that follows all phases of the development cycle
• Develops and maintains databases, tables, stored procedures, views and other database objects within SQL Server
• Builds the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL or other technology
• Develops and maintains SSIS packages
• Builds clean logic to support LCPS reporting and analytic tools
• Works cross-functionally with other departments to understand and document requirements for new or changed data processes
• Remains current with emerging technologies and suggests adoption of new products or processes when appropriate
• Continues to learn and stay current on all aspects of SQL Server

Qualifications

• Bachelor’s Degree in Information Technology 
• Microsoft Certified SQL Server DBA or Developer preferred
• Strong understanding of database structures, theories, principles, and practices
• SQL Knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience with data management and data processing flowcharting techniques
• Knowledge of reporting and query tools and practices; experience with SSRS or Qlik a plus
• 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