Senior IT Software Developer - Metropolitan Water District - La Verne, 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.6 billion gallons per day, nine surface water reservoirs, 800 miles of pipeline, and 16 hydroelectric power plants.
DESCRIPTION
SENIOR INFORMATION TECHNOLOGY SOFTWARE DEVELOPER
The Business Technology Group, Information Technology Section, has (1) opening for a Senior Information Technology Software Developer available within the Enterprise Water Systems Unit located in La Verne, California.
JOB SUMMARY
The IT Senior Software Developer specializing in Laboratory Information Management System (LIMS) business domain will support, administer, maintain, upgrade and tune MWD's LIMS suite of applications. LIMS suite of applications are written in MS VB.Net and C#, and Thermo Nautilus with an Oracle backend for transactional and data warehouse software. This position supports the end-to-end processing of sampling and analysis information throughout the MWD water distribution system including sample scheduling, collection, analysis, results documentation and data warehousing, reporting requirements, and tracking to ensure the business needs and regulatory requirements are met. The primary role of this position is to provide IT platform support for the Laboratory business community in testing and reporting to ensure that MWD complies with regulatory requirements to meet water quality objectives. LIMS annually manages over 45,000 unique water samples collected at MWD's water source, treatment, and distribution facilities for operational monitoring, regulatory compliance, and research projects. Over 75,000 chemical, microbiological, and physical tests are performed on these samples annually, with over 300,000 unique results measured and archived in databases for reporting purposes.
This position will provide system administrative support in the following areas:
-LIMS application maintenance
-LIMS application development, including documentation and training
-LIMS database
-LIMS programming
-System upgrades
-Operate water quality instrumentation interface
-Set-up database connections
-Interface with water quality instruments
-Set-up data upload to LIMS
-User support
-First-line user support
-Sample scheduling
-User-level application configuration
-Bar code printing
-Background processing
-Create user documentation
-Perform user training
-LIMS stakeholder group
-Define business strategy for LIMS
-Define lab automation projects
JOB FUNCTIONS
1. Defines, designs, develops, and deploys new or modified custom software that generates reports and sub reports accessing multiple data bases.
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. Performs other related Application Software Developer job duties as required.
Work Schedule: 10 hours per day, 4 days a week, Monday through Thursday
EMPLOYMENT STANDARDS
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 Master's degree from an accredited college or university in a related field and four years of relevant experience.
Required Knowledge of: Reporting tools concepts and tool specific functions; relational database; Relational Data Base - Data Definition Language create tables, indexes, views; Unified Modeling Language Concepts; Object Oriented Concepts; reporting tools functions; relational data base objects: triggers, stored procedures and packages; coding data base query statements; instantiate Object Oriented classes extending HTTP protocol; 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; code and implement middle tier classes and interfaces; multi-threaded and collection of objects processing; dynamic reporting applications using incoming parameters; designee, code, test and deploy relational data base objects: Data base security, firewall technologies, roles and user privileges; web services technology; 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; instantiate existing Object Oriented classes; invoke business logic objects from Graphic User Interface objects; 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.
CERTIFICATIONS, LICENSES, AND REGISTRATION REQUIREMENTS
Employees in this position are required to obtain and maintain the following certifications, licensing and registrations:
Certificates
* None
Licenses
* None
Registrations
* None
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.
Vision Requirements: No special vision requirements.
JOB RELATED SELECTION CRITERIA:
40% Technical Knowledge of:
Water Quality Laboratory Business Domain
40% Technical Expertise of:
Coding in MS.Net Visual Basic, C# Software, Data warehouse, and object oriented concepts
10% Customer Support
10% Team work
Benefits:
* Competitive compensation
* Excellent Medical, Dental, Life, Vision, Retirement plans including Pension plan and 401K (with matching employer contribution), tuition reimbursement, paid holidays, and more
* Training and advancement opportunities
* Excellent working environment
CLOSING
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].
Reasonable accommodation for people with disabilities may be requested by calling (213) 217-7738 at least 5 working days in advance of the scheduled examination date(s).
MWD is a Federal and State EO employer - Veterans/Disabled and other protected categories.
JOB REQUIREMENTS:
To apply for this position, please copy and paste the following link into your browser address bar:
http://mwdh2o.contacthr.com/38313832
.jpg)