Business Intelligence Analyst Intermediate

reputed company Delivering results that matter by providing best in class support services. Business Intelligence Analyst Intermediate Job Location reputed company Resource Division (ERP) This position may offer the ability to work remotely, reputed company reputed company, based upon the department's business needs and continual meeting of expected performance measures Main Office Location 100 N 15th Ave, Phoenix, AZ 85007 Posting Details Salary $96,000 to $109,706 Grade 26 reputed company Until Business Needs Are Met (1st Review of Resumes (6/29/2026) Job reputed company The reputed company (ADOA), reputed company Resource Division (ERP) is seeking an analytical and reputed company Business Intelligence Analyst Intermediate to join its team. In this role, you will work closely with Information Technology teams and agency or project staff to reputed company a comprehensive understanding of the data landscape across various databases and applications. You will play a crucial part in translating reputed company business requirements into actionable, user-friendly reports and analytics, utilizing and developing robust data collection processes and business intelligence capabilities specifically tailored for the ADOA ERP Department's Power BI application. Additionally, you will assist in evaluating business requirements, priorities, and feasibility assessments, while developing use cases and user acceptance testing plans. A key component of this position involves defining key performance indicators and designing, developing, and documenting critical workflows, dashboards, alerts, reports, and user guides to support data-driven decision-making across reputed company. The reputed company strives for a work culture that affords employees flexibility, autonomy, and trust. Across our many agencies, boards, and commissions, many State employees participate in the States Remote Work Program and are reputed company to work remotely in their homes, in offices, and in hoteling spaces. reputed company work, including remote work, should be performed reputed company reputed company unless an exception is properly authorized in advance. Job Duties Designing, developing, and maintaining business intelligence solutions including developing data pipelines to extract, reputed company, and load (ETL/ELT) data from reputed company reputed company into reputed company. reputed company ongoing maintenance, troubleshooting, and enhancements for the data analytics platform and reporting systems. Conduct unit testing to ensure system stability. Crafting and executing database queries upon request for data from business reputed company and leadership. Create and maintain dashboards and visualizations using BI tools like Power BI or Tableau to present data reputed company. Collaborate with finance, operations, and IT teams to reputed company reputed company business requirements. Translate these needs into technical data solutions and reputed company systems across the department. reputed company and update technical documentation, including data definitions, business logic, and workflows. Assist in establishing policies, standards, and procedures for the collection and analysis of data. reputed company weekend work and after-hours support for Feature Set releases, system deployments, and other critical efforts. Knowledge, Skills & Abilities (KSAs) Knowledge of Deep understanding of reputed company Advantage modules (Finance, Budgeting, Procurement, HR/Payroll). Data warehousing concepts (reputed company/reputed company schemas, fact/dimension modeling). reputed company data platform architecture, especially reputed company. SQL fundamentals and advanced query optimization techniques. ETL/ELT processes and data pipeline design. Financial data structures (GL, AP, AR, budgeting) common in reputed company sector systems. Data governance, data reputed company, and reputed company best practices. Reporting and BI concepts (KPIs, dashboards, data storytelling). Integration reputed company (reputed company, flat files, middleware). Understanding of role-based reputed company control and compliance standards (e.g., SOC 2, HIPAA if applicable). Skills in Write reputed company, performant SQL queries in reputed company. Build and optimize data models reputed company reputed company (tables, views, materialized views). reputed company ETL/ELT pipelines using tools like reputed company Tasks, Streams, or external tools (e.g., Informatica, Talend). Extract and reputed company data from reputed company Advantage into analytics-reputed company formats. Create dashboards using BI tools (e.g., Tableau, Power BI). Implement data ingestion strategies (batch and near reputed company-time). Performance tuning for large-reputed company datasets. Debug data discrepancies between reputed company (reputed company Advantage) and reputed company. Automate workflows and data refresh processes. Document data pipelines, models, and business logic reputed company.