Enterprise Architect IV Salem, OR (On-Site) mth contract job vacancy

Vacancy expired!

Location : Salem,OR Duration : 6mnths+ The Governor's executive order 21-29 requires contractors who work onsite to provide proof of being fully vaccinated, including both doses of a two-dose Covid-19 vaccination or one dose of a single-dose Covid-19 vaccination, and at least 14 days have passed since the individual's final dose of Covid-19 vaccination PRIOR to the contract start date.

Please only propose candidates who are fully vaccinated and willing to provide proof of vaccination.

This position requires some onsite work in Salem, Oregon, including initial training and weekly onsite meetings. Any permission for remote work (following training) is highly conditional upon proven capabilities, proficiency with work, understanding of work environment and team dynamics. Remote work permission is granted at the discretion of the Agency.

Onsite working conditions are anticipated to resume state-wide after January 1, 2021. In alignment with department-wide return to work, the expectation is that the key person will work fully onsite as soon as the general workforce transitions back into the Agency workplace.

Oregon-based or West Coast-based contractors preferred, due to time zone work requirements and due to ultimate Return to Work (onsite) department transition.

Remote work schedule must abide by PST time zone and business hours. The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Oregon Client (ODHS). OIS provides the technology systems and services that support more than 11,000 OHA and Client 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 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

Encompassing all listed skills and experience required/desired, this position will be responsible for building, optimizing, and deploying Power BI data visualization dashboards and reports.

Qualifications include extensive hands-on experience in Power BI, including dimensional modelling, report layout/design and development, deep expertise in Data Analysis Expressions (DAX), working with on-premises EDW and SSAS, and extensive RLS knowledge and deep understanding of the Power BI Service. Please make sure resumes submitted CLEARLY reflect the required skills and experience.

Resumes that do not reflect the required skills will be rejected, Interviews will be conducted via MS Teams. Interview times will reflect Pacific Standard Time.

Key Person must have the capability to train and attend work meetings on site in Salem, Oregon, with any possibility for remote work

highly conditional upon proven understanding, skill level, and Agency permission.

Qualifications

Type

Category

Qualification

Description

Competency

Required Skills Database 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 Development and Administration Advanced (7-9 Years) Yes Skills Others Tabular Development SSAS or Azure Advanced (7-9 Years) Yes Skills Others ArcGIS Mapping Advanced (7-9 Years) Yes 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 Visual Studio Proficient (4-6 Years) Yes Skills Others Communication skills both verbal and written Proficient communication and collaborative abilities among team, stakeholders, and managing staff required. Advanced (7-9 Years) Yes Skills Others Team work Polished and proficient collaborative capabilities required among team members via MS Teams, chat, and email. Advanced (7-9 Years) Yes

Vacancy expired!

ID	#23298751
State	Oregon
City	Salem
Job type	Contract
Salary	USD TBD TBD
Source	Suncap Technology
Showed	2021-11-23
Date	2021-11-22
Deadline	2022-01-21
Category	Et cetera
Create resume

Job Details

Enterprise Architect IV/Salem, OR (On-Site) 6 mth+ contract

Related jobs

»Lead Federal Enterprise Architect

»Principal Cloud Software Architect

»Senior Solution Delivery Architect

»Hybrid - Child, Family Mental Health Therapist - Salem

»Unarmed Retail Security- MIL/LEO - Salem, OR - $26/hr.

»Senior Technical Architect

»Consulting Architect - AI/ML