Data Analyst/Senior Data Analyst

Preferred/Desirable skills specific to this assignment include professional work experience, knowledge of and/or demonstrated skills in the following:  SQL Tools, Python, Power BI, and cloud data platforms such as Databricks.  Knowledge of machine learning techniques and algorithms for predictive analytics.  

A Data Analyst is responsible for assisting departments and divisions with the development and use of data analysis and reporting solutions that provides actionable insights and informs managerial decision-making to address social, economic, and City management issues and to drive improvements to the City’s delivery of services.  A Data Analyst creates, participates in, and ensures a successful data analytics practice that helps the City find trends; uncovers opportunities; predicts actions, triggers, or events; and makes decisions. 

Work requires independent judgement and initiative in combining a broad scope of professional, organizational effectiveness, knowledge, and analytical judgement to assist with a variety of complex citywide issues.  Incumbents are required to carry out assignments with general instruction and guidance, and to seek direction/information proactively.  This position is expected to assess and promote data-driven practices that will improve City operations and outcomes for Mesa residents and visitors.  A Data Analyst works with project teams and business clients to collect, clarify, and translate business requirements into actionable projects.  The Data Analyst is distinguished from the Senior Data Analyst in areas of responsibility related to the level of training, support, and information provided to department leadership and management for decision-making, as well as, in the types of analysis (descriptive/diagnostic versus predictive/prescriptive) performed and/or lead.  Employees in this class must demonstrate analytical skills, requirements gathering, and quality assurance; and must exercise professional discretion while performing day-to-day activities independently within established guidelines and procedures.  This class is supervised by the Chief Data Officer who reviews work through conferences, reports, and overall results achieved.  Employees may progress to a Senior Data Analyst by non-competitive promotion upon meeting specific criteria-based promotion requirements of performance, training, and experience.  This class performs related duties as required.  This class is FLSA exempt-administrative.

Senior Data Analyst ($78,503.78 - $113,033.02 annually)

A Senior Data Analyst is responsible for assisting departments and divisions with the development and use of data analysis and reporting solutions that provides actionable insights and informs managerial decision-making to address social, economic, and City management issues and to drive improvements to the City’s delivery of services.  A Senior Data Analyst creates, participates in, and ensures a successful data analytics practice that helps the City find trends; uncovers opportunities; predicts actions, triggers, or events; and makes decisions. 

Work requires considerable independent judgement and initiative in combining a broad scope of professional, organizational effectiveness, knowledge, and analytical judgement to resolve a variety of complex citywide issues.  Incumbents are required to carry out assignments without detailed instruction or guidance.  This position is expected to assess and promote data-driven decision-making analysis that will improve City operations and outcomes for Mesa residents and visitors.  The Senior Data Analyst is distinguished from the Data Analyst in areas of responsibility related to the level of advanced training, support, and information provided to department leadership and management for decision-making, as well as in the types of analysis performed and/or lead that includes predictive and prescriptive analysis projects that incorporate analytic models.  Employees in this class must demonstrate analytical skills, as well as considerable working knowledge of methodologies and techniques for business process modeling, requirements gathering, and quality assurance; and must exercise professional discretion while performing day-to-day activities independently within established guidelines and procedures with minimal supervision.  This class is supervised by the Chief Data Officer who reviews work through conferences, reports, and overall results achieved.  Employees may progress to this class by non-competitive promotion uponmeeting specific criteria-based promotion requirements of performance, training, and experience.  This class is FLSA exempt-administrative.

Please refer to the link below for the full job description and additional information regarding assignments, preferred qualifications, and essential functions.Employee Values:  All employees of the City of Mesa are expected to uphold and exhibit the City's shared employee values of Knowledge, Respect, and Integrity.

Data Analyst:

Minimum Qualifications Required.  Graduation from an accredited college or university with a Bachelor's Degree in Business Analytics, Data Analytics, Data Science, Public Administration, Organizational Development, Management Sciences, Engineering, Statistics, or a related field, OR graduation from an accredited college or university with a Bachelor’s Degree and completion from an accredited certificate program in Business Analytics, Data Analytics, Data Science, or a related field.  A minimum of three years full-time, professional work experience in a quantitative field with demonstrated expertise in statistical, analytical software (examples:  SQL tools, Microsoft Excel, Power BI, Tableau, common statistics programs, etc.).  Graduation from an accredited college or university with a Master’s Degree in Business Analytics, Data Analytics, Data Science, Public Administration, Organizational Development, Management Sciences, Engineering, Statistics, or a related field will be considered qualifying experience for both work experience and Bachelor’s Degree requirement. 

Special Requirement.  An individual must pass a background investigation through the City of Mesa Police Department (by assignment).  

Preferred/Desirable Qualifications.  Graduation from an accredited college or university with a Master’s Degree in Business Analytics, Data Analytics, Data Science, Computer Science, or Statistics.  Extensive (5 years) professional work experience in a quantitative field with demonstrated expertise in statistical, analytical software (examples: SQL tools, Microsoft Excel, Power BI, Tableau, common statistics programs, etc.). 

Senior Data Analyst:

Minimum Qualifications Required.  Graduation from an accredited college or university with a Bachelor's Degree in Business Analytics, Data Analytics, Data Science, Public Administration, Organizational Development, Management Sciences, Engineering, Statistics, or a related field, OR graduation from an accredited college or university with a Bachelor’s Degree and completion from an accredited certificate program in Business Analytics, Data Analytics, Data Science, or a related field.  A minimum of five years full-time, professional work experience in a quantitative field with demonstrated expertise in statistical, analytical software (examples: SQL tools, Microsoft Excel, Power BI, Tableau, common statistics programs, etc.).  Graduation from an accredited college or university with a Master’s Degree in Business Analytics, Data Analytics, Data Science, Public Administration, Organizational Development, Management Sciences, Engineering, Statistics, or a related field can substitute for two years of work experience.  Two years of full-time employment with the City of Mesa as a Data Analyst and a Master’s Degree in a field described above will also be considered as meeting the minimum qualifications requirement.

Special Requirement.  An individual must pass a background investigation through the City of Mesa Police Department (by assignment).

Preferred/Desirable Qualifications.  Graduation from an accredited college or university with a Master’s Degree in Business Analytics, Data Analytics, Data Science, Computer Science, or Statistics. Extensive (5 years) professional work experience in a quantitative field with demonstrated expertise in statistical, analytical software (examples: SQL tools, Microsoft Excel, Power BI, Tableau, R, Python, Apache Spark, Qlik, Jupyter, Databricks, other common statistics programs, etc.).  Supervisory or lead experience.Data Analyst:
http://apps.mesaaz.gov/jobdescriptions/Documents/JobDescriptions/cs5010.pdf

Senior Data Analyst:
http://apps.mesaaz.gov/jobdescriptions/Documents/JobDescriptions/cs5306.pdf

Salary : $67,798 - $113,033