Data Analyst

Job Title: Data Analyst

Worksite: 345 7th Avenue, Floor 14, New York, NY 10001

Rate of Pay: $82,763.00 per year

Data Analyst is needed to perform the following duties:

·         Work closely with the ETL Lead, Solution Architect and Business Analysts to understand business requirements, providing expert knowledge and solutions on Data Warehousing, ensuring delivery of business needs in a timely cost-effective manner.

·         Create database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment.

·         Evaluate and design data collection, data staging, data movement, analytics delivery, data quality and archiving strategies.

·         Perform data profiling, source-target mappings, SQL tunings and optimization, testing and implementation.

·         Identify opportunities to optimize the ETL environment, implement monitoring, quality, and validation processes to ensure data accuracy and integrity.

·         Provide post-implementation support, respond to problem quickly and provide both short- and long-term resolutions.

·         Assist in developing project plans, assigning the appropriate process steps and time estimations.

·         Establish, update, and delete identity columns as surrogate keys and used GUID and sequences for unique identification.

·         Work with multiple constraints including primary key, foreign key, check, default to ensure the data integrity.

·         Generate reports to retrieve data and provide actionable insights using function, views, Stored Procedures within the ETL process.

• Analyze database performance with SQL query manager and Optimize indexes to significantly improve queries.

Bachelor's Degree is required in Statistics, Mathematics, or Analytical Finance .

Apply: Mail CV to Joseph Cassidy, 345 7th Avenue, Floor 14, New York, NY 10001.