Sql data analyst Jobs in Pearland, TX

The Open Government Analyst performs a role for the City subject to a great deal of statutory regulation and legal requirements due to its responsibility for the City's administration of the Texas Local Government Records Act, Open Meeting Act, and the Texas Public Information Act. This position performs advanced-level administrative and technical duties for the programs of records management, public information, and agenda management and is a highly responsible and complex support position in the City Secretary's office. This position is responsible for determining regulatory and administrative requirements in accordance with adopted retention schedules and
applicable policies, and local, state, and federal law.

The position is distinguished by the increased levels of complexity and responsibility of duties. The Open Government Analyst is expected to coordinate with the Deputy City Secretary and keep the City Secretary informed of the Analyst's activities. This job works independently, under limited supervision, reporting major activities through periodic meetings.

Duties and Responsibilities
The functions listed below are those that represent the majority of the time spent working in this job. Management may assign additional functions related to the
type of work of the job as necessary.

Essential Functions

• Administers the City's public information request response program by managing the receipt of requests; entering requests received in person or via email, reviewing, assigning, clarifying, and preparing cost estimates and calculations; as well as tracking and monitoring requests received to ensure timely completion of all requests.
• Administers the City's public information web portal and provides technical citywide, as well as external customers, coordinates resolution of requestor complaints to the Attorney General's Office.
• Provides training and education for compliance with CSO programs policies, procedures, relevant laws and regulations, and best practices.
• Research, review, and analyze City records as requested by City staff, the public, and other public entities.
• Assists the public with policies and procedures in accordance with related statutory process requirements.
• Retains and applies specific knowledge in all areas of the City Secretary's Office, including but not limited to the Texas Public Information Act, Texas Open Meetings Act, Texas Election Law, Code of Ethics, and records management.
• Assists in the development, revision, and implementation of standard operating procedures.
• Assists in coordinating and administering all phases of municipal elections; monitors election processes; ensures compliance with Texas Local Government Code, Texas Election Code, Texas Ethics Commission, and other election laws, rules, and regulations.
• Accept campaign finance filing reports from the mayor and city council, as well as council candidates, during election season, and during their annual and semiannual filing dates.
• Assists with the preparation of documents, document folders, copying, collating, and assembling meeting packets, postings, notices, and filing of City records such as contracts, agreements, ordinances, resolutions, minutes, and agreements and contracts.
• Processes permits and licenses including the verification of applications and creating and updating a list of current and expired permits.
• Maintains the City Secretary's Office website and boards and commission portal.
• Processes accounts receivable and accounts payable for the department, budget adjustments, and PO requests.
• Receives and screens calls for City's Secretary's Office and City Hall receptionist desk.
• Performs all other duties, special tasks, and responsibilities as directed, both independently and/or as part of a team effort.

Minimum Education and Experience Requirements

• Requires associate degree or comparable experience.
• Municipal experience preferred.
• Three years of experience in records and file room management, including two years using an automated records management system.
• Additional relevant work experience resulting in acceptable proficiency levels in the above knowledge; skill and education requirements may be substituted in lieu of specific
  education requirements.
• Advanced knowledge of the Internet, and office software such as MS Word, PowerPoint, Excel, and specialized records management software systems.
• Knowledge of the rules of English grammar, spelling, and punctuation. Skilled in preparing documents without errors in grammar, spelling, or punctuation.
• Knowledge and understanding of the City, office operations and functions, and public policy. Knowledge of general records information management practices and
  procedures with specific ability to categorize records series and determine a record's life cycle.
• Working knowledge of the requirements of the Texas Public Information Act, Texas
• Uses time effectively to accomplish tasks.

Special Certifications and Licenses

• Valid Texas Driver License
• Texas Notary Commission (must be eligible to become a Texas notary)
• Texas Municipal Clerk's Certification (preferred)