Business Intelligence Analyst II - RWRD

Summary

Join to apply for theBusiness Intelligence Analyst II - RWRDrole atPima CountyJoin to apply for theBusiness Intelligence Analyst II - RWRDrole atPima CountyOverviewPima County Regional Wastewater Reclamation Department (RWRD) is seeking a Business Intelligence Analyst II to assist in the transformation of critical data into data visualizations for tracking Key Performance Indicators (KPIs). The role is responsible for gathering, calculating, analyzing, and interpreting data, and working with personnel to provide information for improved operational efficiencies. The position involves working with business units to analyze, document, and design solutions for data analysis, interpretation, and reporting. The BI Analyst II ensures data is accurate, congruent, and reliable, and readily available for analysis or integration.ResponsibilitiesProvides analytical support for the development of business intelligence solutions.Works on complex, cross-functional business intelligence solutions affecting one or more departments.Participates in multiple projects as team member, can act as the team lead when needed.Works with internal and external customers and Analytics and Data Governance partners to develop and analyze BI needs.Interprets business requirements and determines data analysis solutions to meet department needs.Designs analytics and custom reports that can be used in multiple departments throughout the County.Performs analysis for a wide range of requests using data from various platforms.Researches business problems and creates data models to analyze identified issues.Provides direction for planning, design, and execution of data analysis solutions.Reviews test plans and monitors testing process to ensure results meet identified needs; provides support to test teams and resolves issues.Provides input to the development of quality metrics, standards, policies, and procedures for BI tools and systems.Creates data quality tickets and ensures timely resolution.Researches tools and mechanisms for data analytics; interfaces with vendors to stay current on technologies.Ensures BI solutions adhere to current County standards.Designs and delivers end-user training and training materials.Provides guidance, training, and problem-solving assistance to other team members.Minimum QualificationsBachelor's degree in computer science, computer engineering, management information systems (MIS), or a closely related field, and five years of business analysis or related technical experience, or two years with Pima County in BI Analyst I or similar role. Relevant education/experience may be substituted. Qualifying education and experience must be documented in the Education and Work Experience sections of the application.Preferred QualificationsMinimum three (3) years of experience understanding and analyzing a wide variety of industry data systems related to financial systems, asset management, utilities, laboratory information systems, or SCADA systems.Minimum two (2) years of experience using data analysis tools, software, and languages including SQL, Power BI, Tableau, Qlik, Python, DAX, and Power Query.Minimum two (2) years of experience in an analytics/analyst role.Minimum one (1) year of experience in data modeling, predictive analytics, statistical methods, and data transformation.Selection ProcedurePima County HR reserves the right to admit only candidates who meet the minimum qualifications. Applications will be evaluated based on listed education and experience. Candidates meeting minimum qualifications may be evaluated against preferred qualifications. The hiring authority will interview and select from a referral list; additional assessments may be required.Supplemental InformationLicenses and Certificates: Valid driver license is required at time of application. AZ driver license required at time of appointment. The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review. Failure to obtain/maintain required licenses and certifications may be grounds for termination. Any offer is contingent upon Fleet Services' review/approval of driving record.Special Notice Items: Pre-employment background checks; post-offer, pre-employment screening including verification of work history, education, and criminal history. A prior criminal conviction will not automatically disqualify a candidate.EEO Information: Pima County Government is an Equal Employment Opportunity employer. We are committed to an inclusive and diverse workforce and will not discriminate in employment opportunities or practices on the basis of race, color, religion, national origin, age, disability, gender, sexual orientation, kinship, political interest, or any other characteristic protected by law.#J-18808-Ljbffr

Job Description

Join to apply for theBusiness Intelligence Analyst II - RWRDrole atPima CountyJoin to apply for theBusiness Intelligence Analyst II - RWRDrole atPima CountyOverviewPima County Regional Wastewater Reclamation Department (RWRD) is seeking a Business Intelligence Analyst II to assist in the transformation of critical data into data visualizations for tracking Key Performance Indicators (KPIs). The role is responsible for gathering, calculating, analyzing, and interpreting data, and working with personnel to provide information for improved operational efficiencies. The position involves working with business units to analyze, document, and design solutions for data analysis, interpretation, and reporting. The BI Analyst II ensures data is accurate, congruent, and reliable, and readily available for analysis or integration.ResponsibilitiesProvides analytical support for the development of business intelligence solutions.Works on complex, cross-functional business intelligence solutions affecting one or more departments.Participates in multiple projects as team member, can act as the team lead when needed.Works with internal and external customers and Analytics and Data Governance partners to develop and analyze BI needs.Interprets business requirements and determines data analysis solutions to meet department needs.Designs analytics and custom reports that can be used in multiple departments throughout the County.Performs analysis for a wide range of requests using data from various platforms.Researches business problems and creates data models to analyze identified issues.Provides direction for planning, design, and execution of data analysis solutions.Reviews test plans and monitors testing process to ensure results meet identified needs; provides support to test teams and resolves issues.Provides input to the development of quality metrics, standards, policies, and procedures for BI tools and systems.Creates data quality tickets and ensures timely resolution.Researches tools and mechanisms for data analytics; interfaces with vendors to stay current on technologies.Ensures BI solutions adhere to current County standards.Designs and delivers end-user training and training materials.Provides guidance, training, and problem-solving assistance to other team members.Minimum QualificationsBachelor's degree in computer science, computer engineering, management information systems (MIS), or a closely related field, and five years of business analysis or related technical experience, or two years with Pima County in BI Analyst I or similar role. Relevant education/experience may be substituted. Qualifying education and experience must be documented in the Education and Work Experience sections of the application.Preferred QualificationsMinimum three (3) years of experience understanding and analyzing a wide variety of industry data systems related to financial systems, asset management, utilities, laboratory information systems, or SCADA systems.Minimum two (2) years of experience using data analysis tools, software, and languages including SQL, Power BI, Tableau, Qlik, Python, DAX, and Power Query.Minimum two (2) years of experience in an analytics/analyst role.Minimum one (1) year of experience in data modeling, predictive analytics, statistical methods, and data transformation.Selection ProcedurePima County HR reserves the right to admit only candidates who meet the minimum qualifications. Applications will be evaluated based on listed education and experience. Candidates meeting minimum qualifications may be evaluated against preferred qualifications. The hiring authority will interview and select from a referral list; additional assessments may be required.Supplemental InformationLicenses and Certificates: Valid driver license is required at time of application. AZ driver license required at time of appointment. The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review. Failure to obtain/maintain required licenses and certifications may be grounds for termination. Any offer is contingent upon Fleet Services' review/approval of driving record.Special Notice Items: Pre-employment background checks; post-offer, pre-employment screening including verification of work history, education, and criminal history. A prior criminal conviction will not automatically disqualify a candidate.EEO Information: Pima County Government is an Equal Employment Opportunity employer. We are committed to an inclusive and diverse workforce and will not discriminate in employment opportunities or practices on the basis of race, color, religion, national origin, age, disability, gender, sexual orientation, kinship, political interest, or any other characteristic protected by law.#J-18808-Ljbffr