It Data Analyst

Bryan, TX, United States

Job Description

Supports the City's modernization efforts by improving how data is collected, analyzed, and used to streamline operations and enhance public services. Work involves the transformation of manual and paper-based processes into efficient, digital workflows and supporting data-driven decision making across departments. This position contributes to improving City operations, empowering staff through data, and delivering modern public services to residents.
Essential Job Functions

  • Designs, creates, and maintains relational databases and data systems of moderate to high complexity.
  • Works with open datasets, including populating and extracting data from internal and public open datasets.
  • Performs data analysis, including conceptualization, modeling, and presentation of data.
  • Performs a variety of technical tasks related to capturing, managing, and analyzing data
  • Designs reporting dashboards to translate data into an understandable illustrative format and fulfills ad hoc reporting requests.
  • Develops procedures for data validation, analysis, and presentation.
  • Trains staff on updated tools and data processes.
  • Reviews and provides technical assistance to users' requests for new data elements and systems, and identifies and coordinates changes to the existing shared data environment.
  • Determines and implements database search strategies and storage requirements.
  • Creates test database environments and necessary libraries and procedures.
  • Provides support to the design and maintenance of database structures, performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models.
  • Executes procedures necessary to save, retrieve, and recover databases from hardware and software failures to ensure database integrity and database security.
  • Assists with the installation and upgrades of database software to include analyzing, designing, and implementing databases.
  • Assists in the evaluation of and recommendation for the selection of database management software for potential acquisition. Coordinates and supports migration to new data management system.
  • Researches and recommends modern data tools, including AI-enabled platforms, to support modernization.
  • Maintains documentation of applicable processes and procedures as required.
  • Performs related duties as required.
  • Responds regularly and promptly to work.
Minimum Qualifications
  • Master's degree in Computer Science, MIS, Data/Business Analytics, Statistics, or similar field of study plus two (2) years of experience in systems and process automation, including use of data visualization tools (Power BI, Tableau or similar); OR a Bachelor's degree plus four (4) years of experience as previously listed; OR an Associate's degree plus 6 years of directly related experience as previously listed.
  • Experience supporting municipal government applications is a plus.
  • Experience with data engineering and/or AI/ML is a plus.
Equivalent combinations of related education, experience, training, and certification may also be considered.
Knowledge, Skills & Abilities
Knowledge of:
  • Principles, methods and techniques used in designing, developing, testing, implementing, and maintaining computer software systems.
  • Data processing techniques, including the types of hardware and software currently used to process data with different levels of complexity.
  • Basic project management principles and techniques.
  • Structured analysis and database concepts.
Ability to:
  • Streamline manual tasks and support automation projects.
  • Extract data from database systems such as SQL, Oracle, Access, etc.
  • Multitask and work in an environment with frequent interruptions.
  • Maintain current proficiency on database technology, methodologies, and concepts.
  • Maintain confidentiality of sensitive information.
  • Perform all phases of business systems analysis and design functions, responsible for application design, coding, testing, debugging and thorough documentation skills.
  • Translate business processes into detail application design specifications.
  • Support applications using MS SQL databases.
  • Analyze, breakdown, identify requirements and design or modify an application or system to solve a business problem.
  • Organize workload; establish priorities; and meet established deadlines.
  • Prepare clear, concise and complete reports, correspondence and other written materials.
  • Anticipate, identify and effectively resolve various issues and problems.
  • Provide management with sound, positive advice and information concerning job tasks.
  • Display regular and timely attendance (report to work on time, work scheduled hours, utilize leave responsibly to ensure sufficient coverage of departmental operations, etc.).
  • Comply with City and department administrative directives, policies, and procedures.
  • Establish and maintain positive and cooperative working relationships with all levels of City staff and the general public.
Skills:
  • Strong verbal and written communication skills.
  • Strong public contact and customer service skills.
  • Strong analytical, problem-solving, and time-management skills.
Licenses, Certifications & Special Requirements
Licenses:
  • Texas Class C driver's license with a good driving record as measured by the City's evaluation system.
Special Requirements:
  • On-call technical support is required on a rotating basis for all systems; must be able to respond and escalate within posted time constraints.
  • Must be able to access Texas Criminal Justice Information Services (CJIS) System data. As a result, the person selected for the position cannot possess a felony or Class A misdemeanor conviction; or a Class B misdemeanor conviction within the past 10 years.
Certifications:
  • Certifications such as Tableau, Microsoft Power BI Data Analyst Associate, and/or CompTIA Data+ are a plus.
Certificate Pay Program:
  • The City of Bryan IT Department provides a Certificate Pay Program (CPP). New employees are eligible after the first 90 days of employment. Employee must be in good standing to qualify.
  • The primary goal of the IT CPP is to develop the technical skills of the IT staff to improve/focus on the overall service level of IT support services.
  • Receive up to $450/month in certification pay for qualifying certificates.
  • Reimbursement is available for qualifying passed certificate exams while employed by the City of Bryan IT.
Physical Demands
Physical demands include but are not limited to: sitting, talking, hearing, seeing, standing, walking, driving, bending, reaching, twisting, pushing, pulling, using hands and fingers to operate office equipment and machines, and occasionally lifting and/or moving objects up to and including 25 pounds.
Working Conditions
Work is performed primarily in an office setting or a well-lighted and temperature-controlled working environment.
Equipment
Work shall be performed with tools, appliances and equipment approved by those agencies and bodies that have control, authority, or approval of the design working ranges or limitations of those items; the employee has the responsibility to conform to those ranges and limitations.
Equipment may include but is not limited to: multi-line telephone, computer, printer, fax, scanner, calculator, and vehicle.
Additional Notes/Instructions for Applicants
This job description is not intended to be construed as an exhaustive list of responsibilities, duties, and skills required. City management has exclusive rights to alter this job description at any time without notice.
Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments. This document does not create an employment contract, implied or otherwise, other than an 'at-will' relationship.
Quicklink for Posting
Supplemental Questions
Required fields are indicated with an asterisk (*). * * I understand that prior to submittal I must: 1) Verify the application form includes my complete work history & education. 2) If I have previously applied, verified my application is up-to-date, including current dates of employment. (Note: A resume will not substitute the need to add your work history to the application form.)
  • Yes
  • No
  • Select the primary way you heard about this employment opportunity:
  • City of Bryan Website
  • City of Bryan Social Media
  • City of Bryan Employment Office
  • City of Bryan Employee
  • Friend/Relative
  • Indeed
  • Google
  • Glassdoor
  • LinkedIn
  • Facebook
  • Texas Municipal League
  • Careers in Government
  • Television Station
  • Radio Station
  • Newspaper
  • Career Fair (specify location below)
  • College/University Website (specify school below)
  • Other Website (specify below)
  • Other Source (specify below)
  • Unknown
  • * If known, specify details of source selected above (name, station, location, etc.):
(Open Ended Question) * * What is your expected wage/salary for this position?
(Open Ended Question) * * Do you possess municipal government experience?
  • Yes
  • No
  • * What is the highest level of education completed? (Make sure this information is reflected under the Education History Section of the application)
  • GED
  • High School Diploma
  • Associate's Degree
  • Bachelor's Degree
  • Master's Degree
  • PhD
  • Do you possess experience using data management tools such as Tableau, Power BI, etc.?
  • Yes
  • No
  • If 'Yes', please describe your experience. If 'No', enter N/A.
(Open Ended Question) * Do you possess experience with AI/ML?
  • Yes
  • No
  • If 'Yes', please give a summary of your technical experience. If 'No', enter N/A.
(Open Ended Question) * * Do you possess any job-related certifications?
  • Yes
  • No
  • * If 'Yes', list the certifications (including any dates of expiration, if applicable). If 'No', enter N/A
(Open Ended Question) * * List three (3) strengths/skills you possess that you believe would make you a good fit for this position:
(Open Ended Question)
Documents Needed to Apply
Required Documents * Resume
Optional Documents * Cover Letter
  • Letter(s) of Recommendation
  • Certification(s)
Bryan Municipal Building
300 S. Texas Avenue
Bryan, Texas 77803
City of Bryan, Texas
To ensure the security of your data, you will be logged out due to inactivity in 3 minutes at

Skills Required

IT
Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD6753113
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    $70,000-95,000 per year
  • Employment Status
    Permanent
  • Job Location
    Bryan, TX, United States
  • Education
    Not mentioned