Queries MS SQL Management Skills Management Technologies Communicate And Collabora   Requirement id 134065 Job title Analyst Job location in Office Bldg, IA Skills required Complex Database Structures, Master Data Management, SQL Analyst, Queries MS SQL Management Skills Managem Open Date 25-May-2022 Close Date Job type Contract Duration 13 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: Complex Database Structures, Master Data Management, SQL Analyst, Queries MS SQL Management Skills Managem Start Date :06/06/2022 End Date :06/06/2023 Submission Deadline :5/30/2022 Client Info :IDPH-Information Management: Department of Public Health Description : The purpose of this position is to oversee daily operations for electronic laboratory reporting for infectious & communicable diseases and environmental health conditions. In addition, this role will assist with other data exchange projects at the Iowa Department of Public Health involving both internal and external customers. • Oversees daily operations for electronic laboratory reporting for infectious & communicable disease and environmental health condition surveillance. • Monitors system-wide electronic laboratory reporting traffic, identifies potential issues, investigates and facilitates resolution of identified issues. • Consults and troubleshoots potential connectivity issues with data sharing partners across the State of Iowa in collaboration with CyncHealth. • Provides end user support and training for the smartLab system and the HL7 messaging protocol. • Extracts and analyzes data to ensure data accuracy, integrity and consistency, and transform raw data into meaningful, actionable information using MS SQL Server Management Studio, MS Excel or Google Sheets. • Monitors dashboards and data reports in Tableau and creates tools in MS Excel by using pivot tables and Excel formulas such as VLOOKUP. • Develops stored procedures and functions using MS SQL Server Management Studio for data extraction and validation to support electronic exchange of any nationally notifiable disease - health limited data set to the Centers for Disease Control and Prevention (CDC). • Provides technical support to the Iowa Surveillance and Electronic Exchange team and surveillance programs in various ways as projects arise such as data extraction, analysis and reporting using various tools like MS Excel and MS SQL Server Management Studio. • Creates smartLab portals and user accounts, maintains and updates the MS Access database containing contact information for ELR data providers and their associated stage in ELR participation. • Participates in weekly team meetings and quarterly CDC calls, and provides status updates.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 134065 while calling.   Other jobs in IA: Des Moines (16), West Des Moines (2), West Desmoines (1),         (Analyst: Complex Database Structures, Master Data Management, SQL Analyst, Queries MS SQL Management Skills Managem in Office Bldg, IA)

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)