• SQL Development: Design, develop, and optimize complex SQL queries to meet business requirements and ensure optimal performance.
• Data Modeling and Design: Work closely with business stakeholders and data architects to develop logical and physical data models tailored for BI purposes.
• Redshift Expertise: Leverage extensive experience with Amazon Redshift to design, maintain, and optimize data warehouses ensuring high availability, performance, and security.
• Dashboard Development: Create intuitive, actionable, and user-friendly dashboards using BI tools, ensuring that business stakeholders can easily interpret and act on the data.
• Data Integration: Develop ETL processes to integrate data from diverse sources into our data warehouse.
• Performance Tuning: Monitor and improve query performance and optimize data loads for Redshift, ensuring efficient data retrieval and reporting.
• Collaboration: Work closely with data analysts, business teams, and IT to ensure that the BI solutions are aligned with business goals and technical requirements.
• Documentation: Maintain clear documentation of database designs, data definitions, and dashboards to ensure knowledge sharing and consistency.
• Continuous Learning: Stay up-to-date with the latest trends, tools, and best practices in BI development, especially regarding Redshift and related AWS services.

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Minimum of 3 years experience in a BI developer role.
• Proven expertise in SQL with the ability to write complex, highly-optimized queries.
• Extensive experience with Amazon Redshift, including design, development, and optimization.
• Strong experience with BI tools for dashboard development.
• Knowledge of ETL tools and processes.
• Strong analytical, problem-solving, and troubleshooting skills.
• Ability to work independently and collaborate with cross-functional teams.
• Excellent communication skills, both written and verbal.