PowerBI Architect

***Need a true hands on PowerBI SME Someone with good architecture, development, and administration experience with PowerBI

***Do not want a Data Architect They are too general and not specific enough in PowerBI

REQUIREMENTS: Education and Experience:

• Bachelor s degree or equivalent combination of training and experience
• 7+ years of experience in Business Intelligence architecture and data modelling.
• 5+ years of experience with Power BI development experience.
• Experience with ETL Processes and data integration tools (SSIS, Azure Data Factory)
• 4+ years of experience with Microsoft SQL server or other SQL
• Expert level proficiency with at least two BI tools (e.g., Power BI, Business Objects, MicroStrategy, etc.).
• Proficiency in DAX and Power Query (M Language)
• Demonstrated experience with relational data warehouse design and management.
• Demonstrated experience with SDLC, agile scrum methodology, software tools and practices.
• Experience securing and managing reporting including PII data a plus.

Skills/Knowledge:

• Exceptional analytical, conceptual, and problem-solving skills.
• Strong ability to analyze user requirements and build front-end BI applications according to specifications.
• Strong knowledge that demonstrates database technical functionality such as performance, security, and reliability.
• Should understand and be able to contribute to all phases of the software development life cycle.
• Strong ability to collaborate in the development of necessary processes, technologies, and standards.
• Self-directed and comfortable working in a face-paced environment where priorities can change with limited notice.
• Strong and effective inter-personal and communication skills and the ability to interact professionally with a diverse group of users and staff. Ability to clearly articulate process requirements and expected outcomes.

MAJOR RESPONSIBILITIES:

• Architect, design, develop, and maintain end to end business intelligence solutions based on Microsoft Power BI platform. Responsible for defining the strategy to continued build-out and adoption of the Power BI platform at the bank. Develop and manage an enterprise semantic model that enables consistent, reusable business logic across Power BI objects and teams. Collaborate with data engineers to create scalable and flexible data models optimized for Power BI report and dashboard delivery.
• Manage the Power BI service including workspace and capacity management, gateway configuration, usage metrics, monitoring, and auditing as well as permissions. Drive efficiency through automation wherever possible. Stay current on new features available within the platform.
• Serve as the SME for Power BI Architecture, design, and build. Define and share best practices to raise collective skill across the enterprise. Create and share documentation, guide cards, and templates to standardize and aid in development of new Power BI objects including SDLC requirements. Act as a resource to partner with business users to guide on the effective use of semantic models, templates, and reports. Educate users on new analytics platform datasets available as well as new features of Power BI platform.
• Work with internal customers to understand requirements for reporting, dashboards, and reports. Build and maintain an inventory of dataset needs to be prioritized and built as required. Coordinate with data engineers to align focus for delivery.