- Salary
- $92k – $131k/yr
- Location
- Spotsylvania, VA, VA, US
- Department
- Engineering
- Education
- Bachelor
- Source
- GovernmentJobs
Description
Under minimal supervision, responsible for designing, developing, and supporting the County’s data infrastructure, enabling the County to connect, organize, and effectively utilize its existing systems and information. Position works directly with assigned business areas and alongside project managers and systems engineers to integrate line-of-business applications, automate data movement, and deliver reporting and analytics that support operational decision-making.
Reports to the Chief Information Officer/Deputy Chief Information Officer.
This position is essential. Personnel occupying this position may be scheduled to work regardless of weather conditions and/or when general County offices are closed.Bachelor's Degree in Computer Science, Information Systems, Engineering, Data Science, or a related field; supplemented with at least five (5) years of previous experience in systems automation, data integration, data administration, data engineering, or data analytics; or any equivalent combination of education, training and experience which provides the requisite knowledge, skills, and abilities.
Experience with enterprise cloud and productivity data platforms, such as Microsoft 365, Power BI, and Azure data services.
Experience automating data movement, validation, reporting, or operational workflows using scripts, APIs, integration platforms, or scheduled processes.
Experience working within a government or other regulated environment with formal data classification and compliance frameworks.
Reports to the Chief Information Officer/Deputy Chief Information Officer.
This position is essential. Personnel occupying this position may be scheduled to work regardless of weather conditions and/or when general County offices are closed.
- Meets with assigned business-area stakeholders to understand operational workflows and determine workflow, integration, reporting, and analytics needs, translating those needs into technical requirements.
- Designs, develops, and maintains data pipelines and integrations that move data between business systems automatically, reducing manual and duplicative data entry.
- Configures applications to enable reliable data output while working with assigned business areas to structure, catalog, and organize their data and extend the value of existing platforms.
- Contributes to the design and buildout of a centralized data repository supporting cross-functional reporting and analytics.
- Develops and maintains dashboards and reporting products that replace disconnected, manually maintained spreadsheets with shared, current views of operations.
- Prepares, organizes, and structures organizational data to support approved enterprise analytics and AI tools with well-governed, reliable inputs.
- Implements data validation, refinement, and cleansing controls to ensure accuracy, consistency, and reliability across connected systems.
- Applies the governance, security, retention, and compliance requirements applicable to the assigned business area, including the appropriate handling of sensitive and regulated data.
- Coordinates with vendors on data access, extracts, and interfaces for hosted and third-party systems.
- Documents data flows, models, and integration architecture and communicates technical concepts clearly to non-technical stakeholders.
- Performs other related duties as required.
Experience with enterprise cloud and productivity data platforms, such as Microsoft 365, Power BI, and Azure data services.
Experience automating data movement, validation, reporting, or operational workflows using scripts, APIs, integration platforms, or scheduled processes.
Experience working within a government or other regulated environment with formal data classification and compliance frameworks.
- Knowledge of the policies, procedures, and activities of the County and of departmental practices as they pertain to the performance of duties relating to the position of Data Engineer.
- Knowledge of principles and practices associated with analysis of computer systems, including evaluation of current business processes and workflows, determination of user needs, and development of recommendations to improve efficiency of operations.
- Knowledge of the terminology, principles, and methods utilized within the department.
- Knowledge of the laws, ordinances, standards, and regulations pertaining to the essential duties and responsibilities of the position.
- Knowledge of SQL, relational databases, and data modeling.
- Ability to develop and support ETL/ELT processes, APIs, and scripts (such as Python) in production or other critical environments.
- Ability to frame work application and repository interconnects, facilitating information ingestion across dissimilar systems. Environment is a mixture of on-premises, cloud, and SaaS.
- Ability to develop dashboards, reports, and analytics solutions using modern business intelligence tools and industry-leading SaaS analytics platforms.
- Knowledge of data governance, quality, and security principles.
- Ability to manage multiple projects, collaborate with stakeholders of varying technical backgrounds, and verify data pipeline services following patching or maintenance activities.
- Ability to comprehend, interpret, and apply regulations, procedures, and related information.
- Ability to keep abreast of any changes in policy, methods, computer operations, equipment needs, policies, etc., as they pertain to departmental operations and activities.
- Ability to effectively communicate and interact with supervisors, members of the public, and all other groups involved in the activities of the department.
- Ability to assemble information and make written reports and documents in a concise, clear, and effective manner.
- Ability to use independent judgment and work with little direct supervision as situations warrant and as part of a team.
- Ability to read, understand, and interpret financial, technical, and computer reports and related materials.
- Ability to evaluate, audit, deduce, and/or assess data using established criteria. Includes exercising discretion in determining actual or probable consequences and in referencing such evaluation to identify and select alternatives.
- Ability to apply principles of persuasion and to coordinate activities of a project, program, or designated area of responsibility.
- Ability to read a variety of informational and technical documentation, directions, instructions, and methods and procedures.
- Ability to write reports with proper format, punctuation, spelling, and grammar, using all parts of speech.
- Ability to speak with and before others with poise, voice control, and confidence using correct English.
- Ability to apply principles of influence systems, and to exercise independent judgment to apply facts and principles for developing approaches and techniques to resolve problems.
- Ability to utilize a wide variety of references, descriptive, advisory and/or design data and information.
- Ability to utilize mathematical formulas, statistical analysis, add and subtract totals, multiply and divide, and determine percentages.
- Ability to deal with people beyond giving and receiving instructions. Must be adaptable to performing under stress when confronted with an emergency.
- Ability to communicate respectfully and professionally.
PHYSICAL REQUIREMENTS
Must be physically able to operate a variety of office machines, tools, and equipment, such as a computer, printer, fax machine, copy machine, calculator, or telephone. Tasks require the ability to exert light physical effort in sedentary to light work, but which may involve some lifting, carrying, pushing and/or pulling of objects and materials of light weight 40 pounds). Tasks may involve extended periods of time at a keyboard or work station. Requires the ability to inspect items for proper length, width, and shape, visually with job-related equipment. Requires the ability to coordinate hands and eyes in using job-related equipment. Requires the ability to handle a variety of items, job-related equipment, control knobs, switches, etc. Must have the ability to use one hand for twisting or turning motion while coordinating the other hand with different activities. Must have minimal levels of eye/hand/foot coordination. May require the ability to differentiate colors and shades of color. Requires the ability to talk and/or hear (talking - expressing or exchanging ideas by means of spoken words; hearing - perceiving the nature of sounds by ear).
Skills
PythonAzureSQLData ScienceData EngineeringETLPower BICompliance
