Data Engineer
Seattle, WA

Job Description

Position Description Benefits Supplemental Questions

Department Overview

The City of Seattle is seeking qualified candidates for the position of Data Engineer with 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 in making this possible.

Seattle IT is the technology backbone of the City of Seattle's complex operations and its ability to deliver a wide array of services for the residents of Seattle. The 700+ strong professionals in Seattle IT are involved in the full spectrum of a modern IT enterprise offering many dynamic career opportunities. Our vision is simple: be a Best-in-Class digital services delivery team and set best practices for others to follow.

The Data Engineer will design, develop and implement data platforms to support enterprise-wide analytics and reporting. This position is part of the Data team within the Service Modernization division and will be primarily responsible for providing analysis, architecture, design, development, testing, deployment and automation of various data platforms and components.

The ideal candidate will have demonstrated experience in implementing end-to-end, source-target-user ETL and ELT data pipelines over complex on-prem and off-prem platforms, by closely working with business owners, functional leads, performance analysts, data stewards and technical team members.

Job Responsibilities:

* Develop ETL solutions using SQL Server Integration services (SSIS)
* Develop multidimensional cubes using SQL Server Analysis Services (SSAS)
* Create T-SQL scripts for database objects
* Create MDX and XMLA scripts for OLAP database objects
* Meet with business analysts and subject matter experts to understand and document business requirements
* Translate customer requirements into unambiguous, scalable, robust and flexible technical solutions for implementation
* Create and maintain architecture diagrams, data models, mapping documents, business rules, data flow diagrams and other design related artifacts
* Develop ETL processes per technical design specification and the established design standards
* Perform impact analysis on change requests
* Analyze and troubleshoot production issues quickly to ensure system uptime meets service level agreements
* Assist the data warehouse team in designing efficient processes to load and manage data, including assessment of data quality in the source systems and implement appropriate business rules, data mappings, and transformation rules
* Actively participate in code reviews, unit testing, system integration testing and remedy solution defects
* Clearly and concisely communicate status of all assigned tasks to the project team, stakeholders and management
* Perform a variety of job tasks commensurate with IT Professional B level

Qualifications: Required Qualifications

Note: Equivalent combinations of education and experience will be considered.

* Bachelor's degree in computer science or computer technology or a closely related field
* Solid understanding of data warehouse principles and multi-dimensional data modeling concepts, source to target mapping and data integration architecture
* A minimum of 3 years of experience in the development of ETL/OLAP solutions, preferably on the Microsoft SSIS/SSAS stack
* Knowledge in data migration/integration with cloud services like Azure, AWS, etc.,
* Excellent SQL skills and ability to create T-SQL/stored procedures
* Demonstrated ability to meet tight deadlines, follow development standards and effectively raise critical issues with the team
* Must be a self-starter who can work independently yet be a strong team player with excellent attention to detail and customer service skills
* Experience in creating and maintaining requirements specifications and technical design documents
* Ability to prioritize and complete technical tasks with minimal instruction and supervision
* Aptitude for learning new development tools and technologies quickly
* Establish strong working relationships with coworkers, customers, project team, vendors and across all levels of the organization
* Strong oral and written communication skills to convey technical details to non-technical staff and customers

Desired Qualifications

* Proficiency in developing applications using C#, Java, Python etc.
* Experience with Full-stack DevOps engineering and knowledge of compute, network, storage and cost optimized implementations
* Knowledge of big data ecosystem using tools like Hadoop, MapReduce, HBase, Oozie, Flume, MongoDB, Cassandra and Pig
* Experience with NoSQL databases, such Cassandra, MongoDB, Cosmos DB
* Experience working with DevOps tools: ADO, Git, Jenkins, Dockers, etc.
* Knowledge of Machine Learning including pattern recognition clustering, text mining, etc.
* Working knowledge in data migration/integration with off-premise / cloud data services.
* Experience building, administering and managing scalable analytical platforms containing both structured and unstructured data.
* Knowledge in version control and change/release management processes. Experience with source control mediums such as Team Foundation Server (TFS), Visual Studio Team Services (VSTS) or Git
* Experience in release management lifecycle including scheduling and managing releases and updates
* Experience with Agile development methodologies

Additional Information: Please submit a resume and a cover letter with your application.