Browse Jobs
For Employers
Post JobLog inGet Started

Business Intelligence Specialist

Johnson Controls
New Cairo, Cairo
Posted 3 years ago
47Applicants for1 open position
  • 22Viewed
  • 0In Consideration
  • 0Not Selected
Search other opportunities

Job Details

Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:

Skills And Tools:

Job Description

Job Scope:

  • This role will be responsible of managing BI, analytics solutions, designing and implementing BI systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users. He / She is also responsible for ensuring high levels of BI availability through support functions and in-depth testing.

Job Description:

  • Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.
  • Translate business needs to technical specifications
  • Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
  • Design, build and deploy BI solutions (e.g. reporting tools)
  • Create tools to store data (e.g. Tabular model)
  • Conduct unit testing and troubleshooting
  • Evaluate and improve existing BI systems
  • Collaborate with teams to integrate systems
  • Develop and execute database queries and conduct analyses
  • Create visualizations and reports for requested projects
  • Develop and update technical documentation
  • Coordinate with developers and end-users and gather all data design specifications as per customer requirements.
  • Design communication process and prepare plans for all work assignments and ensure completion within the deadline.
  • Monitor all data projects according to the development life cycle and ensure compliance to quality standards.
  • Administer design of Business Intelligence projects and develop dashboards and operations for reports.
  • Develop reports and dashboards on SQL servers.
  • Prepare test cases and plans and perform tests on systems.
  • Install and assist to configure various Business Intelligence tools.
  • Perform troubleshoot on all Business Intelligence tools and assist in resolution.
  • Monitor monthly release cycle and perform unit tests for Quality Assurance.

Job Requirements

  • Bachelor’s degree in Computer Science, IT, or relevant field.
  • Minimum 4 years of relevant experience in the field.
  • In-depth understanding of data warehouse design (e.g. dimensional modeling) and data mining.
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
  • Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI).
  • Experience with tier-one applications, databases, and data warehouses.
  • Hard knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
  • Strong understanding of relational databases.
  • Strong ability to analyze user requirements and build front-end BI applications according to specifications structures.
  • Analytical mind with a problem-solving aptitude.
  • Understanding of Agile methodologies.
  • Knowledge & experience of UI.
  • Proven abilities to take initiative and be innovative.
  • Excellent command of English language both written and verbal is a Must.

Featured Jobs

Similar Jobs

Search other opportunities
JobsIT/Software DevelopmentBusiness Intelligence Specialist