BI Architect, Power BI Performance Specialist

🔥 1 hour ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Aevium

WebsiteLinkedInAll Job Openings

51 - 200 employees

💼 Consulting

🤖 Artificial Intelligence

☁️ SaaS

Consulting • Artificial Intelligence • SaaS

Aevium is a consultancy and execution partner created by former CTOs that combines AI strategy, engineering, and business vision to help companies prioritize and implement AI and technology solutions that move business indicators. They offer AI strategy (AI Polaris) to map and prioritize opportunities, governance, and 30/60/90 day roadmaps, and provide AI-augmented Smart Squads—multidisciplinary, mission-designed teams with accelerators and governance—to deliver execution capacity without simple staff allocation. Aevium targets complex, regulated or legacy environments and industries like fintech, healthtech, digital retail, banks, insurers, SaaS, industry, education, and logistics; focuses on governance, architecture, KPIs, and measurable impact; and emphasizes converting strategy into deliverable technical execution, AI agents in production, and modernization efforts.

📋 Description

• Assess and redesign the architecture of Power BI datasets and reports • Optimize queries in Power Query/M, DAX, and SQL • Create high-performance semantic models, with a focus on star schema • Reduce load times, memory consumption, and dashboard latency • Define high-performance analytical tables in platforms such as ClickHouse, SQL Server, AWS Athena/Redshift, or similar • Work with aggregated tables, snapshots, materialized views, and intermediate layers • Review relationships, cardinality, DAX measures, calculated columns, and filter usage • Support Power BI Embedded strategy, capacity planning, gateway configuration, and refresh processes • Establish best practices for publishing, governance, version control, and technical documentation • Collaborate with Data Engineering to improve pipelines and source data structures

🎯 Requirements

• Advanced Power BI • Advanced DAX • Power Query/M • Advanced SQL • Dimensional modeling • Performance Analyzer • VertiPaq Analyzer / DAX Studio • Star schema models, fact and dimension tables • Refresh optimization and DirectQuery/Import tuning • Creation of high-performance analytical tables • Experience with ClickHouse (advantageous) • Experience with Power BI Embedded (advantageous) • Knowledge of Lakehouse/Data Lake architecture (advantageous) • Experience in AWS environments (advantageous) • Familiarity with FinOps for BI (advantageous) • Data governance and metrics catalog management (advantageous) • Experience with large-scale data volumes (advantageous)

🏖️ Benefits

• 20 days of scheduled paid leave per year to rest, travel, or enjoy important moments with peace of mind • TotalPass, with access to gyms, nutritionists, and psychologists to support your physical and mental health and well-being