1 Attachment 2
RESOLUTION NO. ____________
A RESOLUTION OF THE COUNCIL OF THE CITY OF
BURBANK APPROVING THE ESTABLISHMENT OF THE
SALARY AND CONFLICT OF INTEREST CODE
DESIGNATION FOR THE CLASSIFICATION OF LEAD
DATA ENGINEER
THE COUNCIL OF THE CITY OF BURBANK RESOLVES:
1. The Position Classification, adopted by Resolution No. 9240 on the 16 th day
of June, 1953, as amended, is further amended by the addition thereto of the classification of Lead Data Engineer. This classification is added with a title and speci fication as set forth in Exhibit A, and a bi-weekly salary as follows:
CTC Barg. Code Job Series Grade Step 1 Step 14 0043 M Info Sys M.1313 $4,326.62 $5,689.51
2. After review and consultation by the Management Services Department, City Clerk’s Office and the Office of the City Attorney, it has been determined that this classification is a Designated Position as defined in the City’s Conflict of Interest Code and shall be required to file a form 700 St atement of Economic Interests as required by Government Code § 81000 et seq. and shall be required to report in disclosure categories 1, 3, 5, and 6.
3. The Financial Services Director is authorized to make such revisions, changes in summaries, fund totals, grand totals, and other portions of the budget document as necessary to reflect and implement the terms and provisions of this resolution.
PASSED and ADOPTED this ___ day of July, 2022.
__________________________
Jess A. Talamantes
Mayor
Approved as to Form:
Attest: Office of the City Attorney
____________________________ By: _______________________ Zizette Mullins, MMC, City Clerk Joseph H. McDougall City Attorney
2 STATE OF CALIFORNIA )
COUNTY OF LOS ANGELES ) ss.
CITY OF BURBANK )
I, Zizette Mullins, MMC, City Clerk of the City of Burbank, do hereby certify that the foregoing Resolution was duly and regularly passed and adopted by a vote of the Council of the City of Burbank at its regular meeting held on the ___ day of July, 2022, by the following vote:
AYES:
NOES:
ABSENT:
____________________________
Zizette Mullins, MMC, City Clerk
3 Exhibit A
Resolution for the Classification of Lead Data Engineer
CITY OF BURBANK
LEAD DATA ENGINEER
DEFINITION
Under direction, to act as a hands-on technical team lead on data and analytics’ initiatives for the City’s digital business mission; to analyze, design, create, deploy, and manage the organization's data architecture, data pipeline strategy, and data related programs; and perform related work as required.
ESSENTIAL FUNCTIONS
Designs, creates, deploys, and leads the organization's enterprise data architecture, employing subject matter expertise and relevant technology tools and solutions; functions as a business liaison in operationalizing data and analytics on behalf of business stakeholders; administers databases for commercial off -the-shelf (COTS) applications; serves as a technical lead for key business stakeholders, information technology (IT) experts, and subject matter experts to plan and deliver optimal analytics and data science solutions for the organization; writes documentation, uses statistical methods, and develops statistical models; analyzes data needs of the organization; participates in the formulation of data related strategies, policies, and procedures; performs data warehouse administration; designs and supports shared data resources; ensures accuracy and completeness of data in master files and utilizes data tools; establishes and maintains security and integrity controls including data backup/recovery specif ications; monitors and resolves data related problems; performs validation checks; automates and optimizes data pipelines, data flows, and data consumption with structured and unstructured data from different sources; builds processes supporting data transformation, data structures, metadata, and data stores; integrates data managed by heterogeneous systems, as well as any applications using or processing that data; supports data scientists, developers, business analysts, and database administrators in prov iding optimal data technology solutions; organizes data at a macro and micro level; addresses data infrastructure issues relating to velocity, variety, and volume of data; develops a logical data model as a standard for consuming applications; maps systems and interfaces used to manage data; sets standards for data management; analyzes the current state and conceives desired future state, and conceives projects needed to address deficiencies between the current state and future goals; participates in working groups and advisory committees related to data and database administration for innovative and proof of concept solutions; collaborates organization wide to build and deliver analytic tools for users, stakeholders, and staff to provide actionable insight into the use of data, business performance metrics, and other relevant business objectives; ensures compliance and governance in data use; integrates data architecture with business processes amongst cross functional business areas aligning with overall data architecture; builds, optimizes, and manages reusable data pipelines and data analytics solutions through successful production deployment;
4 supervises, trains, and evaluates employees; makes effective recommendations regarding hiring, promotions, transfers, and disciplinary action as needed up to and including termination; drives on City business.
MINIMUM QUALIFICATIONS
Employment Standards:
• Knowledge of – principles, practices, and techniques of computer programming, systems design, computer operating systems, statistics, and procedures; any combination of programming languages such as Python, Java, C Sharp (C#), R, Structured Query Language (SQL), and Procedural Language extensions to SQL (PL/SQL); various database management systems , data modeling techniques, data warehousing techniques, concepts, practices, and procedures of data collection, modification, and analytical practices of performing various complex data interpretation and integration using application programming interfaces; principles and practices of sound personnel management and supervision; spelling, grammar, and punctuation.
• Skill in – designing, developing, scripting, extracting, transforming, and modeling data; working with structured and unstructured data, to inc lude utilizing large data sets; statistics, predictive modeling, and optimization; operating modern computers and related software; creating scalable systems.
• Ability to – lead, initiate, evaluate, supervise, and govern projects aligning the enterprise ar chitecture to achieve project specific objectives; astutely operate in a large organization emphasizing design, governance, methodology, and modeling; articulate and persuade; be highly creative and collaborative; apply data concepts and techniques and recommend changes to meet future requirements; work with staff to resolve technical and operational problems and recommend solutions; communicate effectively, both orally and in writing perform assigned tasks quickly and accurately; follow oral and written di rections; write clear and accurate data and system documentation; establish and maintain effective working relationships with supervisors, fellow employees, and the public.
Education/Training: Any combination of education and/or experience that has provided the knowledge, skills, and abilities necessary for acceptable job performance as determined by the City. Example combination includes, but is not limited to graduation from an accredited college or university with a bachelor’s degree in computer scienc e or a closely related field and five years of hands -on experience in software engineering, database administration, data warehousing, data science, or application programming.
License & Certificates: A valid California Class “C” driver’s license or equivalent at time of appointment; a current industry -recognized certification in Data Science or Data Analytics (to be determined at the time of recruitment) may be required at the time of appointment. All required licenses and certificates must be maintained throughout employment in this classification.
SUPPLEMENTAL INFORMATION
None.