1037 PowerBi Fabric / Databricks / AI Consultant

Apex Systems; Irving (TX); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

Employee stock purchase program

401(k) with company match

Health Savings Account

Professional development opportunities

Job summary

A leading technology solutions provider in Texas is seeking an experienced professional to design and implement modern analytics and data platform solutions. The successful candidate will be responsible for architecting Power BI solutions, optimizing SQL Server platforms, and providing technical guidance to clients. Strong hands-on experience in Power BI, Microsoft Fabric, and SQL Server is required. Benefits include insurance options, a 401(k) plan with matching, and opportunities for professional development.

Qualifications

• Deep expertise in enterprise BI architecture and performance optimization.
• Strong hands-on experience in Power BI and SQL Server environments.
• Knowledge of row-level security and governance controls.

Responsibilities

• Design enterprise Power BI architectures and optimize dashboard solutions.
• Implement SQL Server data platforms ensuring high availability and performance.
• Engage with customers, providing technical leadership and training.

Skills

Power BI solution design

DAX

SQL Server performance optimization

Data modeling

Performance tuning

Tools

Power BI

SQL Server

Azure Databricks

Tableau

Microsoft Fabric

Job description

Job #3026690

Role Overview

This role focuses on designing and implementing modern analytics and data platform solutions, enabling organizations to leverage Power BI, Microsoft Fabric, and SQL-based architectures for scalable, high-performance data analytics and reporting. The successful candidate acts as a trusted technical advisor and solution architect, guiding customers’ database, engineering and other teams through design, implementation, migration, and optimization of modern data platforms. The role bridges data engineering, analytics, and business intelligence to maximize the value of data through Fabric-powered analytics and Power BI-driven insights.

Core Responsibilities

• Power BI and Analytics Solutions (80%): design enterprise Power BI architectures, develop and optimize semantic models, DAX calculations, dashboards, and Power BI Embedded solutions. Lead or execute Tableau to Power BI migrations. Implement security models including Row Level Security (RLS) and governance controls.
• SQL Platform (20%): focus on performance, high‑availability, and fail‑over clustering. Design, implement, and optimize SQL Server–based data platforms, ensuring scalability, security, and high performance.
• Customer and Delivery Engagement: provide technical leadership in customer‑facing engagements, engage with IT executives and business leaders, deliver training and upskilling workshops.

Technical Skills (Power BI)

• Power BI solution design and Power BI Embedded development
• Tabular data modeling and database design
• Optimize tabular data models
• Troubleshoot slow running Power BI and paginated reports
• DAX, Power Query M language development and optimization
• Paginated report development (SQL Server Reporting Services)
• Data connectivity best practices to SQL, Analysis Service, Oracle, MySQL, Azure, AWS
• Optimize performance across datasets, semantic models, and reports
• Familiar with Power BI REST API
• Build data pipelines using Power Query
• Fabric Lakehouse, Warehouse, One Lake, data pipelines, and semantic models
• Direct Lake vs Import vs Direct Query decisioning
• GitHub Copilot and Power BI Copilot use for productivity and AI‑assisted analytics
• Modernize on‑prem data warehouses to Azure‑based architectures (Azure Synapse / Fabric)
• End‑to‑end analytics architecture spanning ingestion, transformation, semantic modeling, and BI consumption
• Design Direct Lake, Import, and DirectQuery strategies
• Spark, Python or other coding skills; Azure Databricks advantage

Technical Skills (SQL)

• Performance optimization – query tuning, indexing, partitioning
• High availability and disaster recovery
• SQL code reviews; dissect query plan, T‑SQL code
• Data encryption and replication
• SQL edition and version differences management
• Storage management, capacity planning, policy‑based management
• Extended events and traces
• Windows Failover Clustering
• SQL Server Reporting Services, SQL Server Analysis Services
• Azure SQL Database: performance tuning, security & compliance (Azure AD auth, managed identity, TDE, always encrypted, auditing, ATP, Defender for SQL)
• High availability & resiliency – built‑in HA, geo‑replication, auto‑failover groups
• Scaling & cost optimization – elastic pools design and optimization

Qualifications

• Deep expertise in enterprise BI architecture, semantic modeling, modern data warehouse patterns, performance optimization.
• Strong hands‑on experience in Power BI, Microsoft Fabric, and SQL Server environments.
• Experience with Power BI Embedded and application integration.
• Experience leading or executing Tableau to Power BI migrations.
• Knowledge of row‑level security and governance controls.
• Experience designing and optimizing SQL Server‑based data platforms.
• Strong performance tuning background for SQL Server.
• Excellent communication and customer‑facing skills.

Benefits

• Medical, dental, vision, life, disability insurance.
• Employee stock purchase program (ESPP) and 401(k) with company match.
• Health Savings Account (HSA).
• Employee Assistance Program (EAP) with counseling sessions.
• Corporate discount savings program.
• Professional development: on‑demand training, certification prep, library of technical and leadership courses.
• Career coaching and support teams.

Equal Opportunity Employer

Apex Systems is an equal opportunity employer and welcomes applications from all qualified candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.