CDMP AWS Healthcare Experience PHI SQL Scripts Relational Database Database Experien   Requirement id 110855 Job title Analyst Job location in Dorchester, MA Skills required CDMP, ETL Tools, AWS, Healthcare Experience PHI SQL Scripts Re Open Date 15-Oct-2020 Close Date Job type Not specified Duration 8 Months Compensation DOE Status requirement --- Job interview type Phone Screening    Email Recruiter: coolsoft Job Description Analyst: CDMP, ETL Tools, AWS, Healthcare Experience PHI SQL Scripts Re Note: Email Submission Note: Maximum number of resumes per ITS63 Vendors: 3 Submission Deadline: 10/23/2020 Start Date: 11/3/2020 End Date: 6/30/2021 Client: EHS Description: SUMMARY: The Senior Database Analyst/Designer will work on the Data Cleanup and Standardization project at the Registry of Vital Records and Statistics (RVRS) in Dorchester, MA. Goal of the project is to consolidate the data from multiple data sources on multiple platforms into one single SQL Server instance which will become the Operational Datastore (ODS) at RVRS. This project is part of a larger program to modernize all the IT environment at RVRS. The Senior Database Analyst/Designer will work closely with the staff at the RVRS, the IT Application Manager, ETL Developer/s and a Senior IT Project Manager as well as a Business Analysts to analyze and document the current data sources and generate work instructions for the ETL Developer/s. Job Duties: • Create and maintain an inventory of all data sources in use by RVRS. • Create and maintain a data dictionary for all data sources • Design data/table structure on a staging environment • Translate business rules and requirements into design specifications for data standardization, normalization/de-normalization, access security... • Create a data model and Data Dictionary for all data domains/entities (Birth, Death, Fetal Death, Marriage, Divorce, Providers, Morgues....) on the ODS • Translate requirements and business rules into instructions for ETL programmer and SQL developers to write the transition scripts • Write test plans and acceptance criteria Education and Experience: Mandatory • Bachelors degree in Computer Science, Computer Information Systems, Information Management or equivalent work experience • Proven track record of designing and implementing complex and large scale Enterprise Databases • +10 years of o designing relational database o creating conceptual, logical and physical data models o documenting databases using Entity Relationship Models and Data Dictionaries o writing SQL scripts o working in a software development environment • Deep understanding of database concepts, data domain concepts, security concepts, Normal Forms, Data Warehousing… • Eliciting and writing requirements, design specifications and work instructions for developers • Strong Project Management and leadership skills • Working through ambiguity • Communicating clearly with technical and non-technical stakeholders Desirable • CDMP or similar certification • Hands on experience with ETL tools and processes • Familiarity with AWS hosting • Experience working in a healthcare environment • Experience working with PHI   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 110855 while calling.   Other jobs in MA: Boston (103), Burlington (1), Cambridge (1), Canton (3), Chelsea (9), Franklin (1), Lexington (2), Malden (10), Marlborough (2), Maynard (2), Newton (1), Quincy (6), Sharon (1), Waltham (1), Welesley (1), Wellesley (6), Westborough (1), Westbourough (1),         (Analyst: CDMP, ETL Tools, AWS, Healthcare Experience PHI SQL Scripts Re in Dorchester, MA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)