Data Engineer II
Print (https://www.governmentjobs.com/careers/boiseid/jobs/newprint/5154949)
Apply
?
Data Engineer II
Salary
$76,065.00 - $90,322.00 Annually
Location
Boise City Hall, ID
Job Type
Full Time Regular
Job Number
23 -07346
Department
Information Technology
Opening Date
11/26/2025
Closing Date
12/10/2025 12:00 PM Mountain
Description
Benefits
Questions
Summary Statement
As a Data Engineer II with the City of Boise, you'll design and build the data systems that power decision-making across our organization. This is a hands-on role where you'll create data pipelines, manage databases, and ensure information flows smoothly from source systems to the people who need it.
You'll be part of a small, close-knit team that moves quickly and works well together. We're not just maintaining existing systems - we're building the foundation for how the City approaches data engineering. Your work will directly shape our standards and practices as we grow, and your ability to collaborate and communicate will be just as important as your technical skills.
In this role, you'll work across the full data lifecycle: designing scalable database solutions, building ETL/ELT pipelines, optimizing performance, and making data accessible for analytics and applications. You'll collaborate with teams across the city, translate business needs into technical solutions, and help others understand how to use data effectively.
What matters most: You're technically strong with SQL and data integration, you enjoy solving complex problems, you communicate clearly with both technical and non-technical colleagues, and you thrive in a collaborative, fast-paced environment where your ideas and expertise will have immediate impact.
This position is open due to a promotion within our team - come grow with us!
This position is hybrid eligible and requires residency in the Boise metro area. Candidates must currently live in the area or be prepared to relocate at their own expense prior to employment. No relocation assistance is provided. Candidates must be legally authorized to work in the United States
WHY WORK FOR THE CITY OF BOISE?
Top talent deserves top-notch benefits. The City is among the best in the Treasure Valley when it comes to the benefits and perks we offer our employees.
ZERO premium medical coverage option for you and your family
PERSI retirement benefits plus 401(k)/457b with employer match
10 hours vacation per month (increases with tenure) + 12 paid holidays + 8 hours sick leave per month
10 weeks Parental Leave
Up to $500 annual WellBeing incentive
Tuition reimbursement and free local bus pass
Basic Life and Long Term Disability insurance at no cost
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
Performs other duties as assigned. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this position at any time
Requirements
Required Knowledge, Experience, And Training
Bachelor's degree in computer science, information technology, or a closely-related field and four years progressively responsible professional experience in database and data warehouse management and ETL processing or an equivalent combination of education and/or experience.
Level of Knowledge:
Functional knowledge of No-SQL databases
Functional knowledge in relational databases MSSQL Server, SSIS, JSON, XML, FTP
Functional knowledge demonstrating competence troubleshooting and debugging with profiled tools including SQL profiler, Fiddler, etc.
Functional knowledge working on integrated development environments including Visual Studio, VSCode, and Microsoft SQL Management Studio for the purpose of developing and writing clean, consistent, logical, and well-documented code
Functional knowledge of using source control repository in a team environment.
Abilities:
Display an attitude of cooperation and work harmoniously with all levels of city employees, the general public, and other organizations
Communicate effectively in the English language at a level necessary for efficient job performance
Complete assignments in a timely fashion
Understand and comply with all rules, policies, and regulations
Maintain prompt and regular attendance
Perform all essential and marginal functions as assigned by an authorized employee, supervisor, and/or manager with or without reasonable accommodation.
Individuals must be capable of operating vehicles safely and have 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 Elastic stack, SSRS, PowerBI, Python, R and open data concepts.
Licensing And Other Requirements
Valid state-issued driver's license.
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
Driving Record Check
Criminal Justice Information System background check (CJIS)
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 rarely lifting/carrying up to 35 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. Position requires hand/finger dexterity.
Working Environment
The work environment will include inside conditions. Employees will also drive a vehicle as part of this position.
Top talent deserves top-notch benefits. The City is among the best in the Treasure Valley when it comes to the benefits and perks we offer our employees.
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:
PERSI retirement benefits
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
12 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 mybenefits.cityofboise.org
