Job Description :

Hi,

        We have  Enterprise Architect IV  position with our direct client State of OR, based  in Salem, OR for 6 months project on contract basis. If suitable, Pl send me resume with rate and contact details.

 

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 11,000 OHA and DHS agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and state hospital facilities; and promote and protect the state public health. 

ODHS is modernizing and optimizing its data warehouse environment. The Office of Research, Reporting, Analytics and Implementation (ORRAI) is responsible for data warehousing, reporting and analytics for ODHS. ORRAI serves all five ODHS programs. 

ORRAI has created a secure and sound data warehouse (DW) which supports reporting, dashboards, and analytics.These reporting and dashboard tools, in conjunction with analytics, provide the foundation for business insight and making informed is modernizing the current data warehouse using contractors and ORRAI staff. 

ODHS recently completed an assessment to validate and confirm the current DW implementation strategy is aligned with ODHS goals.The assessment also suggested a modernization plan would benefit from a complement of contracted staff and in-house data warehouse experts.Maintaining the existing warehouse while developing a modernized DW is impossible without an influx of resources. 

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: 

1.    Semantic model design and development (e.g. SSAS and Power BI tabular models) 

2.    Building Analysis Services Tabular models (e.g. DAX queries) 

3.    Power BI reporting, Power Query and analysis tool design and development 

4.    SSBI Deployment, Power BI Administration, operations/governance best practices 

5.    Power BI end user adoption 

6.    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: 

  • 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 
  • WhereScape tool sets 
  • Power BI 
  • Power BI Report Builder 
  • Graphical design 

 

Qualifications

 

Type

 

Category

 

Qualification

 

Description

 

Competency

 

Required

   
 

Skills

 

Others

 

Graphical Design

 

 

 

Proficient (4-6 Years)

 

Yes

   
 

Skills

 

Others

 

Microsoft Business Intelligence Stack and Data Analytics

 

 

 

Proficient (4-6 Years)

 

Yes

   
 

Skills

 

Others

 

Microsoft SQL Server

 

SSAS, SSRS

 

Expert (10+ Years)

 

Yes

   
 

Skills

 

Others

 

MS Power BI

 

Design and fully functional dashboards/reports experience and understanding - Report Builder - Services environment (workspaces, dataflows, etc.)

 

Advanced (7-9 Years)

 

Yes

   
 

Skills

 

Others

 

Power BI and Maps

 

ArcGIS Mapping

 

Advanced (7-9 Years)

 

Yes

   
 

Skills

 

Others

 

Power BI Development and Administration

 

 

 

Advanced (7-9 Years)

 

Yes

   
 

Skills

 

Others

 

Tabular development on SSAS or Azure

 

Must have.

 

Advanced (7-9 Years)

 

Yes

   
 

Skills

 

Others

 

Visual Studio

 

 

 

Proficient (4-6 Years)

 

Yes

   
 

Skills

 

Others

 

WhereScape tool sets/technology

 

Experience required. Understanding required.

 

Proficient (4-6 Years)

 

Yes

   

 

 

      



Client : Salem OR

             

Similar Jobs you may be interested in ..