Senior Engineer - BI HANA

Job Location:  Chennai
Job Description:  SkillSet: troubleshooting, " project plans", inspection, commissioning, safety.
  • Create Technical specifications and standard modelling documents for HANA.
  • Business requirement gathering discussion.
  • Perform data modelling and developed Analytical views, calculated views for the transactional data in HANA Studio.
  • Develop complex calculation view using SQL and CE-Function.
  • Create advanced modelling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
  • Develop the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
  • Create Users, Roles, privileges, Packages, schema as part of HANA security and development.
  • Migrate HANA content from development, testing environment to Production environment using delivery units.
  • Create Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool.
  • Integrate BOBJ with SAP HANA1.0.

Areas of specialization will include:

  • Business Intelligence
    • Data visualization, User Interface design
    • Data analysis and design of KPI/Measures/Metrics
    • Development of Reports using AZ adopted BI technologies
  • Data Integration
    • ETL and ELT concepts, principles and implementations
    • Data Virtualization concepts, principles and implementations
  • Data Management
    • Data Quality with Data Profiling
    • Master Data Management
    • Meta Data Management
    • Data Archival
  • Applicable tools: -
    • SAP HANA
    • Big Data Technologies Hive, Impala
  • Understanding of data management and integration services
  • Life cycle management and capacity planning
  • Creation of standards and procedures for administrators to maintain AstraZeneca's environments.
  • Supports operational and engineering aspects of Data Services support

Candidate Focus Challenge

  • Defines and directs the system engineering activities and ensures that System Engineering teams deliver subject matter expertise to projects, maintenance activities and incident problem management
  • Works with preferred third party suppliers to provide strategic and innovative technology solutions aligned with AstraZeneca business needs as well as regulatory requirements
  • Provides technical input to business cases, Request for Proposals, supplier selection and evaluation of proposals
  • Leads resolutions of risks identified in third party supplier impact assessments
  • Ensures infrastructure lifecycle maintenance needs are identified and managed
  • Maintains awareness and knowledge of industry trends and proactively identifies and drive identification of opportunities to be leveraged in Information Services solutions
  • Works with Architects to define business solutions, ensuring their alignment with business strategies and priorities, as well as expected target benefits
  • Leads effort to plan, engineer and design solutions and oversees the design and documentation of solution components
  • Provides technical expertise, direction and support to Solutions Engineers, Architects, and project managers
  • Leads efforts to ensure that modified solutions interact appropriately, areas of impact are considered and addressed and meet performance requirements
  • Plans all activities associated with implementation of solutions
  • Plans all activities associated with maintenance of solutions
  • Supports Incident and problem management
  • Primary ownership in documenting and resolving all problem tickets for MW Application Server environment
  • Participate in all operational activities/ administration activities including on-call rotation as required
  • Responsible for capacity planning of MW Application Server infrastructure and for creating sizing model for project delivery
  • Learn, evaluate and conduct proof of concepts on new technologies as they emerge and that are pertaining to AZ environment
  • Serve as the key technical resource for the team providing advice, training and technical support for various project initiatives and day to day operations

Candidate Knowledge, Skills Experience

  • 8+ years of BI Engineering experiences
  • 5+ years of 24*7 operational production support experience supporting multiple time zones/geographical regions

Education, Qualifications, Skills and Experience


  • Technical or Business Degree
  • Proven skills and experience managing and controlling large project and programme budgets
  • Excellent communication and relationship management skills
  • Experience managing and leading global project teams
  • Strong knowledge and experience with Microstrategy/Qlikview .
  • Evidence of shaping innovative solutions that have a major impact within the business area and organisation
  • Excellent business acumen with sensitivity to environment
  • Experience working in a global organization where stakeholders and project team members are geographically dispersed.


  • Masters degree
  • Demonstrated leadership skills interacting with senior leaders


Functional Area:  ERP / CRM
Experience:  5 - 7 years
Qualification:  ("Graduation in any field")
Salary:  7 Lakh to 12 Lakh INR
Job Ad publication date: 06 Mar 2021  

Related Jobs

Related Jobs