Senior Business Intelligence Developer with Redshift Expertise
The position requires a seasoned professional to join the project team and play a pivotal role in delivering reports for a new product rollout.
* Develop highly optimized aggregate queries leveraging partitioning and indexing on hundreds of millions of IoT data stored in AWS Redshift.
* Meet regularly to review progress and adjust report visualizations with key stakeholders.
Responsibilities:
1. Work with stakeholders including Executive, Product, and Data teams to understand objectives, important metrics, and how they measure business performance.
2. Create visualizations that empower internal customers to make informed business decisions.
3. Develop, secure, and maintain data and reporting according to best practices.
4. Account for the accuracy of data presented through validation processes and testing procedures.
5. Assemble complex data sets that meet business requirements.
6. Create and optimize data models for efficient data retrieval and analysis.
7. Investigate and resolve issues in BI tools and reports reported by end users.
Key Skills & Requirements:
* Advanced Power BI development skills, including data visualization, performance tuning, and UX optimization.
* Experience with AWS Redshift Database.
* Proficiency in data modeling, particularly with star schema designs for reporting and analysis.
* Expertise in SQL for data preparation, optimization, and transformation.
* Skilled in Power Query and M code for data transformation and troubleshooting.
* Excellent writing and communication skills for clear documentation, collaboration, and troubleshooting.