Job Description :
Role: Microsoft BI Developer (SSIS)
Location: Cary, NC
Microsoft BI Exp.: 5+ years
Duration: 1 year and extendable
BR/H on C2C: DOE
Hiring Mode: Contractual through IMPLEMENTATION PARTNER
Education: Bachelor Degree in computer science or equal academic qualification
Mode of interview: Video

Technical/Functional Skills
4-6 Years of Business Intelligence Development
At least 2 years of experience in Dimensional Modeling / Data Warehouse Design
Strong understanding of multi-tiered applications
Experience in MS BI stack (SSIS, SSAS, SSRS) 2012/2014/2016, and SharePoint 2010/2013, specifically in SSIS.
Demonstrated success in complex problem solving and an understanding of quality delivery.
Demonstrated ability to work with others having differing priorities/views/goals than your own; to meet your goals.
Understand and lead others in use of System Development Life Cycle (SDLC

Experience Required
Requires 4+ Years of experience with Microsoft SQL server 2005+.
Requires 4+ years of technical experience with T-SQL, SSIS, SSRS, SSAS, MDX, Stored Procedures and Triggers.
Must be willing to do Business Analyst type tasks as this role requires the developer to refine requirements and interact with customers
Knowledge in database applications, report writing, screen modifications, scripting and data structures.
Requires system experience working with end users.
Requires the ability to work independently and strong organizational skills with ability to prioritize multiple projects and requests
Requires knowledge of how errors impact users; database and applications.
Requires ability to recognize discrepancies and perform research to determine cause and correct errors.
Requires knowledge of software applications and ability to comprehend and research technical issues.
Requires ability to manage data in a production focused environment.

Roles & Responsibilities
Devise data strategies that address customer requirements
Build an inventory of data needed to implement the solution
Be knowledgeable about new opportunities for data acquisition and new uses for existing data
Develop data models for database structures
Design, document, construct and deploy database architectures and applications that are scalable, secure, high performance and reliable.
Implement measures to ensure data accuracy and accessibility
Combine new systems with existing data management solutions
Produce and enforce database development standards
Technical Design, Build, and Unit Test for a new SSAS Cube.
Support of objects developed during system and performance testing for brake-fix and performance tuning
Develop KT documentation and transition of project items developed to existing support team for ongoing support and maintenance
Collaborate with cross-functional teams and clients to define, design and deliver enhancements, new applications and technical solutions that meet the needs of the company, its clients and end users.
Research, evaluate and implement new technology to optimize application efficiency and usability.
Maintain records to document system and programming development and revisions.
Design modifications based on defined requirements and coordinates development efforts on maintained applications.
Ensure adherence to appropriate design, coding and source control standards.
Ability to translate business need into report needs.
If interested, please revert with resume, visa status, validity & expected BR/H on C2C at neha AT sierrasoln DOT com


Client : Confidential