Data Engineer

Description

**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.

Duties

• 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 (these are required for all positions at ACG):
Accountability
Accessibility
Inclusivity
Integrity Requirements

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.

Toll Free Applicant Technical Support: If you experience technical difficulty with the NEOGOV system (i.e. uploading or attaching documents to your online application), call NEOGOV technical support at 855-524-5627. Helpful hints: if you are having difficulty uploading or attaching documents to your application, first, ensure your documents are PDF or Microsoft Word files, and second, close the document before you attempt uploading (attaching) it.

As a Regular Full-Time employee at Arapahoe County Government, you are eligible for benefits such as:

• 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

For a more detailed listing of our benefit programs, click on the MENU link on the left and then Benefits Summary. 01 Please choose the response that best describes your educational background.

• Some high school courses
• High School Graduate or GED
• Associate Degree
• Associate Degree in Computer Science, Information Science, Engineering, or a related field
• Bachelor's Degree
• Bachelor's Degree in Computer Science, Information Science, Engineering, or a related field
• Master's Degree
• Master's Degree in Computer Science, Information Science, Engineering, or a related field

02 Please choose the answer that best describes your years of experience in data engineering or data analytics.

• No Experience
• Less than 1 year of experience
• 1 year to less than 2 years of experience
• 2 years to less than 3 years of experience
• 3 years to less than 4 years of experience
• 4 years to less than 5 years of experience
• 5 years to less than 6 years of experience
• 6 years to less than 7 years of experience
• 7 or more years of experience

03 Please describe your experience in data engineering or data analytics.

Required Question