Data Engineer II

Salary: $76,065.60 - $90,322.96 Annually
Location : Boise City Hall, ID
Job Type: Full Time Regular
Job Number: 23 -07788
Department: Information Technology
Division: Data Services
Opening Date: 11/06/2026
Closing Date: 11/20/2026 12:00 PM Mountain

Summary Statement
The City of Boise is looking for a Data Engineer II who wants to use their technical skills on data that supports real projects and essential services across our community. This position sits within IT but works closely with Public Works, with a strong focus on Water Renewal operations and projects. You'll build and maintain data pipelines, develop data models, integrate information from a variety of systems, and create the reliable data foundation analysts need for dashboards, reporting, and decision-making. You'll work with tools such as SQL, Azure Data Factory, SSIS, APIs, and other modern data technologies while partnering directly with the teams who use the data. This position is hybrid eligible but requires living in the Boise area and working onsite as needed.

This position is hybrid eligible, but requires someone who lives in the Boise area and can work onsite as needed to collaborate with the teams and projects they support.

To ensure internal equity and alignment with the approved budget for this position, offers are made within the posted hiring range. Although the hiring range is fixed, employees receive an exceptional benefits and total rewards package that enhances the overall value of employment with the City of Boise.

Required Knowledge, Experience, And Training

• Bachelor's degree in computer science, information technology or a closely-related field
• Two - four years of experience in database and data warehouse management and ETL processing,
• Or an equivalent combination of education and/or experience.

Special Requirements
Applicants must be able to pass:

• City of Boise background check processes which includes a criminal history check and reference checks in accordance with the City of Boise Hiring Process Regulation
• Criminal Justice Information System background check (CJIS)
• Hybrid Work Eligible

Disclaimer: This job posting may close earlier than the listed closing date. If this occurs, a minimum of 24 hours' notice will be provided prior to closing. Applications received for this recruitment may be used to fill similar vacancies within the City of Boise as they occur
Essential Functions
Data Architecture & Modeling

• Design and implement scalable relational (SQL) and non-relational (NoSQL) data solutions
• Translate business requirements into conceptual, logical, and physical data models
• Ensure data is classified, secured, transformed, and aggregated for usability across diverse business needs
• Develop, test, and maintain databases and applications to enable efficient and secure data retrieval

Pipeline Development & Maintenance

• Build and support ETL/ELT pipelines that integrate data from multiple sources into warehouses, lakes, and applications
• Monitor and resolve performance issues, malfunctions, and bottlenecks in complex environments
• Install, configure, and optimize database systems and related software
• Implement disaster recovery, backup, and restoration processes

Process Analysis & Optimization

• Evaluate current data processes and recommend improvements for efficiency and scalability
• Collaborate with business owners to present solutions and implement enhancements
• Debug and troubleshoot data workflows, ensuring accuracy and reliability

Automation & Scripting

• Develop integrations using Azure Integration Services
• Extract and integrate data from diverse sources (SQL, SFTP, APIs, file systems, web services)
• Create ETL processes using SSIS, Azure Data Factory, advanced SQL techniques, and modern data transformation frameworks

Data Analysis & Mentorship

• Perform SQL performance tuning and advanced query optimization
• Provide guidance to data analysts on data usage and modeling
• Support storytelling with data to drive business insights

Database Administration

• Administer multiple database and integration servers across environments
• Plan, upgrade, and maintain database infrastructure for availability and scalability
• Troubleshoot, tune, and configure servers to meet enterprise requirements

Continuous Learning & Innovation

• Stay current with emerging technologies, tools, and best practices in data engineering, cloud platforms, and security
• Participate in training, conferences, and professional development opportunities

Requirements

Additional Required Knowledge, Experience, And Training

Knowledge of:

• Proficiency with relational databases (SQL Server, PostgreSQL, MySQL) and NoSQL systems (MongoDB, Cosmos DB)
• Experience with ETL/ELT tools and frameworks (SSIS, Azure Data Factory or similar)
• Strong skills in SQL, JSON, XML, and data integration protocols (FTP, APIs, web services)
• Familiarity with debugging and profiling tools (SQL Profiler, Fiddler)
• Experience with IDEs such as Visual Studio, VS Code, and SQL Management Studio
• Competence in source control systems (Git, Azure DevOps, GitHub) in collaborative environments
• Knowledge of Azure preferred

Ability to:

• Collaborate effectively across teams and with stakeholders at all levels
• Communicate clearly in English, both verbally and in writing
• Deliver assignments on time with attention to detail and quality
• Demonstrate initiative, adaptability, and problem-solving skills
• Maintain regular attendance and comply with organizational policies
• Perform essential functions with or without reasonable accommodation
• Operate vehicles safely and maintain an acceptable driving record

Preferred Knowledge, Experience, And Training

• Seven years of progressively responsible professional experience in database and data warehouse management and ETL processing.

• Experience with Azure, Power BI, or Python

Knowledge of:

• Elastic stack
• SSRS
• PowerBI
• Python
• Open data concepts.

Working Conditions

The physical effort characteristics and working environment described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical Efforts
While performing the duties of this job the employee is occasionally lifting/carrying up to 10 pounds and rarely lifting/carrying up to 20 pounds. Also, the employee is rarely pushing/pulling up to 20 pounds. The noise level is occasionally moderate. Work includes sensory ability to talk and hear. Work in this position also includes close vision. Employees will sit, stand, walk, reach and grasp. Position requires hand/finger dexterity.

Working Environment
The work environment will include inside conditions.

Most positions are eligible for the general benefits listed here; firefighters, police officers, senior managers, command staff, and directors may be offered other benefit plans.

Healthcare:

• ZERO premium medical coverage option for you and your family
• Low-cost dental and vision options
• Post-employment health savings account

Retirement and Investment Plans:

• Required participation in PERSI Base Plan retirement benefits with standard employee and City contribution rates
• 401(k) or 457b pre-tax investment options with employer match
• 457b Roth after-tax investment options with no match

WellBeing Program:

• Up to $500 cash per year for participants
• Alternative transportation incentives

Paid Leave - City employees receive generous paid leave:

• 10 hours of vacation per month, and this increases the longer you stay with the City
• 13 paid holidays every year
• 8 hours of sick leave per month
• 10 weeks Parental Leave

Life & Long Term Disability:

• Basic Life insurance at no cost to you
• Long Term Disability insurance at no cost to you

Other optional benefits:

• Pre-tax Flexible Spending Accounts
• Supplemental Life Insurance
• Supplemental Disability Insurance
• Tuition reimbursement
• Free local bus pass
• Corporate discount programs
• AFLAC
• Employee Assistance Program for short-term counseling on work, family, finances, and personal issues

Please visit our website for further details
01

Do you possess a valid state-issued driver's license?

• Yes, I have a valid state-issued driver's license.
• No, I do not currently have a valid state-issued driver's license.

02

Are you at least 19 years of age or older?

• Yes
• No

03

Do you have any experience using Databricks?

• No related experience
• Less than 1 year
• 1 to less than 2 years
• 2 to less than 4 years
• 4 or more years

04

Describe a complex data pipeline or ETL process you've built. What were the main challenges you faced, and how did you solve them?
05

This position is hybrid eligible and requires residency in the Boise metro area. Do you currently live in the Boise metro area, or are you prepared to relocate at your own expense prior to employment? (No relocation assistance is provided.) Please briefly explain your current situation and timeline:
Required Question