Data Production Specialist Job in Kenya

Ascribe Ltd. is a leading supplier of Business Intelligence, Consultancy and clinically focused IT solutions and services in healthcare, with customers in the UK, Republic of Ireland, Malaysia, Hong Kong, Australia and New Zealand. Ascribe Ltd. has offices in the UK, Kenya & Australia.

Data Production Specialist (SQL Developer)

Reporting to the Project & Group Projects Manager, The Data Production Specialist works as part of the Projects Team based in Kenya, and is primarily tasked with producing and enhancing the company’s implementation of data

conversions and database solutions.

Main purpose of job

The Data Production Specialist is responsible for data conversion and integration based on one to multiple data source(s) and destination(s), to proactively meet customer needs as defined in a Functional Specification.

Key Responsibilities:

• Design, develop, deploy and support SSIS/ETL Packages/Routines
• Design, develop and maintain MSSQL 2005/2008/2012 database objects such as tables, views, stored procedures, functions, triggers, indexes, constraints, etc.
• Analyze data to identify root-cause of issues related to data warehouse and ETL processes, and provide troubleshooting expertise in resolving technical issues
• Develop and automate ETL processes that follow standards and best practices and are highly optimized
• Create and amend Crystal Reports and other types of printed output

Qualifications and Experience:

• Bachelor’s degree in Computer Science or related discipline.
• Microsoft Certification in SQL
• Demonstrable experience with T-SQL, SSIS and Microsoft database tools. Experience with SSRS, SSAS an added advantage.
• Optimize T-SQL/SSIS performance and processing methods.
• Ensure accuracy and integrity of the data and applications through analysis, coding and problem resolution.
• Experience specializing in transforming XML, Flat files, or other delimited formats into RDBMS.
• Provide input into standards and best practices for code development.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Knowledge of Crystal Reports added advantage.
• Effective interpersonal and communications skills.

Send your CV not exceeding 2 pages and application letter detailing your experience, expected salary and why you are the right person for this job to jobsnow@ascribe.com by 25/03/2014.