Data Engineer
Richmond VA
Required Skills : Strong SQL and PL/SQL skills are a MUST have (ideally 45 years of experience) Ideally 45 years of experience as a data engineer in either AWS or Azure ETL experience is needed This person will be doing a combo of development work and data migration This will be on site in Richmond VA (non negotiable)
- Purpose of Position:
The Data Engineer is responsible for designing building and maintaining robust data systems. They will also be responsible for the development and maintenance of agency applications. They will maintain all current applications per user requirements develop reporting adhere to agency and state software standards provide the data needed by the data group utilizing the current and new infrastructure and technology. |
- Knowledge Skills Abilities and/or Competencies required to successfully perform the work:
- Extensive experience designing automated pipelines that handle the extraction transformation and loading (ETL) of data from various sources into storage systems.
- Extensive experience designing building and managing databases and data warehouses.
- Experience integrating data from diverse sources such as APIs databases and flat files.
- Advanced proficiency in SQL. Proven knowledge and hands on experience with PL/SQL scripting including stored procedures functions triggers and packages.
- Hands on experience in performance tuning to ensure efficient execution times while querying large datasets from a database.
- Ability to troubleshoot errors related to data or other programmatic issues.
- Skills in cloud platforms like AWS Azure and OCI.
- Experience with ETL tools like Talend.
- Strong verbal and written communication skills.
- Must be able to work on multiple projects and contribute to project scope and estimates of effort.
|