Enterprise Architect

28 Jun 2024

Vacancy expired!

This position requires some onsite work in Salem, OR, including initial training and weekly onsite meetings. Any 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. Remote work schedule must abide by PST time zone and business hours.

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
  • Client 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 collaboratewith 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

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.

Key Person must have the capability to train and attend work meetings on site in Salem, OR.About Us:AgreeYa is a global systems integrator delivering competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,850 staff across offices. AgreeYa works with 500+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public sector, Pharma & Biotech, and others. Please visit us at www.agreeya.com for more information.AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website to learn about our Career & Culture.

  • ID: #43664165
  • State: Oregon Salem 97301 Salem USA
  • City: Salem
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-06-28
  • Deadline: 2022-08-07
  • Category: Et cetera