Senior Data Engineer

Salary : $93,475.20 - $145,080.00 Annually

Location : Tacoma, WA

Job Type : Classified

Remote Employment : Flexible / Hybrid

Job Number : 0152-25A

Department : Information Technology

Division : Information Technology

Opening Date : 02 / 24 / 2025

Closing Date : 3 / 17 / 2025 5 : 00 PM Pacific

Position Description

The City of Tacoma's Information Technology Department is currently recruiting for a dedicated and results-driven Senior Data Engineer (IT Analyst, Senior Technical, DA).

This position serves a key role in the City's transformation to using data as an asset, starting with our SAP S / 4 ERP system. The senior data engineer will be part of an exciting, fast paced, citywide, multimillion-dollar analytics program. This individual will be part of shaping the future of analytics at the City of Tacoma. This position will report to the data engineering manager.

A day in the life of the senior data engineer :

• You serve as the City's lead data engineer for data integrations between separate, disparate systems as well as joining multiple datasets within a single complex system, like SAP S / 4.
• You assist the team with defining data standards for data modeling, data quality, metadata management, data organization, data storage, data movement and data security.
• You collaborate with business users, architect, senior IT analysts, data stewards and business analysts to translate requirements into data design and solutions, especially dimensional models.
• You lead the City's enterprise data integration efforts and facilitate the definition of the City's reference data architecture.
• You lead city's data pipelines & analytics solution design, development and implementation involving SAP technologies, FME, Snowflake and Tableau.
• You review, recommend, and follow best practices and help to enforce best practices guidelines and standards for data lake governance and design.
• Potentially lead other contractors and more junior engineers.

Qualifications

Equivalent combination to : Bachelor's degree in computer science or related field and five or more years directly related information technology work experience.

LICENSES, CERTIFICATES AND OTHER REQUIREMENTS

Some positions may require a valid Washington State Driver's License at time of appointment with maintenance thereafter.

Some positions may require incumbents to successful pass a Criminal Justice Information Services (CJIS) background check

Positions assigned to the Tacoma Police Department may require additional background checks which may include fingerprinting and / or a polygraph test.

Desired Experience :

5 years of leading data lake development and modeling in SAP S / 4 HANA CDS views, ABAP development in Eclipse, 2 years of RDMS systems and data lakes such as Snowflake / MS SQL / Oracle / Databricks / Microsoft Fabric / AWS redshift, etc. as developer and administrator. 2 years of analytics tools such as Tableau / PowerBI / MicroStrategy, etc. as developer and administrator.

Knowledge & Skills

Selection Process & Supplemental Information

City of Tacoma Commitment to Diversity and Inclusion

At the City of Tacoma, we're on a mission to make our workforce as diverse and inclusive as the community we serve. We're committed to eliminating racial and other disparities, and we actively seek out candidates from a wide range of backgrounds and cultures. Join our team at the City of Tacoma and help us build a more vibrant, inclusive, and equitable community for all.

The City of Tacoma believes that diversity of thought, background, and experience contributes to our success and innovation. If you're passionate about this role and our mission, we encourage you to apply. If you have a less traditional background, we want to hear about your transferrable skills and experience. We value a variety of perspectives and are excited to see what you bring to the table.

Our Community :

Tacoma is centrally located just 32 miles south of the city of Seattle and 31 miles north of the state capital, Olympia. The City of Tacoma is also home to the Port of Tacoma, which is among the largest container ports in the United States. Like most cities in the northwest, Tacoma is surrounded by beautiful nature, offering residents many opportunities for outdoor adventures.

Largely suburban in nature with a small, but dense, urban core, Tacoma is home to numerous institutes of higher learning that attract students from across the country. The University of Washington Tacoma, Pacific Lutheran University, University of Puget Sound, a satellite campus of the Evergreen State College, three community / technical colleges, and several trade and business schools are within Tacoma's geographic area. Downtown's Cultural District is the site of the Washington State History Museum, Museum of Glass, the Tacoma Art Museum, and America's Car Museum.

With its affordable housing and distinctive neighborhoods and business districts, the city has been recognized numerous times as a best city to live in the nation. To see a few of the great things Tacoma has to offer, view this YouTube Video!

ICMA City of YOUR Destiny video link : https : / / www.youtube.com / watch?v=2n5MWl8KFvI

Communication with the City of Tacoma :

We primarily communicate via email during the application process. Emails from cityoftacoma.org and / or governmentjobs.com must be placed on your safe domain list to ensure that you receive notifications in a timely manner. As a precaution, you may also want to check your junk email folders.

In order for your application materials to be considered, all information must be submitted by the closing date and time listed on this job announcement.

Instructions for the application :

Interested individuals should apply online and attach a detailed resume and cover letter describing your experience as they relate to the responsibilities of this position.

NOTE : Applications received without attaching the required resume and cover letter may not progress in the selection process.

Applications will be accepted for this position until 5 : 00 pm Pacific Time on Monday, March 17, 2025. To be considered for this position, in addition to completing your application fully, please attach : Resume, cover letter, copies of certificates and degrees, and sample work.

The City of Tacoma provides excellent medical, dental and vision plans for the whole family; paid holidays and paid leave; participation in the Tacoma Employees' Retirement System (alternate plan for Police / Fire); continuing education and advancement opportunities and a growing variety of City-sponsored health and wellness opportunities and incentives.

Medical Coverage : For eligible employees and their families, including domestic partners and dependent children age 26 or younger.

Dental Coverage : For eligible employees and their families, including domestic partners and dependent children age 26 or younger.

Vision Coverage : For eligible employees and their eligible dependents.

Paid Leave : City employees are entitled to received paid holidays, sick / vacation leave or personal time off (PTO), depending upon union affiliation and appointment type.

Insurance Plans : Employees are covered by a long-term disability plan. Short-term and expanded long-term disability insurance plans are also available to employees. The State Industrial Insurance Act also covers employees.

Deferred Compensation : Income can be set aside on a pretax basis and invested for supplementation of normal retirement income.

Retirement : All employees of the City, except members of the Police and Fire services, Tacoma Rail and certain project employees, are included in the Tacoma Employees' Retirement System. Information on the Tacoma Employees' Retirement System can be found at www.cityoftacoma.org or by calling (253) 502-8200.

Other Employment Information

Direct Deposit : Employees are paid on a bi-weekly schedule by direct deposit.

Salary Increases : Based on satisfactory job performance, the City provides for a regular progression of salary increases for most classifications according to the salary schedule.

Union Affiliation : Many job classifications are covered by union security provisions which require union membership, dues, or payment of equivalent service fees.

Note : The provisions of this job announcement do not constitute an expressed or implied contract. Any provision contained herein may be modified and / or revoked without notice.

The Supplemental Questionnaire is part of the examination process; accordingly, it should be completed carefully. It must be submitted with your application. Do not indicate "see resume" or copy unrelated content from your resume when answering these questions. Answer all information requested in each question. Failure to do so may result in rejection of your application.Responses to supplemental questions must be original content created by the applicant using their own words. The use of online tools or resources to create responses, such as Artificial Intelligence (ChatGPT, etc.), Google, Bing, etc., or plagiarism in any form, is considered cheating and falsification of the application.I certify that the information provided is accurate and complete to the best of my knowledge. I understand that any falsification may cancel any terms, conditions, or privileges of employment.

Applicants must be authorized to work in the United States for any employer. There is no sponsorship available for this position. Will you now or in the future require sponsorship for employment visa status (e.g., H-1B status)?

Do you have a Bachelor's degree in Information Technology / Computer Science or related field?

How many years of experience do you have as a data engineer or with directly related information technology work?

In addition to attaching a cover letter and resume, please also attach copies of your degree or certificates of training to your application. Also, please attach any samples of work you may have done in the past. Please indicate "Yes" to show that you have read and understand these instructions.

Please tell us how you learned about this job opening.

Please provide specific information regarding how you learned about this job opening. Thank you, your feedback will be used to evaluate our success reaching the public and refine our methods for future job postings.

INSTRUCTIONS : This is a competitive selection process. Applicants will be required to respond to written questions outlining their experience, knowledge, skills, and abilities necessary to perform the essential functions of this position. Applicants who meet the minimum qualifications will have their responses to Supplemental Questions #9 to #15 reviewed and scored by a committee of subject matter experts, as the Experience and Training Test. These questions will be scored based on the information provided. It is the responsibility of the applicants to adequately describe all pertinent experience and training. Please make sure you read the questions and provide complete informative answers, including your roles in the position and key activities. DO NOT respond with 'see resume' in lieu of answering these questions; this will result in a failing score. Providing false information will result in disqualification. Please indicate "Yes" that you have read and understand the instructions for questions #9-15.

Please describe your experience as it pertains to SAP S / 4 HANA CDS (Core Data Services) views.

Please describe your experience with SAP ABAP (Advanced Business Application Programming) on S / 4 HANA environment.

Please describe your experience as it pertains to SAP Datasphere.

Please describe your experience as it relates to any ETL (extraction transformation loading) tools like FME (Feature Manipulation Engine), SNP Glue, etc.

Please describe your experience as it relates to Snowflake.

Please describe your experience as it relates to Tableau.

One of the City's Guiding Principles is Equity. Describe what equity means to you and describe an experience you have working with diverse groups of people.

Required Question

Salary : $93,475 - $145,080