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 modelingSQL, Python, and / or JavaGit / GitHubCloud computing (Google Cloud Platform, AWS, etc.)Data Warehousing (BigQuery, Snowflake, DataBricks, etc.)ETL processesData ModelingAPI developmentData governance, data quality, and data security principles.Project ManagementSome knowledge of :
Data visualizationITIL FrameworkAbility 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 fieldThree (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 InsuranceLife and Supplemental Life InsuranceShort and Long Term DisabilityMandatory Pension PlanDeferred Compensation PlanPre-paid Legal ServicesVacation and Sick LeavesHoliday payTraining and Educational Reimbursement OpportunitiesFor 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 coursesHigh School Graduate or GEDAssociate DegreeAssociate Degree in Computer Science, Information Science, Engineering, or a related fieldBachelor's DegreeBachelor's Degree in Computer Science, Information Science, Engineering, or a related fieldMaster's DegreeMaster's Degree in Computer Science, Information Science, Engineering, or a related field02 Please choose the answer that best describes your years of experience in data engineering or data analytics.
No ExperienceLess than 1 year of experience1 year to less than 2 years of experience2 years to less than 3 years of experience3 years to less than 4 years of experience4 years to less than 5 years of experience5 years to less than 6 years of experience6 years to less than 7 years of experience7 or more years of experience03 Please describe your experience in data engineering or data analytics.
Required Question
