We are seeking an experienced Power BI developer to join our team and play a pivotal role in delivering reports for a new product rollout. You will meet regularly to review progress and adjust report visualizations with key stakeholders.
You will be developing Power BI reports from hundreds of millions of unaggregated rows of IoT data stored in AWS Redshift. You should be skilled at creating highly optimized aggregate queries with a keen understanding of how to leverage partitioning and indexing.
The ideal candidate has 5+ years of advanced Power BI development skills, including data visualization, performance tuning, and UX optimization. They have experience working with AWS Redshift Database and are proficient in SQL for data preparation, optimization, and transformation.
Key Responsibilities
* Work closely with stakeholders to understand business objectives, important metrics, and how they measure business performance.
* Create visualizations that empower the organization to make informed business decisions.
* Develop, secure, and maintain data and reporting according to best practices.
* Account for the accuracy of the data presented 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.
Required Skills and Qualifications
* Advanced Power BI development skills, including data visualization, performance tuning, and UX optimization.
* Experience working with AWS Redshift Database.
* Demonstrated ability to interpret stakeholder requests and translate into actionable insights through analyzing data and preparing 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.
Benefits
This is an excellent opportunity for a talented Power BI developer to grow their skills and contribute to a successful project.
The ideal candidate will be part of a collaborative team that values innovation and excellence.