What are the responsibilities and job description for the Data Engineer with SQL and Snowflake position at N Consulting Ltd?
Role :Data Engineer with SQL and Snowflake
Duration: 6 months
Location: Edinburgh(Hybrid)
Required Skills and Qualifications:
- Proven experience working with SQL Server (e.g., T-SQL, Stored Procedures, Indexing, Query Optimization, System Catalog Views).
- Strong experience in Snowflake architecture, including data loading, transformation, and performance tuning.
- Proficient in ETL processes using tools such as Informatica PowerCenter and BDM, AutoSys, Airflow, and SQL Server Agent.
- Experience with cloud platforms preferably AWS.
- Strong knowledge of AWS cloud services, including EMR, RDS Postgres, Redshift Athena, S3, and IAM.
- Solid understanding of data warehousing principles and best practices.
- Strong proficiency in SQL for data manipulation, reporting, and optimization.
- Knowledge of data modeling and schema design.
- Experience working with large, complex datasets and implementing scalable data pipelines.
- Familiarity with version control tools such as GitLab.
- Experience with data integration, data governance, and security best practices.
Salary : $300 - $350
