SQL Information Systems Data Coordinator
MedAssets, Inc. - Bridgeton, MO

This job posting is no longer available on MedAssets, Inc.. Find similar jobs:MedAssets jobs

Job Purpose:
The purpose of this position is to import client files of various formats into SQL databases to feed MedAssets Products. Additionally this position provides technical support for internal and external clients.

Role Qualifications:
Must have the ability to work in an environment that requires quick turnaround, poise, and skill with frequent interaction with senior management and external business partners requiring diplomacy, problem solving skills, resourcefulness, and professionalism.

This position requires confidentiality, initiative, and sound decision making.

Essential Duties & Responsibilities:
Coordinates with MedAssets Implementations to set up new clients. This includes adding new clients to MAS products, creating import maps, gathering import requirements, verifying client data, and testing data submissions.

Maintains file specific SQL import maps

Communicates Import statistics to the field

Downloads client data submissions from various ftp sites

Reviews and checks data submissions for issues and errors prior to importing

Contacts internal and external clients to resolve data issues as needed

Exports data from MedAssets products for customer deliverables

Performs analysis of data for special projects

Develops SQL scripts, MicroSoft Access programs, stored procedures, and processes for the department as needed.

Assists with various projects as deemed necessary

Internal Responsibilities:
Adheres to all company policies and procedures including, but not limited to those identified within the Standards of Business Conduct and the Employee Handbook, as may be amended from time to time. Adheres to all applicable laws and regulations and the company's governance/compliance program.

Responsible for reporting violations of the company's policies and procedures, Standards of Business Conduct, governance program, laws and regulations through the company's Help Line or other mechanism that may be available at the time of the violation. Assists with internal control failure remediation efforts.

Becomes knowledgeable of internal control responsibilities through training and instruction. Responsible and accountable for internal control performance within their area of responsibility. Participates in the internal controls self-assessment process.

Ensures concerns with internal control design or performance and process changes that impact internal control execution are communicated to management.

Minimum Knowledge, Competencies & Qualifications:
Bachelor’s degree in a healthcare related field or equivalent business related experience.

MicroSoft Certification or formal training is preferred.

Medical product knowledge is preferred.

SQL programming skills are required

Working knowledge of SQL BI Dev Studio/SQL Server Integration Services is prefered

Communicate effectively with customers, internal staff, and field staff. May interact with members and vendors requiring an understanding of the importance of customer service

Has an understanding of purchasing and ERP systems to work with various customers to provide required information to the department.

Ability to define problems, collects data, establish facts, and draw valid conclusions.

Has the ability to solve complex problems encountered by members and/or suppliers.

Must be able to strengthen Company’s relationship with members and supplier and build trust.

Demonstrates strong analytical and problem solving abilities and is very detail oriented.

Demonstrated ability to work on multiple projects within a team environment

Proficiency with MS Office

Strong oral and written communication skills

Strong work ethic with the ability to complete tasks and deliverables under tight deadlines while maintaining flexibility

Adjusts to changing priorities

Advanced ability in organization, time management and planning skills

Strong interpersonal and partnership skills

Ability to work independently and as a team player

Reporting to this position: No direct reports

Travel: Some travel may be required

Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear. The employee must occasionally lift and/or move up to 15 pounds.

Mental Demands: T he employee must be able to follow directions, to get along with others, and handle stress;

Work environment: The noise level in the work environment is usually minimal.

Required Skills

Required Experience

About this company
64 reviews
MedAssets is at the center of improving the quality and effectiveness of the healthcare industry. From establishing best practice value for...