Sr Data Engineer

JOB TITLE: Sr. Data Engineer JOB LOCATION: Remote WAGE RANGE : $55hr to $60hr JOB NUMBER: 26-00546 REQUIRED EXPERIENCE: Power BI Expert 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 Certifications (Preferred) Microsoft Power BI Data Analyst (PL-300) Microsoft Azure Data Engineer (DP-203) Microsoft Azure Solutions Architect Required Technical Skills Power BI (Expert Level) Power BI Desktop development Power BI Service administration Advanced DAX development Power BI data modeling Dataset optimization Incremental refresh Composite models DirectQuery architecture Power BI gateways Workspace management Power BI deployment pipelines Row-Level Security (RLS) Power BI REST API integration 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 Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.