FOR IMMEDIATE DETAILS about this position, please contact Kiana Arevalo @ (949) 991-8285 // KArevalo@calance.com ======================================================== • • We will NOT accept 3rd Party (C2C) Contractors • • ======================================================= Position: Enterprise Data Architect JOB REF#: 43604 - 11126-25 Duration: 2 Months (Contract) Location: REMOTE - Salem, OR 97302 Pay Rate: $88.75 per hour (W2 ONLY) This role is 100% REMOTE - this is only a TWO MONTH Contract, REMOTE • • HOURS: (Monday - Friday, 8 AM – 5 PM, Pacific Standard Time Enterprise Data Architect will be leading the development of a comprehensive conceptual data model for the CAM system, then using that model to design dimensional data structures (star schemas), establish mappings, and document data dictionaries to support integration into the ODHS Enterprise Data Warehouse. This work will ensure CAM data is structured and documented for long-term reporting, analytics, and data governance alignment. Project Scope: Contractor will work with ORRAI’s data warehouse team and CAM/CALMS project contractors to lead data modeling efforts that bridge business requirements with data architecture implementation. This includes the development of a conceptual data model, translation into dimensional star schemas, creation of mapping documents, and delivery of a data dictionary consistent with standards. The contractor will ensure modeling work is accurate, well-documented, and aligned with data governance and warehouse integration needs. Responsible for designing and implementing information systems which will adequately support the enterprise infrastructure of the organization. Analyzes system requirements and ensures that systems will offer security and will be effectively integrated with current applications. Ensures that all systems are working at optimal levels and offers support to application development department regarding new technologies and system requirements. Has thorough knowledge of infrastructure, application programming, and web and software applications. Requires a bachelor's degree in area of specialty and at least nine years or equivalent experience in the field or in a related area. Familiar with a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgement to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected. RESPONSIBILITIES INCLUDE: Collaborate with CAM/CALMS contractors and ORRAI DBEs and DBAs to gather and clarify data requirements. Develop a comprehensive conceptual data model that defines key business entities, relationships, and data domains for the CAM system. Translate the conceptual model into a dimensional model (star schema) suitable for data warehouse integration. Design and document fact and dimension tables in alignment with data warehousing best practices. Develop mapping documentation between CAM system data and the designed star schema to support ETL planning and implementation. Create and maintain a detailed data dictionary for all modeled entities, attributes, and business rules, following ODHS metadata standards. Facilitate workshops and meetings to validate models with stakeholders and ensure shared understanding. Use tools such as Microsoft Visio or Erwin to produce clear and maintainable diagrams and documentation. Ensure all deliverables align with ORRAI architecture, data governance practices, and metadata frameworks. Provide support and consultation as the data structures move through the logical and physical implementation phases in the ODHS data warehouse. • • Please note, this is only a TWO MONTH Contract, REMOTE • • REQUIRED SKILLS/EXPERIENCE: Extensive experience in conceptual and dimensional Data Modeling, including star schema design for Data Warehouses. Strong proficiency in data modeling tools such as Microsoft Visio and/or Erwin. Demonstrated ability to create clear and accurate data documentation, including entity definitions, mappings, and data dictionaries. Strong verbal and written communication skills, with the ability to facilitate discussions and document requirements across technical and non-technical audiences. Experience working with data warehouse teams, including DBEs and DBAs, in enterprise environments. Familiarity with human services programs or public sector data systems is preferred. TECHNICAL SKILLS REQUIRED: Data Analysis (7-9 years of experience) Data Modeling in conceptual data modeling for large, complex system (7-9 years of experience) Data Warehousing (4-6 years of experience) SQL (7-9 years of experience) Microsoft Visio and/or Erwin data modeler (4-6 years of experience) Strong understanding, experience in design dimensional models and data modeling methodologies Excellent verbal and written communication Demonstrated ability to work closely with: Business analysts and program subject matter experts Database Engineers Database Administrators External contractors and project team In addition, the ideal candidate will have skills and experience in: Experience working with public sector, human services, or healthcare data systems (e.g., APD, CAM/CALMS, MMIS) Familiarity with data governance, data cataloging, and metadata management initiatives Experience supporting data warehouse development using SQL Server, Snowflake, or similar platforms DESIRED SKILLS: Knowledge of data governance, metadata, and ETL processes is a plus. ========================================== ========================================== Calance Consultant Benefits Offerings: EPO/PPO Medical Plans HMO/PPO Dental programs - Vision - VSP (Vision Plan Summary) 401K Retirement vesting program (VOYA) Paid Bi-Weekly/Direct Deposit Flex Spending Plan Voluntary Life, AD&D, STD or LTD plans