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 among 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.
Seattle IT is seeking a Senior Data Engineer, ITP-A Exempt
Come and work at Seattle's Department of Information Technology supporting our Seattle Police Department! We are currently recruiting a Senior Data Engineer to become a Data Integration Lead for the Data Engineering and Analytics Team. This position is a key development and administrative role for operational and public safety analytics and will work as a key team member for providing important Seattle Police Department analytics data. In this role, you will guide database and infrastructure design, development, and provide integration leadership to improve the data warehouse architecture, extract, transform, and load (ETL) processes, and analytics data models.
You are also responsible for consistent performance of these data systems, and for building strategic relationships with our Seattle Police to collaborate on issues, improvements, priorities, and future state roadmaps. Utilizing your experience and knowledge, you will establish policy, process, and best practices.
Using your experience and vision, you will define future work and data technologies for reporting and analytics of police activities. This involves crafting technical roadmaps and recommending data strategies for projects involving cloud and on-premises data solutions.
While database expertise is a necessary skill for this position, AWS cloud services will be used extensively, and you will also be relied on to understand processing and server requirements, and various cloud data analytics platforms and tools.Primary Job functions:
Coordination of Seattle IT roles to support and enhance the existing Seattle Police Data Analytics Platform (DAP) Data Mart/Warehouse Solution. Monitor processes as needed, possibly requiring availability outside of normal business hours, respond to customers, and IT staff to resolve issues. Prioritize support work with other planning and development tasks.
Lead production support, lead infrastructure design, participate in requirements and design, lead development, unit testing, participate in regression and UAT testing, lead deployment.
Plan, build, and implement improvements to AWS Cloud based data analytics systems, on-premises data stores, and analytical models. This involves communication and coordination with business owners, program managers, data scientists, data architects, and developers across IT, Seattle Police, and external consulting companies. Analyze resource needs, and feasibility of proposed changes or enhancements, build, schedule, communicate, and implement updated data products.
Research, plan, and propose future state data analytics using new technologies and Amazon Web Services. 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 management.Required Qualifications: 
Education: Successful candidates will have 5 years’ experience and training in Computer Science, Business Information systems, Database Management, Amazon Web Services, or a related field or a similar combination of experience and education.
Experience:Demonstrated ability working with data to address business needs, including development of data repositories, warehouses, operational data stores, analytics models, or related systems.
Work experience with database systems, and SQL languages, database scripting, management, scheduling, optimization, integration tools.
Experience recommending solution architectures and requirements for large data analytics projects, including the ability to scope processing, memory, and storage needs.
Experience and knowledge of data analytics services in cloud services, including data project migrations, cloud native analytics tools and services, deployment processes, security and privacy principles, and service cost strategies. Experience working in an Agile work environment and using tools such as Jira, Confluence, SharePoint, Teams.
Technical/Professional skills needed to succeed:
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.
Analytics and Cloud Data: Experience with Cloud based data tools such as AWS Cloud Formation Templates, S3, Glue, Python, Spark, Athena, or other cloud data tools. Understanding of Analytics and reporting tools (i.e. O365 tools, Tableau, etc.). Strong desire to learn and explore new capabilities in this area.
Knowledge of Amazon Web Service or other cloud services and processes for building and supporting data warehouses, data marts, and data stores. Skills to provide leadership and perform development work moving and merging of approximately 20 Police Department data sets into curated data sources for reports and dashboards that are used by SPD to inform operational decisions.
Criminal Justice Information Services (CJIS) certification - You must pass an FBI background investigation and certification process for work on Seattle Police systems.Desired Qualifications
Established experience with written, verbal, and illustrative communication. Ability to modify communication styles to communicate relevant technical content with the professionals that perform the various city business functions, as well as technical engineers, and management.
Dedication to Race, Social Justice, and Equity
You will be expected to take part and understand Seattle’s need to continually address race-based disparities and to end institutionalized racism. A major role will be to work with Seattle IT and departments to prioritize project work based on how it assists Seattle to address equity. This involves participation in race and social justice initiatives and crafting standard processes for using a related tool kit in all projects. To deliver accurate city performance data, this role is necessary for our city departments to understand and manage the equitable distribution of City services.
Salary: The full salary range for this position is $51.89 - $77.84 per hour. The salary for this individual role has been identified as $51.89 – $77.84 per/ hour.
Why work at the City of Seattle?
The City of Seattle recognizes every City employee must play a role in ending institutional and structural racism. Our culture is the result of our behavior, our personal commitments, and the ways that we courageously share our views and encourage others to do the same. To cultivate an antiracist culture, we seek employees who will engage in the Race and Social Justice Initiative by working to dismantle racist policies and procedures, unlearn the way things have always been done, and provide equitable processes and services.
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.
Application Process: For optimal consideration, we encourage you to include a cover letter and resume with your application. We encourage you to use your cover letter to discuss why you want to do this work and how you meet the qualifications for the position. Your resume should summarize the talent, experience, knowledge, and skills you bring to this work. Apply online at https://www.governmentjobs.com/careers/seattle/
If you have any questions, please contact Alfreda Wilson, at Alfreda.wilson2@seattle.gov
Workplace Environment (Telework Expectation): This position offers the flexibility of a hybrid work schedule. At this time, hybrid telework schedules have a minimum requirement of two days onsite per week. Individual schedules will be based on operational needs and agreement between the employee and their supervisor.
Background Check: This hiring process involves a background check of conviction and arrest records in compliance with Seattle's Fair Chance Employment Ordinance, SMC 14.17. Applicants will be provided an opportunity to explain or correct background information.
Criminal Justice Information Services (CJIS) certification - You must pass an FBI background investigation and certification process for work on Seattle Police systems.
Who may apply: This position is open to all candidates that meet the minimum qualifications. The City of Seattle values different viewpoints 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 City 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.
#LI-FW1