What are the responsibilities and job description for the Senior Data Engineer position at City of Tacoma?
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.
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.
- Skill in analysis, problem solving and troubleshooting
- Strong written and verbal communication skills
- Ability to lead individuals in analytics related project implementation and maintenance
- Advanced knowledge of data lake development and modeling
- Advanced knowledge of RDMS systems and data lakes such as Snowflake/MS SQL/Oracle/Databricks/Microsoft Fabric/AWS redshift, etc.
- Knowledge of analytics tools such as Tableau, Power BI, MicroStrategy, etc.
- Strong knowledge of relational databases and custom SQL skills
- Strong business knowledge and understanding data warehousing related to large-scale ERP type systems, SAP HANA Studio, SAP Datasphere knowledge a plus
- Working knowledge of ETL (extract, transform, load) methodologies and tools like FME/SNP Glue
- Knowledge of data privacy, compliance, security role designs and RBAC implementation
- Ability to address query performance and tunning issues
- Working knowledge of Python a plus
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.
**For assistance with the NEOGOV application process, questions regarding this job announcement, or if you are experiencing complications while applying, please contact the Human Resources office at (253) 591-5400 by 4:00 pm of the closing date of the job announcement. This will allow us to assist you before the job announcement closes.**
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.
Salary : $93,475 - $145,080
