Job Title: Senior Power BI Developer
We are seeking a highly skilled Power BI Report developer to play a pivotal role in delivering reports for a new product rollout. You will work closely with stakeholders to review progress and adjust report visualizations.
The successful candidate will be developing Power BI reports from hundreds of millions of unaggregated rows of IoT data stored in AWS Redshift. Proficiency in creating highly optimized aggregate queries, leveraging partitioning and indexing is essential.
Responsibilities:
* Work with stakeholders to understand objectives, important metrics, and how they measure business performance.
* Create visualizations for all parts of the company that empower them to make informed business decisions.
* Develop, secure, and maintain data and reporting according to best practices.
* Account for the accuracy of the data presented to internal customers through validation processes and testing procedures.
* Assemble large, complex data sets that meet business requirements.
* Create and optimize data models to ensure efficient data retrieval and analysis.
* Investigate and resolve issues in BI tools and reports reported by end users.
Required Skills & Qualifications:
* 5+ years of advanced Power BI development skills, including data visualization, performance tuning, and UX optimization.
* Experience with AWS Redshift Database.
* Demonstrated ability to interpret stakeholder requests and translate into actionable insights through analyzing data and preparing insightful reports.
* Proficiency in data modeling, particularly with star schema designs for reporting and analysis.
* Expertise in SQL for data preparation, optimization, and transformation.
* Proficient in DAX for creating calculations, measures, and Calculation Groups in Power BI.
* Skilled in Power Query and M code for data transformation and troubleshooting.
* Excellent writing and communication skills for creating clear documentation and collaboration with team members.
* Working knowledge of version control systems, especially git, for managing code.
* Ability to work independently.