Responsible for designing, developing, and maintain data solutions that transform raw information into actionable insights, enabling informed decision-making across the organization. With regular attendance, this role collaborates with stakeholders to understand business needs, builds and optimizes data models, and develops reports, dashboards, and analytics tools that support strategic and operational goals.
Develop, maintain, and present reports by data mining, collecting, integrating, modeling, analyzing, and summarizing information and trends in formats that meet user needs.
β’ Design and develop data models to support reporting, dashboards, and advanced analytics.
β’ Utilize Power BI, Microsoft Reporting Services, or other software in a Microsoft SQL/T-SQL environment to design and produce models.
β’ Coordinate meetings to consult and collaborate needs and recommend additions or modifications to achieve desired outcome.
β’ Conduct analyses of functional business processes and requirements.
β’ Provide report training for various Public Safety and County organizations and personnel.
β’ Perform other duties as assigned.
Bachelorβs* degree in Computer Science, Information Systems, Data Analytics, or a related field.
β’ 4 years of experience in data modeling, database design, and/or query optimization or in a related IT role.
* Approved work experience beyond that required which provides equivalent knowledge, skills, and abilities may be considered and substituted for the stated education.
β’ Have and maintain a valid Driverβs License, as well as meet eligibility requires of βacceptable driving standardsβ as defined by the County.
KNOWLEDGE, SKILLS & ABILITIES
β’ Effective communication and interpersonal skills for interacting with diverse individuals.
β’ Ability to multi-task, prioritize, and manage time effectively.
β’ Proficiency in using the Microsoft Office Suite and other software related to data management, communication, and other common business processes.
β’ Ability to follow established policies and procedures for confidentiality while adapting to evolving privacy standards and technologies.
β’ Ability to build and maintain positive relationships within a team.
β’ Basic knowledge of I.T. security practices.
β’ Extensive technical aptitude skills and ability to comprehend complex technical topics and specialized information.
β’ Ability to disseminate information to technical and non-technical individuals.
β’ Proficiency in SQL and scripting languages for data manipulation and analysis.
β’ Experience in designing, developing, and optimizing reports, dashboards, and data models.
β’ Ability to translate business needs into technical BI solutions.
The work environment is typically a professional office setting, involving regular use of computers, standard office equipment, and frequent interaction with both internal staff and the public in a structured, task-oriented atmosphere. Work hours may include evenings, early mornings, weekends, call-ins, and holidays. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential tasks.