REF # 1906313
Views:

2,094 total views, 3 views today

Location:
Cape Town

Technical Consultant (SQL)

Enquire / Apply

ENVIRONMENT:

A leader in cloud-based analytics solutions seeks a Technical Consultant with strong SQL skills to join its team. Your core role will be the design, configuring, implementation and support of products with the aim or providing innovative solutions that add value to clients. You require a Computer Science/Information Systems Degree or related with at least 2 years’ experience writing T-SQL queries, stored procedures & functions, practical experience with MSSQL & exposure to SSIS/ETL tools. Any C#, SSRS or Crystal Reports and Data Warehousing experience will prove beneficial.

 

DUTIES:

Attend and participate in daily stand-ups.

Design investment data and compliance solutions based on specifications provided by Business Analysts and Senior Consultants/Architects.

Implement ETL and data integration tasks.

Develop enquiries, dashboards and reports.

Guide, advise and provide support to clients based on existing implementations.

Provide technical training to clients.

Construct custom SQL queries against product databases (MS SQL Server) turning large volumes of data into usable information, applying business rules where applicable.

Collaborate closely with team members, sharing knowledge regarding best practices and experience gained.

Work towards making clients self-sufficient by creating solutions that are automated, transparent, simple and well documented.

Assist clients with product upgrades to enable enhanced features or resolve issues.

Interact with the product developers to ensure that the evolution of the product aligns with client needs.

Improve your technical skills and that of the team.

Grow your knowledge of the investment management industry.

 

REQUIREMENTS:

A Computer Science / Information Systems Bachelor’s Degree or related with excellent results.

Minimum of 2 Years’ –

Writing T-SQL queries, stored procedures and functions.

Practical experience with MSSQL.

Exposure to SSIS or ETL tools.

 

Nice-to-haves –

Finance Degree or qualification.

C# knowledge.

Experience working in the Investment management or related industry.

Exposure to reporting (SSRS or Crystal).

Data Warehouse design and the principles of the ETL process, BI, compliance or investment accounting systems in an Asset Management or related organisation.

 

ATTRIBUTES:

A smart individual looking to grow and make an impact.

A passion to deliver innovative solutions to our clients, quickly and of a high level of quality.

Commitment to being part of a young and dynamic team focused on excellence

An eagerness to work directly with clients and the ability to communicate professionally and effectively

A willingness to learn about our products and adopt our implementation methodology.

An interest in the investment management industry and making sense of investment data.

 

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 bethany@datafin.com and mention the reference numbers of the jobs.

Tags
Degree, Permanent

Apply for this vacancy:

Attach CV