City of Glendale 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 SQL 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: 01
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
02
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
03
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
04
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
05
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
06
How many Interactive Dashboards have you created in a professional capacity?
0-5 5-10 10 or more
07
Do you have a data analytics-related certification or degree?
Yes No
Required Question
$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 SQL 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: 01
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
02
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
03
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
04
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
05
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
06
How many Interactive Dashboards have you created in a professional capacity?
0-5 5-10 10 or more
07
Do you have a data analytics-related certification or degree?
Yes No
Required Question