Agilent Technologies, Inc. BI Hana Modeling Lead in Santa Clara, California


Agilent inspires and supports discoveries that advance the quality of life. We provide life science, diagnostic and applied market laboratories worldwide with instruments, services, consumables, applications and expertise. Agilent enables customers to gain the answers and insights they seek –– so they can do what they do best: improve the world around us. Information about Agilent is available at

Designs and develops new IT technical solutions/capabilities to solve large, complex business problems and deliver new capabilities. Responsible for technical planning, designing, development and modification of new solution specifications and application. This includes technical design of content structure, user/process flows and interfaces. Proficient in information technology, platforms and architecture. Manages large information technology vendors in the technical aspects of designing and developing IT solutions.

This position is an expert Level IT professional position in the Business Intelligence team of Agilent IT Corporate Information Solutions organization. We are seeking to fulfill a role in a broad spectrum of functional consulting, solution design, technical consulting, and team leadership activities.

The successful person for this job will be able to use his/her strong SAP Hana Data Modeling domain experience to lead the global implementation of Business Intelligence reporting solutions. The candidate must be able to work with team members from many functions, businesses, organizations and geographies. The ideal candidate will have very good experience in implementing SAP Hana as BI Reporting solution in a global manufacturing environment and be involved in the entire project lifecycle of BI Reporting solution implementation. Here is what you will be measured on:

  • Reduces broad business requirements into detailed IT architecture plans.

  • Leads large new IT solution design; is the key technical contributor

  • Solves complex, high impact design problems

Expertise on creating new data models in Hana based on business requirements. Required to develop Hana models on real time replicated data from SAP ECC and CRM systems.

  • Implementing best practices on Hana scripting and data modeling, implementing security and code migration standards.

  • Designing BI Reporting solutions on Spotfire or SAP BI suite (Design studio, Webi, Lumira) for finance, Sales & Distribution, Services functional areas in collaboration with business partners, IT peers and outsourced IT partners in multiple countries.

  • Envision & Develop reporting solutions to influence business results by creating the right KPIs, templates, dashboards and scorecards for actionable insights

  • Provide solution guidance to technical team members on usage of accepted industry standards and design extraction logic from SAP ECC and CRM systems to reporting systems

  • Perform proof of concept study for new Reporting KPI’s, technologies and solutions

  • Fostering knowledge sharing and improving processes and practices between Business and IT teams

  • Effectively working across cross functional teams

  • Expertise of developing analytics solutions for Sales, Finance, supply chain, CRM functional areas is needed.


Skills Required:

  • Bachelors or Master Degree or University Degree or equivalent work experience

  • Typically 8-10+ years relevant experience for entry to this level. Post-graduate and/or certification /license may be required.

  • Expertise in designing and developing data models using Hana views as well scripts.

  • Expertise on Hana Live content for Finance and SD modules.

  • Expertise on using different perspectives in Hana studio. Should be proficient in analyzing and debugging existing data models.

  • Performance tuning of different data models in Hana.

  • Solid understanding of analytics tools like SAP BI Suite (Webi, Design Studio, Lumria), Spotfire.

  • Good understanding on Hana administration toolkit.

  • Expertise on using SLT replication from ECC and CRM sources.

  • Experience in conceptualizing, designing & creating BI Solutions, should be proficient in Data modelling methodologies.

  • Experience of SAP ECC and CRM applications, should possess solid understanding of SAP tables and data structures.

  • Experience with reporting system and data warehouse requirements gathering, analysis and design of ETL processes

  • Expert knowledge of Data Warehousing and Business Intelligence design principles.

  • Possess strong business acumen and consistently demonstrates forward thinking.

  • Is able to effectively work with ambiguous or incomplete information.

  • Problem solving and strong analytical skills.

  • Strong interpersonal skills and demonstrated commitment to teamwork.

  • Good oral and written communication skills

  • Ability to prioritize assignments/projects and multi-task within restricted time constraints.

Agilent Technologies, Inc. is an Equal Employment Opportunity and Affirmative Action employer. We value diversity at all levels. All individuals, regardless of personal characteristics, are encouraged to apply. All qualified applicants will receive consideration for employment without regard to sex, pregnancy, race, religion or religious creed, color, gender, gender identity, gender expression, national origin, ancestry, physical or mental disability, medical condition, genetic information, marital status, registered domestic partner status, age, sexual orientation, military or veteran status, protected veteran status, or any other basis protected by federal, state, local law, ordinance, or regulation and will not be discriminated against on these bases.

For more information about equal employment opportunity protections, please view the ‘EEO is the Law’ poster available here:,

Agilent Technologies, Inc., is committed to diversity in the workplace and strives to support candidates with disabilities. If you have a disability and need assistance with any part of the application or interview process or have questions about workplace accessibility, please contact +1-262-754-5030 (US and Canada only) or email EOE AA M/F/Vet/Disability

Date Posted: 24/Jul/17

Requisition: 2072600

Job Title: BI Hana Modeling Lead

Business: Global Infrastructure

Job Category: Information Technology

Job Sub-Category: IT Systems Design & Implementation

Region: Americas

Country or Area: United States

State/Province: California

Town/City: Santa Clara

Shift: Day Job

Job Type: Experienced

Schedule: Full-time

Travel Required: No

Duration (Temp Positions Only): Not applicable

HR Country Location: United States

HR Town/City Location: Santa Clara