Description

Key Responsibilities:
*) Analyze source systems and design, develop, and maintain scalable ETL/ELT pipelines using Azure Synapse, Azure Data Factory, and related Azure services.
*) Build and manage data ingestion workflows from Salesforce, including API integrations, schema alignment, and performance tuning.
*) Develop and maintain data models, data transformations, and semantic layers to support Power BI reporting and analytics.
*) Optimize Synapse pipelines, SQL queries, and data storage for performance, reliability, and cost efficiency.
*) Troubleshoot pipeline failures, Salesforce API issues, and Power BI dataset/dataflow refresh problems.
 
Skill Required / Desired/Amount of Experience:
*) Strong Hands-on experience configuring, designing, developing and testing dashboards using Power BI Required 5Years.
*) Experience supporting Power BI datasets, dataflows, and Direct Query/Import models Required 5Years.
*) Experience working with structured and semi-structured data formats (JSON, CSV, Parquet, etc.) Required 3Years.
*) Strong experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake or Databricks workflows Required 3Years.
*) SQL Mastery: Advanced query writing, ETL/ELT, performance tuning, and optimization Required 5Years.
*) Programming Languages: Strong proficiency in Python or Scala for data processing Required 3Years.
*) Hands-on experience in developing efficient PL/SQL procedures Required 5Years.
*) Experience with Programming and Scripting (SQL, T-SQL, and data query optimization) Required 2Years.
*) Solid understanding of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL, monitoring tools) Required 2Years.
*) Experience in Azure Data Lake Storage (ADLS), Delta Lake, and data modeling concepts and Warehousing (star schema, snowflake schema)Required 2Years

Key Skills

Education

Bachelor's degree