Requires three (3) years of experience with the following skills: Power BI software development, including data modeling and semantic layer implementation; Database and business intelligence management; Writing complex SQL queries using CTEs, subqueries, window functions, and aggregations; Performing complex joins and creating views to manipulate large datasets; Optimizing SQL queries through indexing and analysis to reduce latency; Writing and optimizing DAX calculations including query performance tuning in Power BI; Developing complex data transformation logic using the M formula language in Power Query; Creating dashboards based on business requirements using Power BI, with the ability to drill down data and visualize it with charts, reports, or dashboards; Maximizing query folding and ensuring efficient data transformations to minimize memory overhead and improve refresh speed; Designing and implementing incremental refresh policies for efficient handling of billion-row datasets; Performing granular partition processing using SQL Server Management Studio connected to Power BI workspaces; Designing and implementing dynamic parameters in Power Query, along with error handling and data profiling; Maintaining and supporting existing dashboards; Conducting deep dive model diagnostics using Vertipaq Analyzer to identify high cardinality columns; Implementing dynamic row-level security frameworks using DAX; Developing and deploying Power BI reports; Using MS Excel for data analysis and report generation using Power BI semantic models; Analytical scripting using Python libraries including Matplotlib or Seaborn; and. Our values - putting clients first, doing the right thing, leading with exceptional ideas, committing to diversity and inclusion, and giving back - aren't just beliefs, they guide the decisions we make every day to do what's best for our clients, communities and more than 80,000 employees in 1,200 offices across 42 countries.