Report writer Jobs in Phoenix, AZ

Salary : $93,240.00 - $139,860.00 Annually

Location : Glendale, AZ

Job Type : Full Time

Job Number : 2024-03964

Department : Innovation And Technology

Opening Date : 02 / 24 / 2025

Closing Date : 5 / 5 / 2025 11 : 59 PM Arizona

Hours per Week : 40

Description

The Role :

The Business Intelligence Report Writer evaluates, designs, and develops enterprise business intelligence reports, dashboards, and solutions. Works closely across multiple departments and IT teams to ensure dashboards, reports, data, and metrics provide reliable and clear information that accurately assists with planning, measuring, trending and enhances operational performance. Research technology best-practices, implement frameworks, and align BI directions with strategic business initiatives. The Business Intelligence Report Writer analyzes metric data sources, monitors data quality, defines logical inter-dependencies, and builds comprehensive business process dashboards or reports.

The ideal candidate for the role will have a Bachelor's degree in Computer Science, Mathematics, Statistics or a related field and two years progressively responsible experience in a directly related area such as Business Intelligence systems and advanced business reporting tools. Benefits :

The City of Glendale offers a generous benefits package with competitive rates that become effective the 1st of the month following 30 days of employment. You can review the or visit the for more information. Holiday, Vacation, and Sick Leave :

Regular status position's offer :

• The City of Glendale observes 10.5 holidays per year, and full-time employees are also granted an additional 12 hours of holiday special leave per calendar year to celebrate their cultural or religious holidays.
• Vacation leave accrues at 5.33 hours per pay period (138 hours per year), and increases to 6.12 hours after 5 years, and to 7.6 hours after 10 years of service.
• Sick leave accrues at 4.4 hours per pay period (114 hours per year).

Retirement :

This position participates in the Arizona State Retirement System (ASRS).

Contribution is mandatory, and the current contribution rate is 12.27%.

Essential Functions

Evaluates customers' needs and abilities in order to provide appropriate solutions.

Acquires data from primary or secondary data sources using standard SQL.

Creates complex, visually appealing, and interactive dashboards / scorecards / reports to support business processes such as compliance and regulatory needs etc., including related trends, and projections.

Determines data quality and assists in analysis of data consistency derived from transaction and business intelligence systems.

Works with DBAs to design data ETL extractions and manipulations to support production and ad-hoc analyses and reports.

Provides guidance on industry best-practices and help select strategic data platforms, tools, and processes.

Recommends standards, policies, and procedures for the form, structure, and attributes of the BI tools and systems.

Provides support and training to business teams as necessary. Assists with unit testing systems integration testing and user acceptance testing.

Supports the company's commitment to protect the integrity and confidentiality of systems and data.

Filters and "cleans" data by reviewing computer reports, printouts, and performance indicators to locate and correct sources of data error.

Works with management to prioritize business and information needs.

Adheres to current data visualization standards for dashboard and report design.

Follows established change control processes as necessary.

Leverages existing data and reports to minimize unnecessary data and report creation.

Ensures proper security measures are applied as necessary to data repositories and reports.

Analyzes and document business processes.

Performs other related duties as assigned.

Minimum Qualifications / Special Requirements / Success Factors

A Bachelor's degree in Computer Science, Mathematics, Statistics or a related field and two years progressively responsible experience in a directly related area such as Business Intelligence systems and advanced business reporting tools.

Any equivalent combination of education, training and experience that provides the required knowledge, skills and abilities is qualifying. One year of relevant experience may be substituted for each year of required education.

Knowledge of :

Power BI

Power Query and DAX

Tableau software

Data visualization design principles

Data cleaning methodologies

Data standard best practices

Software analysis, design, development, and implementation techniques

Current industry trends and best practices

Use of technology for business operations

A wide variety of analytical processes (data privacy, governance, measurement, information security, etc.)

Extract, Transform, and Load (ETL) tools

Ability to :

Work in a self-directed manner

Prioritize work processes and projects

Analyze business processes

Identify data trends and patterns

Conduct research; analyze findings; prepare and present recommendations to management

Communicate clearly both verbally and in writing

Establish and maintain effective working relationships with city staff

Continually learn and demonstrate new skills via hands on training, classroom training and self-study

Translate broader business initiatives into clear team objectives and concrete individual goals, aligning appropriately with other groups for efficient, coordinated action

Special Requirements

Industry standard certification(s) as appropriate such as Data Analytics, Business Intelligence or related area. (Preferred)

Success Factor Classification Level - Professional / Supervisory

To view the success factor definitions please click here . This position 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 position change.

Physical Requirements / Working Conditions

Office setting

Benefit information is outlined here :

Please select the response that most accurately reflects your education and experience as it relates to the Business Intelligence Report Writer position with the City of Glendale.

A Bachelor's degree in Computer Science, Mathematics, Statistics or a related field and two years progressively responsible experience in a directly related area such as Business Intelligence systems and advanced business reporting tools.

Three years of college coursework in Computer Science, Mathematics, Statistics or a related field and three years progressively responsible experience in a directly related area such as Business Intelligence systems and advanced business reporting tools.

Two years of college coursework in Computer Science, Mathematics, Statistics or a related field and four years progressively responsible experience in a directly related area such as Business Intelligence systems and advanced business reporting tools.

One year of college coursework in Computer Science, Mathematics, Statistics or a related field and five years progressively responsible experience in a directly related area such as Business Intelligence systems and advanced business reporting tools.

Six years progressively responsible experience in a directly related area such as Business Intelligence systems and advanced business reporting tools.

None of the above

How many years of experience do you have as a Business Intelligence Report Writer?

Five or more years

Three to four years

Two to three years

One to two years

Less than one year

No experience

How many years of experience do you have with Power BI?

Five or more years

Three to four years

Two to three years

One to two years

Less than one year

No experience

How many years of experience do you have with other BI tools such as Tableau, Alteryx, etc.?

Five or more years

Three to four years

Two to three years

One to two years

Less than one year

No experience

How many years of experience do you have with DAX and Power Query?

Five or more years

Three to Four years

Two to Three years

One to two years

Less than 1 year

No experience

How many Interactive Dashboards have you created in a professional capacity?

5-10

10 or more

Do you have a data analytics-related certification or degree?

Required Question