Job Description
Key Responsibilities
· Design and develop advanced Power BI dashboards, reports, and visualizations tailored to business needs.
· Create and maintain reusable report components, templates, and themes to ensure consistency and scalability.
· Perform data extraction, transformation, and loading (ETL) using SSIS and complex SQL queries.
· Develop and optimize data models using Power BI and SQL Server Analysis Services (SSAS).
· Implement DAX expressions for calculated columns, measures, and KPIs.
· Ensure data accuracy, completeness, and consistency across all reporting layers.
· Debug and resolve issues in reports, data models, and ETL pipelines.
· Configure and manage Power BI gateways, scheduled refreshes, and row-level security.
· Collaborate with business stakeholders to gather requirements and deliver BI solutions aligned with business goals.
· Participate in Agile ceremonies, sprint planning, and code reviews.
· Maintain documentation for report logic, data sources, and business rules.
· Support ad-hoc reporting needs and mentor junior developers on BI best practices.
· Integrate Microsoft Fabric capabilities into BI workflows, including Copilot features for enhanced automation and user interaction.
· Work with diverse data sources including SQL Server, SharePoint, PostgreSQL, Salesforce, Excel, and cloud-based APIs.
Required Knowledge & Skills
Experience: 610 years in BI development, with a strong focus on Power BI and SQL.
· Proficient in Power BI Desktop and Power BI Service.
· Strong command of DAX for complex calculations and performance tuning.
· Experience with Power Query (M language) for data transformation.
· Familiarity with Power BI REST API and embedding reports in applications.
· Knowledge of Power BI Premium features including deployment pipelines and dataflows.
· Hands-on experience with Microsoft Fabric, including Copilot integration for report generation and data exploration.
· Experience working with multiple data sources including SQL Server, SharePoint Lists and Libraries, PostgreSQL, Salesforce CRM, Excel/CSV files, RESTful APIs and cloud connectors
· Advanced SQL for data manipulation, joins, subqueries, indexing, and performance optimization.
· Experience With Stored Procedures, Views, Functions, And Triggers.
· Ability to work with large datasets and optimize query performance.
· Understanding of Agile/Scrum practices and tools like Jira or Azure Boards.
· Experience working within enterprise frameworks and release procedures.
· Familiarity with development environments, staging, and production workflows.
· Strong analytical and troubleshooting skills.
· Excellent time management and multitasking abilities.
· Effective communication and stakeholder engagement.
Personal Attributes
· Good communication skills.
· Ability to easily fit into a distributed development team.
· Customer service oriented.
· Enthusiastic/High initiative.
· Ability to manage timelines of multiple initiatives.
