Job ID: NC-596486 (95590628)
Data Analyst with BA, SQL, PL/SQL, ETL, Tableau, BI and healthcare experience
Location: Raleigh NC (DHHS)
Duration: 12 months
Interview: In-person or webcam
SkillRequired / DesiredAmountof Experience
Should have the capability to translate business requirements into technical solutionsRequired3Years
Proven working experience as a data analystHighly desired3Years
Technical expertise regarding data models, database design development, data mining and segmentation techniquesRequired3Years
Strong knowledge on SQL, Pl/SqlDesired3Years
Strong knowledge of and experience with reporting, databasesRequired3Years
Strong experience with ETL techniquesHighly desired3Years
Hands-on experience in different file transfer methodologies and different file types and layoutsHighly desired3Years
Experience with Tableau, dashboard design and developDesired3Years
Excellent verbal and written communication skills with the ability present to both technical and business audiences.Required3Years
Strong experience in Healthcare DataDesired3Years
Proven experience delivering Business Intelligence solutionsDesired3Years
Project Management
• Working with Project Management and/or DHHS MES Architects to identify and maintain all data integrations in an Integration Library knowledge repository
• Working with Project Management to track the status of all data-related project tasks and features relevant to a business unit, flag any risks to business and help design mitigation
• Work with Business Unit Project Manager (PM)
• Work with Integrations Status Project Manager, if necessary
Data Requirements
• Working with the Data Office to identify and document data sources and data elements that are important for business, including all intake, storage, processing and transmission of the data, both internal & external
• Hands-on experience in different file transfer methodologies and different file types and layouts such as csv, txt, XML etc.
• Hands-on experience in extracting, manipulating and categorizing complex healthcare data and producing accurate output
• Documenting data flows relevant to a business unit
• Data quality assurance
oEstablish data-quality metrics and requirements
oDefine the values, ranges and parameters that are acceptable for each data element
oEstablish procedures for detection and correction of data- quality issues
oCollaborate to establish policies, procedures and internal controls affecting the quality of data
oEngage in the ongoing and detailed evaluation of data quality including identification of anomalies and discrepancies, identifying root cause(s), and implementing corrective measures
Documentation and Analytics Capabilities
• Documenting all reporting requirements for a business unit
• Establish procedures for detection and correction of data- quality issues
• Collaborate to establish policies, procedures and internal controls affecting the quality of data
• Engage in the ongoing and detailed evaluation of data quality including identification of anomalies and discrepancies, identifying root cause(s), and implementing corrective measures
Competencies, Knowledge, Skills and Abilities Required in this Position
•Strong technical knowledge regarding data, metadata, and data standards
•Excellent technical documentation and communication skills
•Databases, SQL, and data modeling basics
•Knowledge of healthcare data
•Detail oriented