A.C. Coy

SQL BI Developer

US-PA-Pittsburgh
1 month ago(12/15/2017 4:12 PM)
Job ID
2017-17668
# of Openings
1
Category
Information Technology

Overview

Our client, is seeking a SQL and BI developer who will be responsible for designing databases and ensuring their stability, reliability, and performance, creating stored procedures holding the business logic for dynamic applications, and building and supporting SSAS cubes.  This is a Direct Hire position.

Responsibilities

  • Help write and optimize in-application SQL statements and stored procedures
  • Ensure performance and availability of databases
  • Design and create database structures, OLAP structures (fine tuning per customer requirements), and Star Schemas
  • Prepare documentations and specifications
  • Collaborate with other team members and stakeholders

Qualifications

  • Bachelor's degree in Computer Science, Information Science, or related work experience
  • 5-7 years of experience developing highly tuned T-SQL Stored Procedures and functions
  • 5-7 years of experience in database design including referential integrity, with strong understanding of key data elements, table indexing and database tuning
  • Experience with Microsoft SSAS, MDX Query development
  • Experience designing high performing reporting data structures, STAR Schemas, SSAS Cubes and MDX query building
  • Experience with SSAS with understanding of inter-platform data transfers such as Oracle to SQL ETL process and vice versa, and with the following tools: MS SQL Server Management Studio 2012 and MS SQL Data Tools 2012
  • POWER BI experience required
  • Ability to solve complex problems, strong analytical skills and the ability to trace issues to the root source
  • Highly motivated and self-directed; independent worker, self starter, ability to work without direct supervision
  • Experience with live data handling, particularly in situations involving sparse and/or incomplete data sets
  • Ability to develop and execute on detailed design documents and work plans from high-level requirements and specifications
  • Able to work nights and/or weekends as required
  • Strong problem-solving skills

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed