Azure Synapse & Power BI Data Engineer (Contract)

Intellibee; Raleigh (NC); On-site; USD 95,000 - 135,000; Full time

Job summary

Intellibee is seeking a Data Engineer specialized in Power BI to design, develop, and optimize data pipelines on cloud platforms. The role focuses on Azure Synapse, Data Factory, and integrating Salesforce/Curam/Oracle data to support analytics and dashboards.

You will build scalable ETL/ELT pipelines, model data for BI reporting, and optimize performance while ensuring cost efficiency. Strong SQL and Python/Scala skills are required, along with hands-on data warehousing knowledge.

Qualifications

• Strong hands-on experience configuring, designing, developing and testing dashboards using Power BI.
• Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models.
• Experience working with JSON, CSV, Parquet, and other structured/semi-structured data formats.
• Strong experience designing and optimizing scalable data pipelines using Azure Synapse, Snowflake or Databricks.
• SQL mastery with advanced query writing, ETL/ELT, performance tuning.
• Programming languages: Python or Scala for data processing.
• Hands-on experience with PL/SQL procedures.
• Knowledge of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL).
• Familiarity with data warehousing concepts (star/snowflake schemas).

Responsibilities

• Analyze source systems and design, develop, and maintain scalable ETL/ELT pipelines on Azure Synapse and related services.
• Build and manage data ingestion workflows from Salesforce via APIs and schema alignment.
• Develop and maintain data models, transformations, and semantic layers for Power BI reporting.
• Optimize Synapse pipelines, SQL queries, and data storage for performance and cost efficiency.
• Troubleshoot pipeline failures, API issues, and Power BI dataset refresh problems.

Skills

Power BI

SQL

Python/Scala

ETL/ELT

Data modeling

API integrations

Data governance

Tools

Azure Synapse

Azure Data Factory

Power BI

Salesforce API

Curam/Oracle

ADLS

Delta Lake

Snowflake

Databricks

Job description

Intellibee is seeking a Data Engineer specialized in Power BI to design, develop, and optimize data pipelines on cloud platforms. The role focuses on Azure Synapse, Data Factory, and integrating Salesforce/Curam/Oracle data to support analytics and dashboards.

You will build scalable ETL/ELT pipelines, model data for BI reporting, and optimize performance while ensuring cost efficiency. Strong SQL and Python/Scala skills are required, along with hands-on data warehousing knowledge.