Senior Human Resources Data Analyst (Senior Management Systems Analyst)

Position Description
Vision: Seattle is a thriving and equitable community powered by dependable transportation.

Mission: To deliver a transportation system that provides safe and affordable access to places and opportunities.

The Seattle Department of Transportation (SDOT) is a nationally recognized municipal transportation agency at the leading edge of multi-modal transportation. In our quickly growing city, accessibility, safety, affordability, and reliability - are top of mind for us every day! Our core values drive our work toward creating an equitable, sustainable, and vibrant city for all. SDOT's core responsibilities include maintenance and operations of the city's transportation right-of-way, the expansion of the city's bicycle and pedestrian network, care of over 240 bridges, permitting use of public spaces and enhancing access to the regional transit system. With approximately 1,100 dedicated staff, SDOT maintains an operational presence 24 hours a day, 7 days a week, in all weather conditions to serve and ensure Seattle's public mobility.

SDOT has an exciting opportunity for a collaborative and tech-savvy Senior Human Resources Data Analyst (Senior Management Systems Analyst) on our PAWS (People Analytics and Workforce Solutions) team within the People & Culture Division. This key team member will support departmental workforce reporting and computer application development. This position reports to the PAWS Manager and will act independently and as part of a team, leading the way on project development, reporting design and strategy implementation. Additionally, this Analyst will support data reporting, policy, process, and system improvements leveraging technological solutions as our Human Resources team strives to become the best human-oriented team in the City. The position works across the entire organization and collaborates with staff from other departments within the City. You are invited to come to help keep Seattle moving!
Job Responsibilities

• Serves as SDOT's SharePoint Online (SPO) secondary site collector and subject matter expert; People & Culture Division's primary SPO and InWeb owner; must be skilled in assigning SharePoint permissions, hierarchies, and inheritance; design and update SPO site pages, lists, and libraries.
• Develops and maintains Microsoft Power Apps (Power Automate, Power BI, Dataverse, Forms).
• Designs, develops, maintains, and implements systems processes for the work order systems, ticketing systems, salary compensation, interview panel pools, Adobe Sign, and other projects (internal and external to SDOT).
• Works independently and collaboratively on system developments, implementation of applications, and streamlining business processes.
• Gathers business and systems requirements. Analyzes current business and systems processes, documentation in UML diagrams, flow charts, and data schemas.
• Gathers requirements from all levels of the department to develop and design reports using data visualizations, interprets and makes recommendations to the executive and the senior leadership team.
• Researches, analyzes, problem-solves, reports, and recommends solutions based on existing systems/tools.
• Writes complex SQL statements for key workforce teams, calculates accumulated creditable hours, Merit leave, analytic salary study, PDR requests, and additional ad hoc reporting as needed by the department.
• Acts as SDOT HR's department administrator for HRIS (EV-5, payroll, labor reconciliation).
• Supports department goals in promoting diversity and social justice in keeping with the City's Race and Social Justice Initiative.

Qualifications
Minimum Qualifications:
Education:

• Bachelor's Degree in business, information science, computer science, or related field.

Experience:

• Three (3) years of experience with data analysis, application design, relational databases, data architecture, and graphical information reporting.

OR: An equivalent combination of education and experience that demonstrates the ability to perform the position duties.

Though not requirements, strong candidates will have some of the following experience or are able to describe comparable experience:

• Previous experience working with macros, VBA, SQL, Python, and various programing languages.
• Experience working with Tableau, Power Apps, Power Automation, logic, functions, and algorithms.
• Previous experience developing, tracking, and reporting on HR-oriented metrics.
• Strong customer service orientation and commitment to customer satisfaction.
• Ability to effectively work in a multi-cultural workplace with a diverse customer base.
• Attention to detail, organization, and the ability to actively manage multiple processes.
• Ability to effectively work in a multi-cultural workplace with a diverse customer base.

Other Requirements:
Work Environment / Physical Demands:

• Work is typically performed in a hybrid work environment in which a minimum of 2 days of the work is completed in a City office, and 3 days of the work is completed remotely in a regular 40-hour work week.

Additional Information

Your application will not be reviewed if these items are missing or incomplete.

Hiring Process
Applications are reviewed after the posting closes. Qualified candidates must submit the following to be considered: Completed NEOGOV online application.Supplemental questionnaire responsesCover letter describing how your skills and experience align with the stated job responsibilities and qualifications.Current résumé indicating relevant experience and education.
Offers of employment are contingent on verification of information provided by the applicant as part of the application process, including a potential background check.

Please note this job advertisement is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

The full salary range for this position is $47.57 - $55.44 hourly.

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 .

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:
"Most" Employees Plans - Human Resources | seattle.gov

Closing Date/Time: 9/12/2023 4:00 PM Pacific