Job Description :
Job Title: Power BI Architect Location: Salem, OR Duration: 5 Months Note: Selected candidates need to be on board Onsite. They need to pick their on- boarding documents and equipment manually. No expenses will be paid for travelling Job Description: 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 WhereScape) 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 Lead process in creating a dashboard/visualization strategy Power BI and SSBI environment setup and configuration ORRAI team mentoring SSBI adoption and governance strategy 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: Excellent understanding of Microsoft SQL Server Stack (SSAS, SSRS) Proficient with Microsoft Business Intelligence Stack and Data Analytics Power BI development and administration Familiar (experience) and understanding of WhereScape tool/technology Proficient in design and fully functional dashboards/reports on MS Power BI Proficient and understanding of Power BI Services environment (workspaces, dataflow) 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 WhereScape tool sets Power BI Power BI Report Builder Graphical design Required/Desired Skills Skill Matrix Skill Matrix Technology Years of Experience Overall IT Experience Communication (1 - 10) Microsoft SQL Server MS Power BI Power BI Development and Administration WhereScape tool sets/technology Graphical Design Microsoft Business Intelligence Stack and Data Analytics