Data Engineer

This posting is open until filled We are seeking a highly skilled and motivated Data Engineer to join our county government's Data Services Team. As a Data Engineer, you will play a critical role in building and maintaining the data lifecycles and repositories that support our data‑driven decision‑making processes. Your expertise will enable the availability of high‑quality data for various stakeholders within the organization. This role requires strong technical skills, a deep understanding of data architecture, and a passion for leveraging data to drive meaningful insights and improvements in government operations. Responsibilities Collaborate with cross‑functional teams to understand data requirements, and design and implement scalable and efficient data pipelines to extract, transform, and load (ETL) data from various sources into data warehouses or data lakes. Apply data transformation techniques to cleanse, validate, and enrich incoming data, ensuring its quality, integrity, and consistency. Design and construct data warehouse schemas and tables to optimize data storage, retrieval, and analytics performance. Develop and maintain data models to support the county government's reporting, analytics, and visualization needs. Continuously monitor and enhance data pipelines and warehouse performance, identifying and resolving bottlenecks, and optimizing data retrieval and processing times. Implement data security measures, including access controls and encryption, to protect sensitive information. Ensure compliance with relevant data privacy regulations. Create and maintain comprehensive documentation for data pipelines, data models, and data dictionaries to facilitate knowledge sharing and support data governance initiatives. Collaborate with data scientists, analysts, and other stakeholders to understand their data requirements and provide technical support, troubleshooting, and guidance on data‑related issues. Skills, Abilities and Competencies Considerable knowledge of: Data engineering, data warehousing, ETL processes, and data modeling SQL, Python, and/or Java Git/GitHub Cloud computing (Google Cloud Platform, AWS, etc.) Data Warehousing (BigQuery, Snowflake, DataBricks, etc.) ETL processes Data Modeling API development Data governance, data quality, and data security principles. Project Management Some knowledge of: Data visualization ITIL Framework Ability to: Develop ETL scripts. Manage cloud infrastructure. Set up error monitoring. Interact with external APIs. Implement version control best practices. Implement security best practices. Write testable code. Communicate with non‑technical stakeholders and cross‑functional teams. Manage and lead a team in a project‑oriented environment. Behavioral Competencies (required for all positions at ACG) Accountability Accessibility Inclusivity Integrity Education and Experience Bachelor's Degree from a fully accredited institution in Computer Science, Information Science, Engineering, or a related field Three (3) years of full‑time experience in data engineering or data analytics. Any equivalent combination of education and work experience that satisfy the requirements of the job will be considered. Supplemental Information Pre‑Employment Additional Requirements Must successfully pass pre‑employment testing which includes an acceptable motor vehicle record (MVR) and background check. Post‑Employment Requirements Successful completion of bi‑annual Colorado Justice Information System (CJIS) training.

WORK ENVIRONMENT

Work is generally remote, confined to the state of Colorado. Occasional time on‑site at county facilities may be required.

PHYSICAL DEMANDS

The following are some of the physical demands commonly associated with this position. Spends 90% of the time sitting and 10% of the time either standing or walking. Occasionally lifts, carries, pulls or pushes up to 20 lbs. Occasionally uses cart, dolly, or other equipment to carry in excess of 20 lbs. Occasionally climbs, stoops, kneels, balances, reaches, crawls and crouches while performing office or work duties. Verbal and auditory capacity enabling frequent interpersonal communication through automated devices, such as computers, telephones, and similar; and in public meetings and personal interactions. Constant use of eye, hand and finger coordination enabling the use of automated office machinery or equipment. Visual capacity enabling constant use of computer or other work‑related equipment. Below, please list any special physical demands associated with this position. For instance, exposure to hazardous environments, blood borne pathogens, extreme heat/cold, use of power equipment or machinery, wearing of PPE (personal protective equipment). Definitions Occasionally: Activity exists less than 1/3 of the time. Frequently: Activity exists between 1/3 and 2/3 of the time. Constantly: Activity exists more than 2/3 of the time. Benefits Medical, Dental, and Vision Insurance Life and Supplemental Life Insurance Short and Long Term Disability Mandatory Pension Plan Deferred Compensation Plan Pre‑paid Legal Services Vacation and Sick Leaves Holiday pay Training and Educational Reimbursement Opportunities #J-18808-Ljbffr Arapahoe County