Data Modeler I

POSITION TITLE: DATA MODELER I

Supervised by: Data Modeler Team Lead (Direct)

Data Modeler Manager (Indirect)

Supervises: N/A

Status: Full-time, Exempt

POSITION SUMMARY. The Data Modeler I focus on activities related to the creation, modification, and population of SQL Server databases, archiving a wide variety of client legacy data to MediQuant products. Incumbent must have a growing knowledge of MediQuant software products and how these work in conjunction with created databases. Data Modeler will report to a Data Modeler Team Lead.

JOB DUTIES and ESSENTIAL FUNCTIONS. A qualified individual must be able to perform the essential functions of the job as listed, with or without accommodation. (An Asterisk (*) Identifies an Essential Function)

• Translates functional product requirements into technical designs for Legacy System archives (*)
  • Understands and contributes to Project Scope via evaluation of client data and legacy System knowledge.
  • Ability to learn and comprehend DataArk Schema Modules and applications.
  • Ability to map/translate/load associated simple Legacy System data via SQL Server and load plan.
  • Able to assist other Data Modeler Team Members, during absence, with project responsibilities on simple Legacy Systems.
  • Ability to ensure work is accurate and complete validation hand-off steps.
  • With assistance from Team Lead, ability to enter IT support tickets for tasks such as Go-Live and Product & Solution Delivery RFA.
• Trouble Shooting and Problem Solving (*) – Identifies problems and pro-actively intervenes to mitigate or eliminate potential for negative impact.
  • Effectively checks work for accuracy, understanding where opportunities for errors exist. Takes ownership to ensure own work is error-free.
  • Determines when an immediate fix is the best course, or when it is necessary to hand the situation to an identified source for root cause resolution.
  • Uses experience and expertise to intrinsically follow the data and ease the standard validation process.
• Organization and Time Management (*) – Handles multiple projects and prioritizes deadlines.
  • Identifies and utilizes all resources available when priorities conflict to meet deadlines. Must be able to clearly communicate issues and tenacious in finding resolution.
  • Able to handle fluctuating workloads and can prioritize during times of peak demand and conflicting priorities. Knows when to seek assistance to ensure deadlines are met and a quality product is delivered.
  • Meet the minimum utilization requirements of the role as required – expectations are subject to change but will be communicated in writing
• Communicate clearly with internal customers (*) – Understands the importance of keeping all team members apprised of the project status.
  • Seeks to understand clients' expectations by asking questions with assistance from identified project resources.
  • Works as the migration expert on the implementation team alongside sales and support.
  • Ability to follow direction from Team Lead and/or more experienced Data Modelers.
  • Able to identify areas of improvement for DataArk and effectively communicate these to their Team Lead.
  • Liaise with the Project Team to create a methodology to meet client needs.

QUALIFICATIONS

Competencies

• Collaboration Skills
• Communication Proficiency
• Organizational Skills
• Presentation Skills
• Problem Solving/Analysis
• Technical Capacity
• Thoroughness
• Time Management

Required Education and Experience

• Bachelor’s degree in computer engineering, computer systems, computer science, engineering or software engineering, or equivalent number of years of experience, plus three years of data modeling design, architecture, administration and development experience, preferred.
• Strong SQL scripting skills and experience parsing and manipulating file data.
• Proven Healthcare IT, clinical or revenue cycle experience
• Experience with full lifecycle implementations (from analysis through deployment and support).
• Highly skilled in process chain design, data security, object migration to different environments.
• Extensive experience with design documentation.
• Intermediate-level knowledge of SQL (*) – Creates, modifies, and populates SQL Server databases in accordance with the environments and parameters of the system that is being migrated:
• Utilizes knowledge of tables and normalization to determine where data should reside.
• Determines an accurate and efficient approach to writing and editing SQL scripts used to load client data. Uses SQL to diagnose and solve data integrity issues.

Preferred Education and Experience:

• HealthCare experience preferred.
• Previous experience in Hospital & Healthcare, Computer Software industries, preferred.
• Ability to discern and clearly understand client's needs through effective communication and interaction.
• Ability to solve problems using logical thought processes and devising creative solutions.
• High attention to accuracy and detail.
• Ability and desire to work in a strong team culture.
• Knowledge with HIPAA regulations involving PHI and HITECH
• Strong customer service and Information technology acumen

Work Environment. This job operates in a blend of professional office and home office environments. Incumbent will use standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.

Physical Demands. While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to sit for long periods of time, stand; walk; use hands to finger, handle or feel; and reach with hands and arms. The employee is occasionally required to climb or balance; and stoop, kneel, crouch or crawl. The employee must occasionally lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.

Position Type and Expected Hours of Work. This is a full-time position, and hours of work and days are typically Monday through Friday, 8:30 a.m. to 5 p.m. Some flexibility in hours is allowed, but the employee must be available during the “core” work hours of 9:00 a.m. to 3:30 p.m. and must work 40 hours each week to maintain full-time status. Occasional evening and weekend work may be required as job duties demand.

Travel. Little to no travel is expected for this position however infrequent travel to company meetings and professional development opportunities may be required.

Work Authorization/Security Clearance. In compliance with Federal employment laws, MediQuant will verify the identity and employment authorization of each person hired.

AAP/EEO Statement. MediQuant, Inc. is an equal opportunity employer.

Compliance. Employee shall comply with all MediQuant policies, state and federal laws, regulations, and contractual obligations when accessing MediQuant or client Confidential Data, Confidential Information, and Information Assets.

Other Duties. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time.