1872 Consulting
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.
#J-18808-Ljbffr
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.
#J-18808-Ljbffr