As a Business Intelligence Analyst, you will start your journey into the world of data by aiding our team in delivering data-driven insights. You
will assist in the construction and maintenance of dashboards, scorecards, and reports, providing essential support that contributes to our
understanding of business operations. Your work will help identify trends and patterns that inform our strategic decisions, fostering your
growth in the field of Business Intelligence.
Responsibilities :
Data Acquisition & Preparation
- Collect, clean, and organize data from multiple sources (SQL databases, APIs, spreadsheets).
- Perform data transformation using Power Query (M) and SQL.
- Ensure data quality through validation and error handling.
Data Modeling
Build and maintain data models, relationships, and hierarchies for reporting.Implement best practices for star / snowflake schema and optimize model performance.Report & Dashboard Development
Design and develop interactive dashboards and reports in Power BI Desktop.Apply advanced features like drill-through, bookmarks, tooltips, and custom visuals.Create scorecards and KPI dashboards for business performance tracking.Data Analysis & Insights
Develop DAX measures and calculated columns for KPIs and advanced analytics.Perform trend analysis, root cause analysis, and identify actionable insights.Support business teams in interpreting data and making data-driven decisions.Integration & Deployment
Publish reports to Power BI Service, manage workspaces, and configure scheduled refresh.Implement Row-Level Security (RLS) and other governance measures.Integrate Power BI reports into applications, portals, or SharePoint.Performance Monitoring & Optimization
Monitor dashboard performance and optimize queries, visuals, and data models.Track and report on data refresh status and resolve failures promptly.Collaboration & Documentation
Work closely with stakeholders to gather requirements and translate them into BI solutions.Document data sources, transformations, business logic, and report specifications.Participate in team discussions to understand evolving data needs.Compliance & Best Practices
Adhere to data governance, security, and privacy policies.Stay updated on Power BI and SQL best practices and emerging features.Skills : Power BI
Data modeling and relationship designDAX (Data Analysis Expressions) for measures and calculated columnsPower Query (M) for data transformationAdvanced visualization techniques and custom visualsPower BI Service : deployment, workspace management, scheduled refresh, and Row-Level Security (RLS)SQL
Writing optimized queries for data extractionJoins, aggregations, subqueries, and Common Table Expressions (CTEs)Query performance tuning and troubleshootingData Integration & ETL
Connecting to multiple data sources (databases, APIs, Excel)Basic understanding of ETL concepts and data pipelinesFamiliarity with incremental refresh and dataflow conceptsData Management & Analysis
Data collection and organization from multiple data sourcesData cleaning and validation for accuracy and consistencyBasic to intermediate data analysis and summarizationRoot cause analysis for data anomaliesUnderstanding of data governance, privacy, and security standardsReporting & Visualization
Designing interactive dashboards and reports aligned with business KPIsCreating scorecards and performance tracking visualsApplying visualization best practices for clarity and usabilityAdditional / Preferred Skills
Familiarity with Azure Data Services (e.g., Azure SQL, Data Factory) or other cloud platformsExposure to Azure dev ops version control (Git) and BI deployment best practicesAwareness of performance optimization techniques for large datasetsBasic knowledge of Python for data manipulation (optional but valuable)As a Business Intelligence Analyst, you will start your journey into the world of data by aiding our team in delivering data-driven insights. You
will assist in the construction and maintenance of dashboards, scorecards, and reports, providing essential support that contributes to our
understanding of business operations. Your work will help identify trends and patterns that inform our strategic decisions, fostering your
growth in the field of Business Intelligence.
Responsibilities :
Data Acquisition & Preparation
Collect, clean, and organize data from multiple sources (SQL databases, APIs, spreadsheets).Perform data transformation using Power Query (M) and SQL.Ensure data quality through validation and error handling.Data Modeling
Build and maintain data models, relationships, and hierarchies for reporting.Implement best practices for star / snowflake schema and optimize model performance.Report & Dashboard Development
Design and develop interactive dashboards and reports in Power BI Desktop.Apply advanced features like drill-through, bookmarks, tooltips, and custom visuals.Create scorecards and KPI dashboards for business performance tracking.Data Analysis & Insights
Develop DAX measures and calculated columns for KPIs and advanced analytics.Perform trend analysis, root cause analysis, and identify actionable insights.Support business teams in interpreting data and making data-driven decisions.Integration & Deployment
Publish reports to Power BI Service, manage workspaces, and configure scheduled refresh.Implement Row-Level Security (RLS) and other governance measures.Integrate Power BI reports into applications, portals, or SharePoint.Performance Monitoring & Optimization
Monitor dashboard performance and optimize queries, visuals, and data models.Track and report on data refresh status and resolve failures promptly.Collaboration & Documentation
Work closely with stakeholders to gather requirements and translate them into BI solutions.Document data sources, transformations, business logic, and report specifications.Participate in team discussions to understand evolving data needs.Compliance & Best Practices
Adhere to data governance, security, and privacy policies.Stay updated on Power BI and SQL best practices and emerging features.Skills : Power BI
Data modeling and relationship designDAX (Data Analysis Expressions) for measures and calculated columnsPower Query (M) for data transformationAdvanced visualization techniques and custom visualsPower BI Service : deployment, workspace management, scheduled refresh, and Row-Level Security (RLS)SQL
Writing optimized queries for data extractionJoins, aggregations, subqueries, and Common Table Expressions (CTEs)Query performance tuning and troubleshootingData Integration & ETL
Connecting to multiple data sources (databases, APIs, Excel)Basic understanding of ETL concepts and data pipelinesFamiliarity with incremental refresh and dataflow conceptsData Management & Analysis
Data collection and organization from multiple data sourcesData cleaning and validation for accuracy and consistencyBasic to intermediate data analysis and summarizationRoot cause analysis for data anomaliesUnderstanding of data governance, privacy, and security standardsReporting & Visualization
Designing interactive dashboards and reports aligned with business KPIsCreating scorecards and performance tracking visualsApplying visualization best practices for clarity and usabilityAdditional / Preferred Skills
Familiarity with Azure Data Services (e.g., Azure SQL, Data Factory) or other cloud platformsExposure to Azure dev ops version control (Git) and BI deployment best practicesAwareness of performance optimization techniques for large datasetsBasic knowledge of Python for data manipulation (optional but valuable)Applicants may be required to appear onsite at a Wolters Kluwer office as part of the recruitment process.
Skills Required
Power Bi, Dax, Sql