Azure Data Engineer: Power BI & Data Pipelines Lead

Tech Mirrors; North Carolina; On-site; USD 110,000 - 170,000; Full time

Job summary

Tech Mirrors seeks a Data Engineer to design, develop, and optimize cloud data pipelines and analytics solutions. The role focuses on Azure Synapse Analytics, Power BI, and integrating Salesforce/Curam/Oracle data sources to support program needs.

Responsibilities include building ETL/ELT pipelines, data ingestion from Salesforce, data modeling, and optimizing performance and costs across the data platform.

Qualifications

• Analyze source systems and design, develop, and maintain scalable ETL/ELT pipelines using Azure Synapse, Azure Data Factory, and related Azure services.

Responsibilities

• 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.

Skills

Power BI dashboards

Power BI datasets

Power BI dataflows

JSON

CSV

Parquet

Azure Synapse

Snowflake

Databricks

SQL

Python

Scala

PL/SQL

T-SQL

Azure Cloud

ADLS

Delta Lake

Data modeling

Tools

Salesforce

Curam

Oracle

Job description

Tech Mirrors seeks a Data Engineer to design, develop, and optimize cloud data pipelines and analytics solutions. The role focuses on Azure Synapse Analytics, Power BI, and integrating Salesforce/Curam/Oracle data sources to support program needs.

Responsibilities include building ETL/ELT pipelines, data ingestion from Salesforce, data modeling, and optimizing performance and costs across the data platform.