> Markdown version of [/jobs/ext/4638087-data-engineer-ii](https://www.wearedevelopers.com/jobs/ext/4638087-data-engineer-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Engineer II

- **Company:** City of Boise
- **Location:** Boise, ID, United States
- **Experience:** Experienced
- **Salary:** $76,066 - $90,323
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Data Analysis, Microsoft Azure, Profiling, Information Systems, Databases, Data Architecture, Information Engineering, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Security, Data Systems, Relational Databases, Software Debugging, Disaster Recovery, File Systems, Elasticsearch, Fiddler (Software), Github, Revision Control Systems, JSON, Python (Programming Language), PostgreSQL, Microsoft Visual Studio, Microsoft SQL Server, MongoDB, MySQL, NoSQL, Open Data Protocol, Query Optimization, Power BI, Sqlprofiler, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Visual Studio Online, Web Services, Extensible Markup Language (XML), File Transfer Protocol (FTP), Azure Data Factory, Sql Optimization, Git, Usage Tracking, Information Technology, Cosmos DB, Data Management, Physical Data Models, Cloud Integration, Sql Database Administration, Data Pipelines, Sql Tuning
- **Published:** November 8, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=e12185ebb7fa86a6

## About the Role

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

## Description

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