Overview
Remote
$60 - $70
Accepts corp to corp applications
Contract - Independent
Contract - 9 Month(s)
Skills
Agile
Daptiv
ERwin
ELT
Microsoft Azure
Meta-data Management
Public Health
Azure Databricks
Delta Lake
Synapse
Python
SQL Server
T-SQL
SSIS
data warehousing
facts
dimensions
Job Details
Title: Data Modeler/Architect(775851)
Duration: 9 Months
Client: Commonwealth of Pennsylvania
Note: Remote role
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.
- The selected contractor will collaborate with EDW team members and DOH program area stakeholders to develop and implement solutions that meet the requirements for using the data.
- This position will be expected to develop and implement data analysis methodologies, validate business use cases for accuracy and completeness of proposed data models, and work with business analysts, application developers, and DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, and program area customer satisfaction objectives.
Responsibilities:
- 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 for data management and analysis.
- Conduct training and transfer of knowledge sessions for maintaining and updating data models, data dictionaries, 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:
- 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 organization s objectives and requirements.
- The Data Modeler is familiar with a variety of database technologies, environments, concepts, methodologies, practices, and procedures.
- Demonstrable, advanced experience with data profiling, analysis and design, developing and documenting information domain models, data structures, objects, attributes, relationships, and integrity rules
- Experience with logical and physical data modeling, including use of tools like ErWin, or similar.
- Experience managing metadata, data dictionaries and technical documentation
- Experience with analyzing and translating business requirements and use cases into optimized models, data flows, and developing database solutions
- Experience with and knowledge of relational databases, entity relationships, data warehousing, 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 Azure Databricks, Delta Lake, Synapse and Python
- Experience with evaluating implemented data systems for variances, discrepancies, and efficiency
- Experience with Azure DevOps and Agile / Scrum development methods
- Auditing databases to maintain quality and creating systems to keep data secure
- 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 and data to 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 health data sets.
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.