Qualified candidates will have extensive knowledge regarding data extraction, transformation and loading (ETL); data warehousing; aggregation, reporting and data mining techniques. The Data Analyst will be responsible for ongoing delivery of current data work as well as ongoing efforts to improve data processes.

Production Data Management
You will be responsible for a certain group of client’s data to ensure that the data import process runs smoothly and to quickly be able to trouble shoot and fix when the import fails. You will also be responsible for any development of new SSIS packages for new imports of your clients data and be able to effectively communicate and work with the Business Analysts to gather data requirements, data mapping and QA of the client’s data. Additional duties are, bug fixing import and data cleansing issues, fine tuning and enhancing performance of existing store procedures.

Required Skills & Experience
-Strong Microsoft SQL Server 2005/2008 and Transact Structured Query Language (TSQL) skills.
-Capable of fine tuning SQL queries by use of indexing,
-Capable of writing and debugging complex SSIS packages.
-Data Cleansing
-Strong SSIS/DTS/ETL skills.
-Working knowledge of C#
-Working knowledge SSRS is preferred but not essential.
-Query optimization techniques, including table indexing and analyzing execution plans.
-Deep understanding of relational database concepts.
-Data Analysis – Experience consolidating disparate data sets into usable data.
-Ability to collaborate and communicate clearly with other team members and management.
-Preferred experience with following tools/technologies
-Preferred knowledge on these applications but not essential; LINQPAD, SVN, Red Gate.

Education & Background:
-B.S. in Engineering or Computer Science
-3+ years relevant hands on data management and design experience

This job description is not intended to be all inclusive. The candidate hired will also perform other reasonable related business duties as assigned by supervisor. The company reserves the right to revise or change job duties as needed. This job description does not constitute a written or implied contract of employment.