Data Warehouse Developer

Share and send to your friends !
Data Warehouse Developer
Benefits: Negotiable
Location: Cape Town
Job policy: Employment Equity position
Type: Permanent
Reference: #21362
Company: Datafin Recruitment

An innovative investment firm seeks the coding talents of a highly meticulous and self-driven data warehouse developer with a passion for data-driven systems. Your role will include developing integration solutions utilising T-SQL and other vendor integration tools, ETL development to load Data Warehouse, maintain existing SSRS report definitions and testing and deployment of new development. The successful candidate must possess a Degree/Diploma in Information Science or related technical discipline, 5-8 years’ SQL experience - stored procedures, UDF’s, T-SQL, performance tuning and optimisation, RDBMS, error handling and logging, SSIS, SSRS, Power BI, knowledge of financial concepts and terms and work experience with relational and dimensional database structures.
Duties:
  • Work as part of a larger IT team using the Scrum methodology.
  • Interact with business users, Business Analysts and other Developers to understand user requirements.
  • Develop integration solutions using T-SQL and other vendor integration tools.
  • ETL development to load Data Warehouse.
  • Maintain existing SSRS report definitions to present the data.
  • Support existing integration and reporting solutions in the production environment by analysing problems reported by users and track down their cause through debugging techniques and discussion with other team members.
  • Testing and deployment of new development.

Requirements:
Qualifications –
  • Degree or diploma in information science or related technical discipline.

Experience/skills –
  • 5-8 years SQL experience (stored procedures, UDF’s, T-SQL, performance tuning and optimization, RDBMS, error handling and logging, etc.) is essential.
  • Experience with data integration, validation and reconciliation (SSIS or similar).
  • Expert knowledge of reporting technologies (SSRS, Power BI or similar)
  • Working experience with relational and dimensional database structures.
  • Interacting with business users to understand requirements and producing solutions.
  • Knowledge of financial concepts and terms and interested in attending courses to improve business knowledge.

Advantageous –
  • Experience creating and maintaining cubes (SSAS).
  • Experience working in AWS Cloud implementation.
  • Exposure to PostgreSQL.
  • Financial Services industry experience.

Attributes:
  • Attention to detail and quality.
  • Problem-solving
  • Willingness to take initiative and responsibility.
  • Ability to meet deadlines and deal with pressure.
  • Ability to work effectively as part of a diverse team and cross-train with team members.
  • Strong analytical skills.
  • Good communication.

While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.
Comments:
When applying for jobs, ensure that you have the minimum job requirements. Only  SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please e-mail a word copy of your CV to target="_blank and mention the reference numbers of the jobs. We have a list of jobs on http://www.datafin.com . Datafin IT Recruitment - Cape Town Jobs.
Posted on 10 Jan 16:09, Closing date 9 Feb
Apply
Michelle Roberts
[email protected]
087 351 0743

General Details Location: , GreyvilleDurban City Advertised By: Agency Job Type: Part-Time Description To ensure the accurate and timeous accounting and reconciliation of company transactions and the production of the…
General Details Location: , Jeffreys BayEastern Cape Advertised By: Agency Job Type: Full-Time Description Our client based in Humansdorp is looking for an experienced a Quality Controller. (EE) Knowledge and…
General Details Location: , SwellendamOverberg Advertised By: Agency Company Name: van Leeuwen Consultancy Job Type: Contract Employment Equity: Non EE/AA Description ‘n Gesin met drie jong kinders, woonagtig op ‘n…
General Details Location: , OtherJohannesburg Advertised By: Agency Job Type: Contract Description Our client based in Sandton is seeking the expertise of an IT Business AnalystpetenciesCognitive| Analysis and Attention to…
General Details Location: , Bo-KaapCape Town Advertised By: Agency Job Type: Contract Description Supports regions, business units, and functions as a dedicated billing subject matter expert Aggregate, Calculate & Submit…
General Details Location: , StellenboschCape Winelands Advertised By: Agency Job Type: Full-Time Description We are looking for an experienced Scrum Master to coach and coordinate our development teams. Agile thinking…