What are the responsibilities and job description for the Business Intelligence (BI) Report Writer position at City of Glendale (AZ)?
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 FY24 Benefits Guide or visit the City of Glendale’s Benefits page for more information. |
| Holiday, Vacation, and Sick Leave: | |
Regular status position’s offer:
|
| Retirement: | |
|
- 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.
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)
To view the success factor definitions please click here. (If needed, click here to download PDF reader).
Salary : $93,240 - $139,860
