Research and Data Analyst

at  Kitsap Transit

SUMMARY

We are looking for a qualified and experienced individual to join our Marketing department who will under general supervision, lead the Marketing department’s research needs in priority areas, including customer experience, ridership growth and marketing campaigns. This position will collaborate across departments and use data to identify, develop and communicate key performance indicators, trends, forecasts and business opportunities.

QUALIFICATIONS

Knowledge, Skills and Abilities:

• Following are some highlights of the knowledge, skills and abilities required to be successful in this position.
• Strong problem-solving skills, strategic thinking, and the ability to frame business questions into data analysis problems and informed decision-making.
• Strong proficiency in data manipulation (i.e., cleaning, filtering, aggregation, joining, preprocessing data) and analysis using Excel, SQL, and Python/R. Competent in data cleaning and validation techniques.
• Intermediate proficiency in GIS software like ArcGIS, QGIS, or equivalent to create maps and perform geospatial joins and analysis.
• Proficiency in basic statistical concepts such as mean, median, mode, variance and standard deviation, and descriptive analysis. Knowledge of hypothesis testing and p-values and understanding of probability distributions.
• Inferential statistics knowledge and skills are desirable (i.e., correlation, regression, clustering, hypothesis testing, factor analysis, conjoint analysis, cross-tabulation, TURF analysis).
• Ability to create basic data visualizations using tools like Excel, Tableau or R. Intermediate to advanced skills desirable in data visualization and dashboard creation using tools like Tableau, PowerBI, R, Python or similar.
• Experience with processing JSON data from Facebook, Google Map, and other web APIs is desirable.
• Experience with intercept interviews, customer-journey mapping, marketing research and/or customer segmentation analysis is desirable.
• Strong attention to detail and problem-solving skills.
• Willingness to stay abreast of the evolving state of practice in data analysis and continuous learning to improve knowledge, skills and abilities.
• Ability to work independently and as part of a collaborative team and prioritize workload to accomplish tasks with defined timelines in a fast-paced environment.
• Ability to communicate complex technical information to diverse audiences through reports and presentations.
• Proficient in Microsoft Office suite including Word, Excel, Outlook and PowerPoint.
• Experience with Smartsheet is desirable.

Kitsap Transit employees who wish to apply must have a satisfactory performance and attendance record. Kitsap Transit Operators with any of the following criteria in the last twelve months are excluded from recruitment opportunities:

• a current Decision-Making Leave or higher in the Safety category
• more than two held customer complaints
• more than four unscheduled absences
• more than two late reports

Education and Experience:
A Bachelor’s degree in business analytics, marketing, planning, social science, computer science, data science, data analytics, statistics, math, physics, human-centered design and engineering, transportation engineering, engineering, economics, environmental studies, geography, or a closely related field AND two years of increasingly responsible experience in data analysis, digital marketing/advertising, demographic/behavioral research, transportation planning, consulting, or business development; OR at least six years of demonstrated experience in any of the fields listed above which provides the applicant with the knowledge, skills and abilities required to perform the work effectively and efficiently.

Licenses and Certifications: The following certifications are highly desirable:

• Tableau Certified Data Analyst
• Google Data Analytics Professional Certificate
• Meta Marketing Analytics Professional Certificate
• Microsoft Power BI Data Analyst Professional Certificate
• ESRI ArcGIS Pro Professional Certificate
• Microsoft Azure Data Fundamentals Certificate
• Data Engineer Associate Certificate

WORKING CONDITIONS/PHYSICAL REQUIREMENTS:

Positions in this class typically require: Positions in this class typically require: dexterity of hands and fingers to operate a computer keyboard and other equipment talking, hearing, seeing and repetitive motions.
Sedentary Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met. Regional travel may be required. May need to work weekends and outside regular office hours.
Selection Process: After evaluating the completed application packets, we will invite the most qualified applicants to the next step in the recruitment process. We will not make any hiring decisions until all steps in the selection process are completed, including reference and background checks. Kitsap Transit does not pay any relocation costs.
To Apply: If you decide to apply for this position, please visit our employment link at https://www.governmentjobs.com/careers/kitsaptransit. Please contact Marianne Rajan in the Human Resources Department at (360) 478-5852 if you have any questions.
Closing Date: This posting is open until filled. You may include a resume; however, it may not be used in lieu of a completed application.

Selective certification may be used to achieve affirmative action goals. You can find Kitsap Transit’s EEO Policy at https://www.kitsaptransit.com/uploads/pdf/eeo-policy-statement.pdf

• Please contact Marianne Rajan, Human Resources Manager at (360) 478-5852 if you have any questions.
• Kitsap Transit is committed to providing access and reasonable accommodation in its services, programs, activities, and employment for individuals with disabilities. To request disability accommodation in the hiring process, contact jobapplada@kitsaptransit.com or 360-479-4348 (TDD).
• If you qualify for the Veterans Scoring Criteria under RCW 41.04.005 and 41.04.010, you must answer all questions regarding Veterans Scoring Criteria Status Declaration in the application and upload a copy of the substantiating document as listed in the application.
• Kitsap Transit is subject to the requirements of the Federal Drug-Free Workplace Act and CFR Part 40 & Part 655, which prohibits the use of marijuana at any time while employed by Kitsap Transit.

Leads marketing research to understand customer needs and develops strategies for the growing use of Kitsap Transit’s services. Uses a wide range of research methods, data processing techniques and rigorous analysis to describe and monitor sources of demand, demand patterns, customer pain points, ridership growth opportunities and challenges.
Analyzes marketing efforts to optimize effectiveness of strategies used to reach and engage target audiences. Studies market trends to determine how best the agency can respond to emerging trends and patterns. Analyzes customer feedback, survey data and other data sources to monitor and evaluate impact of marketing activities and service changes on customer satisfaction, customer experience and community relations.
Identifies data requirements for research projects, collects the required data, performs ETL (extract, transform, and load) processes and uses statistical and analytical techniques to answer business questions, inform field research, and develop insights to assist the agency in decision making. Data sources may include and is not limited to surveys, field observations, focus groups, interviews, website analytics, internal data sources, census data, geospatial data, and external data sources (including web APIs).
Produces and maintains databases, data warehouses and data products using tools such as SQL, R, Python, and/or PowerBI. Creates maps and GIS data products using ArcGIS Pro, QGIS or equivalent. Produces interactive data visualizations and dashboards using Tableau, PowerBI or equivalent.
Collects, analyzes and presents data on paid, earned, shared, and owned (PESO) media; transit agency ridership; service quality/performance; customer feedback/satisfaction; customer-journey maps; market demand; and channel performance; and other priority areas as assigned., with an eye towards recommending changes to improve performance and customer experience.
This position reports to the Marketing and Public Information Director.