Senior IT Software Developer (Business Intelligence/Cognos) - Metropolitan Water District - Los Angeles, CA - EXPIRED
This is an archive of an expired job.
Job Information:
Company: Metropolitan Water District
The Metropolitan Water District of Southern California is a consortium of twenty-six cities and water districts that provides drinking water to nearly 19 million people in Southern California. Metropolitanís mission is to provide its service area with adequate and reliable supplies of high quality water to meet current and future needs in an environmentally and economically responsible way. Metropolitanís facilities include the 242-mile Colorado River Aqueduct, five conventional water treatment plants with a combined capacity of 2.3 billion gallons per day, nine surface water reservoirs, 800 miles of pipeline, and 16 hydroelectric power plants. SENIOR IT SOFTWARE DEVELOPER (Business Intelligence/Cognos)
Metropolitanís Information Technology Section has one (1) opening for a Senior IT Software Developer available at its Headquarters in Los Angeles, California.
As a Senior IT Software Developer you will be responsible for architecting and developing business intelligence (BI) solutions using IBM Cognos, IBM DataStage, and Oracle database in accordance with enterprise standards and user requirements. Areas of responsibility include partnering with business users to identify and maximize opportunities to utilize data warehouse to improve business processes; evaluating, planning, designing, and implementing new data marts and data warehouses; delivering insightful, consumable, and actionable reports, scorecards, dashboards, metadata or semantic modeling (cubes), and analytical outputs to improve business performance; ensuring reliability, consistency and availability of data warehouses.
JOB DUTIES
1. Defines, designs, develops, and deploys new or modified custom software that generates reports and sub reports accessing multiple databases.
2. Defines, designs, develops, and deploys new or modified custom software, programming language, and structured query language for relational databases.
3. Reviews deliverables, provides technical advice, and makes recommendations.
4. Defines, designs, develops, and deploys new or modified data marts for specific business domains, Extraction Transformation Load scripts, and Business Intelligence dashboards. Optimizes and tunes new or modified data marts.
5. Acts as Project Manager; plans, coordinates, and conducts projects within area of responsibility, including monitoring scope, quality, budget, and schedule.
6. Performs other related Application Software Developer job duties as required. JOB REQUIREMENTS: MINIMUM QUALIFICATIONS
Education and Experience: Bachelorís degree from an accredited college or university in a related field and six years of relevant experience; or a Masterís degree from an accredited college or university in a related field and four years of relevant experience.
Relevant Experience is defined as: a combination of experience (6 years with a Bachelorís degree/4 years with a Masterís degree) designing data warehouses using Cognos or other BI tools. A Minimum of 2 years of experience with Cognos is required.
Required Knowledge of: Reporting tools concepts and tool specific functions; relational database; Relational Data Base - Data Definition Language create tables, indexes, views; reporting tools functions; relational data base objects: triggers, stored procedures and packages; coding data base query statements; reports, sub-reports and advanced reporting functions and stored procedure calls; design, code, test and deploy relational database sub queries, out joins, unions, cursors and exception handling; Data warehouse star schema, dimensions, fact table. Data warehouse data management tools; Extraction Transformation Load processors; Business intelligence dash boarding; Data warehouse tuning and establish the most efficient dimensions, fact table and Extraction Transformation Load processes for high system availability; and current office technology and equipment.
Required Skills and Abilities to: Tune reports process, anticipate potential performance problems, determine and implement solutions; tune relational data base applications, integrate multi data base schemas, and provide technical advice; tune and enhance distributed software applications; integrate transactional data with data warehouse for strategic planning applications; produce reports, understand reporting tools and access vendor site; work with relational database triggers, stored procedures, cursors and referential integrity objects; access relational database vendor web tutorials and training documentation; provide strategic and tactical planning for enterprise information systems; develop prototypes; perform data warehouse tuning and consolidation of multiple data marts into an Enterprise Data warehouse; use independent judgment and exercise discretion; problem solve; prioritize and multi- task; communicate clearly and concisely, both verbally and in writing; establish and maintain effective working relationships with those contacted in the course of work; work independently and in a team environment; lead and train; and operate current office equipment including computers and supporting applications.
License Required: Valid California Class C Driver License or equivalent that allows you to drive in the course of your employment is required at the time of application.
PHYSICAL DEMANDS, WORK ENVIRONMENT, AND VISION REQUIREMENTS
The physical demands and work environment characteristics described here are representative of those that must be met or may be encountered by an employee to successfully perform the job duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the job duties.
Physical Demands: The work is sedentary. Typically, the employee may sit comfortably to do the work. However, there may be some walking; standing; bending; carrying of light items such as paper, books, or small parts; driving an automobile, etc. No special physical demands are required to perform the work.
Work Environment: The work environment involves everyday risks or discomforts that require normal safety precautions typical of such places as offices, meeting and training rooms, libraries, and residences or commercial vehicles, e.g., use of safe work practices with office equipment, avoidance of trips and falls, observance of fire regulations and traffic signals, etc. The work area is adequately lighted, heated, and ventilated.
Work Schedule: 9/80, Monday ñ Friday with alternate Fridays off
JOB SELECTION CRITERIA
- 40% Technical Knowledge (Data warehouse concepts, ETL process, BI Reports and dashboards)
- 20% Written Test (Communication and Technical questions)
- 20% Analytical
- 10% Customer Service
- 10% Job Preparation
100% Total Benefits:
- Competitive compensation
- Excellent medical, dental, life, vision
- Retirement plans, including pension plan and 401k
- Tuition reimbursement
- Training and advancement opportunities
- Excellent working environment
- Public transportation reimbursements and van pools
For more information on MWD benefits, please use the following link: http://www.mwdh2o.com/PDF_Careers/benefits.pdf
This job announcement has been designed to indicate the general nature and level of work being performed by employees in this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job. To receive a copy of the complete job description, please send an email to [email protected].
The Metropolitan Water District of Southern California is committed to providing reasonable accommodations to qualified individuals with disabilities. Qualified individuals with disabilities, who need a reasonable accommodation during the application or selection process, please call (213) 217-7738 or email [email protected].
MWD is a Federal and State EO employer - Veterans/Disabled and other protected categories. To apply for this position, please copy and paste the following link into your browser address bar: https://mwdh2o.contacthr.com/63739172
.jpg)