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.
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
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
The most pressing issue for businesses today is the quest for growth, and more than innovation, operations or even customer relationships, CEOs are looking for talent and leadership to secure and sustain it. People are truly an organization’s greatest asset.
With an active nationwide database of more than 500,000 seasoned professionals, A.C.Coy employs the latest tools to manage effective recruit...ing. The technology helps to quickly identify and contact the right candidates with the skills and experience clients need.
The tools that A.C.Coy uses provide a unique perspective regarding culture, performance, leadership, and team "fit". And our integration methodology ensures that new leaders are integrated quickly and successfully without breaking stride.