Une candidature complète en une minute
Un CV et une lettre de motivation personnalisés, prêts à envoyer.
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.
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.
Bachelor's Degree is required in Statistics, Mathematics, or Analytical Finance .