Business Intelligence Engineer 2

Employer: The Leland Stanford Jr University

Job Location: 505 Broadway, Redwood City, CA 94063

Job Title:  Business Intelligence Engineer 2

Job Duties:  Position located in Redwood City. Responsible for development of complex technical analysis and design of new data warehouse from heterogeneous OLTP sources, new programming, modifications, data modeling, scheduling, tuning, testing and maintenance of systems in support of new and existing Business Intelligence (BI) and other projects. Responsible for databases, data acquisition, ETL strategies and tools and technologies like Informatica. Must be able to create ETL code using Informatica software. Provide data analysis and root cause analysis, conceptualize, design, implement and develop solutions for critical BI components. Responsible for coding using scripting language like Shell, Javascript, PL/SQL. Perform dataflow, system and data analysis and develop meaningful and useful presentation of data in BI applications. Plan and implement standards, define/code conformed global and reusable objects, perform complex database design, data modelling (EDW and programming and streamline the systems. Consult with client groups to assess user needs and understand the business processes; convert user requirements into technical solutions. Must have experience in software engineering principles and skills working on Unix/Linux/Windows Operating systems, Version Control and Office software.

May telecommute within area of intended employment at employer’s discretion.

Requirements:  Master’s degree in Computer Science, Mechanical Engineering, Electrical Engineering or related degree and five years of experience in any occupation in Data warehouse methodology or concepts. Or Bachelor’s degree in Computer Science, Mechanical Engineering, Electrical Engineering or related degree and seven years of experience in any occupation in Data warehouse methodology or concepts.

Must also possess five years of experience in each of the following:

• Data Modeling and designing data warehouse from heterogeneous OLTP sources
• Databases, data acquisition, ETL strategies and tools and technologies like Informatica
• Oracle database
• Data analysis and root cause analysis
• ETL experience using Informatica Software
• Scripting language like Shell, JavaScript, PL/SQL
• Software engineering principles and skills working on Unix/Linux/Windows Operating systems, Version Control and Office software.

May telecommute within area of intended employment at employer’s discretion

Salary: The expected pay range for this position is $118,100 to $123,970 per annum. Stanford University provides pay ranges representing its good faith estimate of what the university reasonably expects to pay for a position. The pay offered to a selected candidate will be determined based on factors such as (but not limited to) the scope and responsibilities of the position, the qualifications of the selected candidate, departmental budget availability, internal equity, geographic location and external market pay for comparable jobs.

At Stanford University, base pay represents only one aspect of the comprehensive rewards package. The Cardinal at Work website (https://cardinalatwork.stanford.edu/benefits-rewards)  provides detailed information on Stanford’s extensive range of benefits and rewards offered to employees. Specifics about the rewards package for this position may be discussed during the hiring process. 

The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned.

Consistent with its obligations under the law, the University will provide reasonable accommodations to applicants and employees with disabilities. Applicants requiring a reasonable accommodation for any part of the application or hiring process should contact Stanford University Human Resources at [email protected] . For all other inquiries, please submit a contact form .

Stanford is an equal employment opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

Send CV and refs to: Nicole Ambayec at [email protected] . Use reference job code Req#102804