- Microsoft SQL Server
- Driver's License
The City of Fort Lauderdale community builders possess a passion for public service demonstrated by a high degree of enthusiasm, self-reliance, and job proficiency. They effectively convey the vision and mission of the organization and provide excellent service and satisfaction to our internal and external customers. We Build Community, in a fast-paced organization that operates by vision, strategy, and action. Would you fit in? Apply now.
The Data Warehouse Analyst ensures that Business Intelligence systems and processes are in place to develop accurate and timely insights, support strategic analytic initiatives and develop the City's analytics capabilities. Works with internal stakeholders to understand their business information needs, gather requirements, design, build, implement, test and maintain BI solutions. Develop citywide BI information strategy and technology roadmap.
This is highly responsible professional and technical work of more than average difficulty in the analysis, development, implementation and maintenance of data warehousing technology, including collaboration with business units to analyze and define program requirements.
An employee in this class is responsible for performing complex data warehouse architecture, design, population and maintenance, writing technical user documentation and providing training, and designing and writing user reports. Incumbents must work effectively with City customer departments to learn organizational functions and to ensure the accuracy of data warehouse information.
Under direction, an employee in this class is required to exercise considerable initiative and independent judgment in the creation, implementation and use of data warehousing technology. Advice and assistance are available in handling more complex matters. Work is reviewed through personal conferences, analysis of written reports, and the quality and accuracy of the data warehouses.
ESSENTIAL JOB FUNCTIONS
Essential functions are the basic job duties that an employee must be able to perform, with or without reasonable accommodation. The list of essential functions, as outlined herein, is intended to be representative of the tasks performed within this classification. The omission of a function does not preclude management from assigning essential duties not listed herein if such duties relate to the position.
Performs complex data warehouse architecture and design
Works with database management systems including access via Open Database Connectivity (ODBC), Structured Query Language (SQL), Stored Procedures
Works with data warehouse design techniques utilizing SQL-based databases such as Oracle or Microsoft (MS) SQL Server
Works with multiple operating systems including current versions of Windows (desktop and server), UNIX and Linux and network and application file transfer protocols
Determines user requirements for data extract and design and writes reports, analysis and verifies data extracts for accuracy
Performs research, analysis, planning and implementation of information systems technology
Plans, manages, prioritizes and implements complex technology plan projects
Coordinates with outside vendors and City department personnel to ensure projects are completed in accordance within schedule and scope
Provides data warehouse architecture, design, population and maintenance
Works with vendors on problems and upgrades to data warehouses
Works with City enterprise applications such as financial, payroll, human resources, building permits and billing activities
Provides primary support for Payroll Projections for the Budget Office
Establishes and maintains effective working relationships with City officials and employees, vendor representatives, and the general public
Performs related work as required
NOTE: The duties of this position will include all of those duties set forth in the official job description.
This position will remain open until a sufficient number of qualifying applications have been received.
The City offers a wide variety of benefits to their employees. In addition to the competitive benefits package and salary, the City offers 401(a) participation with a 9% City contribution and no employee match!!
Say "Hello" to the City of Fort Lauderdale and Say "Goodbye" to Your Student Loan!
That's right! Under the U.S. Department of Education's Public Service Loan Forgiveness (PSLF) program, the remaining balance on your student loan may be forgiven after you have made 120 qualifying monthly payments while working full-time at the City of Fort Lauderdale! Please visit www.fortlauderdale.gov/PublicServiceLoanForgiveness for more information or to see if you qualify.
This job classification is in Management Category III for benefits purposes.
This job classification is included within the bargaining unit represented by Federation of Public Employees and therefore is subject to the terms and conditions of the Collective Bargaining Agreement between the City of Fort Lauderdale and Federation of Public Employees.
Bachelor's Degree in computer science, information systems, or a closely related field, and at least three (3) years of experience in database design, data warehouse design, report writing, Structured Query Language (SQL) design and query writing. Additional qualifying experience or completion of coursework at an accredited college or university in a job-related field, may substitute on a year-for-year basis for the required experience or education, at the Division Manager's discretion.
Possess or be able to obtain a State of Florida driver's license.
THE EXAMINATION AND HOW TO APPLY:
Depending on the number of applicants and the quality of their education and experience, the examination may consist of one or more of the following tests: Evaluation of Training and Experience, Oral Interview, Written Examination, or other assessment method. Applicants must attain a minimum score of 70 in each part of the examination in order to qualify. All successful applicants may be required to take a medical examination and/or pass a drug screening prior to appointment.
An eligible veteran who enters an open-competitive examination shall receive preference points added to the total passing score earned in the examination as provided for in the Florida Statutes. To obtain veteran's preference, candidates MUST submit a copy of separation papers and the City of Fort Lauderdale's veteran's preference claim form (J204) at time of application.