Email

contact supportHub360  sales@supporthub360.com.au

Phone

contact supportHub360  +618 6166 7626

Microsoft Data Warehousing and Business Intelligence Consultant

General Experience:

  • 5 years+ experience of Business Intelligence / Data Warehouse development and delivery
  • Strong data modelling / design skills, required to be proficient in dimensional data models and cube design, Utilise best practices to select and design the data warehouse architecture
  • Ability to analyze various sources systems and data models
  • Ability to communicate technical information to various stakeholders
  • Report to Team lead who will provide project guidance and direction, your strong hands on skills will be put to the test and utilized on a daily basis
  • Ability to communicate with the Business Analyst, Technical Analyst when it comes to converting the requirement into specific development (ETL, Cube and report visualization) activities
  • Understand full SDLC and/or Agile Scrum
  • Strong knowledge of relational and OLAP database technologies – MS SQL Server & MS SQL Analysis Services, including programming in SQL / T-SQL scripting / VB Script / Power BI / DAX

Must Have skills

  • Extensive experience with Microsoft (SQL SERVER, SSIS, SSAS, SSRS and Power BI)
  • Strong knowledge of Database Administration activities
  • Experience with Version control mechanisms and iterative release / Agile methodologies
  • Write deployment scripts and manage deployments (debug release cutover issues and failures)
  • Strong skills in developing OLAP cube structures, writing and debugging complex MDX queries
  • Experience in BI, ETL and DB Performance tuning and handling large data processing

Preferred Skills

  • Knowledge of and Experience in other competing vendor solutions would be advantageous (Eg. DB : Oracle/PostgreSQL, ETL: Informatica/ODI/PDI, BI/Reporting : OBIEE, MicroStrategy, Pentaho BI, Tableau)

Data Visualization

  • Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
  • Convert existing reporting tools to a standardized reporting infrastructure using Microsoft products
  • In-depth knowledge and hands on development of BI Dashboards, Ad-Hoc Analysis, Publisher Report & Data Model

Data profiling and testing

  • Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling, data reconciliation while adhering to enforced development methodologies.
  • Determine testing needed to assure the functionality and integrity of reporting solutions

Soft Skills

  • Excellent written and verbal communication skills
  • Strong analytical and problem solving ability
  • Strong attention to detail and accuracy
  • Ability to learn fast and work independently
  • Knowledge of or Strong ability to translate knowledge to different tool sets

Qualification and Continual Learnings

  • Tertiary qualification in computer science or computer engineering degree or equivalent in relevant experience in the IT industry.
  • Formal training or certification in DB, SQL or ETL toolsets
Job Location: India

Apply for this position

Allowed Type(s): .pdf, .doc, .docx