Senior Power BI Developer
First seen by Alion on Aug 29, 2026.
Responsibilities :
- 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.
Skills
Power BI, SQL, DAX Power BI, ETL, Data Analytics, Artificial Intelligence, Data Ingestion, Power Query M