Data Visualization Specialist

Job Description
Position Summary:
The Data Visualization Specialist is responsible for creating organizational value by combining exceptional analytical skills with knowledge of data visualization techniques to deliver actionable information, analyses and reports aligned to Performance Management objectives. This role works cooperatively with the PhillyStat360 team, OIT, and the City departments to understand program objectives and manage complex projects.
This position is responsible for working closely with the Chief Counsel/Director and their First Deputy to support implementation of processes and systems to maximize employee and City-wide performance on quality-of-life issues in an environment that promotes positive morale, equity, diversity and inclusion. This position will directly focus on City departmental delivery of services relating to quality-of-life concerns.
The Data Visualization Specialist may supervise the day-to-day work of associate data coordinators.
Essential Functions:
Acquire data from multiple sources, both internal and external. Ensure data accuracy and integrity by cleaning and preprocessing data.
Use appropriate statistical and geospatial analysis techniques to explore and identify patterns, trends, and correlations.
Prepare and present reports, summaries, and recommendations to both technical and non-technical audiences.
Develop and test data-driven hypotheses to answer specific questions.
Build predictive models, including regression, AI, machine learning, or time series models to forecast trends and outcomes.
Work with database systems to retrieve, manipulate, and analyze data efficiently.
Conduct training sessions and workshops to educate stakeholders on best practices for data visualization and dashboard usage.
Stay abreast of latest features and updates in data visualization software and provide recommendations for adoption.
Write SQL queries to extract relevant data.
Utilize SQL queries to extract, clean, and transform data from various sources for analysis.
Apply statistical techniques and predictive analytics using R and Python to derive insights from complex datasets.
Conduct spatial analysis and create geographic visualizations using ArcGIS to identify patterns and trends in spatial data.
Collaborate with stakeholders to understand data requirements and design customized dashboards tailored to their needs.
Ensure the accuracy, integrity, and reliability of dashboard data by regularly validating and updating data sources.
Optimize dashboard performance and user experience by implementing best practices in design and usability.
Design and develop interactive dashboards and visualizations using Tableau, PowerBI, and other industry-standard tools.
Create visually compelling charts, graphs, and maps to effectively communicate key insights and findings to stakeholders.
Generate automated reports and presentations for internal and external audiences, incorporating dynamic visualizations to enhance understanding.
Ensure data security and compliance with data privacy regulations.
Prepare standard operating procedures (SOPs) and ensure complete documentation of datasets, scripting routines, and workflows.
Serve as Subject Matter Expert for agencies to ensure compliance with appropriate data management, integration, and sharing protocols.
Participate in meetings and events within department, city and the greater data analytics community.
Serves as primary liaison between employees to implement Office initiatives, policies, practices, and procedures as well as trouble shooting issues as they arise.
Present reports at departmental meetings, informational sessions, and select conferences.
Mentors, supervises, and evaluates subordinate staff and interns.
Ensures compliance with standard operating procedures.
Other duties as assigned.
Required Competencies, Knowledge, Skills, and Abilities
Knowledge:
Experience with Tableau and/or PowerBI applications for data visualization and analytics.
Proficiency with R and/or Python, and SQL programming languages for data analysis and manipulation.
Experience developing statistical methods and analyses, including predictive analytics, and correlation and regression models using appropriate statistical software tools.
Familiarity with industry-standard data visualization and graphics tools for creating professional reports, presentations, web content, and educational materials.
Proficiency in developing database query strategies from spatial and non-spatial relational databases.
Knowledge of cloud services and data management principles.
Familiarity with regulatory requirements related to Personally Identifiable Information (PII).
Experience using ESRI ArcGIS software suite to publish data and produce GIS applications.
Proficiency in spatial data creation, editing, and maintenance using ESRI ArcGIS software.
Skills:
Ability to effectively communicate complex technical information to diverse audiences.
Excellent written and oral communication skills.
Strong project planning, organization, and time management skills.
Ability to create and maintain good working relationships and collaborations while working independently and taking initiative.
Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint, Outlook).
Proficiency in data analysis and manipulation using R, Python, SQL, and other relevant programming languages.
Experience with data visualization and graphics tools for creating professional reports, presentations, web content, and educational materials.
Ability to develop database query strategies to extract and manipulate data from spatial and non-spatial relational databases.
Experience handling regulatory requirements related to PII.
Proficiency in using ESRI ArcGIS software suite to publish data and produce GIS applications.
Proficiency in spatial data creation, editing, and maintenance using ESRI ArcGIS software.
Abilities:
Strong analytical and problem-solving abilities.
Ability to work effectively in a fast-paced environment, managing multiple priorities and meeting tight deadlines.
Willingness to expand professional competency by taking advantage of appropriate continuing education and training opportunities.
Ability to adapt to new technologies and methodologies in data analysis, visualization, and GIS.
Capacity to work collaboratively with cross-functional teams and stakeholders to achieve project goals and objectives.
Commitment to advancing diversity, equity, and inclusion in all aspects of work.