Data Analyst

Sky I.T. Group

New York (NY)

Sur place

USD 70 000 - 110 000

Plein temps

Il y a 32 heures
Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

Sky I.T. Group is seeking a Data Analyst to join our New York team. You will collaborate with ETL leads and business analysts to translate requirements into robust data solutions and build database objects using T-SQL in DEV and PROD environments.

You will design data collection and archiving strategies, perform profiling and tuning, and ensure data quality and integrity across the ETL process. A strong foundation in statistics or analytical finance supports success.

Qualifications

  • Bachelor's degree required in statistics, mathematics or analytical finance.
  • Experience with ETL, data warehousing, and data quality.
  • Ability to design database objects and optimize SQL performance.

Responsabilités

  • Collaborate with ETL Lead, Solution Architect and BAs to map business requirements to data solutions.
  • Develop database objects (Procedures, Functions, Packages, Triggers, Indexes, Views) using T-SQL in DEV and PROD.
  • Design data collection, staging, movement, analytics delivery, data quality and archiving strategies.
  • Perform data profiling, source-target mappings, SQL tuning and implementation.
  • Identify opportunities to optimize ETL environment and implement data quality monitoring.
  • Provide post-implementation support and both short- and long-term resolutions.
  • Assist in project plans, assign steps and time estimations.
  • Establish identity columns and GUIDs/sequences for unique IDs.
  • Work with PK, FK, CHECK and DEFAULT constraints to ensure data integrity.
  • Generate reports to retrieve data and provide actionable insights using SQL components within ETL.
  • Analyze database performance with SQL and optimize indexes to improve queries.

Connaissances

SQL
T-SQL
ETL
Data Warehousing
Performance Tuning

Formation

Bachelor's Degree in Statistics, Mathematics, or Analytical Finance

Outils

SQL Server

Description du poste

Job Posting - Data Analyst
Data Analyst

Job Title: Data Analyst

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

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 .

Stop Cleaning Data.
Start Using It.
Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Data Analyst
Data Analyst

Remote Jobs • Alpharetta (GA)

Sur place
USD 65 000 - 90 000
Data Analyst
Data Analyst

staffit solutions • St. Louis (MO)

Sur place
Confidential
Data Analyst: ETL, SQL & Data Quality Specialist
Data Analyst: ETL, SQL & Data Quality Specialist

staffit solutions • St. Louis (MO)

Sur place
Confidential
Data Analyst
Data Analyst

Arsenault • Chicago (IL)

Hybride
USD 70 000 - 90 000
Paid Time Off (Vacation, Sick & Public Holidays)
Work From Home
Stock Option Plan
Data Analyst
Data Analyst

Akido Companies Internal Job Board • Indiana

Sur place
USD 60 000 - 75 000
Data Analyst
Data Analyst

Heat learning portal • États-Unis

À distance
USD 60 000 - 90 000
Data Analyst
Data Analyst

iQuartic Inc. • États-Unis

Sur place
USD 65 000 - 90 000
Data Analyst
Data Analyst

Winaxis LLC • Dallas (TX)

Sur place
USD 65 000 - 90 000
Data Analyst
Data Analyst

Winaxis LLC • Boston (MA)

Sur place
USD 70 000 - 90 000
Data Analyst
Data Analyst

InterEx Group • États-Unis

Sur place
USD 60 000 - 80 000