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 Integration Specialist (SQL Developer)
Data Integration Specialist (SQL Developer)
2
Positions
Reporting to the Project & Group Projects Manager, The Data Integration 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 Integration 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:
Reporting to the Project & Group Projects Manager, The Data Integration 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 Integration 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 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 will be an added advantage.
- Experience
with T-SQL, SSIS and Microsoft database tools.
- Experience
with SSRS, SSAS an added advantage.
- Optimize
T-SQL/SSIS/ (SSRS an added advantage) code 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 before 31/01/2013.