BI and SQL Specialist 22 views

Our client is a Media and Marketing company based in Johannesburg servicing the International market. They are seeking a BI and SQL Specialist for the Development Department.

Main objective

Responsible primarily for report and database development.

Key areas of responsibility

  • SQL server 2014+ relational database development
  • Stored procedures, Functions, triggers
  • SSIS and SQL queries
  • Developing SSRS reports
  • Writing more complex queries for specialized requirements on current and new projects
  • Develop operational reporting systems
  • Develop systems to support operations
  • Ensure that data sources cater for demands of ad hoc extracts
  • Operations and maintenance of standard, routine queries
  • Operate, maintain, enhance and optimize queries and systems
  • Ensure correct preparation of data for all operations
  • Additional tasks related to data extracts, automated operations and SQL queries as required
  • Assist with queries to support both business projects, operational and informational needs
  • Ensure that best practices are adhered to at all times

Skills and attributes

Strong attention to detail

  • Self-starter with the ability to handle multiple tasks in a fast-paced demanding environment
  • Ability to work under pressure and deliver on deadlines
  • Ability to liaise directly with users and have good communication skills

Technical skills

  • Mandatory SQL Skills
  • SQL Database design and architecture
  • Dimensional and relational design concepts
  • Writing T-SQL Scripts
  • Stored Procedures
  • Functions
  • Views
  • Understanding of data
  • Table management
  • Microsoft Reporting Services
  • Microsoft Integration Services
  • Microsoft SQL Server DBA skills
  • Knowledge of OLAP cubes
  • Excel knowledge (using PowerPivot, PowerQuery and PowerMap)

Advantageous Technical skills

 C# experience

  • Hadoop
  • Data Warehousing
  • MongoDB
  • Power BI

Qualifications and experience

 Business Intelligence experience including design and maintenance of dimensional data warehouses

  • Must have SQL server 2014+ and relational database development, Stored procedures, Functions, triggers, SSIS and SQL query experience
  • BSc Comp Science, industry qualifications or equivalent experience
  • A minimum of 3 years relevant experience
  • In depth knowledge of business data

Other qualifiers :

  • SSRS
  • SSIS
  • SSAS
  • Must have a BI background
  • Worked with SQL for at least 3 years minimum
  • Must have worked with C# for at least 1 year

 

 

 

More Information

Apply for this job

Leave your thoughts

Share this job

In Africa for the World!

Seven Recruitment and Consulting Solutions is a starting solutions provider in Recruitment and the wider Human Resources function based in Cape Town South Africa.

Contact Us

Phone: South Africa:
+27 74 783 7537

Phone: United Kingdom:
+44 7497 377394

Address:
239 High Level Road,
G1 Normanhurst,
Sea Point
Cape Town 8005 South Africa