Power BI and Data engineer

Data Engineer – Azure / Power BI

Position Overview
We are seeking an experienced Data Engineer to design, develop, and optimize scalable data pipelines and analytics solutions on cloud-based data platforms. The role will leverage Azure Synapse Analytics, Azure Data Factory, Power BI, and integrations with Salesforce or Curam/Oracle to support business and program needs.

Key Responsibilities

• Design, develop, test, and maintain scalable ETL/ELT pipelines using Azure Synapse, Azure Data Factory, and related Azure services.
• Develop data ingestion workflows from Salesforce, including API integrations, schema alignment, and performance optimization.
• Build and maintain data models, transformations, and semantic layers for Power BI reporting and analytics.
• Develop and optimize Power BI dashboards, datasets, dataflows, and DirectQuery/Import models.
• Optimize Synapse pipelines, SQL queries, and data storage for performance, reliability, and cost efficiency.
• Work with structured and semi-structured data including JSON, CSV, and Parquet.
• Troubleshoot pipeline failures, Salesforce API issues, and Power BI dataset/dataflow refresh problems.
• Develop efficient PL/SQL procedures and perform SQL/T-SQL query optimization.

Required Skills

• Power BI: 5+ years of hands-on experience designing, developing, configuring, and testing dashboards.
• Power BI Datasets/Dataflows: 5+ years supporting datasets, dataflows, and DirectQuery/Import models.
• SQL: 5+ years of advanced SQL, ETL/ELT, query writing, performance tuning, and optimization.
• PL/SQL: 5+ years developing efficient PL/SQL procedures.
• Data Pipelines: 3+ years designing and optimizing scalable pipelines using Azure Synapse, Snowflake, or Databricks.
• Python or Scala: 3+ years of strong programming experience for data processing.
• Structured/Semi-structured Data: 3+ years working with JSON, CSV, Parquet, and similar formats.
• Azure: 2+ years of experience with Azure Synapse, ADLS, Azure Data Factory, Azure SQL, and Azure monitoring tools.
• ADLS / Delta Lake / Data Warehousing: 2+ years of experience with ADLS, Delta Lake, data modeling, star schema, and snowflake schema.
• T-SQL / Scripting: 2+ years of experience with SQL, T-SQL, scripting, and query optimization.

Preferred/Additional Experience

• Salesforce API and data integration experience.
• Experience integrating data from Salesforce, Curam, or Oracle.
• Experience with Azure-based analytics and enterprise data warehouse environments.
• Strong troubleshooting and performance-tuning experience across data pipelines and Power BI.