GeorgiaTEK Systems Inc. · 21 hours ago
Power BI architect
GeorgiaTEK Systems Inc. is seeking a Power BI Architect to design and develop complex PowerBI reports and dashboards. The role involves troubleshooting existing reports, integrating PowerBI with various data sources, and collaborating with stakeholders to ensure optimal performance and adherence to best practices.
Responsibilities
Design and develop complex PowerBI reports and dashboards with advanced calculations, ensuring optimal performance and scalability
Troubleshoot and optimize existing PowerBI reports by analyzing performance bottlenecks, refining queries, solving gateway issues and improving data refresh times
Integrate PowerBI with multiple data sources (SQL Server, Azure, APIs, Excel, 3rd party applications) and establish automated data refresh schedules and gateway configurations
Collaborate with stakeholders to gather requirements, create technical documentation, and provide best practices guidance on PowerBI governance and security
Qualification
Required
Design and develop complex PowerBI reports and dashboards with advanced calculations, ensuring optimal performance and scalability
Troubleshoot and optimize existing PowerBI reports by analyzing performance bottlenecks, refining queries, solving gateway issues and improving data refresh times
Integrate PowerBI with multiple data sources (SQL Server, Azure, APIs, Excel, 3rd party applications) and establish automated data refresh schedules and gateway configurations
Collaborate with stakeholders to gather requirements, create technical documentation, and provide best practices guidance on PowerBI governance and security
Strong data modeling skills with experience in star/snowflake schemas, normalization, and building relationships across multiple data sources
Advanced knowledge of PowerBI Service, Desktop, Report Server, including row-level security (RLS), deployment pipelines, and workspace management
Solid SQL skills and experience with database design, query optimization, and working with relational databases (SQL Server, Azure SQL, etc.)
Proficiency in data visualization best practices, performance tuning techniques, and integrating PowerBI with Azure services (Azure Analysis Services, Data Factory, Synapse)