Senior Power BI Developer with Advanced Data Analytics Expertise
Our organization seeks a highly skilled Senior Power BI Developer to play a pivotal role in delivering reports for a new product rollout. You will work closely with stakeholders to understand business objectives, important metrics, and how they measure performance.
This project involves developing Power BI reports from hundreds of millions of unaggregated rows of IoT data stored in AWS Redshift. The ideal candidate should be skilled at creating highly optimized aggregate queries with a keen understanding of how to leverage partitioning and indexing.
The key responsibilities include:
* Collaborating with stakeholders to define objectives, important metrics, and performance measurements.
* Designing and implementing visualizations for all parts of the company to empower informed decision-making.
* Developing, securing, and maintaining data and reporting according to best practices.
* Validating data accuracy through thorough testing procedures.
* Assembling large, complex data sets that meet business requirements.
* Creating and optimizing data models to ensure efficient data retrieval and analysis.
* Investigating and resolving issues in BI tools and reports reported by end users.
The necessary skills and qualifications include:
* 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.
* Proficiency in data modeling, particularly with star schema designs for reporting and analysis.
* Expertise in SQL for data preparation, optimization, and transformation, including advanced query techniques like window functions and aggregations.
* 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 collaborating with team members.
* Working knowledge of version control systems, especially git, for managing code and collaboration.
* Experience in setting up and maintaining local development and testing environments.