The Metropolitan Water District of Southern California

Job Details

Job Summary


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 warehouse; 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 warehouse.

1. 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.

2. Reviews deliverables, provides technical advice, and makes recommendations.

3. Defines, designs, develops, and deploys new or modified custom software, programming language, and structured query language for relational databases.

4. Acts as Project Manager; plans, coordinates, and conducts projects within area of responsibility, including monitoring scope, quality, budget, and schedule.

5. Performs other related Application Software Developer job duties as required.

WORK SCHEDULE: Monday – Friday, 9/80 (Alternate Friday’s Off)

• 40% Technical Knowledge
• 20% Written Test (Communication and Technical questions)
• 20% Analytical
• 10% Customer Service
• 10% Job Preparation

Job Requirements

Education and Experience: Bachelor’s degree from an accredited college or university in a related field and six years of relevant experience; or Master’s degree from an accredited college or university in a related field and four years of relevant experience.

Relevant Experience is defined as: designing data warehouse using Cognos or other BI tools

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 that allows you to drive in the course of your employment

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.

Vision Requirements: No special vision requirements.


• Competitive compensation
• Excellent medical, dental, life, vision and retirement plans, including pension plan and 401k (with matching contribution), tuition reimbursement, and more
• Training and advancement opportunities
• On-site fitness center
• Excellent working environment
• Hub of public transportation: rail, subway, buses, and taxis
• Public transportation reimbursements and van pools

For more information on MWD benefits, please use the following link:

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

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

MWD is a Federal and State EO employer – Veterans/Disabled and other protected categories

Who We Are About Your Water In The Community Doing Business With Us Careers Newsroom