Analyst / Specialist, Business Intelligence

Business intelligence specialist is responsible for implementing ETL solutions for clients in different industries dealing with various types of challenging data

  1. Design, build and deploy effective SSIS packages

  2. Implement stored procedures and effectively query a database

  3. Identify and test for bugs and bottlenecks in the ETL solution

  4. Analyses and revises existing system logic difficulties and documentation, as necessary.

  5. Includes analysis of business and user needs, documentation of requirements, and translation into proper system requirement specifications.

  6. Functions as a liaison between the client, community, and internal IT and/or external software vendors to develop system solutions to processing systems or business problems. Interfaces with business unit to solve complex business issues through data analysis.

  7. Ensures data quality and integrity across data-specific application implementations

  8. Works cross-functionally to collect data and makes actionable recommendations at all levels.

  9. Respond to ad-hoc requests for information from systems and assist with configuration of reports in a timely, efficient, and accurate manner.

  10. Design, build, and deliver new reports, measures, and KPIs.

  11. Perform any other duties as required by the line manager.

Requirements :

Minimum Qualification:

bachelor's degree in computer science, information technology or another computer-based discipline.

Minimum Experience:

1+ years of experience in research and development or a similar field.

Competencies (Knowledge, Skills & Abilities):

Solid foundation of ETL knowledge

Extensive experience in T-SQL: Writes advanced SQL including some query tuning

Experience in the identification of data quality

Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing

Some Knowledge of C#/VB.NET a plus

Utilize ad-hoc techniques to perform on-the-fly analysis of data

Proficient in how to deploy to and debug a production SSIS environment

Extensive experience troubleshooting and solving complex technical problems

Problem Solving Skills

Strong oral and written communication skills

Strong technical skills

Location : Tamkeen Technologies

Department : Manpower

Apply for Analyst / Specialist, Business Intelligence