Senior Power BI Developer with Redshift experience

Catalyte; São Paulo; Teletrabalho; BRL 120.000 - 160.000; Tempo integral

Resumo da oferta

A dynamic tech consultancy is seeking a Senior Power BI Developer for a remote contract role. The ideal candidate will have over 5 years of experience in Power BI development, focusing on delivering detailed reports from complex IoT data stored in AWS Redshift. Responsibilities include collaborating with stakeholders to create impactful visualizations and ensuring data accuracy. Strong SQL and DAX skills are essential, along with excellent communication abilities. This is a full-time contract position based in Brazil.

Qualificações

• 5+ years of advanced Power BI development skills.
• Experience with AWS Redshift Database.
• Proficient in SQL and DAX for data preparation.
• Strong communication skills for documentation.
• Ability to work independently.

Responsabilidades

• Work with stakeholders to understand business objectives.
• Create visualizations for informed business decisions.
• Maintain data accuracy through validation and testing.
• Develop data models for efficient retrieval and analysis.
• Resolve BI tool issues reported by end users.

Conhecimentos

Power BI development

AWS Redshift

Data visualization

SQL optimization

DAX

Data modeling

Version control (git)

Independent work

Communication skills

Data transformation

Descrição da oferta de emprego

We are looking for a Senior Power BI Developer for a 100% Remote, 3 month + contract (3rd Party C2Cs). Location: Brazil, South America (work remote supporting US based client/project).

• contractNo 3rd Party C2Cs Please.Location : Brazil, South America (work remote supporting US based client / project)

Employment Type

Contract Work, 40 hours weekly 100% Requirement: Must have good verbal & written communication (English)

Summary: We are seeking an experienced, highly skilled Power BI Report developer to join our project 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. For this project, 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.

Responsibilities

• Work with stakeholders including the Executive, Product, and Data teams to understand objectives, important metrics, and how they measure business performance.
• Create visualizations for all parts of the company that empower them to make 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 the execution of 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, ensuring accuracy and performance.

Skills & Requirements

• 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 to drive business decisions.
• 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, collaboration with team members, and troubleshooting with end users.
• Working knowledge of version control systems, especially git, for managing code and collaboration.
• Experience in setting up and maintaining local development and testing environments.
• Basic understanding of data engineering concepts, including ETL processes and data pipelines.
• Ability to work independently.