Duties, Functions and Responsibilities: - Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned. - Designs, creates, and maintains relational databases and data systems. - Collaborates with City IT analysts to identify data issues and prioritize improvements. - Informs solution design and improvements to meet data quality goals. - Leads and oversees data classification and data-mining activities to enable more accurate analysis. - Determines necessary actions required to generate and publishes open data on the City’s open data portal. - Creates data visualizations and reports to present to audiences using presentation tools. - Creates standards and patterns for data distribution and retention. - Implements statistical models to identify and reveal trends, patterns, and relationships in data to provide guidance to others for decision making processes. - Enables access to City and external data sources. - Suggests analytics opportunities and best practices. - Contributes to management of central data stores and metadata to establish quality expectations. - Identifies opportunities to increase data quality, including automation and data entry procedural training. - Creates and implements techniques for data collection, accuracy and management. Responsibilities – Supervisor and/or Leadership Exercised: May provide leadership, work assignments, evaluation, training, and guidance to others. Knowledge, Skills and Abilities: - Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed. - Knowledge of data integration tools, data management architectures such as Data Warehouse, Data Lake, Data Hub Management, and data exploration techniques (binning, pivoting, summarizing, and finding correlations). - Knowledge of analytics, visualization and business intelligence tools. - Knowledge of data structures, patterns and data models and related industry-standard methodologies. - Knowledge of Source-to-Target Mapping, Extract-Transform-Load ( ETL ) processing and Change Data Capture ( CDC ) concepts. - Knowledge of statistical software, database queries and programming languages (e.g., Java, C++, Scala, SQL , Hive, Python and R), XML , JSON and XSD’s. - Knowledge of Big Data concepts, frameworks, products, and tools. - Knowledge of data models and structures as well as database design tools (e.g., Visio, SQL , tec.) - Skill in data modeling, database and data management, SQL coding, data warehousing, reporting, data warehousing, relational databases, and data integrity skills. - Skill in data analysis, data visualization, data mining, reporting, and data integrity skills. - Ability to clearly communicate technical concepts with clients to increase their understanding of their operations. - Ability to consider and incorporate the implications of analysis into recommendations for business decisions. - Ability to see the big picture and make decisions based on strategy and value delivered. - Ability to turn data insights into recommendations for both clients and internal stakeholders based on context. - Ability to adhere to required compliance to all change management policies and procedures. - Ability to adhere to required compliance to all information security policies and procedures.