Azure Data Engineer With Power BI Experience - Remote

The Dignify Solutions, LLC

Jersey City, NJ(remote)

JOB DETAILS
SKILLS
Analysis Skills, Application Programming Interface (API), Best Practices, Business Analysis, Business Intelligence, Centers for Disease Control and Prevention (CDC), Data Analysis, Data Lake, Data Management, Data Mart, Data Modeling, Data Sets, Data Storage, Data Warehousing, Database Extract Transform and Load (ETL), Desktop PC, DevOps, Dimensional Modeling, Identify Issues, Leadership, Microsoft Product Family, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Performance Analysis, Performance Management, Performance Metrics, Power BI, Power Engineering, Power Management, Query Optimization, REST (Representational State Transfer), Reporting Dashboards, SQL (Structured Query Language), SQL Databases, Snowflake Schema, Star Schema, Stored Procedures
LOCATION
Jersey City, NJ
POSTED
30+ days ago

Key Responsibilities

  • Design and implement scalable ETL/ELT pipelines using Azure Data Factory.
  • Build automated data ingestion pipelines from multiple enterprise systems, APIs, and data lakes.
  • Implement incremental loads, CDC frameworks, and automated data orchestration workflows.
  • Develop reusable data integration frameworks to standardize ingestion patterns.
  • Develop high-performance Power BI dashboards and analytical reports for business and executive leadership.
  • Build complex DAX calculations, measures, and KPIs.
  • Manage Power BI Service workspace architecture and deployment pipelines.
  • Implement Power BI data governance and best practices.
  • Design enterprise data warehouse and data mart architectures.
  • Implement dimensional modeling (Star/Snowflake schema).
  • Develop advanced SQL queries, stored procedures, and functions.

Azure Data Platform Development

  • Azure Data Factory
  • Azure Data Lake Storage
  • Azure SQL Database
  • Azure Synapse Analytics
  • Azure DevOps
  • Monitor and optimize data pipelines and Power BI datasets.
  • Ensure high-performance reporting for large enterprise datasets.
  • Troubleshoot Power BI refresh failures and query performance issues.

Required Technical Skills

  • Power BI Desktop development
  • Power BI Service administration
  • Advanced DAX development
  • Power BI data modeling
  • Dataset optimization
  • Power BI gateways
  • Power BI deployment pipelines
  • Power BI REST API integration
  • Azure Data Factory pipeline development
  • Data orchestration and scheduling
  • Azure Data Lake
  • Azure Synapse
  • Azure Storage
  • Advanced SQL and T-SQL
  • Stored procedures and functions
  • Query optimization
  • Data warehousing design

Preferred Experience

  • Experience building enterprise BI platforms serving 500+ users
  • Experience with Power BI governance frameworks
  • Experience integrating Power BI with Azure Synapse or Databricks
  • Experience building self-service BI platforms
  • Microsoft Power BI Data Analyst (PL-300)
  • Microsoft Azure Data Engineer (DP-203)

About the Company

T

The Dignify Solutions, LLC