BI Solutions Architect (Power BI)

Veracity

Santa Clara, CA

JOB DETAILS
SKILLS
Access Control, Analysis Skills, Application Programming Interface (API), Architectural Design, Architectural Services, Best Practices, Business Intelligence, Business Intelligence Software, Caching, Cloud Computing, Communication Skills, Computer Science, Cross-Functional, Data Modeling, Data Structures, Dimensional Modeling, Industry Standards, Information Technology & Information Systems, Information/Data Security (InfoSec), Leadership, Maintain Compliance, Mentoring, Microsoft Product Family, Microsoft Windows Azure, Performance Modeling, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Python Programming/Scripting Language, Reporting Dashboards, SQL (Structured Query Language), Scalable System Development, Standards Development, Training/Teaching, Usability Engineering
LOCATION
Santa Clara, CA
POSTED
Today
Job Title: BI Solutions Architect (Power BI)
Location: Santa Clara, CA (Onsite)
Job Type: Full-Time

We are seeking a highly skilled BI Solutions Architect with deep expertise in Power BI and the Microsoft BIecosystem. This role will be responsible for designing scalable BI architectures, building advanced data models, and delivering insightful dashboards that drive strategic decision-making.

The ideal candidate will have strong experience in Power BI, Power Platform (Power Automate, Power Apps), data modeling, and performance optimization, along with the ability to lead BI initiatives and collaborate across business and technical teams.

Key Responsibilities

Architecture & Design
  • Design and implement end-to-end BI architecture using Power BI and Microsoft BI stack
  • Ensure alignment with business requirements, scalability, and best practices
  • Define BI standards, frameworks, and governance models
Data Modeling
  • Develop efficient and scalable dimensional data models
  • Optimize data structures for reporting and analytics
  • Implement best practices in DAX and Power Query
Dashboard & Reporting
  • Lead development of interactive dashboards and reports
  • Deliver actionable insights for business stakeholders
  • Ensure usability, performance, and visual clarity
Integration & Data Connectivity
  • Integrate Power BI with:
    • Multiple data sources (SQL, cloud, APIs)
    • Enterprise systems
  • Collaborate with data engineering and IT teams
Performance Optimization
  • Identify and resolve performance bottlenecks
  • Optimize:
    • Queries
    • Data models
    • Report rendering
  • Implement caching and data refresh strategies
Security & Governance
  • Implement data security and access controls
  • Ensure compliance with:
    • Organizational policies
    • Industry standards
  • Manage roles, permissions, and governance frameworks
Strategy & Leadership
  • Define and drive BI strategy and roadmap
  • Align BI initiatives with business goals
  • Provide architectural guidance and leadership
Training & Support
  • Mentor junior team members
  • Provide training to end-users on Power BI tools
  • Promote BI adoption across the organization
Documentation
  • Maintain detailed documentation of:
    • Architecture designs
    • Data models
    • Configurations and processes
Must-Have Skills
  • 5-7+ years of experience in Power BI (Architect-level experience required)
  • Strong expertise in:
    • Microsoft BI Suite
    • Power BI, Power Automate, Power Apps
  • Advanced skills in:
    • Data Modeling (Dimensional Modeling)
    • DAX and Power Query
  • Strong experience with:
    • SQL
    • Python
    • Jupyter Notebooks
  • Experience integrating Power BI with multiple data sources
  • Strong analytical, problem-solving, and communication skills
  • Proven ability to lead BI projects and collaborate cross-functionally
Nice-to-Have Skills
  • Experience with Azure Data Services (Azure Synapse, Data Factory, etc.)
  • Exposure to other BI tools and platforms
  • Power BI Certification
Education
  • Bachelor's degree in Computer Science, Information Systems, or related field

About the Company

V

Veracity