This site uses cookies. To find out more, see our Cookies Policy

Database Developer II in New Albany, OH at CRS Group

Date Posted: 11/17/2018

Job Snapshot

Job Description

Overview: The CRS Group is currently looking for a Database Developer II for one of our clients in the New Albany area. The CRS Group is a nationwide Staffing Firm who works primarily with Fortune 500 and Fortune 1000 corporations.
Job Description:
  • 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

  • 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

ss #82871
Qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or genetic information.