BI Engineer 2

Location
Stanford
Posted
Sep 18, 2017
Institution Type
Four-Year Institution


Stanford University

BI Engineer 2

Job Number:
76362

OBIEE Business Intelligence Engineer will be a key member of the Data Management and Reporting (DM&R) group reporting to the Tech Manager of Enterprise Reporting and Business Intelligence. This is highly demanding role, with 100 % solid hands-on need with combination of Finance, HR and Students functional background. The successful candidate will have frequent interactions on day to day basis with University Business customers and with internal Technical team.

Data Management and Reporting (DMR) group under Administrative Systems manages all of the data management applications that include Enterprise Data Warehouse, Oracle Business Intelligence Enterprise Edition (OBIEE), Tableau, and Informatica applications. DMR team serves the entire campus with data needs and serves as one stop shop for Enterprise Reporting and Business Intelligence content. This team works with all schools and departments on campus and provides information, analytics and reporting solutions across all ERP applications and EDW.

CORE DUTIES*:

  • Provide complex analysis, conceptualize, design, implement and develop solutions for critical BI components.
  • 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, OBIEE data modelling, BIP programming and streamline the systems.
  • Consult with client groups to assess user needs and understand the business processes; convert user requirements into technical solutions.
  • Contribute to data analysis, design and development of new and ongoing business intelligence (BI) projects involving complex EDW structures OR on OLTP systems.
  • Collaborate closely with internal and external teams to understand and apply changes/modifications impacting data warehouse.
  • Conduct and participate in code walkthroughs and document technical design. Assist in quality control testing. Meticulously follow software methodologies defined.
  • Monitor reporting processes, system audits, dashboard reporting and presentation layer functioning and performance. Pro-actively resolve issues as found. Support the performance of systems.
  • Follow the release cycles and implement on-time delivery of bug fixes, change requests and enhancements. Troubleshoot and solve technical problems.

    * - Other duties may also be assigned
    Education & Experience:

    Bachelor's degree and seven years of relevant experience in computer science, or engineering or a combination of education and relevant experience.

    Knowledge, Skills and Abilities:

  • Deep hands-on experience on OBIEE RPD & BIP Reporting Data models, Development for seamless cross-functional and cross-systems data reporting.
  • Expertise and solid experience in BI Tools - OBIEE, Tableau and Business Objects
  • Strong programming skills, relational database skills with expertise in Advanced SQL and PL/SQL, indexing and query tuning
  • Experienced in Business Intelligence and Data warehousing concepts and methodologies.
  • Extensive experience in data analysis and root cause analysis and proven problem solving and analytical thinking capabilities.
  • Analytical capabilities to slice and dice data and display data in reports for best user experience.
  • Demonstrated ability to review business processes and translate into BI reporting and analysis solutions.
  • Ability to follow Software Development Lifecycle (SDLC) process and should be able to work under any project management methodologies used.
  • Ability to define and solve logical problems with right solutions
  • Ability to follow best practices and standards.
  • Ability to identify BI application performance bottlenecks and tune.
  • Ability to work quickly and accurately under pressure and project time constraints
  • Ability to prioritize workload and work with minimal supervision
  • Exposed to ETL tools Informatica or equivalent.
  • Exposed or Basic knowledge to scripting language like Python, R, Shell, JavaScript, HTML5
  • Basic understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, Version Control and Office software.
  • Nice to have, exposure to big data technologies

    Certifications and Licenses:

  • Preferred Certification in OBIEE Foundation Suite & Advance SQL

    PHYSICAL REQUIREMENTS*:

  • Constantly perform desk-based computer tasks.
  • Frequently sitting.
  • Occasionally stand/walk.
  • Rarely writing by hand; lift/carry/push/pull objects that weigh up to 10 pounds.

    * - Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of his or her job.

    WORK STANDARDS:

  • Interpersonal Skills: Demonstrates the ability to work well with Stanford colleagues and clients and with external organizations.
  • Promote Culture of Safety: Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors based on training and lessons learned.
  • Subject to and expected to comply with all applicable University policies and procedures, including but not limited to the personnel policies and other policies found in the University's Administrative Guide, http://adminguide.stanford.edu.

    We are not able to provide relocation for this position. Sponsorship is possible.

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

    Thank you for your interest!


    Job: Information Technology Services

    Location: Business Affairs: Administrative Systems (IT)
    Schedule: Full-time
    Classification Level:

    To be considered for this position please visit our web site and apply on line at the following link: stanfordcareers.stanford.edu

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




    jeid-8b117ab0a55cf04e819e15f59e1923e5