Job Description

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. Work with diverse data sources including SQL Server, SharePoint, PostgreSQL, Excel, Snowflake and cloud-based APIs.

Required Knowledge & Skills:

Experience

: 6-10 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. 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.