What are the responsibilities and job description for the Power BI Architect position at Affine Inc?
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.
Technical Expertise:
- 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.
Data Management and Integration:
- 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.
Designing BI Architecture:
- 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.
Technical Skills:
- SQL
- Power BI
- Excel
- Experience of Power BI architecture
- Project Management
- Stakeholder Management
Job Type: Full-time
Benefits:
- Health insurance
- Paid time off
- Referral program
- Relocation assistance
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Experience:
- Power BI: 6 years (Required)
- Enterprise architecture: 3 years (Required)
- Project management: 4 years (Required)
Ability to Commute:
- Wilmington, DE 19805 (Required)
Ability to Relocate:
- Wilmington, DE 19805: Relocate with an employer provided relocation package (Required)
Work Location: In person
