Cedars-Sinai EIS Senior Data Warehouse Architect\Prog in Los Angeles, California

The architect\programmer will be responsible for data warehouse architecture tied to operational and analytical data stores. This may include modifying the ODS, Data Warehouse model design, or data load process. This position interfaces with business stakeholders and business analysts to gather DW requirements and translate business requirements into data warehouse design.

The candidate must have prior history with Oracle PL/SQL, dimensional models via a star schema approach, solid troubleshooting & analytical skills, and proven SQL query capability. Epic Clarity knowledge and/or Embarcadero ER/Studio is a plus; knowledge of healthcare terminology is essential.

Educational Requirements:

Bachelor’s degree in Computer Science or related field and five years work related experience in the Data Warehouse field; OR Ten years work related experience in the Data Warehouse field.

Experience:

•At least three years of experience working in the Healthcare industry preferred

•At least five years of experience with Oracle PL/SQL programming.

•At least three years recent experience working with nix or Linux server.

•Must have a thorough knowledge of Oracle Database

•Three years of experience working with Embarcadero modeling tools, preferred.

•Knowledge of development life-cycle and production environment procedures.

•Must have good communication, analytical, and organizational skills: both written and verbal.

•Proficient on writing and maintaining SQL Code.

Licenses/Certifications: N/A

Cedars-Sinai is an EEO employer. Cedars-Sinai does not unlawfully discriminate on the basis of the race, religion, color, national origin, citizenship, ancestry, physical or mental disability, legally protected medical condition (cancer-related or genetic characteristics or any genetic information), marital status, sex, gender, sexual orientation, gender identity, gender expression, pregnancy, age (40 or older), military and/or veteran status or any other basis protected by federal or state law.