Descrição
Job Summary
Key Responsibilities:
- Design, develop, and maintain Power BI reports and dashboards for multiple business functions, ensuring accuracy, performance, and usability.
- Create robust data models using Power BI Desktop and implement efficient DAX measures, calculated columns, and role-level security.
- Collaborate with data engineering and ETL teams to define data requirements, ensure reliable data sources, and optimize data pipelines for reporting needs.
- Implement and maintain Power BI workspace governance, deployment pipelines, versioning, and scheduled refreshes; ensure adherence to best practices and security standards.
- Optimize report performance through query tuning, aggregation tables, incremental refresh, and model design improvements.
- Partner with business stakeholders to gather requirements, translate them into analytics solutions, and iterate on visualizations based on user feedback and metrics.
- Develop and document data dictionaries, modeling conventions, report specifications, and end-user guides to promote consistency and adoption.
- Build automated reporting solutions and integrate Power BI with other tools and platforms (e.g., Azure, SQL Server, REST APIs) as required.
- Mentor and provide guidance to junior BI developers and analysts; contribute to team knowledge sharing and continuous improvement of BI practices.
- Monitor usage and report performance, and partner with analytics teams to measure impact and recommend enhancements based on quantitative insights.
Required Qualifications:
- Bachelor’s degree in Computer Science, Data Science, Information Systems, Finance, or a related field, or equivalent practical experience.
- 5+ years of experience in business intelligence or data analytics workstreams, with at least 3 years focused on Power BI development in production environments.
- Proven experience building complex Power BI models, advanced DAX, and interactive visuals for enterprise-scale reporting.
- Strong SQL skills and experience working with relational databases and non-relational databases (e.g., Redshift, SQL Server, Azure SQL) and data warehousing concepts.
- Experience integrating Power BI with AWS services (Glue, Redshift, S3)or similar cloud data platforms preferred.
- Familiarity with Power BI governance, security, deployment pipelines, and performance tuning.
- Legal right to work in the hiring country.
Required Skills:
- Advanced DAX and data modeling skills, with strong understanding of star/snowflake schemas and dimensional modeling.
- Proficiency in SQL for data extraction, transformation, and troubleshooting of data quality issues.
- Solid understanding of ETL/ELT processes, data pipeline orchestration, and data quality best practices.
- Ability to translate business requirements into intuitive visualizations and actionable analytics that drive decision-making.
- Strong communication and stakeholder management skills; comfortable presenting technical concepts to non-technical audiences.
- Experience with Power BI administration, workspace management, and automation (Power BI REST API, PowerShell) is a plus.
- Attention to detail, problem-solving mindset, and ability to manage multiple priorities in a fast-paced environment.