Key Responsibilities:

  • Development and support tasks related to various components of Microsoft SQL Server and Azure platforms.
  • Implement ETL (Extract, Transform, Load) processes to correctly and efficiently process, transform, and load data into the data warehouse.
  • Create, optimize, and maintain complex SQL queries and scripts for data extraction and transformation.
  • Create and manage data pipelines to transfer information between different systems and data warehouses.
  • Ensure data quality, accuracy, and security through robust testing and verification procedures.
  • Optimize data architecture and processes for performance, scalability, and cost-effectiveness.
  • Create and generate reports and dashboards using BI tools (SSRS, Power BI) to provide actionable analytics to stakeholders.
  • Monitor and troubleshoot data warehouse applications.
  • Actively familiar with industry trends and best practices in data engineering, data warehousing, and reporting.

Requirements:

  • Minimum 3+ years of proven hands-on experience as a Data Warehouse Developer, with in-depth knowledge of data warehousing and ETL concepts.
  • 3+ years of experience and solid knowledge of MS SQL Server.
  • Strong knowledge of T-SQL; ability to write effective T-SQL code.
  • Experience in SQL query/execution plan/data model level performance tuning.
  • Experience in SSIS or other ETL tool.
  • Experience in Power BI, SSRS, or other BI/reporting tool.
  • Big Data technologies (Spark, Hive, Hadoop eco-system) and/or data warehousing technologies (e.g., Databricks, Snowflake, Teradata).
  • Programming languages: Java, Scala, Python, C#.
  • English language proficiency at B2 level (speaking, writing, reading).
  • Ability to write reports, business correspondence and procedure manuals.
  • Ability to effectively present information and answer questions to managers, clients, users and a wide audience.
  • Ability to effectively collaborate with people at different levels of the organization, with different needs and goals; including facilitation and teamwork skills.
  • Experience in the following technologies would be considered an advantage: Microsoft Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory.