What are the responsibilities and job description for the PowerBI Architect position at Affine?
Responsibilities
- Design, develop, and deploy Power BI reports and dashboards that provide key insights into business performance.
- Create and maintain complex Power BI data models, integrating data from multiple sources.
- Write and optimize SQL queries to extract, manipulate, and analyze data from various databases.
- Collaborate with cross-functional teams to understand business requirements and translate them into effective BI solutions.
- Perform data analysis using Excel, Power Query, and other tools to support reporting and analytics needs.
- Monitor and troubleshoot Power BI reports and data refresh schedules to ensure consistent performance.
- Implement security measures and ensure data is presented to the appropriate audience through role-based access.
- Continuously improve the usability, interactivity, and performance of reports.
- Provide training and support to end-users on Power BI usage.
- Staying up-to-date with the latest Power BI technologies and trends.
- Selecting and implementing appropriate Power BI tools and technologies.
- Optimizing data storage and retrieval for efficient data access.
- Integrating data from multiple sources, ensuring data quality and consistency.
- Establishing data standards and governance to maintain data integrity.
- Developing and maintaining data models, ETL processes, and reporting solutions.
- Conceptualizing and designing the organization's data infrastructure, including data warehousing, data models, and ETL processes.
- Ensuring the system can scale with the company's future needs.
- Collaborating with stakeholders to gather and analyze business requirements.
- SQL
- Power BI
- Excel
- Experience of Power BI architecture
- Project Management
- Stakeholder Management
