Business Intelligence Architect

REQUIREMENT:

a) Lead the design, development, and optimization of advanced Power BI and Paginated reports with a focus on accuracy, usability, and performance. Ensure alignment with enterprise data strategy, working closely with data engineers and business analysts in the Microsoft Fabric environment.

b) Consolidate and streamline overlapping report requests to reduce redundancy and improve reporting efficiency.

c) Support guidance and adoption of Microsoft Fabric best practices in report building and data modeling to ensure efficient, maintainable solutions.

d) Translate CRM data structures (i.e. ERDs) into structured and scalable data products.

e) Build and manage reusable certified data models using Microsoft Fabric tools, including Dataflows, Lakehouse, Warehouse, Pipelines, etc.

f) Provide Power BI self-service tools training to enable independent data exploration for business users.

g) Conduct workshops and develop documentation to support data literacy and empower end users.

h) Support the reporting team to act as a trusted advisor to business stakeholders, helping them understand and extract value from reporting solutions.

MINIMUM REQUIREMENTS:

· 12+ years of experience with expert-level proficiency in Power BI, including DAX, Power Query, and Paginated Reports (SSRS Report Builder).

· 8+ years strong experience in data modeling and architecture, particularly using Microsoft Fabric, Dataflows, and Data Lake solutions.

· 6+ years experience in designing and implementing certified datasets and data governance frameworks.

· Preferred to hold one of following certificates: Microsoft Certified: Fabric Data Engineer Associate (DP-700) and/or Microsoft Certified: Fabric Analytics Engineer Associate (DP-600).

· Preferred to have education degree in computer science, or mathematics, or statistics.

POWER BI & PAGINATED REPOST DEVELOPMENT EXPERIENCE

Provide a summary of two projects where the proposed resource displayed knowledge and experience in end-to-end development of Power BI and Paginated reports, with a focus on data accuracy, usability, and performance optimization.

BEST PRACTICE AND USER TRAINING EXPERIENCE

Describe proposed resource’s experience promoting and following internal development best practices and delivering user training to business functions. This should include an overview of the tools and training approaches they employ as well as any best practices around training and change management.

REQUIREMENTS ELICITATION EXPERIENCE

Describe proposed resource’s experience working with non-technical stakeholders to understand business needs and translate complex requirements into effective data and reporting solutions, while identifying opportunities to streamline and consolidate reporting efforts.