Architect (Data Modeler)
Architect (Data Modeler)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
The Data Modeler / Data Architect is a senior level resource with specialized knowledge and experience in data analysis data modeling and database design. The selected contractor must have proven and demonstrated experience in the development validation publishing and maintenance of data designs logical and physical data models data dictionaries and metadata repositories.
Manage assignments and track progress against agreed upon timelines.
Participate in status reviews process reviews deliverable reviews and software quality assurance work product reviews with the appropriate stakeholders.
Perform research on potential solutions and provide recommendations to the EDW and DOH.
Participate in testing of implemented solution(s).
Give presentations for the EDW other DOH offices and agencies involved with this project.
Ensure project compliance with relative federal and commonwealth standards and procedures.
Conduct training and transfer of knowledge sessions for maintaining and updating data models data dictionaries and metadata.
Complete the weekly project status updates in Daptiv if necessary. This will be dependent on a project being entered into Daptiv.
Utilize a SharePoint site for project and operational documentation; review existing documentation.
CONTRACTOR SKILLS AND EXPERIENCE REQUIREMENTS
REQUIRED SKILLS:
The Data Modeler / Architect can design develop and implement data models and data lake architecture to provide reliable and scalable applications and systems to meet the organizations objectives and requirements. The Data Modeler is familiar with a variety of database technologies environments concepts methodologies practices and procedures.
Experience with logical and physical data modeling including use of tools like ErWin or similar.
Experience with analyzing and translating business requirements and use cases into optimized models data flows and developing database solutions
Strong proficiency with SQL Server T-SQL SSIS stored procedures ELT processes scripts and complex queries
Experience with evaluating implemented data systems for variances discrepancies and efficiency
Auditing databases to maintain quality and creating systems to keep data secure
Ability to balance work between multiple projects and possess good organizational skills with minimal or no direct supervision
Ability to present complex technical concepts and data to a varied audience effectively.
4-year college degree in computer science or related field with advanced study preferred.
PREFERRED EXPERIENCE:
This will be a 10-month engagement beginning in September 2025
LOCATION:
In addition DOH will supply all necessary hardware and software for daily use that are needed to complete assigned work items.
Employment Type
Full-time
