Direct Client: SQL Power BI Architect

SSAS, Power BI, SSRS, ArcGIS, Power BI Report Builder, Graphical design
Contract W2, Contract Independent, 6 Months
Depends on Experience

Job Description

SQL Power BI Architect

Salem, OR

6 Months Contract


Looking for the candidates who can work on our W2.


The modernized DW will better address needs of data consumers and programs by creating a self-service BI model. To achieve this result, the agency has standardized on Microsoft’s Power BI. To achieve this goal of creating a self-service BI model, ORRAI recognizes the need address the following areas:


  • Semantic model design and development (e.g. SSAS and Power BI tabular models)
  • Building Analysis Services Tabular models (e.g. DAX queries)
  • Power BI reporting, Power Query and analysis tool design and development
  • SSBI Deployment, Power BI Administration, operations/governance best practices
  • Power BI end user adoption
  • ORRAI SSBI staff development and mentoring

Scope of work:

  • Make DW architecture more agile and accessible
  • Create data layers that align with a dimensional model (Star Schema); that model reflects the programmatic and business needs of ODHS. This data layer should be designed (Model-storming and using our standard tools such as Visual Studio) to be compatible with any data visualization tool, any analytic tool, and have the flexibility to change and adapt to new data sources. In addition, the data layer should be optimized to process mass amounts of data.
  • Tabular model design, development, testing and deployment
  • Power BI report design, development, testing and deployment
  • Power BI and Maps
  • Lead process in creating a dashboard/visualization strategy
  • ORRAI team mentoring
  • Improve performance and reliability of hosting
  • Assist with assessment of hosted, cloud service and make recommendations on best services.
  • Audit existing data systems; models, queries, data quality, security, and suggest a modernization roadmap.


Required skills and experience:


  • Proficient capabilities to communicate and collaborate with video while utilizing MS Teams platform
  • Excellent communication skills involving multiple participants - stakeholders, team members, managing staff, and developers
  • Excellent understanding of Microsoft SQL Server Stack (SSAS, SSRS)
  • Tabular development on SSAS or Azure (Must have)
  • Proficient with Microsoft Business Intelligence Stack and Data Analytics
  • Power BI development and administration
  • Power BI and ArcGIS Mapping
  • Proficient in design and fully functional dashboards/reports on MS Power BI
  • Proficient and understanding of Power BI Services environment (workspaces, dataflows)
  • Experience of conversation of SSRS reports into Power BI Reports and Power BI dashboard
  • Develop recommended data modeling standards for consideration; best practices
  • Develop recommended user of Power BI standards based on existing platform


In addition, the ideal candidate will have skills and experience in:

  • Requirement analysis
  • Data Analytics
  • Power BI
  • Power BI Report Builder
  • Graphical design


Dice Id : 10314943
Position Id : 7191867
Originally Posted : 3 months ago
Have a Job? Post it

Similar Positions

Senior Systems Specialist - Database
  • STM Consulting, Inc.
  • Salem, OR, USA
Business Intelligence Data Modeler
  • DatamanUSA, LLC
  • Portland, OR, USA
Business Intelligence Data Modeler
  • Ensoftek Inc
  • Portland, OR, USA
Power BI Lead - Project Manager
  • ClifyX
  • Seattle, WA, USA
SQL Developer
  • Robert Half
  • Bellevue, WA, USA
Sr. .NET Software Engineer III
  • Reliable Software Resources
  • Boise, ID, USA
SSRS Reports Developer -- Insurance domain
  • Fortune Global Solutions, LLC
  • Woodland, CA, USA
BI Analytics
  • Triune Infomatics Inc
  • Oakland, CA, USA
Sr. .NET UI Developer
  • Saicon Consultants Inc.
  • Pleasanton, CA, USA
Senior .Net Developer
  • ObjectWin Technology Inc
  • Pleasanton, CA, USA