Data Engineer Senior at City of Boise, ID

About the Department

Join the City of Boise as a Data Engineer - Senior and shape the future of our data infrastructure! 

We're seeking an experienced data professional who thrives in Microsoft environments and brings both on-premises and cloud expertise to our evolving technology landscape. This hybrid-eligible role is perfect for someone with deep Azure ecosystem experience who thinks strategically about enterprise-level data systems. You'll architect solutions that bridge traditional on-prem infrastructure with modern cloud capabilities, ensuring our data architecture scales to meet the growing needs of our community. If you have a proven track record in Microsoft shops and want to apply your enterprise-level thinking to meaningful public service, this is your opportunity to make a lasting impact.

Why the City of Boise?

The City offers some of the best benefits in the Treasure Valley:

• ZERO premium medical coverage option for you and your family
• PERSI retirement plus 401(k)/457b options with employer match
• Generous paid leave: 15 vacation days (year one), 12 holidays, sick leave, and 10 weeks parental leave
• Up to $500/year wellness incentive
• Life and long-term disability insurance at no cost
• Tuition reimbursement and professional development opportunities

Position Duties

Architects, designs and creates stable and reliable relational SQL and non-relational NoSQL data solutions and applications. Identifies business needs and translates them into conceptual, logical and physical data models, and end-user application interfaces. Defines and maintains the software infrastructure that keeps data flowing and processing in a secure manner. Ensures data is secured, correctly stored, protected, cleaned, transformed, and aggregated to make data usable and accessible to meet various business requirements. Develops, tests, improves, and maintains new and existing databases and applications to assist users in retrieving data effectively and securely. Designs and implements data pipelines that clean, aggregate, and organize data from multiple complex channels. Solves database and database server usage issues, performance problems and malfunctions across a wide and complex environment. 

Analyses current business and data processes and procedures to solve problems and recommend improvements and simplifications. Analyzes and debugs data processes and implements appropriate corrective actions. Works with customers to identify and characterize core problems and designs appropriate data processes and application solutions. Provides data analysis and story-telling, and SQL performance tuning. Provides guidance, mentoring and support in data usage and data modeling techniques for the internal data analyst community. 

Writes scripts and applications to automate data tasks using C#, Powershell, SQL Agent Jobs, Windows services, scheduled tasks, Logstash and other relevant tools. Provides data mining and extraction from vendor applications and databases to increase data availability and usability. Extract data from various systems including SQL, FTP, file systems, web services, and other sources and protocols. Defines and creates ETL (transform) processing using SQL CLR, C# data model transform, CLR, C# object-oriented approach to data modeling, SQL Server Integration Services, SQL views and UDFs, XML/XSL, and advanced SQL techniques. 

Administers multiple database and application servers, and data server infrastructures. Coordinates planning, upgrades, maintenance, testing, and availability of databases and applications. Provides requirements, design, implementation planning, and implementation of data server environments. Troubleshoots, tunes, administers and configures data and application servers. 

Stays up to date with technology through research of technical bulletins, white papers, etc. regarding security, performance and coding practices. Attends seminars, conferences, and training sessions. 

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.

Minimum Qualifications

Required Knowledge, Experience, And Training
Bachelor’s degree in computer science, information technology, or a closely related field and seven years' progressively responsible professional experience in database, ETL, and data warehouse architecture and design or an equivalent combination of education and/or experience.

• Functional knowledge (Hands-on) experience working in 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. Experience using source control repository in a team environment.
• Advanced knowledge in designing relational and non-relational databases to implement solutions to complex business problems
• Relational and non-relational database technology and data modeling
• Designing, deploying, and supporting Elastic stack solutions using Elasticsearch, Logstash, Kibana, and Beats.
• Observing, troubleshooting, and debugging across multiple interconnected systems to design and implement solutions to ensure performance, stability, program correctness, and system health
• Investigation, troubleshooting, and resolution of advanced technical issues.

Ability to:

• Sees complex relationships in technical dynamics and creates solutions to achieve the overall business goals.
• 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
Ten years of experience designing, developing and supporting databases and data processes in a Microsoft Windows Environment.

Experience with relational database MSSQLServer, Elastic stack, SSIS, SSRS, JSON, XML, FTP. Business intelligence tools, Logstash, Grok, etc.

Experience troubleshooting and debugging with profiler tools including SQL profiler, Fiddler, etc.

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

Credit History Check

Driving Record Check

Transportation Security Administration background check (SIDA)

Criminal Justice Information System background check (CJIS)

Other Qualifications

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.

Apply Now