Senior Power BI Developer - Advanced Analytics & AI

Responsibilities Include

• Event-Driven Analytics: Design, develop, and maintain interactive Power BI dashboards focused on large-scale event analytics and operator activity tracking.
• AI-Driven Data Analysis & Insights: Leverage AI tools and modern AI-assisted features (e.g., Copilot for Power BI, generative AI for data analysis) to accelerate insight generation, automated summary drafting, and analytical workflows.
• End-to-end Dashboard Ownership: Independently diagnose and resolve performance bottlenecks across the Power BI stack and associated reporting tools (data ingestion, Power Query/M language, DAX, and visual rendering).
• Stakeholder Collaboration & Timezone Alignment: Work during US East Coast hours (EST) to engage with clients, review reports early in the day, and translate ambiguous requirements into scalable analytical solutions.
• Advanced Calculations & Data Modeling: Build efficient star/snowflake schemas and develop complex DAX calculations, KPIs, and calculated columns optimized for high-frequency telemetry datasets.
• ETL & Data Integration: Create robust ETL workflows and integrate Power BI with SQL Server, Azure SQL, REST APIs, and enterprise data sources.
• Governance & Maintenance: Implement Row-Level Security (RLS), manage dataset refreshes, and maintain clear technical documentation.

Primary Skills

• Total Experience: 7+ years of hands-on Power BI development.
• AI Tools Exposure: Proven background and practical experience using AI tools for data analysis, automated querying, and insight development.
• Technical Depth: Demonstrated expertise across multiple reporting tools - advanced DAX, robust data modeling (star/snowflake schemas, relationships), and Power Query/M - with full-stack troubleshooting capabilities.
• Business Comprehension & Communication: Excellent communication skills to interact early-day with East Coast clients and articulate technical findings clearly.
• High-Volume Data & SQL Expertise: Strong proficiency in SQL (Azure SQL, SQL Server) and reporting on large-scale telemetry/user-activity log data.
• Optimization & Security: Deep experience in query folding, report performance tuning, and implementing Row-Level Security (RLS).

Secondary Skills

• Experience with AI/ML integration platforms (e.g., Azure OpenAI, Copilot, Python/R scripts for predictive analytics in Power BI).
• Knowledge of cloud data engineering & tools (Azure Data Lake, Synapse, Databricks) and automated pipeline integrations.
• Familiarity with Agile delivery practices and managing client-facing status reviews during EST working hours.

(ref:hirist.tech)