GIS Business Intelligence Analyst

General Summary Salary: $67,387.76/annual min to $80,222.76/annual mid (Depending on qualifications) The GIS Business Intelligence Analyst, with general guidance provided by the GIS Manager works with various divisions to align asset management software (Cityworks, SeeClickFix, pipe inspection software, street conditions software, etc.) with business strategies. Provides user-side administration of the software platforms. Perform complex data driven analysis to support the overall management decisions pertaining to infrastructure maintenance. Work requires a high level of independent and creative thought to address operational issues, extensive contact with employees of affected departments/divisions, and a prompt response to their needs. You can search for this position's full job description here . SUPERVISION General supervision is provided by the GIS Manager. Essential Duties And Responsibilities All behaviors comply with the Code of Conduct & Rules of Behavior outlined in Chapter 8 of the General Government Policies and Procedures Manual. Adheres to assigned work schedule as outlined in City and department attendance policies and procedures. Must possess strong communication skills both verbal and written so that processes in departments who are collaborating with GIS are clearly understood and communicated to the GIS Manager and all involved parties. Must be able to take initiative and offer solutions to end users across all city departments. Advanced technical proficiency in the following: ArcGIS Pro, ArcGIS Desktop, ArcGIS Enterprise/Portal, ArcGIS SDE, SQL Server, and Python. Coordinate with City divisions/departments that utilize the workorder and related systems to evaluate, create and modify process automation cases and workflows. Evaluate and implement divisional needs for visualization, dashboards, reports, intelligent object formulation, custom fields, fee tables and other necessary data. Train city employees for use of asset management related systems. Evaluate and maintain user security related roles and access. Evaluate, implement, customize, deploy, and maintain third-party applications for asset management use in conjunction with IT Department and GIS Division. Develop, implement and maintain integrations between asset management related software/databases. Assist the GIS Manager in administering the GIS geodatabase, SQL servers and web servers by monitoring user activity and database performance, creating user privileges, maintaining database security and implementing custom scripts and compressions to tune the database. Assist the GIS Manager in performing enterprise GIS solution implementations, system upgrades, and custom python, FME, or PowerShell scripting processes to provide for system automation. Develop and analyze database structure and analytical needs. Evaluate Business Intelligence (BI) requirements for the design of solutions, dashboards and reports utilizing multiple area/data sources. Determine optimum database solutions including APIs and ETLs to meet organizational needs. Conduct complex statistical/data analysis for data driven business decisions. Incorporate geospatial analysis using ArcGIS software and its extensions into analytic processes. Customize and extend the functionality of Experience Builder for ArcGIS Enterprise using Arcade as needed. Assist and advise GIS Manager in developing custom python or PowerShell scripting processes to automate complex, repetitive tasks and facilitate data transfer. Utilize FME to automate complex tasks. Monitor data being input into software systems by users to ensure necessary data is collected and procedures are being followed. Coordinates with divisions to increase data entry accuracy as needed. Ensure data integrity for enterprise databases using advanced data management tools, languages and techniques. Perform data import/conversion/normalization of various internal/external data sources/formats. Support Spillman/Motorola, Energov, and MUNIS Enterprise web services utilizing knowledge of Esri Enterprise and Portal software, SQL, Python and FME. Advise GIS Manager on upgrades and python models utilized by Spillman. Assist GIS Manager with implementing upgrades and preparing models. Evaluate and prioritize user requests for system enhancements. Analyzes business processes, details findings and suggests re-engineering steps. Designs and conducts tests of new procedures. Track, monitor and analyze performance measures. Assist/recommend to the GIS Manager improvements to operational technologies. Researches new products, practices, procedures, and alternatives. Establish training materials for all software systems and coordinate regular training classes to ensure all users of the system are adequately trained. Review/write Standard Operating Procedures (SOP) to insure high data standards continuity of tasks. Maintain ability to multi-task in a high activity/energy professional environment that includes multiple concurrent projects and project deadlines in addition to occasional interruptions and walk-in appointments. Attend and participate in professional group meetings. Stay abreast of new trends and innovations in the field of asset management/GIS/ programming/database. Assist the GIS Manager with system architecture decisions and developing specifications related to Budgeting, GIS applications, GIS software installation, new software releases, system upgrades and evaluating and installing patches. Minimum Job Requirements EDUCATION Bachelor's degree from an accredited college or university with major coursework in graphic information systems, business analytics, database, computer science or closely related fields. Experience Five (5) years of experience as a Programmer, Business/GIS/Data Analyst, or related field. CRIMINAL HISTORY Employee will not have a record of being convicted of a Class B misdemeanor or higher offense in order to work with and view Criminal Justice Information Services data. LICENSES AND CERTIFICATES Possession of a valid driver's license. WORK SCHEDULE 9/80 schedule, Monday thru Thursday 7:30 am to 5 pm, alternating Friday 8 am to 5 pm. Physical Requirements / Work Environment This position does not require a physical for employment. Applicants with disabilities meeting the job requirements and capable of performing the essential functions of the job, either on their own or with reasonable accommodation, are encouraged to apply. Full Time Employees The City of Mesquite offers the Zero Premium, Employee Only Benefits under the following plans: High Deductible Medical Plan, Dental HMO Plan, Vision Plan, and Life Insurance. The City is self-insured and offers a choice of two medical plans: HSA, and High Deductible Medical Plans through Blue Cross Blue Shield of Texas. Employee medical coverage goes into effect the first day of the month following 30 days of employment. Coverage is available to all full-time employees at group rates. Employees enrolled in the City's self-insured medical plan also have access to the Mesquite Employee Health Center (MEHC) clinic and pharmacy. The City offers three dental plan options: a managed plan (DHMO), an indemnity plan (DPPO), an enhanced indemnity plan (DPPO Enhanced). Coverage is available to all full-time employees at group rates. The City offers free Vision Insurance to all employees. Dependents can be added for an additional fee. Basic Group Life Insurance protection is provided to eligible full-time employees in the amount of two times the annual salary as recorded at the beginning of each year. The following voluntary benefits are available to full-time employees: Supplemental Life, AD&D Insurance, Cancer Insurance and Long-Term Disability Texas Municipal Retirement System (TMRS): All employees appointed to positions designated to work 1,000 hours or more per year must participate in the TMRS. TMRS is a qualified tax-deferred retirement plan under Section 401 of the IRS. Seven (7) percent of gross earnings are deducted each payroll as a pre-tax deduction and deposited into the member account. When an employee becomes vested and retires, the City provides 2-to-1 matching contributions. Other benefits include Social Security, Tax Saver Program (Section 125 Flexible Spending Account), Deferred Compensation Plans, Direct Deposit, Paid Holidays, Paid Vacation, Sick Leave and Personal Leave. For more information about the City of Mesquite's employee benefits, please visit: http://www.cityofmesquite.com/hrbenefits 01 Select the option that best represents the highest level of education you have achieved. Less than High School completion High School or GED equivalency Technical or Community College attendance Technical School completion Associate's Degree Bachelor's Degree Master's Degree Ph.D. Juris Doctorate 02 Identify your degree area of study for the Business Intelligence Analyst. No Degree GIS Business Analytics Database Computer Science Related Field Non Related Field 03 How many years of experience do you have as a Programmer, Business/GIS/Data Analyst or related field. No Experience 6 months to less than 1 year 1 year to less than 3 years 3 years to less than 5 years 5 years to less than 7 years 7 years to less than 9 years More than 9 years 04 Do you have a valid driver's license? Yes No 05 Have you ever been convicted of a Class B misdemeanor or higher. Yes No 06 PLEASE READ CAREFULLY: If you are a current City of Mesquite employee, have you been employed in your current position with the City of Mesquite for at least 3 months? Please indicate the option that best represents your current status. No, I do NOT work for the City of Mesquite Yes, I am a current seasonal employee with the City of Mesquite Yes, I have been in my current City position as a fulltime/parttime employee for at least 3 months No, I have NOT been in my current City of Mesquite position as a fulltime/parttime employee for 3 months Required Question