Business Intelligence Engineer (ETL)

MINIMUM REQUIREMENTS:

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:

• 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.
• This person will interface with the business and technology teams (development, infrastructure, application and QA) in an agile delivery model
• Experience with Cloud based datawarehouse system: Snowflake, RDS, Redshift, Azure is a huge plus
• Experience with other ETL tools (e.g.Workato, SnapLogic, or Mulesoft) is a plus

Certifications and Licenses:

None

Why Stanford is for You:

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, opened in Spring 2019, 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.

Stanford University’s commitment to safely and effectively meet the public health challenge presented by COVID-19 extends to ensuring University employees may work from home, or another off-site location, where determined appropriate, whenever necessary through the end of June 2021. The department will give reasonable notice when employees are expected to return to work at the Redwood City campus.

Relocation and sponsorship will not be provided for this position.

The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned.

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.

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