Power BI Developer

Roles and responsibilities

We are seeking a skilled Power BI & MicroStrategy Developer with foundational knowledge of PL/SQL to join our dynamic team. The ideal candidate will design, develop, and maintain business intelligence solutions, enabling actionable insights for business stakeholders.

Key Responsibilities

• Design, develop, and deploy interactive dashboards and reports using Power BI and MicroStrategy.
• Collaborate with business users to understand reporting requirements and translate them into technical solutions.
• Optimize dashboards and reports for performance and scalability.
• Develop and maintain database queries and procedures using PL/SQL for data extraction and manipulation.
• Ensure data accuracy, consistency, and integrity across BI platforms.
• Provide technical support and troubleshooting for Power BI and MicroStrategy solutions.
• Stay updated on the latest BI technologies and trends to recommend improvements and best practices.
  

Qualifications And Skills

• Experience: 3+ years of hands-on experience in Power BI and MicroStrategy development.
• Technical Skills:
• Strong expertise in creating visualizations, dashboards, and reports in Power BI and MicroStrategy.
• Basic knowledge of PL/SQL for database queries and procedures.
• Understanding of data modeling, data warehousing, and ETL processes.
• Power BI Desktop: Expertise in developing reports and visualizations using Power BI Desktop.
• Power BI Service: Knowledge of the Power BI Service for report sharing, collaboration, and distribution.
• DAX (Data Analysis Expressions): Proficiency in writing DAX for measures, calculated columns, and advanced analytics.
• Power Query / M: Familiarity with Power Query and M language for data transformation tasks.
• SQL: Strong SQL skills to query relational databases, create views, and optimize queries for use in Power BI.
• Data Modeling: Strong understanding of data modeling concepts, including star/snowflake schemas, relationships, and cardinality.
• ETL Tools: Experience with data extraction, transformation, and loading (ETL) processes, particularly using Power BI tools.
• Azure: Knowledge of Azure services such as Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics for cloud-based data storage and analysis.

Desired candidate profile

1. Data Modeling and Transformation

• Data Extraction and Integration: Extract data from various sources like SQL Server, Excel, CSV, cloud databases (e.g., Azure, Google BigQuery), and external APIs, then integrate it into Power BI.
• ETL (Extract, Transform, Load): Use Power Query and other tools to clean, transform, and load data from multiple sources into Power BI datasets. This may include removing duplicates, merging data, handling missing values, and normalizing data.
• Data Modeling: Create efficient and effective data models by building relationships between tables, setting primary and foreign keys, creating calculated columns, and implementing measures using DAX (Data Analysis Expressions).
• Optimization: Ensure that the data model is optimized for performance, especially when dealing with large datasets, by reducing complexity and improving load times.

2. Report and Dashboard Development

• Design Reports: Develop visually appealing and interactive reports using Power BI’s rich set of data visualization tools (charts, graphs, tables, etc.) tailored to meet business needs.
• Custom Visualizations: Utilize built-in and custom visuals, and may even develop custom visuals when necessary, to enhance the storytelling aspect of reports and dashboards.
• Interactive Dashboards: Design dashboards that allow users to filter, drill-down, and explore data interactively to derive insights.
• Bookmarks and Tooltips: Use features like bookmarks, dynamic tooltips, and slicers to create a more interactive and user-friendly experience.

3. DAX (Data Analysis Expressions)

• Create Measures and Calculated Columns: Use DAX to create measures, calculated columns, and calculated tables that are essential for complex calculations and KPIs.
• Time Intelligence: Implement time-based calculations, such as year-to-date (YTD), quarter-to-date (QTD), and running totals, leveraging DAX functions.
• Complex Aggregations: Develop complex aggregations and metrics that are not available in the source data but are needed for reporting.

4. Performance Tuning and Optimization

• Data Refresh Optimization: Manage and schedule data refreshes, ensuring that reports and dashboards are up to date without overloading the system.
• Performance Tuning: Monitor and optimize report performance by reducing query complexity, optimizing the data model, and utilizing techniques like aggregations, summary tables, and indexing.
• Data Load Optimization: Optimize queries for faster data loads, especially when working with large datasets by using techniques like query folding and reducing unnecessary columns and rows.

5. Power BI Service Management

• Power BI Workspace Management: Manage workspaces, apps, datasets, and reports in Power BI Service to organize and publish reports to users in the organization.
• Permissions and Security: Configure row-level security (RLS) to restrict data access based on user roles or groups, ensuring that sensitive data is protected.
• Report Publishing: Publish Power BI reports to the Power BI Service, share them with stakeholders, and embed them in other applications or websites as needed.
• Scheduling and Automation: Schedule data refreshes and automate report distribution to ensure that stakeholders always have access to the most up-to-date information.

6. Collaboration and Stakeholder Communication

• Business Requirements Gathering: Work closely with business analysts and stakeholders to understand their reporting needs, ensuring that the data and reports meet business goals.
• User Training: Provide training to end users on how to interact with Power BI reports and dashboards, teaching them how to filter, drill-down, and explore data.
• Documentation: Document the design, structure, and logic behind Power BI reports and dashboards for future reference and troubleshooting.