Sql data analyst Jobs in Centennial, CO

Management Analyst

Under direct supervision and direction, this position will lead and conduct complex research and analyses that may include policies and procedures, federal and state legislation, regulatory review, and ultimately preparing appropriate recommendations and responses for consideration by senior staff and City Council.

This position serves as a program and project manager in planning, organizing, developing, and implementing special programs and projects of a varied nature directly related to the function of the assigned department/division. Work may include financial and budgetary analysis, preparation, and administration.

Senior Management Analyst

In addition to the responsibilities of the Management Analyst, the Senior Management Analyst will operate under limited and general supervision and direction, and perform advanced journey level duties, including lead responsibilities of one or more programs and serving as a liaison for various commissions, committees, and groups providing general public relations functions.

Examples of Duties

Essential Duties

• Recommends, develops, implements, and amends organizational policies and procedures.
• Develops schedules, formats, and procedures for budget preparation and control.
• Reviews and analyzes departmental budget estimates and participates in the development of preliminary and final City budgets.
• Coordinates information and assures effective communications between departments; clarifies and reconciles complex issues relating to strategic and operational planning and procedures; coordinates projects with City Council and other regional agencies and organizations.
• Assists in establishing and implementing organizational policies and procedures; monitors effectiveness of policies and procedures and make revisions or recommendations for improvement as appropriate.
• Collects information and data and/or conducts surveys on operational and administrative issues, analyzes findings, prepares reports and makes recommendations to management.
• Performs complex research and analysis activities regarding various financial related projects, including analyses of changing services and impacts upon fees and charges, alternative methods of financing and service delivery, and regulatory impacts.
• In conjunction with the appropriate departments and outside agencies, oversees and performs activities related to developing, implementing, projecting and monitoring revenue and expense related activities for city programs and contracted services.
• Provides training, technical support, and group presentations to employees, executive management, and elected officials regarding operational policies and procedures.
• Coordinates and prepares council reports, financial reports, statistical tables, charts and graphs.
• Other duties as assigned.
• Responsible for the maintenance, updating and retention of records, data, and content managed within the scope of the position. Acquires and utilizes knowledge of City's electronic content management systems and guards against the unauthorized removal, destruction or use of municipal records. Recognizes and respects that City employees forego any personal or proprietary right to the City's records including those that may have been developed, created, or compiled during their tenure in employment.

Senior Management Analyst

• Exercises high level of self-direction and discretion.
• Attends meetings as a representative of management.
• Serves as a management liaison to various boards, committees, commissions, and citizen advisory groups, as may become necessary.
• Responsible for the maintenance, updating and retention of records, data, and content managed within the scope of the position. Acquires and utilizes knowledge of City's electronic content management systems and guards against the unauthorized removal, destruction or use of municipal records. Recognizes and respects that City employees forego any personal or proprietary right to the City's records including those that may have been developed, created, or compiled during their tenure in employment.

Knowledge, Skills and Abilities

Knowledge of:

• Municipal organizations, operations, policies and procedures.
• Principles, methods and practices of public administration, contract and program management, and municipal budgeting.
• Research techniques, methods and procedures.
• Principles and techniques of systems and procedures analysis.
• Principles and practices of fiscal administration and statistics.
• Legal, ethical and professional rules of conduct for public sector employees.
• Applicable State and Federal statutes, rules, codes and regulations.

Ability to:

• Gather pertinent facts, make thorough analyses and arrive at sound conclusions and projections.
• Analyze, interpret and report research/analytical findings in clear, complete and logical form.
• Present ideas concisely and effectively, orally and in writing.
• Operate a personal computer using database and spreadsheet programs; perform limited program modification to adapt software to varying applications.
• Strong written and verbal communication skills with the ability to effectively communicate and interact with all levels of the organization.
• Prepare highly complex policy reports and to present facts clearly and concisely.
• Evaluate complex circumstances, identify tangible alternative actions and formulate effective plans and procedures.
• Exercise tact and discretion in dealing with Federal, State, and City officials as well as the general public, and in handling confidential information.
• Exercise independent judgment and initiative in identifying required work assignments and appropriate methods to be utilized in developing solutions to a variety of work situations. (Senior Management Analyst only)

Skills:

• Strong interpersonal, analytical, verbal and written communication skills
• Excellent public speaking skills.
• Ability to establish and maintain effective working relationships with other City employees, public officials, government agency representatives, and the public.
• Strong project management and negotiation skills.
• Knowledge of local, state, and federal legislation and regulations.
• Ability to analyze administrative and operational data and issues, interpreting policies and regulations, evaluating alternatives, and recommending changes based on findings.
• Use of standard office equipment, computer equipment and software including word processing, database management, and spreadsheet applications and electronic mail.
• Proficiency with MS Office Suite required.

Minimum Qualifications

Minimum Education, Training and Experience Any combination of experience and education that would likely provide the required knowledge and abilities is qualifying.

Education: The equivalent to a Bachelor's degree from an accredited college or university with major course work in public administration, business administration, or a closely related field. A master's degree in public administration is strongly preferred.

Experience:

Management Analyst: One (1) to three (3) years of experience in municipal management or public administration for Management Analyst.

Senior Management Analyst: Three (3) to five (5) years of experience in municipal management or public administration. A master's degree may substitute for one year of experience.

Job Elements/Working Conditions

Requirements to Perform Essential Job Functions

Must be able to perform the essential functions of this job, with or without accommodation.

Physical Demands

The person in this position must be able to remain in a stationary position 50% of the time; needs to occasionally move about inside the office to access file cabinets, office machinery, etc. Occasionally moves office equipment weighing up to 30 pounds. The person in this position frequently communicates with Council members, staff, vendors, and residents; must be able to exchange accurate information in these situations. Must be able to identify Council members, staff, vendors, and residents, as applicable. Must be able to observe, assess, record, and interpret information.

Work Environment

Work is performed primarily in an office setting with in-person and telephone contacts and may involve frequent interruptions. Work may require attendance at evening and/or weekend meetings.

Equipment Used/Required

Frequently operates a computer and other office productivity machinery, such as a calculator, copy/fax machine, and computer printer.

Expectation of All Employees

Support the City's mission and values.

Mission Driven to provide exceptional service to the Centennial community.

Values Collaborative, Intentional, Service Oriented, and Innovative

The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change.