Data Visualization Specialist

Data Visualization Specialist

Requirements

• 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.

Responsibilities

• 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.

Preferred Qualifications

• Any additional education, certifications and experience may substitute for the bachelor’s degree.