PowerBI Developer

Powerbi Developer – Chicago, Il (Remote To Start, And The Majority Of The Time Moving Forward)Under the general direction of the Director, Business Intelligence, our PowerBI Developer will serve as a key resource for understanding our business stakeholders' questions and harnessing enterprise data into compelling data stories to address those inquiries. Analysis performed by this role and the greater Data Analytics team directly influences strategic decision making across the entire company.What You'll Be DoingParticipate in discussions with business partners to define key business questions, translate them into necessary requirements documentation and develop visual data-driven solutions which answer those questionsDevelop reports, thoughtful visualizations, dashboards and KPI scorecards using Microsoft's Power BI and Azure stack employing leading visualization techniquesPerform UX design activities and Power BI navigation features (e.g. bookmarks, drill-throughs) to guide end-users through a data-driven storyDevelop calculations in SQL, DAX and Power BI measures which are accurate and performant on large datasetsWork with our internal customers to manage User Acceptance Testing (UAT) processes and address their feedbackAssist with governance and deployment of Power BI, including administration, content distribution/sharing, training and supportChampion the leading Power BI design methodology and best practicesExtract data from various data sources; perform exploratory data analysis, cleanse, reshape, and aggregate dataEvangelize data analytics best practices among peers and stakeholdersProactively monitor and evaluate the impact of monthly Power BI releasesConduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for executive-level requests and prioritiesRequirements3+ years of experience with Power BI development, visualizations and deploymentExperience (more the better) with the rest of the Microsoft BI stack: TSQL, Power Query, MDX and DAX, SSAS, SSRS, SSISStrong SQL Server database experienceSQL development experience by writing queries and procedures and also using functions to create curated data for use in reportingExperience documenting business requirements, processes and workflowsNice To Have ExperienceAdvanced level of MS Excel skills with knowledge of functions, macros, and VBA programming is preferred.