Previous Job
Data modelling
Ref No.: 17-29729
Location: Carlsbad, California

ThermoFisher Scientific is seeking a Data Modeler/ Analyst located at Carlsbad, CA to work with the BI team on variety of new development and/or enhancement projects to build the enterprise level data warehouse system, which is backed by Oracle Exadata database (11g or later), Informatica ETL tools set and Cognos Reporting. Responsibilities • Participate in requirements definition, analysis and the design of logical and physical data models • Leading data discovery discussions with Business in JAD sessions and map the business requirements to logical and physical modeling solutions. • Conduct data model reviews with project team members • Capture technical metadata through data modeling tools • Code standard Informatica ETL routines • Develop standard Cognos Reports • Collaborate with ETL teams to create data landing and staging structures as well as source to target mapping documents • Ensure data warehouse database designs efficiently support BI and end user requirements • Collaborate with application and services teams to design databases and interfaces which fully meet business and technical requirements • Maintain expertise and proficiency in the various application areas • Maintain current knowledge of industry trends and standards Required Skills • Strong data analysis and data profiling skills • Strong Conceptual, Logical and Physical data modeling for VLDB Data warehouse • Hands on experience with modeling tool such as ERWIN or another industry standard tool • Exposure to ETL tool Informatica or other industry leading tools • Exposure to Cognos Reporting tool or other industry leading tools • Fluent in both normalized and dimensional model disciplines and techniques • Minimum of 3 years' experience in Oracle Database (11g or above). • Bachelorâ€TMs degree in software engineering, computer science or information systems (or equivalent experience) • Effective oral and written communication skills • Ability to learn and maintain knowledge of multiple application areas • Self-motivated, responsible, conscientious, and detail oriented • Ability to follow and inform priorities and timelines • Ability to work independently and in conjunction with a team • Understanding of industry best practices pertaining to Quality Assurance concepts and procedures