Data Analytics Specialist Senior

* Applies a broad range of analytic techniques and approaches to support collaborative problem-solving across CFD – e.g., data analysis, data visualization, dashboarding, GIS, SQL, statistical analysis, business process modelling, program evaluation, behavioral science.* Provides analytical services for CFD’s research and analytics projects, including providing data that is accurate and reliable and integrating and preparing large, varied datasets from internal and external sources for analysis and visualization.* Designs, builds, and maintains enterprise-level data and analytics systems, including SQL-based data pipelines, data warehouses, dashboards, geospatial and situational awareness tools, and automated reporting workflows, while providing technical leadership and strategic guidance to support operations, accreditation/ISO requirements, EMS workload modeling, and long-term enterprise analytics and systems modernization.* Contributes to the team with a proven ability to develop secure, cloud-enabled analytics and geospatial solutions; automate reporting and accreditation workflows; implement data governance and compliance practices; and provide cross-department leadership while contributing to long-term strategy for RMS modernization, enterprise reporting, and analytics ecosystems.* Performs predictive incident response modeling and analysis that helps CFD optimize performance of existing apparatus, predict impacts of future growth, identify optimal new station locations, and justify new station and apparatus requests; maintains, updates, and manages predictive incident modeling software to ensure modelling is as accurate to real-world as possible.* Develops automated reports using SQL Server Reporting Services (SSRS); maintains and troubleshoots a high volume of internal reports that support every division of the department; manages permission for these reports.* Develops new methodologies for analyzing and displaying data, to better leverage existing data.* Performs ad-hoc data analysis and/or compiles data for analysis by SMEs, when information cannot be garnered from existing reports.* Provides data analysis and research, to support program evaluation and outcome measurement related to the performance and operation of the department, including benchmark metrics; departmental program performance; service demand and performance, including forecasting and cross departmental problem-solving and policy analysis.* Analyzes data and provides data and information for Accreditation and ISO; supports the development of continuous quality improvement processes.* Automates tasks and improves processes using Python and SQL programming to minimize staff time on repetitive tasks* Creates datasets that are supplemental to existing datasets and help improve the quality and functionality of reports and dashboards.* Transforms data into actionable information and knowledge for CFD, its stakeholders, and city leadership. Prepares written reports, presentations, and summaries of data from complex records and multiple data sources including GIS data, for various audiences.* Researches, analyzes, and evaluates proposals, projects, and departmental activities, processes, and programs in terms of staffing requirements, needs, priorities, costs, and funding sources; reviews external consultant reports to ensure they’re logically and factually sound and are appropriately informed by industry standards and fire service knowledge.* Designs and executes special projects that combine data and processes into insights that improve decision-making ability; generates new data from special projects, to help CFD fill gaps in information and improve quality of analyses* Interpersonal skills necessary to develop and maintain effective and appropriate working relationships.* Balancing a variety of duties, often changing from one task to another of a different nature.* Performing basic mathematical functions such as addition, subtraction, multiplication, division, percentages, and ratios.* Excellent time management to effectively meet deadlines and adjust when needed for competing priorities* Essential and marginal functions may require maintaining physical conditions necessary for sitting, standing, climbing, or walking for extended periods of time.* Light to moderate lifting and carrying up to 20 pounds; some crouching, stooping, squatting, crawling, reaching, pushing, and pulling when performing tasks.* Adequate vision, hearing, and speech required.* Ability to operate in an environment with frequent interruptions from people and/or noises, which in return could result in some level of stress, fatigue, or strain.* Comprehensive written information in work-related documents.* Ability to hear, understand, and distinguish speech.* Bachelor’s degree from an accredited college or university in Information Technology, Computer Science, Geography, or a related field.* Three (3) years of experience in data warehousing, report and dashboard development, with business analysis and process improvement.* Any equivalent combination of training, education, and experience that provides the required skills, knowledge and abilities.# **Our City, Our Mission**When you join the City of Charlotte, you become part of Team Charlotte — a dedicated group of professionals working together to make a meaningful impact on our community and its future. The City of Charlotte has more than 8,000 employees working across 19 departments to serve close to 1 million residents. From public safety and clean water to transportation, housing and an international airport, our teams deliver essential services to keep Charlotte connected, safe and empowered with opportunity for all.As public servants, we are guided by a clear mission: to be committed to exceptional service every day. No matter the department or role, every team member plays a part in helping our city grow, thrive and meet the needs of those who rely on us.We are a values-driven organization, working collaboratively, acting with integrity and delivering reliable results. We embrace a forward-thinking mindset, encouraging curiosity, innovation and continuous improvement. #J-18808-Ljbffr