City of Austin, TX
Austin, TX, United States
Minimum Qualifications Graduation with a Bachelor’s degree from an accredited four (4) year college or university with major coursework in a related field, plus five (5) years of relevant experience in consultation and the utilization of BI tools. Graduation with a Master’s degree from an accredited college or university may substitute for up to two (2) years of the required experience. Licenses and Certifications Required: None. Notes to Applicants This position reports to the Austin Energy Utility Contact Center Team ( UCC ). The UCC is the primary point of contact for the City of Austin’s utility customers for move requests, billing inquiries, payment arrangements, customer disputes for services, fees, and rates. We are also Austin Energy’s contact for outage and emergency response for all citizens. The Business Intelligence Consultant, will evaluate contact center and business data from multiple data sources and conduct analysis to produce meaningful insights, identifying trends and solutions to improve business performance and customer experience. This position will design and develop recurring and ad-hoc business intelligence solutions such as reports, cubes, and dashboards that can be presented to operational teams and for executive-level review. The Business Intelligence Consultant will also work with technical teams to maintain, troubleshoot, and enhance current BI tools, systems, and software. And will closely collaborate with various teams in defining additional data sources and data storage requirements to support managerial and business intelligence needs. Working with Austin Energy provides a number of health and welfare benefits such as low-cost medical, dental, vision, paid leave time, a highly competitive retirement plan, career development opportunities and more. Please click HERE for more information. Employment Application: The City of Austin employment application is an official document; incomplete applications will not be considered. Please be sure to detail on the application all current and previous employment that you wish to be considered as part of your qualifications. The Employment Record should be complete with job titles, employment dates, job duties, functions, and responsibilities for each position held. Starting salary will be based on overall relevant experience from your application. Résumés will not be accepted and statements such as “see résumé” will not be accepted. You may use “N/A” for fields that are not applicable. Please note that Austin Energy may close the job posting at any time after 7 days from the date of the initial advertisement. Once the job posting has closed, applications cannot be changed. Assessments: Your skill level in some of the competency areas for this job may be assessed through skills testing. If you are selected as a top candidate: Verification of your education (which may include high school graduation or GED , undergraduate and/or graduate degrees) will be required. You must provide proof of education from an accredited organization/institution. If you are identified as a top candidate and are in the military or a veteran, you will need to provide a copy of your DD-214 prior to confirming a start date. This position requires a criminal background investigation. Work Schedule: Work hours may include after hours, holidays, and weekends. Shifts may change according to departmental needs. Employee may be required to work additional hours outside of regular work schedule. Travel: If you are selected for this position, and meet the Driver Safety Standards in the City of Austin Driver Safety Program, you may drive when necessary to multiple locations as part of your regular job duties. Otherwise, you are responsible for getting to and from these locations. Essential: This has been designated as an Essential Employee position. In the event of a City-designated emergency, Essential Employees provide services that impact the public health, safety, utility services, and welfare of members of the Austin community and other employees and ensure the continuity of essential operations. In such an emergency, Essential Employees may be called back in, may be required to modify their schedule, may be assigned to a City-designated work site, or may be retained on site to assist with operations and recovery. Pay Range $33.05 - $42.14 Hours Monday - Friday, 40 hours with additional hours based on business needs. The starting time can be as early as 7:00 a.m. and as late as 9:00 a.m.. Job Close Date 08/15/2024 Type of Posting External Department Austin Energy Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location 4815 Mueller Blvd. Austin, TX Preferred Qualifications Experience with SQL queries Experience with Oracle databases Experience supporting customer service and/or public sector organizations Experience with Business Intelligence tools (Power BI, Socrata, Tableau) Previous experience managing databases and workflow applications with user interfaces, including account management and troubleshooting Previous experience providing user support and training to large organizations Previous experience analyzing data, identifying trends, and delivering business intelligence Previous experience creating analytics visualizations and reports, such as dashboards and other interactive formats Expertise with database structures, data migration, and using MS access Previous experience eliciting customer requirements and implementing enhancements of workflows and layouts in technology applications Ability to travel to more than one work location Duties, Functions and Responsibilities Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned. Analyzes business and functional requirements and translates these requirements into robust, scalable, and operable solutions. Collects, analyzes, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results. Utilizes database and web application technologies to design, develop, and evaluate innovative business intelligence tools and automated reports. Designs, develops, and tests BI solutions such as databases, data warehouses, queries and views, reports, and dashboards. Performs conversions, imports, and exports of data within and between internal and external software systems. Merges BI platforms with enterprise systems and applications and documents new and existing models, solutions, and implementations. Enhances the performance of BI tools by defining data to filter and indexes. Troubleshoots BI tools, systems, and software. Troubleshoots reported data loads or reconciliation inconsistencies in conjunction with the sites for data models and/or reports. Tracks, monitors, and analyzes performance and production issues, and implements improvements. Supports and helps manage external resources, such as service providers and vendor support and participates in vendor evaluations. Maintains the quality of Metadata Repository by adding, modifying, and deleting data. Provides input to the development of data/information quality metrics. Tracks and reports on issues and enhancement requests for the business in a timely manner. Analyzes and tests new releases/versions of software. Designs and delivers end-user training and training materials. Trains users to transform data into action-oriented information and to use that information correctly. Responsibilities - Supervision and/or Leadership Exercised: May provide leadership, work assignments, evaluation, training, and guidance to others. Knowledge, Skills and Abilities Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed. Knowledge of reporting analysis, design, and programming principles as well as knowledge of multiple industry standard reporting tools such as Crystal and Business Objects. Knowledge of industry standard database systems such as MS, SQL , and Oracle. Knowledge of Software Development Life Cycle ( SDLC ) and Information Technology Infrastructure Library ( ITIL ) concepts. Knowledge of release, change, configuration, and incident management. Knowledge of industry reporting techniques and developing and maintaining interactive reports. Knowledge of relational data modeling and relational database design. Knowledge of standard industry ERP technologies such as SAP . Knowledge of business operations as well as one or more business functional areas. Skill in data analysis and data mining. Skill in identifying and solving system and application problems. Skill in coordinating work projects and providing technical assistance. Skill in preparing data structures, flowcharts, and logic flow diagrams. Skill in applying migration procedures. Skill in analyzing and meeting the data processing needs of users. Skill in working with people of varying technical abilities in a team environment. Skill in training groups on reporting standards. Skill in analyzing major system reporting problems and applying appropriate solutions. Skill in actively participating in functional unit testing, integration testing, stress testing, systems testing, and user acceptance testing. Ability to learn City specific and industry standard reporting tool sets. Ability to explain complex technical information in business terms and communicate clearly and effectively both verbally and in writing. Ability to support and work with Business Intelligence/Data Warehousing environments. Ability to establish and maintain effective working relationships with City staff and the general public. Criminal Background Investigation This position has been approved for a Criminal Background Investigation. EEO/ADA City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1. The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s AIDS , AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk. Supplemental Questions Required fields are indicated with an asterisk (*). * This position requires graduation with a Bachelor's degree from an accredited four (4) year college or university with major coursework in a related field, plus five (5) years of relevant experience in consultation and the utilization of BI tools. Graduation with a Master's degree from an accredited college or university may substitute for up to two (2) years of the required experience. Do you meet these requirements? Yes No * Please describe how you meet the minimum qualifications for this position. (Open Ended Question) * Describe your experience with SQL queries and Oracle or other databases. (Open Ended Question) * Describe your experience supporting both internal and external customers. (Open Ended Question) * Describe your experience with Business Intelligence tools (Power BI, Socrata, Tableau, MicroStrategy) (Open Ended Question) * Please describe your experience managing databases and workflow applications with user interfaces. (Open Ended Question) * Do you have previous experience providing user support and training to large organizations? Yes No * Describe your experience analyzing data, identifying trends, and delivering business intelligence (Open Ended Question) * Describe your experience creating analytics visualizations and reports, such as dashboards and other interactive formats (Open Ended Question) * Do you have expertise with database structures, data migration and using MS access Yes No * Do you have experience eliciting customer requirements and implementing enhancements of workflows and layouts in technology applications Yes No * Describe your experience creating and delivering presentations to multiple levels of management. (Open Ended Question) * Do you have the ability to travel to multiple sites as part of the regular job duties? Yes No * This position is classified as an “essential” position. The candidate must be able to work during emergencies or bad weather if they are scheduled to work and, in some cases, when they are not scheduled. Shifts may change according to departmental needs. Are you able to meet these schedule requirements? Yes No * This position requires a criminal background check. By selecting the following, you are acknowledging that you understand if you are selected as a top candidate for this position, you will need a successful CBI to be hired. I acknowledge and understand this position requires a Criminal Background Check. Optional & Required Documents Required Documents Optional Documents
Minimum Qualifications Graduation with a Bachelor’s degree from an accredited four (4) year college or university with major coursework in a related field, plus five (5) years of relevant experience in consultation and the utilization of BI tools. Graduation with a Master’s degree from an accredited college or university may substitute for up to two (2) years of the required experience. Licenses and Certifications Required: None. Notes to Applicants This position reports to the Austin Energy Utility Contact Center Team ( UCC ). The UCC is the primary point of contact for the City of Austin’s utility customers for move requests, billing inquiries, payment arrangements, customer disputes for services, fees, and rates. We are also Austin Energy’s contact for outage and emergency response for all citizens. The Business Intelligence Consultant, will evaluate contact center and business data from multiple data sources and conduct analysis to produce meaningful insights, identifying trends and solutions to improve business performance and customer experience. This position will design and develop recurring and ad-hoc business intelligence solutions such as reports, cubes, and dashboards that can be presented to operational teams and for executive-level review. The Business Intelligence Consultant will also work with technical teams to maintain, troubleshoot, and enhance current BI tools, systems, and software. And will closely collaborate with various teams in defining additional data sources and data storage requirements to support managerial and business intelligence needs. Working with Austin Energy provides a number of health and welfare benefits such as low-cost medical, dental, vision, paid leave time, a highly competitive retirement plan, career development opportunities and more. Please click HERE for more information. Employment Application: The City of Austin employment application is an official document; incomplete applications will not be considered. Please be sure to detail on the application all current and previous employment that you wish to be considered as part of your qualifications. The Employment Record should be complete with job titles, employment dates, job duties, functions, and responsibilities for each position held. Starting salary will be based on overall relevant experience from your application. Résumés will not be accepted and statements such as “see résumé” will not be accepted. You may use “N/A” for fields that are not applicable. Please note that Austin Energy may close the job posting at any time after 7 days from the date of the initial advertisement. Once the job posting has closed, applications cannot be changed. Assessments: Your skill level in some of the competency areas for this job may be assessed through skills testing. If you are selected as a top candidate: Verification of your education (which may include high school graduation or GED , undergraduate and/or graduate degrees) will be required. You must provide proof of education from an accredited organization/institution. If you are identified as a top candidate and are in the military or a veteran, you will need to provide a copy of your DD-214 prior to confirming a start date. This position requires a criminal background investigation. Work Schedule: Work hours may include after hours, holidays, and weekends. Shifts may change according to departmental needs. Employee may be required to work additional hours outside of regular work schedule. Travel: If you are selected for this position, and meet the Driver Safety Standards in the City of Austin Driver Safety Program, you may drive when necessary to multiple locations as part of your regular job duties. Otherwise, you are responsible for getting to and from these locations. Essential: This has been designated as an Essential Employee position. In the event of a City-designated emergency, Essential Employees provide services that impact the public health, safety, utility services, and welfare of members of the Austin community and other employees and ensure the continuity of essential operations. In such an emergency, Essential Employees may be called back in, may be required to modify their schedule, may be assigned to a City-designated work site, or may be retained on site to assist with operations and recovery. Pay Range $33.05 - $42.14 Hours Monday - Friday, 40 hours with additional hours based on business needs. The starting time can be as early as 7:00 a.m. and as late as 9:00 a.m.. Job Close Date 08/15/2024 Type of Posting External Department Austin Energy Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location 4815 Mueller Blvd. Austin, TX Preferred Qualifications Experience with SQL queries Experience with Oracle databases Experience supporting customer service and/or public sector organizations Experience with Business Intelligence tools (Power BI, Socrata, Tableau) Previous experience managing databases and workflow applications with user interfaces, including account management and troubleshooting Previous experience providing user support and training to large organizations Previous experience analyzing data, identifying trends, and delivering business intelligence Previous experience creating analytics visualizations and reports, such as dashboards and other interactive formats Expertise with database structures, data migration, and using MS access Previous experience eliciting customer requirements and implementing enhancements of workflows and layouts in technology applications Ability to travel to more than one work location Duties, Functions and Responsibilities Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned. Analyzes business and functional requirements and translates these requirements into robust, scalable, and operable solutions. Collects, analyzes, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results. Utilizes database and web application technologies to design, develop, and evaluate innovative business intelligence tools and automated reports. Designs, develops, and tests BI solutions such as databases, data warehouses, queries and views, reports, and dashboards. Performs conversions, imports, and exports of data within and between internal and external software systems. Merges BI platforms with enterprise systems and applications and documents new and existing models, solutions, and implementations. Enhances the performance of BI tools by defining data to filter and indexes. Troubleshoots BI tools, systems, and software. Troubleshoots reported data loads or reconciliation inconsistencies in conjunction with the sites for data models and/or reports. Tracks, monitors, and analyzes performance and production issues, and implements improvements. Supports and helps manage external resources, such as service providers and vendor support and participates in vendor evaluations. Maintains the quality of Metadata Repository by adding, modifying, and deleting data. Provides input to the development of data/information quality metrics. Tracks and reports on issues and enhancement requests for the business in a timely manner. Analyzes and tests new releases/versions of software. Designs and delivers end-user training and training materials. Trains users to transform data into action-oriented information and to use that information correctly. Responsibilities - Supervision and/or Leadership Exercised: May provide leadership, work assignments, evaluation, training, and guidance to others. Knowledge, Skills and Abilities Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed. Knowledge of reporting analysis, design, and programming principles as well as knowledge of multiple industry standard reporting tools such as Crystal and Business Objects. Knowledge of industry standard database systems such as MS, SQL , and Oracle. Knowledge of Software Development Life Cycle ( SDLC ) and Information Technology Infrastructure Library ( ITIL ) concepts. Knowledge of release, change, configuration, and incident management. Knowledge of industry reporting techniques and developing and maintaining interactive reports. Knowledge of relational data modeling and relational database design. Knowledge of standard industry ERP technologies such as SAP . Knowledge of business operations as well as one or more business functional areas. Skill in data analysis and data mining. Skill in identifying and solving system and application problems. Skill in coordinating work projects and providing technical assistance. Skill in preparing data structures, flowcharts, and logic flow diagrams. Skill in applying migration procedures. Skill in analyzing and meeting the data processing needs of users. Skill in working with people of varying technical abilities in a team environment. Skill in training groups on reporting standards. Skill in analyzing major system reporting problems and applying appropriate solutions. Skill in actively participating in functional unit testing, integration testing, stress testing, systems testing, and user acceptance testing. Ability to learn City specific and industry standard reporting tool sets. Ability to explain complex technical information in business terms and communicate clearly and effectively both verbally and in writing. Ability to support and work with Business Intelligence/Data Warehousing environments. Ability to establish and maintain effective working relationships with City staff and the general public. Criminal Background Investigation This position has been approved for a Criminal Background Investigation. EEO/ADA City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1. The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s AIDS , AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk. Supplemental Questions Required fields are indicated with an asterisk (*). * This position requires graduation with a Bachelor's degree from an accredited four (4) year college or university with major coursework in a related field, plus five (5) years of relevant experience in consultation and the utilization of BI tools. Graduation with a Master's degree from an accredited college or university may substitute for up to two (2) years of the required experience. Do you meet these requirements? Yes No * Please describe how you meet the minimum qualifications for this position. (Open Ended Question) * Describe your experience with SQL queries and Oracle or other databases. (Open Ended Question) * Describe your experience supporting both internal and external customers. (Open Ended Question) * Describe your experience with Business Intelligence tools (Power BI, Socrata, Tableau, MicroStrategy) (Open Ended Question) * Please describe your experience managing databases and workflow applications with user interfaces. (Open Ended Question) * Do you have previous experience providing user support and training to large organizations? Yes No * Describe your experience analyzing data, identifying trends, and delivering business intelligence (Open Ended Question) * Describe your experience creating analytics visualizations and reports, such as dashboards and other interactive formats (Open Ended Question) * Do you have expertise with database structures, data migration and using MS access Yes No * Do you have experience eliciting customer requirements and implementing enhancements of workflows and layouts in technology applications Yes No * Describe your experience creating and delivering presentations to multiple levels of management. (Open Ended Question) * Do you have the ability to travel to multiple sites as part of the regular job duties? Yes No * This position is classified as an “essential” position. The candidate must be able to work during emergencies or bad weather if they are scheduled to work and, in some cases, when they are not scheduled. Shifts may change according to departmental needs. Are you able to meet these schedule requirements? Yes No * This position requires a criminal background check. By selecting the following, you are acknowledging that you understand if you are selected as a top candidate for this position, you will need a successful CBI to be hired. I acknowledge and understand this position requires a Criminal Background Check. Optional & Required Documents Required Documents Optional Documents
City of Los Angeles
City Of Los Angeles, California, United States
DUTIES ANNUAL SALARY $73,789 to $107,886; $78,738 to $115,111; $85,921 to $125,614; $93,041 to $136,033; and $100,203 to $146,494 The salary in the Department of Water and Power is $100,913 to $125,342; $107,886 to $134,028; $118,055 to $146,661; $127,785 to $158,750; and $137,327 to $170,631. NOTES : Candidates from the eligible list are normally appointed to vacancies in the lower pay grade positions. 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. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf. A Programmer Analyst (Software Developer) does technically difficult programming and application or software support; analyzes existing systems and procedures; determines the feasibility of data processing applications; designs and participates in the implementation of systems of computer programs; and may act as a lead analyst or project leader in supervising technical employees who are performing such work. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor's degree from an accredited four-year college or university with completion of 24 semester or 36 quarter units in information systems, computer engineering, or computer science and two years of full-time paid experience in the analysis, design, development, testing, and implementation of software applications; or Two years of full-time paid experience as an Applications Programmer with the City of Los Angeles. Additional full-time paid programming analyst experience as described in Requirement #1 above may be substituted on a year for year basis for the required bachelor's degree. One academic year is equivalent to 30 semester or 45 quarter units. PROCESS NOTES Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met.Some positions may require a valid California driver's license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI).Experience working in one or more of the following areas is highly preferred: Internet and/or Client/Server Applications utilizing programs such as .NET Framework (C# or VB.NET); ASP.Net; PeopleSoft; PeopleTools; ColdFusion; Java; Javascript; PowerBuilder; C/C++; UDB; PL SQL for Oracle; Transact SQL for SQL Server with Oracle or SQL Server as a backend; Component Object Model (COM); HTML 5; JQuery; AJAX; DB2 as a backend; and MYSQL as a backend;Web services implementation, SOAP and different Remote Procedure Call technologies such as .NET Remoting, CORBA DCOM, JAVA RMI, and REST;GIS Programming (Autodesk or ESRI);Object-Oriented Design concepts and Object-Oriented Design patterns;Web servers such as IIS and Apache;Core Computer Programming concepts such as data structures and algorithm design;Relational Database Design concepts such a normalization and entity-relationship diagramming;Implementation of Enterprise Resource Planning (ERP) packages such as AMS Advantage Financial, SAP, PeopleSoft Financials, or Oracle Financials;Business Intelligence (BI) tools such as Cognos Crystal Reports, and Oracle OBIEE;Integrated Development Environments (IDE) such as IBM's Rational Suite or Versata Design Studio;Application Servers such as IBM's Websphere, Oracle, or TOMCAT;Mobile application development technologies such as Apache Cordova and Dojo;Content management system such as Oracle's Application Development Framework. Applicants filing under Requirement No. 1 who did not receive a degree in information systems, computer engineering, or computer science must indicate the required course information, including the course title, the number of units (semester or quarter), date completed, and the name of the school in the Supplemental Questions section of the on-line application at the time of filing. Applicants who fail to do so will not be considered further in this examination and their applications will not be processed. General education courses and elective units taken outside of the specified major/areas need not be listed. We recommend that you have your course work information with you before you go on-line to file your application.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 accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf .Applicants completing the exam process may be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree in the Attachments section of the on-line application at the time of filing. 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 certifications in one or more of the following areas. Only persons possessing the following at the time of filing may be considered for appointment to fill such positions. Selective Certifications 1 through 23 require Certificates of Completion. You must submit a Certificate of Completion for the following: Certification as a Microsoft Certified Applications Developer, Microsoft Certified Solutions Developer or Microsoft Certified Programmer.Certification as an Oracle Application Developer.Certification as a SAP Solution Consultant or SAP Development Consultant.COBOL/CIS and COBOL using z/OS.DB2: IBM Professional, DB2 (for z/OS); Database Administrator; COBOL Application Programming; IBM Application Developer; CICS Transaction Server for z/OS, IBM System Programmer; CISC Transaction Server V5.2 for z/OS; IBM Certified Application Developer; or DB2 11 for z/OS.Oracle Certified Professional, Java SE 8 Programmer; JAVA SE; JAVA EE; or Java EE Training & CertificationPower BuilderC/CC++Microsoft MCSD App Builder; or Microsoft Visual StudioAdobe ColdFusion 9HTML 5Oracle Advanced PS/SQL; Developer Certified Professional; SQL and PL/SQL Certification PathAJAXOracle People Tools; Application Developer; Certified Expert Certification; PeopleSoft Tools and TechnologySAP Certified Application Associate; Financial Accounting with SAP ERP 6.0 EHP5IBM Deployment Professional FileNet; IBM Certified Specialist; IBM Enterprise Content Management; Filenet Content, Documentum; LaserficheCrystal Reports (SAP); Oracle Business Intelligence; IBM Certified Solution Expert; Cognos BI; or Oracle BI Enterprise Edition (BI EE)jQueryCOBRAAssociate Android Developer; iOS Developer; or iOS Application DevelopmentOracle SOA Suite Certified; Implementation Specialist, Oracle AIA; or PIPHP Technical Certified I - Exstream Software - Design and ProductionOracle Business Intelligence Foundation Suite Certified Implementation Specialist; or Oracle BI PublisherMicrosoft MCSA: SQL Server Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s). Applicants who fail to submit the certificate(s) at the time of filing by not attaching it to the on-line application will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed below: Friday, February 16, 2024 to Thursday, February 29, 2024 Friday, May 17, 2024 to Thursday, May 30, 2024 Additional filing periods may be added based on the City’s hiring needs. The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the weighted multiple-choice test in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weight: Multiple-Choice Test: 100% The examination will consist entirely of a weighted multiple-choice test administered and proctored on-line. In the on-line multiple-choice test the following competencies may be evaluated: Analytical Ability; Attention to Detail; Customer Service; Teamwork; Follow Written Directions; Job Knowledge, including knowledge of: database and programming languages such as C#, C++, HTML5, Java, Javascript, VB, Coldfusion , PHP, .NET, Pearl, mobile programming languages, SQL queries, stored procedures, triggers, views, and big data tools; the systems development life cycle (SDLC) and the required documentation; technical design and documentation such as data modeling, database, flowcharts and diagrams; database platforms and structures such as Oracle, SQL, DB2, big data infrastructures, relational, hierarchical, and object-oriented; and other necessary skills, knowledge and abilities. The multiple-choice test will be proctored and administered on-line during a single session. Candidates invited to participate in the on-line multiple-choice test will be able to take the test from a remote location (i.e., their home) using a computer with a webcam and a reliable internet connection. Candidates will receive an e-mail from the City of Los Angeles outlining the dates and specific steps on how to take the multiple-choice test on-line. Candidates who do not complete and submit the multiple-choice test on-line using a computer by the specified date and time will not be considered further in this examination. Additional test dates may be added as needed. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Programmer Analyst (Software Developer). For candidates who apply between February 16, 2024 and February 29, 2024 , it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, APRIL 16, 2024 AND MONDAY, APRIL 22, 2024 . For candidates who apply between May 17, 2024 and May 30, 2024 , it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, JULY 16, 2024 AND MONDAY, JULY 22, 2024. FAQs for on-line testing are available at https://per.lacity.org/faqs/employment-testing-process.html . Due to COVID-19 and social distancing requirements, only candidates who demonstrate a hardship may be offered the option to take the multiple-choice test onsite at a City facility. NOTES : This examination is based on a validation study and as provided by Civil Service Commission Rule 4.20, the multiple-choice test will not be subject to candidate inspection.As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf. Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin.A final average score of 70% or higher is required to be placed on the eligible list.In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates.The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates.You may take the Programmer Analyst (Software Developer) multiple-choice test only once every 24 months under this bulletin. Your name may be removed from the open competitive list after six (6) months.Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list.In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22 and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list.For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position . All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous
DUTIES ANNUAL SALARY $73,789 to $107,886; $78,738 to $115,111; $85,921 to $125,614; $93,041 to $136,033; and $100,203 to $146,494 The salary in the Department of Water and Power is $100,913 to $125,342; $107,886 to $134,028; $118,055 to $146,661; $127,785 to $158,750; and $137,327 to $170,631. NOTES : Candidates from the eligible list are normally appointed to vacancies in the lower pay grade positions. 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. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf. A Programmer Analyst (Software Developer) does technically difficult programming and application or software support; analyzes existing systems and procedures; determines the feasibility of data processing applications; designs and participates in the implementation of systems of computer programs; and may act as a lead analyst or project leader in supervising technical employees who are performing such work. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor's degree from an accredited four-year college or university with completion of 24 semester or 36 quarter units in information systems, computer engineering, or computer science and two years of full-time paid experience in the analysis, design, development, testing, and implementation of software applications; or Two years of full-time paid experience as an Applications Programmer with the City of Los Angeles. Additional full-time paid programming analyst experience as described in Requirement #1 above may be substituted on a year for year basis for the required bachelor's degree. One academic year is equivalent to 30 semester or 45 quarter units. PROCESS NOTES Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met.Some positions may require a valid California driver's license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI).Experience working in one or more of the following areas is highly preferred: Internet and/or Client/Server Applications utilizing programs such as .NET Framework (C# or VB.NET); ASP.Net; PeopleSoft; PeopleTools; ColdFusion; Java; Javascript; PowerBuilder; C/C++; UDB; PL SQL for Oracle; Transact SQL for SQL Server with Oracle or SQL Server as a backend; Component Object Model (COM); HTML 5; JQuery; AJAX; DB2 as a backend; and MYSQL as a backend;Web services implementation, SOAP and different Remote Procedure Call technologies such as .NET Remoting, CORBA DCOM, JAVA RMI, and REST;GIS Programming (Autodesk or ESRI);Object-Oriented Design concepts and Object-Oriented Design patterns;Web servers such as IIS and Apache;Core Computer Programming concepts such as data structures and algorithm design;Relational Database Design concepts such a normalization and entity-relationship diagramming;Implementation of Enterprise Resource Planning (ERP) packages such as AMS Advantage Financial, SAP, PeopleSoft Financials, or Oracle Financials;Business Intelligence (BI) tools such as Cognos Crystal Reports, and Oracle OBIEE;Integrated Development Environments (IDE) such as IBM's Rational Suite or Versata Design Studio;Application Servers such as IBM's Websphere, Oracle, or TOMCAT;Mobile application development technologies such as Apache Cordova and Dojo;Content management system such as Oracle's Application Development Framework. Applicants filing under Requirement No. 1 who did not receive a degree in information systems, computer engineering, or computer science must indicate the required course information, including the course title, the number of units (semester or quarter), date completed, and the name of the school in the Supplemental Questions section of the on-line application at the time of filing. Applicants who fail to do so will not be considered further in this examination and their applications will not be processed. General education courses and elective units taken outside of the specified major/areas need not be listed. We recommend that you have your course work information with you before you go on-line to file your application.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 accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf .Applicants completing the exam process may be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree in the Attachments section of the on-line application at the time of filing. 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 certifications in one or more of the following areas. Only persons possessing the following at the time of filing may be considered for appointment to fill such positions. Selective Certifications 1 through 23 require Certificates of Completion. You must submit a Certificate of Completion for the following: Certification as a Microsoft Certified Applications Developer, Microsoft Certified Solutions Developer or Microsoft Certified Programmer.Certification as an Oracle Application Developer.Certification as a SAP Solution Consultant or SAP Development Consultant.COBOL/CIS and COBOL using z/OS.DB2: IBM Professional, DB2 (for z/OS); Database Administrator; COBOL Application Programming; IBM Application Developer; CICS Transaction Server for z/OS, IBM System Programmer; CISC Transaction Server V5.2 for z/OS; IBM Certified Application Developer; or DB2 11 for z/OS.Oracle Certified Professional, Java SE 8 Programmer; JAVA SE; JAVA EE; or Java EE Training & CertificationPower BuilderC/CC++Microsoft MCSD App Builder; or Microsoft Visual StudioAdobe ColdFusion 9HTML 5Oracle Advanced PS/SQL; Developer Certified Professional; SQL and PL/SQL Certification PathAJAXOracle People Tools; Application Developer; Certified Expert Certification; PeopleSoft Tools and TechnologySAP Certified Application Associate; Financial Accounting with SAP ERP 6.0 EHP5IBM Deployment Professional FileNet; IBM Certified Specialist; IBM Enterprise Content Management; Filenet Content, Documentum; LaserficheCrystal Reports (SAP); Oracle Business Intelligence; IBM Certified Solution Expert; Cognos BI; or Oracle BI Enterprise Edition (BI EE)jQueryCOBRAAssociate Android Developer; iOS Developer; or iOS Application DevelopmentOracle SOA Suite Certified; Implementation Specialist, Oracle AIA; or PIPHP Technical Certified I - Exstream Software - Design and ProductionOracle Business Intelligence Foundation Suite Certified Implementation Specialist; or Oracle BI PublisherMicrosoft MCSA: SQL Server Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s). Applicants who fail to submit the certificate(s) at the time of filing by not attaching it to the on-line application will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed below: Friday, February 16, 2024 to Thursday, February 29, 2024 Friday, May 17, 2024 to Thursday, May 30, 2024 Additional filing periods may be added based on the City’s hiring needs. The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the weighted multiple-choice test in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weight: Multiple-Choice Test: 100% The examination will consist entirely of a weighted multiple-choice test administered and proctored on-line. In the on-line multiple-choice test the following competencies may be evaluated: Analytical Ability; Attention to Detail; Customer Service; Teamwork; Follow Written Directions; Job Knowledge, including knowledge of: database and programming languages such as C#, C++, HTML5, Java, Javascript, VB, Coldfusion , PHP, .NET, Pearl, mobile programming languages, SQL queries, stored procedures, triggers, views, and big data tools; the systems development life cycle (SDLC) and the required documentation; technical design and documentation such as data modeling, database, flowcharts and diagrams; database platforms and structures such as Oracle, SQL, DB2, big data infrastructures, relational, hierarchical, and object-oriented; and other necessary skills, knowledge and abilities. The multiple-choice test will be proctored and administered on-line during a single session. Candidates invited to participate in the on-line multiple-choice test will be able to take the test from a remote location (i.e., their home) using a computer with a webcam and a reliable internet connection. Candidates will receive an e-mail from the City of Los Angeles outlining the dates and specific steps on how to take the multiple-choice test on-line. Candidates who do not complete and submit the multiple-choice test on-line using a computer by the specified date and time will not be considered further in this examination. Additional test dates may be added as needed. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Programmer Analyst (Software Developer). For candidates who apply between February 16, 2024 and February 29, 2024 , it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, APRIL 16, 2024 AND MONDAY, APRIL 22, 2024 . For candidates who apply between May 17, 2024 and May 30, 2024 , it is anticipated that the on-line multiple-choice test will be administered between TUESDAY, JULY 16, 2024 AND MONDAY, JULY 22, 2024. FAQs for on-line testing are available at https://per.lacity.org/faqs/employment-testing-process.html . Due to COVID-19 and social distancing requirements, only candidates who demonstrate a hardship may be offered the option to take the multiple-choice test onsite at a City facility. NOTES : This examination is based on a validation study and as provided by Civil Service Commission Rule 4.20, the multiple-choice test will not be subject to candidate inspection.As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf. Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin.A final average score of 70% or higher is required to be placed on the eligible list.In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates.The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates.You may take the Programmer Analyst (Software Developer) multiple-choice test only once every 24 months under this bulletin. Your name may be removed from the open competitive list after six (6) months.Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list.In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22 and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list.For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position . All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous