Enterprise Architect IV

Overview

Remote
Depends on Experience
Contract - W2
Contract - 8 week(s)

Skills

Architecture

Job Details

Enterprise Architect IV (Remote)
Primary Location: Remote

V-Soft Consulting is currently hiring for an Enterprise Architect IV (Remote) for our premier client.

Education and 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.
  • Knowledge of data governance, metadata, and ETL processes is a plus.
  • Experience working with the 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.

Knowledge, Skills and Abilities »
  • Data Analysis (7-9 years of experience).
  • SQL (7-9 years of experience).
  • Data Modeling in conceptual data modeling for large, complex systems (7-9 years of experience).
  • Data Warehousing (4-6 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.

WHAT YOU’LL DO:
Job Responsibilities:
  • Create and maintain a detailed data dictionary for all modeled entities, attributes, and business rules, following ODHS metadata standards.
  • 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.
  • 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.
  • 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.

Interested?
Qualified candidates should send their resumes to hdaram@vsoftconsulting.com

V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America, V-Soft Consulting Group is headquartered in Louisville, KY with strategic locations in India, Canada and the U.S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks.

As a valued V-Soft Consultant, you’re eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more. V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth.

V-Soft Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

For more information or to view all our open jobs, please visit www.vsoftconsulting.com or call (844) 425-8425.

#LI-PD1
 
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.