Business Intelligence Developer

Location
Stanford
Posted
Jun 30, 2017
Institution Type
Four-Year Institution


Stanford University

Business Intelligence Developer

Job Number:
75478

ABOUT STANFORD UNIVERSITY AND RESIDENTIAL & DINING ENTERPRISES:


Stanford University, located between San Francisco and San Jose in the heart of California's Silicon Valley, is one of the world's leading teaching and research universities. Since its opening in 1891, Stanford has been dedicated to finding solutions to big challenges and to preparing students for leadership in a complex world.

Residential & Dining Enterprises (R&DE), the largest auxiliary organization at Stanford University, supports the academic mission of the University by providing the highest quality services to students and other members of the university community in a sustainable and fiscally responsible manner. The department is the steward for a $1.8 billion asset portfolio covering 1/3 of Stanford's campus and has a $272 million annual operating budget for FY17. R&DE comprises 800+ staff in the following divisions: the Office of the Senior Associate Vice Provost (SAVP Office), Student Housing, Stanford Dining, Stanford Hospitality & Auxiliaries, Stanford Conferences, and a team of four R&DE strategic business partners: Finance & Administration, Human Resources, Information Technology, and Strategic Communications. R&DE houses 13,000+ students and their dependents while serving over 6.5 million meals annually to students, conference, catering, retail, and concession guests and annually hosts a combined 52,000 guests in the Stanford Guest House and on-campus in Stanford Conferences.


JOB PURPOSE: Responsible for development of technical analysis and design, new programming, modifications, scheduling, tuning, testing and maintenance of systems in support of new and existing Business Intelligence(BI) and other projects.


CORE DUTIES*:
  • Develop insightful business intelligence reports (KPIs, metrics, adhoc queries), dashboards, scorecards, continuous monitoring (thresholds), and/or ad hoc analyses. Clean and transform data as required to deliver actionable information.
  • Participate in user acceptance testing of new BI analysis and reporting systems, upgrades, enhancements and change requests; plan, conduct and document results of testing.
  • Participate in data governance/stewardship assignments.
  • Use reports and analyses to identify potentially problematic data, make corrections, and eliminate root cause for a range of complex data problems (e.g.: input errors or inadequate field edits), and recommend possible solutions and communicate their organizational impact.
  • Use data visualization tools and techniques in translating business analytics needs into engaging and intuitive data visualizations.
  • Consult with client groups to assess user needs and requirements.
  • Perform data analysis, design and development of new and ongoing business intelligence (BI) tools involving complex EDW structures OR on OLTP systems.
  • Provide technical design, coding, testing, implementation, maintenance, system and technical support for BI initiatives.
  • Conduct and participate in code walkthroughs and document technical design. Assist in Quality Control testing. Troubleshoot and solve technical problems
  • Meticulously build BI applications following software methodologies defined.
  • Follow the release cycles and implement on-time delivery of bug fixes, change requests and enhancements.
  • Monitor ETL processes, system audits, Dashboard Reporting and Presentation Layer functioning and performance and pro-actively fix issues as found. Support the performance of systems.
  • Support Source upgrades, Hardware/Software upgrade projects with impact analysis, fixes and end-to-end testing. Provide operational support on failures and outages. * - Other duties may also be assigned
    MINIMUM REQUIREMENTS:
    Education & Experience: Bachelor's degree and five years of relevant experience in computer science, or engineering or a combination of education and relevant experience.


    Knowledge, Skills and Abilities:
  • Basic understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, Version Control and Office software.
  • Strong programming skills, relational database skills with expertise in Advanced SQL and PL/Sql. Skills in Shell Programming.
  • Understanding in Business Intelligence and Data warehousing concepts and methodologies.
  • Knowledge in ETL, presentation layer and reporting design strategies. Ability to support custom built ETL, auditing and scheduling programs.
  • Ability to define and solve logical problems with right solutions.
  • 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 follow best practices and standards.
  • Ability to identify BI application performance bottlenecks and tune.
  • Expertise and experience in BI Tools - Informatica, Business Objects, OBIEE, OBIA, Tableau and QlikView.
  • Ability to programmatically process data in flat files, transform and load into Data warehouse.
  • Quick learner of any new technologies OR business processes.
  • Ability to work effectively in a team environment. Certifications and Licenses: None

    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.


    WORKING CONDITIONS:
    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://apptrkr.com/get_redirect.php?id=1039423&targetURL=s.
  • Consult with client groups to assess user needs and requirements.
  • Perform data analysis, design and development of new and ongoing business intelligence (BI) tools involving complex EDW structures OR on OLTP systems.
  • Provide technical design, coding, testing, implementation, maintenance, system and technical support for BI initiatives.
  • Conduct and participate in code walkthroughs and document technical design. Assist in Quality Control testing. Troubleshoot and solve technical problems
  • Meticulously build BI applications following software methodologies defined.
  • Follow the release cycles and implement on-time delivery of bug fixes, change requests and enhancements.
  • Monitor ETL processes, system audits, Dashboard Reporting and Presentation Layer functioning and performance and pro-actively fix issues as found. Support the performance of systems.
  • Support Source upgrades, Hardware/Software upgrade projects with impact analysis, fixes and end-to-end testing. Provide operational support on failures and outages. * - Other duties may also be assigned
    MINIMUM REQUIREMENTS:
    Education & Experience: Bachelor's degree and five years of relevant experience in computer science, or engineering or a combination of education and relevant experience.


    Knowledge, Skills and Abilities:
  • Basic understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, Version Control and Office software.
  • Strong programming skills, relational database skills with expertise in Advanced SQL and PL/Sql. Skills in Shell Programming.
  • Understanding in Business Intelligence and Data warehousing concepts and methodologies.
  • Knowledge in ETL, presentation layer and reporting design strategies. Ability to support custom built ETL, auditing and scheduling programs.
  • Ability to define and solve logical problems with right solutions.
  • 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 follow best practices and standards.
  • Ability to identify BI application performance bottlenecks and tune.
  • Expertise and experience in BI Tools - Informatica, Business Objects, OBIEE, OBIA, Tableau and QlikView.
  • Ability to programmatically process data in flat files, transform and load into Data warehouse.
  • Quick learner of any new technologies OR business processes.
  • Ability to work effectively in a team environment. Certifications and Licenses: None

    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.


    WORKING CONDITIONS:
    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.


    Job: Information Analytics

    Location: Residential & Dining Enterprises
    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-e7dae1e021d3d2438394f78665504aea