Sr. Data Engineer- Power BI expert

Role : Sr. Data Engineer- Power BI expert
LOCATION: Remote
Long Term Contract/Contract to Perm Potential


REQUIRED EXPERIENCE:
PowerBI Expert

JOB DESCRIPTION
We are seeking a Senior Data Engineer with strong Power BI expertise to design and deliver enterprise-grade data pipelines, data models, and business intelligence solutions on the Azure platform. The ideal candidate will possess deep experience in Azure Data Factory, advanced SQL development, and enterprise Power BI architecture, enabling the organization to transform complex datasets into scalable analytics platforms and executive dashboards.

This role requires expertise in data engineering, BI architecture, data modeling, performance optimization, and governance of Power BI environments.

Key Responsibilities
Data Engineering & Pipeline Development

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

Power BI Development & Architecture (Core Responsibility)

• Design and implement enterprise Power BI semantic models and datasets.
• Develop high-performance Power BI dashboards and analytical reports for business and executive leadership.
• Build complex DAX calculations, measures, and KPIs.
• Design optimized data models using star schema and dimensional modeling.
• Implement row-level security (RLS) and object-level security (OLS).
• Manage Power BI Service workspace architecture and deployment pipelines.
• Implement Power BI data governance and best practices.

Advanced Power BI Responsibilities

• Optimize Power BI dataset performance and query efficiency.
• Implement incremental refresh strategies for large datasets.
• Design DirectQuery, Import, and Composite models based on business needs.
• Manage Power BI gateway configuration and performance tuning.
• Implement Power BI deployment pipelines (Dev / QA / Prod).
• Build enterprise semantic layers supporting multiple reports.

Data Modeling & Data Warehouse Design

• Design enterprise data warehouse and data mart architectures.
• Implement dimensional modeling (Star/Snowflake schema).
• Develop curated data models optimized for Power BI consumption.
• Ensure data consistency, conformance, and governance.

SQL Development

• Develop advanced SQL queries, stored procedures, and functions.
• Optimize SQL workloads through:
  • Indexing strategies
  • Query optimization
  • Partitioning
• Implement data validation, reconciliation, and quality frameworks.

Azure Data Platform Development

Work with the following Azure services:

• Azure Data Factory
• Azure Data Lake Storage
• Azure SQL Database
• Azure Synapse Analytics
• Azure Blob Storage
• Azure Key Vault
• Azure DevOps

Performance Optimization

• Monitor and optimize data pipelines and Power BI datasets.
• Implement parallel processing frameworks.
• Ensure high-performance reporting for large enterprise datasets.
• Troubleshoot Power BI refresh failures and query performance issues.

Azure Data Engineering

• Azure Data Factory pipeline development
• Data orchestration and scheduling
• Azure Data Lake
• Azure Synapse
• Azure Storage

SQL / Data Engineering

• Advanced SQL and T-SQL
• Stored procedures and functions
• Query optimization
• Data warehousing design

Programming (Preferred)

• Python for data transformation
• REST API integrations
• JSON / XML data processing

Email- Phone Number : +1 321 7856 062

STELLENT IT A Nationally Recognized Minority Certified Enterprise

"Happiness can be found, even in the darkest of times, if one only remembers to turn on the light."
- JK Rowling