Database Developer

KellyMitchell matches the best IT and business talent with premier organizations nationwide. Our clients, ranging from Fortune 500 corporations to rapidly growing high-tech companies, are exceptionally served by our 1500+ IT and business consultants. Our industry is growing rapidly, and now is a great time to launch your career with the KellyMitchell team.

Position Title:  Database Developer

Responsibilities:

  • Convert existing sql ETL jobs to SSIS packages
  • Convert existing multidimensional model to a tabular model and enhance it to support historical reporting
  • Set up and maintain the framework required for building, processing, querying and maintaining cubes
  • Write SSIS packages and/or SQL server jobs to process and maintain the cube efficiently
  • Write stored procedures to query the cube from SQL server using DAX and/or MDX

Requirements:

  • Must have MCSE: Business Intelligence certification
  • Minimum of 5 years of experience in T-SQL development with MS SQL Server
  • Must have minimum of 5 years of hands-on experience on Microsoft BI stack (SSAS, SSIS, SSRS)
  • Must be expert in building tabular and multidimensional cubes
  • Expert in writing SQL, MDX, DAX and Power ('M' language) queries
  • Must be able to use the advanced SSAS features such as adding KPIs, adding business intelligence and performing predictive analysis
  • Deep understanding of SQL Server product suite and architecture
  • Have strong data warehouse and data mart knowledge and concepts
  • Experience with reporting tools such as Power BI, Tableau

Mandatory

  • Must have MCSE: Business Intelligence certification
  • Minimum of 5 years of experience in T-SQL development with MS SQL Server
  • Must have minimum of 5 years of hands-on experience on Microsoft BI stack (SSAS, SSIS, SSRS)
  • Must be expert in building tabular and multidimensional cubes
  • Expert in writing SQL, MDX, DAX and Power ('M' language) queries
  • Must be able to use the advanced SSAS features such as adding KPIs, adding business intelligence and performing predictive analysis
  • Deep understanding of SQL Server product suite and architecture
  • Have strong data warehouse and data mart knowledge and concepts
  • Experience with reporting tools such as Power BI, Tableau

 
Published 9 hours ago
You can see similar jobs for here
Loading