Job Location: Boise, ID
The Information Technology Department (IT) collaborates with every department to implement new technology services and provide supporting data and information while maintaining the city’s existing information technology landscape in service to our community.? We are currently seeking an experienced and skilled Sr. Data Engineer to partner with our DevOps Team.
- Architects, designs, creates, and maintains the organization’s data architecture and serves as a member of a DevOps team
- Responsible for the installation and life cycle support of database systems and pipeline processing
- Applies data expertise on current and potential future sources and uses of data, and the quality and relationships between data sets
- Identifies, analyzes and troubleshoots complex problems
- Plans strategically for existing and future data growth and changes
- Ensures optimal performance and scalability and actively works to understand and facilitate the capture, retention and use of information
- Provides technical leadership and support to new and existing large-scale systems and databases in a multi-platform environment of enterprise-level applications
- Work is performed under considerable initiative, judgment, and creativity
The City provides top-notch healthcare for you and your family at little to no cost. Plus, an actual pension plan, 401k matching, a wellness program, tuition reimbursement, paid parental leave, and more. Imagine that.
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. (40%)
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. (30%)
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. (10%)
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. (10%)
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. (10%)
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. Total Percentage = 100%
Required Knowledge, Experience, And Training
- Bachelor’s degree in computer science, information technology, or a closely related field and,
- 7 years of progressively responsible professional experience in database, ETL, and data warehouse architecture and design or
- An equivalent combination of education and/or experience.
Level of Knowledge:
- 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
- The investigation, troubleshooting, and resolution of advanced technical issues
Ability to:
- See 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
- 10 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)
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 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 the 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.
#CityofBoiseHR
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 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:
- 8 hours of vacation per month, and this increases the longer you stay with the City
- 11 paid holidays every year
- 8 hours of sick leave per month
- Six 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
Submit CV To All Data Science Job Consultants Across United States For Free