April 1, 2022
Apply Now
Seattle, WA, United States
April 1, 2022
Apply NowJob description
The City of Seattle is seeking candidates for two Senior Data Engineers to become Data integration Leads for the Data Engineering and Analytics Team within the Applications Division of Seattle Information Technology (IT).
As a city, Seattle is known as a progressive leader in technology, innovation, and the environment. As an employer, the City of Seattle is leading local government in environmental stewardship and social justice amongst other things, making our city what it is today and shaping our exciting future. The organization’s workforce plays a critical role in making this possible.
Seattle IT is a trusted partner that provides secure, reliable, and compliant technologies enabling the City of Seattle to deliver equitable and responsive services to the residents of Seattle. This purpose statement is a simple declaration of who we are and why we do our work. It is intended to be a guide that helps us to not lose sight of why we perform everyday tasks or to invest effort to solve difficult problems. It emphasizes that our existence as a department is to support our City partners. It reminds us that we are part of a larger organization that collectively is working to improve the lives of the residents of our city. The 600+ strong professionals in Seattle IT are involved in the full spectrum of a modern IT enterprise offering many dynamic career opportunities. We hope you’ll join us.
Job Responsibilities:
The Senior Data Engineers are key development and administrative roles for large financial and other departmental data warehouse implementations. These roles will provide expertise in database design and development to manage and enhance the data warehouse architecture, Extract, Transform, and Load (ETL) Processes, and Analytics cubes. The Senior Data Engineer positions will also be responsible for consistent performance of these data systems, and for building strategic relationships with our key customers to collaborate on issues, enhancement, priorities and future state roadmaps.
As a Senior Data Engineer, these positions will take a leadership role in guiding the future work and technologies used in the City of Seattle Data Engineering and Analytics team. This will involve creating roadmaps and recommending strategies for data projects involving cloud and on-premises data solutions.
While Database expertise in both Oracle and SQL Server are important skills for these positions, successful candidates will also be depended on to understand processing and server requirements, and to be able to participate in planning future cloud-based implementations.
Primary Job functions:
- Manage and support existing Data Warehouse Solutions. Monitor evening and weekend processes, respond to customers, and needed Seattle IT Staff/roles to resolve issues. Prioritize support work with other planning and development tasks.
- Plan, Build, and implement enhancements to Data Warehouse and Analytical Cube systems. This involves communication and coordination with customers, and analysis of server resource needs, analyzing feasibility of proposed changes or enhancements, building, scheduling, communicating, and implementing updated data products.
- Research, Plan, and Propose future state data analytics using new technologies and possibly cloud systems. Research and understand industry recommended paths to future state technology use. Analyze and propose solutions that consider technical feasibility in our city environment, business cost/value, and resource needs. Participate in high level discussions and presentations with business and Seattle IT management.
Qualifications:
Minimum Qualifications:
Equivalent combinations of education and experience will be considered for the required qualifications.
Education: Successful candidates for these positions will have a BA degree in Computer Science, Business Information systems, Database management, or a related field or equivalent experience.
Experience:
- 5+ years' experience working with data to address business needs, including development of data repositories, warehouses, operational data stores, analytics cubes or related systems.
- Knowledge of database systems, 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 processed for data project migrations, cloud native tools and services for data analytics, deployment processes, security and privacy principles, and cloud service cost strategies.
Desired Qualifications:
Technical/Professional skills needed to succeed:
- Knowledge and experience with multiple database systems and the related tools sets available, for example Oracle, AQL Server, Postgres SQL, Extract, Transform, Load (ETL) tools, reporting, scheduling and integration tools.
- Understanding of analytics and reporting tools, specifically Excel, Power BI, Tableau, SQL Server Reporting Services.
- 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.
Other Skills Desired:
Communication Skills: Established experience with written, verbal. And illustrative communication. Ability to effectively communicate meaningful technical content with the professionals that perform the various city business functions at our city departments, as well as with Seattle IT technical professionals and various management staff.
Leadership: Experience and ability to provide guidance on processes and technologies used for Data Engineering and Analytics, and to guide customers in their adoption of tools, processes, and technologies.
Team engagement: Serve roles on various City of Seattle, technology teams to provide expertise and support for Information Technology projects that have reporting or analytics requirements. Maintain open contact with Applications, Server, Security, Privacy, and Database teams to address project or program needs and to provide necessary support for the roles of those team.
Commitment to Race, Social Justice, and Equity: Successful candidates for these positions will be expected to take part and understand the City of Seattle’s need to continually address race-based disparities and to end institutionalized racism. As a leadership role on the City of Seattle Data Engineering and Analytics team, a major role will be to work with Seattle IT and City departments to prioritize project work based on how it assists the City of Seattle to address equity. This involves participation in department race and social justice initiatives and creating standard processes for using a related tool kit in all projects. As a key role in providing accurate city performance data, this role is critical for all or our city departments to be able to understand and manage the equitable distribution of City services.
Additional Information:
Please submit your resume and cover letter along with your online application at https://www.governmentjobs.com/careers/seattle/.
Employees of the City of Seattle enjoy competitive pay and comprehensive benefits package generous leave programs, and the satisfaction of doing work that helps make Seattle a great place to live, work, and play. Explore City of Seattle – Benefits at a Glance for more information.
Workplace Environment (Telework Expectation):
Most work is performed in a normal City work/office environment; however, due to the ongoing pandemic and Covid-19 state and local restrictions this team is working remotely. This is subject to change as circumstances dictate.
Most work is performed in a normal City work/office environment; however, due to the ongoing pandemic and Covid-19 state and local restrictions this team is working remotely. This is subject to change as circumstances dictate.
All City of Seattle employees are required to be fully vaccinated against COVID-19. Failure to submit proof of vaccination or qualify for a reasonable accommodation will result in withdrawal of the job offer.
NOTE: Employment contingent upon successful completion of comprehensive background investigation in compliance with Seattle’s Fair Change Employment Ordinance SMC 14.17.
Who May Apply: This position is open to all 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. The Department encourages people of all backgrounds to apply, including people of color, immigrants, refugees, women, LGBTQ people, people with disabilities, veterans and those with diverse life experiences. Accommodations for people with disabilities are provided on request.
#LI-MV1
