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 Doing

• Participate 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 questions
• Develop reports, thoughtful visualizations, dashboards and KPI scorecards using Microsoft's Power BI and Azure stack employing leading visualization techniques
• Perform UX design activities and Power BI navigation features (e.g. bookmarks, drill-throughs) to guide end-users through a data-driven story
• Develop calculations in SQL, DAX and Power BI measures which are accurate and performant on large datasets
• Work with our internal customers to manage User Acceptance Testing (UAT) processes and address their feedback
• Assist with governance and deployment of Power BI, including administration, content distribution/sharing, training and support
• Champion the leading Power BI design methodology and best practices
• Extract data from various data sources; perform exploratory data analysis, cleanse, reshape, and aggregate data
• Evangelize data analytics best practices among peers and stakeholders
• Proactively monitor and evaluate the impact of monthly Power BI releases
• Conduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for executive-level requests and priorities

Requirements

• 3+ years of experience with Power BI development, visualizations and deployment
• Experience (more the better) with the rest of the Microsoft BI stack: TSQL, Power Query, MDX and DAX, SSAS, SSRS, SSIS
• Strong SQL Server database experience
• SQL development experience by writing queries and procedures and also using functions to create curated data for use in reporting
• Experience documenting business requirements, processes and workflows

Nice To Have Experience

• Advanced level of MS Excel skills with knowledge of functions, macros, and VBA programming is preferred.