Location : Central Region
Post Date : 01 November 2017
Employment Type : Permanent
Job Order Number : NMBISQL1
Line of Business : IT & Technology
Technology doesn't change the world - people do, and our client is looking for your outstanding skills as SQL Developer to complete a team of talented professionals who make a real difference every day. If you actively look for creative solutions to a problem, and you're passionate about developing new mobile platforms, this could be the opportunity you've been looking for to grow your career.
- Fine tune performance of ETL, stored procedures, and reports to keep databases and applications optimized; identify root causes in case of failures
- Work with technical and business teams to review, analyse and define requirements for new development and enhancements to/maintenance of existing systems.
- Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
- Design and implement data marts, meta data, and data models
- Design and develop SQL data models for end-users
- Develop advanced reports and dimensional analyses (Cognos), including multi-tab interactive dashboards, complex pixel-perfect reports with numerous prompts designed for bursting to end users etc.
- Create technical documentation on database content, ETL and mapping between databases
- Develop ad-hoc SQL to research data questions
- 7+ years of experience in business intelligence
- Strong working knowledge of MS SQL Server 2008/12 and Transact-SQL. SSIS, SSAS, SSRS knowledge is must
- Experience modelling and designing relational DBs, star schemas, and cubes
- Report development experience in Cognos
- Working knowledge of Cognos Framework Manager
Please send your resume, in WORD format only and quote reference number NM-BISQL-1, by clicking the apply button. Please note that only short-listed candidates will be contacted.
Co. Registration no.: 200612189E | EA Licence no.: 07C5595 | EA Registration no.: R1767726
One Raffles Place Tower 1