Business Systems Analyst Senior

Posting Date

Application Deadline

Pay Range

Job Type

Department

About the Position

Do you have a passion for data and are adept at communicating it to others

As the Business Systems Analyst Senior you will serve as a valuable resource and a critical member of a large and diverse team committed to improving and protecting Maricopa Countys air quality. The position focuses on providing professional-level research analysis and implementation of technology enhancements within the division in coordination with other county departments and vendors. This technology is the vital link between the production of air quality data and its dissemination to our internal and external customers.

About Us

As one of the fastest-growing and largest counties in the nation the Maricopa County Air Quality Department continues to develop innovative programs and engage the community so customers residents and visitors can live work and play in a healthy environment. Air quality has improved significantly over the last 20 years and the department remains committed to increasing compliance with air quality permits and regulations and strengthening the communitys knowledge of air quality issues. From continually monitoring the air we breathe to permitting and inspecting sources of air pollution developing award-winning school education and pollution reduction programs and increasing outreach efforts the department strives for excellence.

Proud to Offer

• Work with a greater purpose

• Tuition reimbursement

• Exceptional work-life balance

• Opportunities for growth and development within Maricopa County

• Low-cost high-value healthcare for you and your qualifying dependents

• Child care benefits including access to our on-site center Maricopa County Kids Club dedicated to serving Maricopa County families exclusively

• Paid vacation sick time and parental leave

• Extensive wellness program including healthcare premium discounts

• Maricopa County participates in the Arizona State Retirement System. This defined retirement benefit requires a 12% monthly contribution rate and includes a 100% employer match on Day 1

• Learn more at Work With Us Maricopa County AZ

We Require

• Three years of related analytical experience including work with complex relational database systems involving data acquisition integration across multiple systems and advanced analysis of complex data structures

• Bachelors degree in Computer Science Information Systems or related field

We Also Value

• Familiarity with Power BI to create and/or update reports

• Familiarity with Microsoft Azure cloud environment

• Familiarity with content management systems (CMS) to update online websites and documents

• Proficiency in writing optimized SQL queries to extract transform and validate data from relational databases to ensure data integrity support reporting needs and fulfill ad-hoc data requests

• Strong Microsoft Word skills and proficiency in collaborative tools such as Teams SharePoint and Microsoft Planner

• Strong Microsoft Excel skills including data connections and queries to develop reports charts and analysis

Job Contributions

• Identifies data quality needs and root causes; develops automated SQL/Python scripts and queries to improve data quality; builds and maintains Power BI datasets/models to deliver leadership dashboards and briefs that communicate accomplishments and areas for improvement.

• Provides high-level technical support and account/access administration for department technologies (portals integrated apps and related services); troubleshoots issues fulfills access requests and coordinates with vendors/IT teams to ensure secure reliable user experiences for staff and the public.

• Leads collaboration with AQD and ETI staff to inventory document and mature AI solutions; develops SOPs training and governance artifacts to ensure safe compliant and effective adoption across the department.

• Defines test strategy and plans (integration systems UAT); prepares test data and detailed test cases; establishes UAT cycles and entry/exit criteria; trains business testers triage defects verifies fixes; conducts release-readiness reviews and validates deployments across non-production and production environments.

• Engage stakeholders to collect data analyze planning needs develop problem statements and define the scope of work. Produce requirements artifacts (BRD user stories acceptance criteria process maps). Collaborate with developers and technical staff to monitor progress resolve issues and validate solutions. Assess implement and support system enhancements and related process improvements.

• Provides operational support for database backup/restore workflows and routine system maintenance including patching integrity and consistency checks index/statistics maintenance capacity/performance monitoring and ticket remediation; functions as the secondary DBA to monitor environments troubleshoot issues and apply documented procedures when the primary DBA is out.

• Translates approved requirements into design configuration and integration specifications; prototypes workflows data mappings and interface components; configures applications and reference data and builds lightweight (non-production) SQL/Python scripts for prototyping/validation; coordinates with developers/admins to promote changes through change-management gates.

• Provide lead experience and guidance to IT Business Systems Analyst and department staff on system functionality and best practices; reviews deliverables for quality and alignment; facilitates knowledge transfer and continuous improvement.

Working Conditions

• Exerting up to 10 lbs. occasionally or negligible weights frequently; sitting most of the time

• Position is typically office or administrative work and is not substantially exposed to adverse environmental conditions.

• Work is typically performed in an office environment and may include a combination of on-site and remote work or full-time remote work at the discretion of the Director and as determined by business needs.

Selection Procedure

• Only the most qualified candidates will be considered

• Consideration will only be given to candidates who submit online applications

• Candidates will be contacted primarily through email and their Workday online application profile

• Must pass a pre-employment background and/or fingerprint investigation as required by statute or policy including drug and alcohol testing requirements for positions designated as safety-sensitive

Maricopa County is an equal opportunity employer.

Apply Now!