Business Intelligence Engineer
- Employer
- Stanford University
- Location
- Business Affairs: University IT (UIT), Redwood City, California, United States
View more
- Employment Type
- Full Time
- Institution Type
- Four-Year Institution
Job Details
- 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, 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.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 ETL processes, system audits 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.Provide timely and accurate estimates for newly proposed functionality enhancementsComfortable working across a wide array of technologies, project types, and business requirements.Utilize technical and domain knowledge to develop and implement effective solutions; provide hands on mentoring to team members through all phases of the Systems Development Life Cycle (SDLC) using Agile practices.
- Mastery in Business Intelligence and Data warehousing concepts and methodologies.Expert in Data Modeling and designing data warehouse from heterogeneous OLTP sources.High expertise on Databases, data acquisition, ETL strategy, design and development using Informatica.Strong programming skills, relational database skills with expertise in Advanced Sql and PL/Sql. Skills in Shell Programming and any Object Oriented Programming language.Ability to design Physical and Reporting Data models for seamless cross-functional and cross-systems data reporting.Should be able to write custom ETL programming from complex data processing and transformations using any programming language, such as PL/Sql, Python, Java, etc.Extensive experience in data analysis and root cause analysis and proven problem solving and analytical thinking capabilities.Broad understanding of multiple existing and next generation Business intelligence tools and technologies.Understanding of Reporting/Analytics and data visualization tools like OBIEE and Tableau including Design and Development.Understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, Version Control and Office software.Ability to prioritize workload and work with minimal supervision.Experience working with Oracle Financials as source is a plus.This person will interface with the business and technology teams (development, infrastructure, application and QA) in an agile delivery modelExperience with Cloud based datawarehouse system: Snowflake, RDS, Redshift, Azure is a huge plusExperience with other ETL tools (e.g.Workato, SnapLogic, or Mulesoft) is a plus
- 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.
- 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.
- Stanford University has revolutionized the way we live and enrich the world. Supporting this mission is our diverse and dedicated 17,000 staff. We seek talent driven to impact the future of our legacy. Our culture and unique perks empower you with:Freedom to grow. We offer career development programs, tuition reimbursement, or audit a course. Join a TedTalk, film screening, or listen to a renowned author or global leader speak.A caring culture. We provide superb retirement plans, generous time-off, and family care resources.A healthier you. Climb our rock wall, or choose from hundreds of health or fitness classes at our world-class exercise facilities. We also provide excellent health care benefits.Discovery and fun. Stroll through historic sculptures, trails, and museums.Enviable resources. Enjoy free commuter programs, ridesharing incentives, discounts, and more.Redwood City. Our new Stanford Redwood City campus is the workplace for approximately 2,700 staff, including University IT, whose jobs are important to supporting the University’s mission. The campus offers amenities such as onsite cafes and a dining pavilion, a high-end fitness facility with an outdoor pool, and a childcare center for Stanford families.
- Schedule: Full-time
- Job Code: 5844
- Employee Status: Regular
- Grade: A16
- Requisition ID: 87773
Organization
Change the world. And yourself.
Stanford University has changed the world, over and over again.
We are one of Silicon Valley's largest employers - and also one of the most unique. Our mission is to educate future leaders and promote interdisciplinary, world-class research and teaching. This passion makes Stanford an intensely creative, rewarding, and challenging place to work. At the same time, our traditions of respect and collaboration sustain a humane, supportive environment in which to pursue your life and your career.
At Stanford you'll work with bright, diverse, dedicated people. You'll find encouragement to learn and grow. You'll enjoy excellent benefits and an outstanding environment.
Stanford Facts at a Glance
Opened 1891
Student Enrollment
- Undergraduates: 6,980
- Graduates: 8,897
Campus
- 8,180 contiguous acres in six governmental jurisdictions
- Nearly 700 major buildings
- 97% of undergraduates live on campus
Research
- 5,300 externally sponsored projects
- $1.33 billion total budget
Faculty
- 2,043 faculty members
- 21 Nobel laureates are currently members of the Stanford community
- 5:1 student to faculty ratio
Stanford University is an Equal Employment Opportunity and Affirmative Action Employer and is committed to recruiting and hiring qualified women, minorities, protected veterans and persons with disabilities.
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert