SSIS/BI Analyst

Georgia  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

Location: Kennesaw
Status: Contract
Compensation: Submit Competitive Rate
Education Level: Not Specified

SSIS/Business Intelligence Analyst opportunity in Cobb County.
Local client is searching for a Analyst that will be responsible for requirements gathering, design, development, and maintenance of high transaction database systems and rich data sets.

Experience and Skills Required.
Education Level:

  • Bachelor Degree or its equivalency (2 years of exempt level = 1 year of college, combination of experience and education may be used to meet the degree requirement) in Computer Science, Information Systems, or other related field that provides the required knowledge and skills in current industry principles and practices.

Experience:

  • 4+ years Business Intelligence and Data Warehousing work experience.
  • 4+ years requirements analysis and management.
  • Expert knowledge of SSIS, SSAS, SSRS, and ETL.
  • Strong knowledge of relational and dimensional data modelling techniques, data warehousing concepts, and data mining concepts.
  • Experience in designing OLAP cubes using SSAS and writing MDX.
  • Experience with data modelling to design high transaction SQL databases.
  • Expert experience writing TSQL, triggers, and complex stored procedures.
  • Excellent analysis and problem-solving skills.
  • Consulting skills to gather requirements and lead analysis and user interface design discussions.
Essential Duties:
  • Understands complex database concepts as well as the implications of different database designs on performance, scalability and maintainability.
  • Writing Transact-SQL statements, stored procedures, and views using industry best practices for security and efficiency.
  • Define business requirements with user groups; translate into technical specifications and develop ETL strategies.
  • Conduct index and performance analysis to ensure solutions provide optimal performance.
  • Creates and maintains SSIS packages.
  • Evaluate, recommend, and implement tools, technologies, and processes to ensure reliability, performance, security, and scalability.
  • Continuous evaluation of database design and/or code to accommodate changing and new requirements.
  • Deliver work products that meet requirements and specifications, are free of defects, and have optimal performance.
  • Ongoing education and research to remain current on emerging technologies and best practices.
  • Mentor CCSD team members specific to the solution and techniques utilized in the design and development.
  • Perform other duties as assigned by appropriate administrator.
MATRIX offers a comprehensive benefits package including a choice of medical plans, dental, vision, life, disability and we subsidize up to 70% of the cost!

Application Requirements
  • Client will not accept subcontractors

Required Qualifications:

  • SSIS
  • ETL
  • OLAP
  • SQL
  • SSAS
  • SSRS
Benefits/Perks
  • Medical
  • Dental
  • Vision
  • and Life Insurance for Full-time W2 Consultants. Supplemental Disability and Long-Term Care Insurance
  • Dependent Care Assistance. 401(k) with Roth feature. Free E-learning Courses

About MATRIX
Whatever your career destination, we're how you get there. For more than 27 years, MATRIX has placed talented contract and permanent IT professionals like yourself at thousands of top-notch organizations throughout the U.S., ranging from Fortune 50 to small IT shops across all industries.
MATRIX surrounds you with personal services from assistance with your Resume and interviewing skills, to background information on the companies you will interview with, and more.
Once you are onboard as a MATRIX consultant, we offer outstanding benefits, a 401(k) program (or plan), discounted training, and other valuable incentives.

Apply today at MATRIX.

Please Note: Your Resume will never be submitted to a client company without your prior knowledge and consent to do so.

Start date
n.a
From
MATRIX Resources, Inc.
Published at
30.07.2012
Project ID:
399276
Contract type
Freelance
To apply to this project you must log in.
Register