Information Technology

Employment TYPE

Contract

LOCATION

Salem, Oregon

DATE POSTED

February 24, 2021

INDUSTRY

Information Technology

POSITION(S)

1

SALARY

Negotiable

Job# J1200

Enterprise Architect IV

About The Opportunity

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Department of Human Services (DHS). 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.

Job Description

  • Oregon Department of Human Services (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 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

    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, 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
  • 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, regardless of how you respond to the Qualifications

Desired Skills

  • Our primary criteria are the qualifications and experience of the proposed key person. Please propose your strongest candidate, at a rate less than or equal to the maximum.
  • Interviews will be conducted via Skype or MS Teams. Interview times will reflect Pacific Standard Time.
  • Due to circumstances beyond our control, we anticipate two weeks or more for the background check completion for the selected candidate. In addition to the standard OHA/DHS background check, the selected candidate will need to pass a CJIS background check. This will likely add to the background check process timeline.
  • Key Person may work remotely.
  • The selected key person could potentially telecommute, as agreed to between the Agency Authorized Representative and the key person. Any decision to allow telecommuting is made with the understanding that decision will be re-evaluated by the Agency Authorized Representative on a regular basis. The key person should be available to work onsite within a reasonable timeframe.
  • Telecommuting will be contingent upon the key person providing his/her own adequate computer, monitor(s), Internet connection, and telephone, and be readily available during normal working hours via phone, email or instant message. Access to Agency systems will be provided via Citrix Remote Desktop or similar software. No hardware or additional software will be provided at the key person\\\\\\\'s home site or his/her PC, unless a specific device is required to perform assigned duties (such as Multi-Factor Authentication devices).
  • If the Agency Authorized Representative and key person agree to allow off-site work, the expectation is for that key person to work onsite as soon as the general workforce transitions back into the Agency workplace.
  • Work schedule is typically Monday - Friday, 8 AM - 5 PM Pacific Standard Time.
  • Please note: Note there are four identical requisitions to support the body of work. Please propose your strongest candidates for one or more requisitions.
  • Duration

    6 Months

    Please Contact me to discuss the hiring process!

    Vomsi Kumar

    Sr. Executive Recruiter
    Contact: (310) 929-8421 Ext: 103
    Email: vomsi.kumar@staffactory.com

    Hi! My name is Vomsi Kumar. Helping consultants with getting their desired job is what makes me feel alive. I build a unique relationship with each of my consultants and work on their profile as per their needs. I believe that my consultants are my assets and this motivates me to serve them in an even better manner. Hence, I work towards the success of every consultant I work with.