Remote Jobs RockRemote Jobs Rock

Associate Staff Engineer

📅 Aug 25, 2023
SQL Server Integration ServicesAzure SynapseAzure Data FactoryAzure Data Bricks

📜 Description

  • Expert in database development including SQL queries, stored procedures, views, and indexes.
  • Build data pipelines using Azure Synapse, Azure Data Factory, and Azure Data Bricks.
  • Create Notebooks in Azure Synapse for data ingestion, analysis, and pipeline construction.
  • Implement data integration (ETL) best practices and techniques.
  • Design data warehousing solutions using Star/Snowflake schema.
  • Understand relational structures and dimensional data modeling.

🛠️ Requirements

  • Proficient in SQL Server Integration Services and Azure Synapse.
  • Experience in database development and data pipeline construction.
  • Familiarity with ETL tools and data governance concepts.
  • Ability to create documentation for various purposes.
  • Exposure to Agile (Scrum) development practices.
  • Strong analytical skills and good communication abilities.
Full job description

Company Description

We are a Digital Product Engineering company that is scaling in a big way! We build products, services, and experiences that inspire, excite, and delight. We work at scale — across all devices and digital mediums, and our people exist everywhere in the world (15000+ experts across 26 countries, to be exact). Our work culture is dynamic and non-hierarchical. We are looking for great new colleagues. That is where you come in!

Job Description

Must have Skills : SQL Server Integration Services, Azure Synapse,

Job Description :

  • Expert in Database development (SQL queries, Stored procedures,views,indexes etc)
  • Expert in building data pipelines using Azure Synapse , Azure Data factory and Azure Data Bricks.
  • Good Exposure in creating Notebooks in Azure synapse for ingesting , analyzing and building data pipelines.
  • Expert in data integration (ETL) best practices and techniques.
  • Sound knowledge of Data Warehousing (Star/Snowflake schema) and solution designing concepts 
  • Good understanding of relational structures, dimensional data modelling 
  • Understanding of common ETL tools preferably SSIS Ability to design ETL unit test cases and debug ETL Mappings 
  • Familiarity with Data Governance concepts and tools (e.g. Data Quality tools, Master Data Management Tools) 
  • Experience in creating documentation for general and custom purposes
  • Exposure to Agile (Scrum) development practices
  • Should have good analytical ability
  • Good written & verbal communication skills

Qualifications

Additional Information

Trusted by Remote Workers