Functional Analyst - Economic Development

Who We Are

Orlando, The City Beautiful

For most of Orlando's history we've been the place everyone wants to visit. Today, we're also the place where everyone wants to live and do business. List after list has Orlando as one of the fastest growing cities in America. We're transitioning from our role as the young upstart to a more mature, global city.

This didn't happen by accident. Together as a community, we developed a shared vision for our city focused on creating partnerships and we've transformed Orlando from a place that was packed with potential into a city on the rise.

Our vision ensures we are an inclusive, compassionate community that is generating jobs, becoming the most sustainable city in the nation, keeping our community safe, making it easier to get around, and increasing the quality of life. Together, we can continue realizing all our city's potential.

Come be part of our community with the City of Orlando.

Nature of Work

Develops, maintains, and enhances new and existing reporting systems according to customer feedback and independent understanding of business operations. Data is turned into information and information into insights that directly influence and advance organizational capability. Performs professional and administrative work and provides direct Business Intelligence support to all levels and disciplines of Economic Development, with emphasis on Building and Development functions that are of key interest to City of Orlando customers. Prepares and delivers presentations that articulate business results to diverse audiences. Capable of leading changes to business processes, systems and technology, and driving faster adoption and higher proficiency amongst staff. Work is performed under the general direction of the Information Platforms Manager and is reviewed through discussions and reports submitted..

Minimum Requirements

Minimum Requirements

Bachelor's degree in Information Management, Computer Science, Statistics, Finance/Economics or related field required and three (3) or more years experience in data analysis and/or custom report development for end users required; or an equivalent combination of education, training, and experience. Direct experience creating SQL queries, tables, stored procedures, and views in relational database environment required. Direct experience with business intelligence applications such as Power BI or Tableau preferred. Valid Florida driver's license is required.

IMPORTANT: To be eligible to proceed forward in the application process, applicants must meet the minimum qualifications listed in the position description. Please ensure your application provides details of all relevant experience related to the position. If you have questions or need clarification concerning the position or application process, please contact Human Resources at jobs@orlando.gov or 407.246.2062.

Supplemental Information

City of Orlando Benefits

If this posting indicates a degree is required, the following experience will apply in lieu of any degree as follows:

• Two (2) years of direct experience for an associate degree;

• Four (4) years of direct experience for a bachelor's degree;

• Six (6) years of direct experience for a master's degree; or

• Nine (9) years of direct experience for a doctoral degree

01

A valid driver license from any state is required for this position. If you possess a Florida DL, enter the DL number (no dashes or spaces) and expiration date in the space provided. Please follow the format shown: Example: X123123121230 Exp 01/01/2022 If you possess a valid driver license from another state or country, enter OTHER STATE. If you do not possess a valid driver license at this time, enter NONE.

02

What is the highest level of education you have attained?

• Less than high school

• High school graduate or equivalent (GED)

• Technical school completed

• Some college (less than 60 semester credits)

• Associate degree or equivalent (60 or more semester credits)

• Bachelor degree (120 or more semester credits)

• Master degree

• Doctorate degree

03

Do you have a Bachelor Degree (or higher) in Information Management, Economics, Computer Science, Statistics, Finance/Economics or related field?

• Yes

• No

04

How much full-time work experience do you have in in data analysis and/or custom report development for end users?

• None

• Some but less than six months

• Some but less than three years

• Between five and eight years

• Between three and five years

• Between eight and ten years

• More than ten years

05

Which frameworks do you have experience with (select all that apply)?

• None
• SQL
• XML
• Javascript
• ETL

06

How would you rate your direct experience creating SQL queries, tables, stored procedures, and views in relational database environment l?

• I am a BEGINNER in creating SQL queries, tables, stored procedures, and views in relational database environment l.
• I am an INTERMEDIATE in creating SQL queries, tables, stored procedures, and views in relational database environment l.
• I am an ADVANCED or EXPERT in creating SQL queries, tables, stored procedures, and views in relational database environment l.
• I have no skill or experience with creating SQL queries, tables, stored procedures, and views in relational database environment l

07

How much full-time experience do you have in data analysis or custom report development? You must include complete details in your online application or resume.

• I have BEGINNING work experience
• I have INTERMEDIATE work experience
• I have ADVANCED or EXPERT work experience
• I have no skill or experience

08

How would you rate your skill and experience with the current release of Microsoft Power BI? You must include complete details in your online application or resume.

• I am a BEGINNING user of Microsoft Power BI
• I am an INTERMEDIATE user of Microsoft Power BI
• I am an ADVANCED or EXPERT user of Microsoft Power BI.
• I have no skill or experience with Microsoft Power BI.

Required Question

Agency City of Orlando