Data Modeler

Hiring: W2 Candidates Only

Visa: Open to any visa type with valid work authorization in the USA

REQUIRED SKILLS:

Manage assignments and track progress against agreed upon timelines.

Plan organize prioritize and manage work efforts coordinating with the EDW and other teams.

Participate in status reviews process reviews deliverable reviews and software quality assurance work product reviews with the appropriate stakeholders.

Participate in business and technical requirements gathering.

Perform research on potential solutions and provide recommendations to the EDW and DOH.

Develop and implement solutions that meet business and technical requirements.

Participate in testing of implemented solution(s).

Build and maintain relationships with key stakeholders and customer representatives.

Give presentations for the EDW other DOH offices and agencies involved with this project.

Develops and maintains processes and procedural documentation.

Ensure project compliance with relative federal and commonwealth standards and procedures.

Understand and convey best practices and standards fordatamanagement and analysis.

Conduct training and transfer of knowledge sessions for maintaining and updatingdatamodelsdatadictionaries and metadata.

Complete weekly timesheet reporting in PeopleFluent/VectorVMS by COB each Friday.

Complete the weekly project status updates in Daptiv if necessary. This will be dependent on a project being entered into Daptiv.

Provide weekly personal status reporting by COB Friday submitted on SharePoint.

Utilize a SharePoint site for project and operational documentation; review existing documentation.

REQUIRED SKILLS:

TheDataModeler/ Architect can design develop and implementdatamodels anddatalake architecture to provide reliable and scalable applications and systems to meet the organizations objectives and requirements. TheDataModeleris familiar with a variety ofdatabase technologies environments concepts methodologies practices and procedures.

Demonstrable advanced experience withdataprofiling analysis and design developing and documenting information domain modelsdatastructures objects attributes relationships and integrity rules

Experience with logical and physicaldatamodeling including use of tools like ErWin or similar.

Experience managing metadatadatadictionaries and technical documentation

Experience with analyzing and translating business requirements and use cases into optimized modelsdataflows and developingdatabase solutions

Experience with and knowledge of relationaldatabases entity relationshipsdatawarehousing facts dimensions and star schema concepts and terminology

Strong proficiency with SQL Server T-SQL SSIS stored procedures ELT processes scripts and complex queries

Working knowledge of AzureDatabricks Delta Lake Synapse and Python

Experience with evaluating implementeddatasystems for variances discrepancies and efficiency

Experience with Azure DevOps and Agile / Scrum development methods

Auditingdatabases to maintain quality and creating systems to keepdatasecure

Demonstrable ability to communicate and document clearly and concisely

Ability to balance work between multiple projects and possess good organizational skills with minimal or no direct supervision

Ability to work collaboratively and effectively with colleagues and as a member of a team

Ability to present complex technical concepts anddatato a varied audience effectively.

More than 10 years of relevant experience

4-year college degree in computer science or related field with advanced study preferred.

PREFERRED EXPERIENCE:

Experience working in the public health or healthcare industry with various healthdatasets.