Previous Job
Previous
SQL Data Analyst
Ref No.: 17-29581
Location: New York, Wisconsin
Required Skills :
SSIS,SQL, TSQL, SSRS

Basic Qualifications :
1. SQL Server Management Studio
2. Able to write complex SQL Scripts, Functions, and Stored Procedures
3. Good understanding of Data Relational Models.
4. Able to create/maintain SSIS packages to import Excel Spreadsheets to SQL database
5. Able to use SSRS to generate ad hoc reports

Job Description :
Apex Systems is looking for a SQL Data Analyst, 12 month contract.
The ideal candidate will support the Financial Data reconciliation team by creating SSIS packages to import Excel data into SQL database, coordinate data restores with the DBA, create scripts to extract data on demand, create ad hoc reports using SSRS, and analyze data to assist on the discovery of reconciling differences. The candidate will be able to work under pressure on a high demand environment, providing data extracts to multiple team members on short notice.
Role:
1. Compile and upload data needed for Financial Reconciliation
2. Create ad hoc reports and data extracts needed for Financial Reconciliation 3. Assist on research of reconciling differences
Multiple high priority data request. Need to be able to work under pressure while maintaining good quality and precision. Need to double check numbers before delivering.
Required Technical Skills (software, hardware, programming, discipline)
1. SQL Server Management Studio
2. Able to write complex SQL Scripts, Functions, and Stored Procedures
3. Good understanding of Data Relational Models.
4. Able to create/maintain SSIS packages to import Excel Spreadsheets to SQL database
5. Able to use SSRS to generate ad hoc reports
Preferred Skills (may include addt’l tech skills or soft skills)
1. Able to write complex SQL Scripts, Functions, and Stored Procedures
2. Good Analytical Skills
3. Thorough and organized