DE&A - Core - Advanced Visualization & Cloud Reporting - Power BI

• 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.