Data Engineer

Loudoun County Government•Leesburg, VA

10d

About The Position

Loudoun County Government has been named one of Forbes' 2025 Best Large Employers! We’re proud to be recognized nationally for our commitment to employee satisfaction and excellence in public service. At Loudoun County, we bring together talented professionals from all backgrounds to make a meaningful impact in a dynamic, growing community — that’s The Loudoun Difference. Welcome and thank you for your interest in employment with Loudoun County Government! ALL SECTIONS OF THE APPLICATION MUST BE COMPLETED IN ITS ENTIITY. THE RESUME IS CONSIDERED SUPPLEMENTAL INFORMATION ONLY. APPLICATIONS THAT ARE INCOMPLETE OR INDICATE 'SEE RESUME' WILL NOT BE TAKEN INTO CONSIDERATION. Loudoun County, located just 35 miles west of Washington, D.C., is renowned for its exceptional quality of life, vibrant economy, and rich historical charm. With a unique blend of cultural, recreational, and educational opportunities, Loudoun offers an ideal environment to live, work, and grow. Recognized by Forbes as one of America's Best Large Employers, Loudoun County Government is committed to creating a workplace where employees thrive. Loudoun is recognized for its outstanding commitment to fostering environments where employees can thrive based on various factors, which include atmosphere, salary, diversity, working conditions and workplace environment. The Loudoun County Department of Information Technology (DIT) is currently seeking a talented, highly motivated individual to serve as Data Engineer for the County’s applications. The Data Engineer will be responsible for ensuring data accessibility across the organization and for collecting and transforming raw data into information that can be used by various key business stakeholders. The successful candidate must be proficient in handling a high-level complex workload, as well as being flexible to ongoing changes. Must be able to work independently and collaboratively with key stakeholders.

Requirements

Excellent analytical and technical skills.
Excellent written, verbal, communication and presentation skills.
Requires any combination of education and experience equivalent to a bachelor's degree in computer science or related field; three (3) years of experience demonstrating the job tasks illustrated.

Nice To Haves

Python experience and PowerBI experience.
Technical expertise in SQL server is strongly preferred.
Experience in Data Engineering practices with various cloud platforms such as AWS, Azure, Google etc. highly preferred.
Experience with Oracle a plus.
Experience in using various modelling tools such as TOAD, Microsoft Visio is preferable.
Any certification or work related to Database management is highly desirable.

Responsibilities

Manages IT and systems development projects, as assigned
Gather and process data that meet functional and non-functional business requirements.
Setup ETL data pipelines.
Integrate data from internal systems, APIs, third-party tools, and cloud platforms
Evaluate new data sources for acquisition and integration.
Collaborate with internal business resources and technical teams/SMEs to understand various data sources and assist with populating the metadata catalog.
Keep data separated and secure based on Data Governance guidelines.
Apply Medallion Architecture principles (Bronze/Silver/Gold layers) to design scalable, organized, and high-quality data pipelines.
Experience performing root cause analysis on data processes to meet business requirements.
Identify opportunities for improvement of existing data processes.
Participate in code reviews, testing, and documentation to maintain high-quality engineering standards.
Implement CI/CD practices (e.g., Git with GITHUB) for data engineering projects, ensuring robust deployment and testing of data solutions