Data Engineer

Loudoun County Government Data EngineerLoudoun 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 entirety. 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.Job SummaryThe job would require strong SQL and Python programming skills and analytical skills. Specific job requirements include:Manages IT and systems development projects, as assignedGather 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 platformsEvaluate 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 solutionsRequires: Excellent analytical and technical skills. Excellent written, verbal, communication, and presentation skills.Minimum QualificationsRequires 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.Preferable skills: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 modeling tools such as TOAD, Microsoft Visio is preferable.Any certification or work related to Database management is highly desirable.Job Contingencies and Special RequirementsPass criminal background check. Depending on assignment, fingerprinting, credit and/or DMV check may be required.Equal Employment Opportunity Loudoun County Government prides itself on fostering a diverse and inclusive workplace that promotes employee wellness and work-life balance. As an equal opportunity employer, we consider all qualified applicants regardless of age, color, disability, gender identity, genetic information, national origin, political affiliation, race, religion, sex, sexual orientation or other non-merit factors.Reasonable Accommodation Applicants who wish to request a reasonable accommodation during the recruitment process should call Human Resources directly at View phone number on click.appcast.io or email Human Resources.BenefitsLoudoun County Government offers a variety of benefits to both regular full time and part time employees. To view the comprehensive benefits package we have to offer you when you join our team, please click here. Employees hired into Regular Part-Time Intermittent positions are eligible for limited County employee benefit programs, based on the position's regularly scheduled hours. Benefits eligibility for temporary employees are dependent on duration of assignment and number of scheduled hours.