DWH Analyst
analyticstech
TrinoS3Airflow
5.1
AI Score
The vacancy has clear tasks but lacks compensation details and company information.
All vacancies
Job description
Extil is looking for a DWH Analyst to gather and document requirements, analyze data sources, and prepare SQL migration scripts.
Responsibilities
• Communication with the Client, identifying and analyzing requirements
• Documenting requirements for the Data Warehouse and data
• Surveying Data Sources
• Preparing scripts for migration in SQL
Requirements
• Gathering requirements (BT, FT, NFT)
• Documenting requirements: data dictionaries, S2T mappings, description of algorithms and transformations
• Experience conducting Discovery on data sources
• Theoretical and practical knowledge of databases (structure, queries and optimization, table properties)
• SQL (Experience with procedures and functions, JOIN, groupings, window functions, experience with table configuration during creation)