City of Boise (ID)-posted 12 days ago
Full-time • Mid Level
Hybrid • Boise, ID
Executive, Legislative, and Other General Government Support

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

  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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.
  • 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.
  • 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.
  • Valid state-issued driver's license.
  • 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)
  • 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.
  • 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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service