We are hiring to fill two (2) BI Engineer 1 positions.
Business Intelligence ETL 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 solid hands-on need with combination of Finance 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.
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.
Follow the release cycles and implement on-time delivery of bug fixes, change requests and enhancements. Troubleshoot and solve technical problems.
Collaborate with offshore teams to ensure technical delivery of business requirements are met on-time.
* - Other duties may also be assigned
Education & Experience:
Bachelors 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.
Ability to work quickly and accurately under pressure and project time constraints
Ability to prioritize workload and work with minimal supervision
Solid experience on Oracle database skills includes PL/SQL, packages, procedures, indexing and query tuning
Nice to have, exposure to big data technologies
Certifications and Licenses:
Preferred Certification in Informatica Powercenter Developer / Administrator
Constantly perform desk-based computer tasks.
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.
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 Universitys Administrative Guide, http://adminguide.stanford.edu.
We are not able to provide relocation or sponsorship for this position.
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.
Located between San Francisco and San Jose in the heart of Silicon Valley, Stanford University is recognized as one of the world's leading research and teaching institutions. Leland and Jane Stanford founded the University to "promote the public welfare by exercising an influence on behalf of humanity and civilization." Stanford opened its doors in 1891, and more than a century later, it remains d...edicated to finding solutions to the great challenges of the day and to preparing students for leadership in a complex world. The University's thriving diverse community is comprised of nearly 7000 undergraduate students, 9000 graduate students, 2000 faculty members, 1900 postdoctoral scholars, and over 11,000 academic and administrative staff in seven schools including several interdisciplinary research centers and institutes. The campus spreads over 8000 contiguous acres and nearly all undergraduates live on campus. Stanford offers bachelor's and master's degrees in addition to doctoral degrees (PhD, MD, DMA and JD) plus a number of professional and continuing education programs and certifications. More at http://facts.stanford.edu and http://www.stanford.edu.
Stanford University is an equal opportunity employer and is committed to increasing the diversity of its faculty. It welcomes nominations of and applications from women, members of minority groups, protected veterans and individuals with disabilities, as well as from others who would bring additional dimensions to the university’s research, teaching and clinical missions.