SQL Data Warehouse expert

Permanant
Islamabad
Posted 6 months ago

Aricrypta is seeking an SQL/Data Warehouse consultant for a full time position in our Islamabad office. The person will participate in tasks related to developing, fixing and updating tasks related to SQL data warehouse on azure environment.

As a data warehouse consultant, you will have the opportunity to work with famous clients across EU on variety of projects.

Responsibilities:

  • Design and develop data warehouse and related structures
  • Write stores procedures and functions according to customer needs
  • perform ETL related tasks
  • Use SSIS and Azure data factory for importing data into tables
  • Performance tune queries and stored procedures to keep the database and application optimized
  • Collaborate with other team members and customer to understand the requirement and deliver according to the business needs
  • Create cubes in SSAS when needed
  • Create reports in Power BI if any such need arises

Skills requirements

  • a bachelor’s degree in Computer Science, Information Systems, or related field
  • Minimum three years experience in data warehousing or related field
  • Strong analytical and problem solving skills
  • Fast learner to learn new technologies and tools
  • 2 to 5 years of experience writing and executing all aspects SQL Server including base SQL, Procedures, Functions, Triggers, etc.
  • Knowledge of SQL Tuning, Monitoring, and Performance measurement
  • Ability to read, understand, and alter existing SQL when necessary
  • Solid understanding of Relational Database Theory
  • Excellent verbal and written skills and the ability to thrive in a team environment

Nice to have

  • Reporting in Power BI, Qlikview or other related field
  • Experience in SSIS or other ETL tool
  • Experience with cube development

Benefits

  • Market competitive salary
  • Medical allowance
  • international travel
  • Opportunity to work with modern technologies in a challenging environment

For further information, please write an email to infor@aricrytpa.com

Job Features

Job CategoryData warehouse

Apply Online

A valid email address is required.
A valid phone number is required.