Data Engineer II - Hybrid, Build Citywide Pipelines

City of Boise; Boise (ID); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Employer-paid health coverage

PERSI retirement with employer match

Paid time off and holidays

Wellbeing incentive

Tuition reimbursement and bus pass

Job summary

The City of Boise is seeking a Data Engineer II to design and maintain data pipelines, models, and analytics-ready data for dashboards and reports. You will work within IT, collaborating with Public Works on Water Renewal projects, using SQL, SSIS, Azure Data Factory, APIs, and other modern data tools.

Hybrid eligible and based in the Boise area, the role emphasizes reliable data foundations and cross-team partnerships to drive informed decisions across municipal services.

Qualifications

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

Responsibilities

• Design and implement scalable relational (SQL) and non-relational (NoSQL) data solutions.
• Translate business requirements into conceptual, logical, and physical data models.
• Develop, test, and maintain databases and applications to enable efficient data retrieval.
• Build and support ETL/ELT pipelines that integrate data from multiple sources into warehouses, lakes, and applications.
• Collaborate with business owners to present solutions and implement enhancements.

Skills

SQL

NoSQL

ETL/ELT tools

Azure Data Factory

SSIS

APIs

Education

Bachelor’s degree in computer science or related field

Tools

Azure Data Factory

SSIS

Power BI

Python

SQL Management Studio

Git

Job description

The City of Boise is seeking a Data Engineer II to design and maintain data pipelines, models, and analytics-ready data for dashboards and reports. You will work within IT, collaborating with Public Works on Water Renewal projects, using SQL, SSIS, Azure Data Factory, APIs, and other modern data tools.

Hybrid eligible and based in the Boise area, the role emphasizes reliable data foundations and cross-team partnerships to drive informed decisions across municipal services.