Power BI Architect

Job Title: Power BI Architect

Location: Denver, CO (Hybrid)

Duration: 12 Months

Mandatory Skills: PowerBI, MS Fabric,

Key Responsibilities:

Reporting Hub Development:

• Design and direct the reporting implementation team to build a reporting hub which will house semantic models and datamarts for a unified reporting portal
• Develop data marts to support targeted, efficient reporting aligned with business objectives.
• Datamarts should be developed for all internal reporting needs as well as serve as a data source to AI initiatives at Redwood.

Technology Leadership:

• Develop a roadmap for end state reporting architecture and build of all reports across various business units.
• Utilize Microsoft Fabric workspaces to design the reporting hub and datamarts.
• Utilize Microsoft Fabric – Power BI to build the reports.
• Leverage the full capabilities of Power BI and Microsoft Fabric, to drive scalability and performance in the reports

Data Integration and Modeling:

• Integrate with engineered data in the enterprise data platform to build semantic models for reporting
• Contribute to organization and designing of reports
• Develop and maintain conceptual, logical, and physical data models that align with organizational reporting and analytics needs.
• Implement standardized, reusable data assets to ensure consistency across the enterprise.

Experience:

• A minimum of 10 years of experience in reporting data architecture with a proven track record of working on transformative enterprise data platform initiative
• Hands-on expertise in building out reporting solutions on cloud using cloud based PowerBI visualization tool
• Experience in Microsoft Fabric, Azure Synapse Analytics, and/or Azure Data Factory (ADF).

Technical Skills:

• Deep expertise in data modeling, including conceptual, logical, and physical models.
• Deep expertise in building reporting visualization solutions on cloud
• Strong proficiency in SQL
• Comprehensive understanding of data mart design, integration of models with visualization tool and metadata management.
• Experience with cloud platforms, particularly Microsoft Azure.
• Experience with ER Studio or similar modeling tools.

Soft Skills:

• Excellent problem-solving and analytical capabilities.
• Superior communication skills, with the ability to articulate complex technical concepts to non-technical stakeholders.
• Strong leadership and project management skills, with the ability to guide cross-functional teams to successful outcomes.