Job description

We are currently seeking applications for the position of Business Analyst, SQL Developer. As a BA, SQL Developer, your responsibilities will include:

  Writing T-SQL Queries using joins and Sub queries in MS SQL Server.
  Developing complex queries involving multiple tables and Joins.
  Extracting, Transforming and Loading (ETL) data from MS ACCESS Database to MS SQL Server.
  Creating and modifying tables, fields, constraints in MS SQL Server.
  Creating or modifying stored procedures in MS SQL Server.
  Scheduling or modifying Jobs to automate in MS SQL Server.
  Knowledge in creating Views, Triggers, and Functions.
  Basic understanding of handling MS Access Database.
  Familiarity with SQL Server Analysis Services (SSAS), Integration Services (SSIS), and Reporting Service (SSRS).

Preferred qualifications:
  Design and Develop QlikView Dashboards.
  Designing Data model (Star / Snowflake Schema).
  KPI designing based on Business Requirements.
  Data fetching from QVDs and creation of QVDs.
  Knowledge in handling variables in QlikView.
  Basic understanding of Section Access.