Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Tableau Visual Studio ArcGIS Graphical DesignLayout Microsoft Business Intelligence
 
Requirement id 118353
Job title Architect
Job location in Salem, OR
Skills required Microsoft SQL Server 2016, Power BI, Tableau, Visual Studio ArcGIS Graphical DesignLay
Open Date 05-Aug-2021
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Architect: Microsoft SQL Server 2016, Power BI, Tableau, Visual Studio ArcGIS Graphical DesignLay

start date:10/04/2021
End date:04/01/2022
submission deadline:08/12/2021

client info : DHS / OHA

Note:

* Candidate must be local or willing to commute or relocate

Description:

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority and the 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 is responsible for serving 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 decisions. ODHS/ORRAI 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 Microsofts 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:

Excellent understanding of Microsoft SQL Server St
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 118353 while calling.
 
Other jobs in OR: Orange (1), Portland (22), Salem (38), Tigard (3), Wilsonville (2),
Microsoft SQL Server 2016 job openings in Salem, OR
Jobs List

Application Developer III - CSR 147-23
Create date: 30-Jun-2023
Start date : 07/24/2023

End Date : 12/31/2023

Submission deadline : 07/10/2023

Client Info : ODFW

Note :

* Position Location : Hybrid

Description :

Developer to implement a web based application for the agencys Willamette Wildlife Mitigation Program (WWMP). The applicati.... (This job is for - MVCASPNet Jobs in OR Salem Developer - (in Salem, OR))

Application Developer IV - 11104-22
Create date: 30-Nov-2022
start date:1/16/2023
End date:07/14/2023

submission deadline:12/06/2022

client info : DHS / OHA

Note:

* Position Location: Remote

Description:

The Health & Service Equity Transformation program is focused on addressing health ineq.... (This job is for - JavaScript Jobs in OR Salem Developer - (in Salem, OR))

System Engineer III - 11099-22
Create date: 29-Jun-2022
Start Date : 07/25/2022


End Date : 01/20/2023


Submission Deadline : 07/06/2022

Client Info : DHS / OHA

Note:
* Position Location Remote

Description :
The Office of Information Services (OIS) is a shared service provider for the Orego.... (This job is for - PHP Jobs in OR Salem Engineer - (in Salem, OR))

System Engineer III - 11094-22
Create date: 02-Feb-2022
start date:2/28/2022
End date:08/26/2022

submission deadline:02/08/2022

client info : DHS / OHA

Note:

* Candidate must be local or willing to commute or relocate.

* This position requires at least one week of onsite work in Salem, Oregon. job Jobs in OR Salem Engineer - (in Salem, OR))

System Specialist IV - 73000-00005084/B36991W77
Create date: 27-Dec-2021
start date:1/17/2022
End date:07/18/2022

submission deadline:12/29/2021

client info : ODOT

Description:

Computer systems specialists provide technical guidance for the development and troubleshooting of computer systems. They identify system data, har.... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR))
 
 Microsoft SQL Server 2016 job openings in other states
Jobs List

DOE SQL Database Administrator (710978)
Create date: 26-May-2023
start date : 07/06/2023

End date : 06/30/2024

submission deadline : 06/01/2023

client info : DOE/TS/DMI

Note :

* Hybrid

Description :

Conduct the following for Azure SQL/Azure SQL MI/SQL on Azure VM, On Prem SQL Server, SSRS, .... (This job is for - Sql Server 2000 Jobs in GA Atlanta Administrator - (in Atlanta, GA))

Database Administrator IV - 118192 - SP
Create date: 18-May-2023
Start date : 07/01/2023
End Date : 06/30/2024

Submission deadline : 5/22/23 at 4:00PM CST.

Client Info :DFI

Note:
* Interview Process: Teams

* Duration of the Contract: 6/30/2024

* Onsite or Remote? Candidate must be a WI resident or willing to relocate
to WI at the candid.... (This job is for - Oracle Jobs in WI Madison Administrator - (in Madison, WI))

Database Architect -59904
Create date: 22-Mar-2023
Start date :04/01/2023
End Date :04/01/2024

Submission deadline : 03/31/2023

Client Info : Fulton County

Note:
* Position Location On Site

Description :

Design strategies for Microsoft SQL Server and Oracle enterprise databases, data warehouse systems, and data lakes. Set standard.... (This job is for - Oracle Database Jobs in GA Atlanta Consultant - (in Atlanta, GA))

NCDST - Technical Architect - Expert -704423
Create date: 20-Feb-2023
Start Date : 3/6/2023
End Date : 03/05/2024

Submission Deadline : 02/22/2023

Client Info : NCDST

Note:
* Onsite

Description :

***This position is onsite.

The Department of the State Treasurer is seeking a candidate to perform technical a.... (This job is for - Development Jobs in NC Raleigh Consultant - (in Raleigh, NC))

Software Engineer II- 2023-2854
Create date: 18-Aug-2022
Start Date : 09/06/2022
End Date : 07/30/2023


Submission Deadline : 08/26/2022


Client Info : CO DNR

Note:
* Position Location Hybrid

Description :

Creates and designs new software by analyzing, testing, assessing and implementing pro.... (This job is for - CSS Jobs in CO Denver Engineer - (in Denver, CO))
 
 
(Architect: Microsoft SQL Server 2016, Power BI, Tableau, Visual Studio ArcGIS Graphical DesignLay in Salem, OR)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us