This position is listed at two different hiring grades. Your experience, relevant knowledge, and skill set will determine the hiring level.
The Data Insights team at Stanford GSB supports the school's integration and analytics needs. We're looking to add a strong hands-on BI Data Engineer to the team, to help architect and build a secure, robust and scalable analytics data store. As the ideal candidate for a small team, we'll ask a lot of you. You have hands-on experience in all the relevant tech and tools. You're experienced in keeping the big picture front and center and building solutions that meld technology ideals and practicality. You're self-motivated and keep yourself current with the industry. You're also fully comfortable with realities like competing priorities, distributed teams and multiple time zones.
Responsible for development of complex 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.
Architect, design, implement and maintain secure, scalable BI data stores for structured and unstructured data for all domains of the school's business - Operations, Learning, Admissions, CRM etc.
Collaborate with Integration Engineers to build ETL processes for ingesting data into BI stores and do data prep for BI dashboards.
Provide complex analysis, conceptualize, design, implement and develop solutions for critical BI components.
Plan and implement standards, define/code conformed global and reusable objects, perform complex database design, data modeling (EDW) and programming and streamline the systems.
Consult with client groups to assess user needs and understand business processes; convert 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.
Monitor industry for emerging technologies and trends; provide appropriate recommendations to team and leadership.
Provide technical mentoring to other team members, as appropriate.
Minimum Knowledge, Skills and Abilities Required:
Mastery in Business Intelligence and Data warehousing concepts and methodologies.
Expert in Data Modeling data from heterogeneous OLTP sources into appropriate BI stores - structured warehouses or data lakes.
Experienced in designing Physical and Reporting Data models for seamless cross-functional and cross-systems data reporting.
Experienced in building robust and reusable Data Prep processes to support BI Analysts.
Expertise on Databases, data acquisition, ETL strategies and tools and technologies like Informatica, Datastage and others.
Experience in R, D3, python, statistical programming or machine learning principles a significant plus.
Experience working with standard SDLC processes.
Self-motivated, demonstrable quick learner of new technologies and/or processes. Experienced in working with distributed teams across time zones.
Minimum Education and Experience Required:
Bachelor's degree and seven years of relevant experience in computer science, or engineering or a combination of education and relevant experience.
Constantly perform desk-based computer tasks.
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.
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/.
Location: Graduate School of Business, California, United States Schedule: Classification Level:
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.
Copyright 2017 Jobelephant.com Inc. All rights reserved.
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 dedicated 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.