Data Analyst

## DUTIES

ANNUAL SALARY

$85,691 to $125,280 and $102,374 to $149,688

The salary in the Department of Water and Power is $129,226 to $160,546; $135,427 to $168,271; $135,991 to $168,940; $152,006 to $188,859

NOTES:

1. Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer.

2. Candidates from the eligible list are normally appointed to vacancies in the lower pay grade positions.

3. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to[http://per/lacity.org/ReciprocityCityDeptsandDwp.pdf](http://per/lacity.org/ReciprocityCityDeptsandDwp.pdf)[(Download PDF reader)](https://get.adobe.com/reader/){target=”blank”}.

A Data Analyst conducts analysis and research related to urban planning, transportation, airports, utilities, police and other administrative and operational issues, and prepares and interprets quantitative analyses through the application of statistical and quantitative analysis concepts and techniques, mathematical models and simulation programs; may use statistical and general software packages involving the use of a personal computer or mainframe terminal; prepares forecasts and develops forecasting or machine learning models; may supervise and participate in the work of a small staff engaged in the above work; and performs other related duties.

## REQUIREMENT(S)/MINIMUM QUALIFICATION(S)

1. Graduation from an accredited four-year college or university with 12 semester or 18 quarter units in upper-division mathematics, statistics, or data analytics; AND one (1) year of full-time paid professional experience in applying advanced statistical, data analysis, or mathematical techniques;or
2. Graduation from an accredited four-year college or university AND two (2) years of full-time paid professional experience in applying advanced statistical, data analysis, or mathematical techniques.

Satisfactory completion of 15 semester units or 20 quarter units of graduate level work in statistical or quantitative analyses or a masters degree in data analytics or a related field from an accredited college or university may be substituted for a maximum of one year of full-time paid professional experience.

PROCESS NOTES

1. Applicants who lack six months of the required experience may file for this examination. However, they cannot be appointed until the full experience is met.

2. Applicants must:
a.List their school name and location, type of degree earned and major in the Education Section of the City application;and
b.List their completed upper-division mathematics, statistics, or data analytics course titles with the number of semester or quarter units as stated in the requirements, school attended and completion dates in the Supplemental Questions Section of the Application.
Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed.

“`{=html}

“`
3. Applicants wishing to substitute completion of 15 semester units or 20 quarter units of graduate level work in statistical or quantitative analyses or a masters degree in data analytics or a related field for a maximum of one year of the required experience must list their school name and location, appropriate course titles, their respective number of semester or quarter units, and completion dates for each course or degree claimed as qualifying in the text box which will appear in the Supplemental Questions section of the on-line application.

4. Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accredited agencies can be found at[http://per.lacity.org/Accredited Institutions 08-21-08.pdf](http://per lacity.org/Accredited%20Institutions%2008-21-08.pdf)[(Download PDF reader)](https://get.adobe.com/reader/){target=”blank”}.

5. For qualifying work experience gainedoutsideof the City of Los Angeles, the term professional experience applies to positions that require possession of a degree from an accredited four-year college or university in order to obtain that position. Therefore, to be considered professional,non-Cityqualifying experience must be gained in positions after obtaining a four-year degree.

6. Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree and coursework. Applicants who wish to expedite this process may attach a copy of their qualifying degree and transcripts (annotated with upper-division courses in mathematics, statistics, or data analytics, and/or graduate level work in statistical or quantitative analyses, credit earned, and grade received) to their on-line application at the time of filing in the Attachments section.

SELECTIVE CERTIFICATION

In accordance with Charter Section 1010(b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. For such positions, only applicants possessing one or more of the following at the time of filing may be considered for appointment.

1. Two years of full-time paid experience performing daily large scale data gathering, database administration, network communication, software programming and statistical analysis using the MV-90 xi software program.

2. Two years of full-time paid experience performing daily large scale data gathering, database management, statistical related programming and analysis using SAS, R-Project/R, or Python using PyData Stack.

3. A bachelors degree from an accredited four-year college or university with a dual major in Economics and Mathematics, or a major in Economics and a minor in Mathematics, or a major in Mathematics and a minor in Economics.

4. Certified Associate in Python Programming (PCAP) Certification.

5. Microsoft Office Specialist Access certification.

6. Microsoft Power BI Certification.

7. Oracle Business Intelligence Foundation 11g Certified Implementation Specialist Certification.

8. Python for Managers certification.

9. Python 3 Programming Certification.

10. SQL Server Certification issued by Microsoft, Oracle, or SAP.

11. Tableau Desktop Certification.

12. Tableau Server Certification.

NOTES:

Those individuals that desire to be considered for Selective Certification as described above, must respond to the Selective Certification Questionnaire at the time of filing. The Selective Certification Questionnaire is located within the Supplemental Questions section of the City application. Applicants who fail to complete the Selective Certification Questionnaire will not be considered further in selective certification.

Selective Certification 3 requires proof of bachelors degree and dual major in qualifying subjects. Applicants that desire to be considered for Selective Certification 3 must attach a copy of their qualifying degree to the on-line application at the time of filing. The degree must be attached to the on-line application BEFORE the application is submitted. If the degree is attached AFTER the on-line application has been submitted,