Business intelligence specialist is responsible for implementing ETL solutions for clients in different industries dealing with various types of challenging data
Design, build and deploy effective SSIS packages
Implement stored procedures and effectively query a database
Identify and test for bugs and bottlenecks in the ETL solution
Analyses and revises existing system logic difficulties and documentation, as necessary.
Includes analysis of business and user needs, documentation of requirements, and translation into proper system requirement specifications.
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.
Ensures data quality and integrity across data-specific application implementations
Works cross-functionally to collect data and makes actionable recommendations at all levels.
Respond to ad-hoc requests for information from systems and assist with configuration of reports in a timely, efficient, and accurate manner.
Design, build, and deliver new reports, measures, and KPIs.
Perform any other duties as required by the line manager.
bachelor's degree in computer science, information technology or another computer-based discipline.
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 : ManpowerApply for Analyst / Specialist, Business Intelligence