Address
Form of work
SalaryPosition Description
Seattle Public Utilities' (SPU) Financial and Risk Services Branch is looking for a dynamic individual to fill a Data Engineer/Systems Administrator position. The position is a key technical role creating and supporting data integration and data analytic products. This position will support SPU’s financial data & reporting environment which consists of a complex data warehouse and several enterprise business applications such as IBM Cognos Analytics. This position provides database design and development to build and enhance the data warehouse architecture, and Extract, Transform, and Load (ETL) processes. This position provides system administration functions such as system configuration, backups, standard updates and fixes, application and server monitoring, maintenance, security, user setup, access/permissions, and performance tuning. Ensures compliance with licensing agreements, troubleshoots issues, and maintains system reliability.
If you feel this may be the perfect job for you, please continue reading ...and APPLY!
About Seattle Public Utilities (SPU): Seattle Public Utilities (SPU) is a community-centered utility that delivers vital services to Seattle residents and businesses including drinking water, drainage and wastewater, and garbage/recycling/compost. SPU also provides drinking water for 1.5 million customers in the region. SPU’s work includes system maintenance and improvements and keeping Seattle clean. Over 1,400 SPU employees work with our community to provide affordable and equitable stewardship of our water and waste resources for future generations.
For more information about Seattle Public Utilities (SPU), please visit:
- SPU Workplace Expectations (Download PDF reader) (Download PDF reader)
- Strategic Business Plan
SPU commits to Our City Values and Race and Social Justice as core principles that guide our work. We actively take steps to dismantle systemic racism and increase service equity. We value diverse life experiences and strive to create a workplace that is welcoming to all. We take steps to be inclusive and equitable in our recruiting, hiring and promotional opportunities.
Why join us?
We know work isn't only about what you do it’s also about who you work for and with! SPU provides a fun and family-friendly work environment that supports a work life balance, including:
- Hybrid work schedule opportunities
- Family-friendly and multicultural work environment
- Generous benefits package
- Free public transportation options
- City pension plan with employer/employee contributions
- Growth potential and advancement opportunities
Job Responsibilities
- Support the financial data warehouse, data marts, and data analytical products.
- Design & develop enhancements to the financial data & reporting environment.
- Assist staff and business customers in connecting, using data marts, and analytical products such as IBM Cognos Analytics, Tableau, and Power BI.
- Perform standard administrative tasks such as set-up, security, and maintenance for new users, clients, roles, and groups, monitor and troubleshoot system performance.
- Use automation and integration tools to build robust scheduled processes for moving and redefining data into data warehouses, data marts, or other analytics data systems.
- Track timeline of future major upgrades, participate in upgrade planning, and apply current product patches.
- Plan server utilization for new and existing projects, work with Server group to enhance or build new servers.
- Migrate new objects (reports, queries) into Test and Production instances.
- Maintain product configuration and lead application testing.
- Maintain data source connectivity/integration, rollback & restore servers as needed.
Please note this job advertisement is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Qualifications
Experience: Requires Three (3) years system administrator, data engineering, or developer experience working with data to address business needs, including development of data repositories, warehouses, data marts, analytics cubes, or related systems.
Education: Bachelor's degree in Computer Science, Information Technology, Business Information systems, Database management, or related field.
Experience/Education Equivalency: A combination of education and/or training and/or experience which provides an equivalent background required to perform the work of the class may be substituted for the required education or experience.
To be successful in this role, a candidate should possess some of the following knowledge/experience, skills & abilities:
- Knowledge and experience with IBM Cognos Analytics or similar business intelligence (BI) tool.
- Knowledge of database systems, SQL languages, database scripting, management, scheduling, optimization, integration tools.
- Understanding of server architectures and requirements for large data analytics projects, including the ability to scope processing, memory, and storage needs.
- Experience and knowledge of cloud services for data analytics, including tools and processes for data project migrations, cloud native tools and services for data analytics, deployment processes, security and privacy principles, and cloud service cost strategies.
- Knowledge and experience with multiple database systems and the related tool sets available, for example Oracle, SQL Server, Postgres SQL, Extract, Transform, Load (ETL) tools, Reporting, scheduling, and integration tools.
- Understanding of Analytics and reporting tools, specifically IBM Cognos Analytics, IBM Planning Analytics, Excel, Power BI, and Tableau.
- Experience building Data Warehouse systems and analytics systems, including learning, and understanding business needs and creating facts and dimensions, analysis cubes, processing scripts, schedules, and implementing integration packages.
Additional Information
How to Apply: In addition to fully completing the online application, please attach your resume and cover letter. Your cover letter should address your knowledge and experience related to the position.
Workplace Environment:This position allows for the flexibility of a hybrid work schedule. Employees will be required to come into the office twice a week. Individual schedules will be agreed upon by the employee and their supervisor.
The full salary range for this position is $45.44 - $68.20 per hour.
Benefits: The City of Seattle offers a comprehensive benefits package including vacation, holiday, and sick leave as well as medical, dental, vision, life and long-term disability insurance for employees and their dependents. More information about employee benefits is available on the City's website at: https://www.seattle.gov/human-resources/benefits/employees-and-covered-family-members/most-employees-plans
Who may apply: The City of Seattle encourages people of all backgrounds to apply, including people of color, immigrants, refugees, women, LGBTQ, people with disabilities, veterans, and those with diverse life experience. This position is open to all qualified candidates that meet the minimum qualifications. The City of Seattle values diverse perspectives and life experiences. Applicants will be considered regardless of race, color, creed, national origin, ancestry, sex, marital status, disability, religious or political affiliation, age, sexual orientation, or gender identity.
If you have any questions, please contact Charles Gilmore at charles.gilmore2@seattle.gov
Learn more about Seattle Public Utilities at our web page www.seattle.gov/util/.
The City of Seattle offers a comprehensive benefits package including vacation, holiday and sick leave as well as medical, dental, vision, life and long-term disability insurance for employees and their dependents.
