Data Engineer

Data EngineerPurpose 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.