HCL Global System - Farmington Hills, MI

posted about 2 months ago

Full-time
Farmington Hills, MI
Professional, Scientific, and Technical Services

About the position

The Business Intelligence Developer position at HCL Global Systems Inc. involves a dynamic role focused on transforming business requirements into actionable insights through the development of OBIEE reports and dashboards. The successful candidate will interact closely with business users to analyze their processes and needs, ensuring that the final outputs align with organizational goals. This role requires a comprehensive understanding of business requirements, which will be translated into detailed designs, including block diagrams and logical flow charts, to facilitate the development of OBIEE applications. In addition to report development, the Business Intelligence Developer will participate in the design of ETL processes, particularly for star schema modeling, which is crucial for effective data warehousing. The role also includes the development of a metadata model for the OBIEE repository, implementing opaque views as necessary, and establishing dimensional hierarchies to enhance data accessibility and usability. The developer will design and develop logical data models in the BMM layer, ensuring that object-level and data-level security configurations are properly set within OBIEE. The position requires configuring Linux servers with essential prerequisites such as Java (JDK) and Apache Tomcat, as well as managing database indexes to optimize performance. The developer will create complex testing procedures within an agile development environment, write SQL queries for data validation, and support the application during QA testing and initial production phases. Documentation is a key aspect of this role, as the developer will be responsible for creating user guides and manuals, as well as training users on ad-hoc reporting across various subject areas. This position may require relocation to various unanticipated work locations throughout the United States, emphasizing the need for flexibility and adaptability in the candidate.

Responsibilities

  • Interact with business users to analyze business processes and transform requirements into OBIEE reports and dashboards.
  • Analyze complete business requirements and develop block diagrams and logical flow charts.
  • Translate detailed designs into OBIEE applications.
  • Participate in ETL design for star schema modeling.
  • Develop metadata model for OBIEE repository.
  • Implement opaque views wherever necessary.
  • Implement dimensional hierarchies.
  • Design and develop logical data models in the BMM layer.
  • Configure object-level and data-level security within OBIEE.
  • Configure Linux servers with required prerequisites like Java (JDK) and Apache Tomcat.
  • Create appropriate database indexes wherever applicable.
  • Create complex testing procedures in an agile development environment.
  • Write SQL queries to compare data against report data for testing.
  • Support the application for any issues during QA testing and initial production support.
  • Create documents to explain functionality and logic behind reports.
  • Create user guides and manuals for running reports and dashboards.
  • Train users on ad-hoc reporting using different subject areas.

Requirements

  • Bachelor's degree in Computer Information Systems or a related field.
  • No prior experience required.

Benefits

  • Referral bonus through employee referral program.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service