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.
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
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.
MedAssets is at the center of improving the quality and effectiveness of the healthcare industry. From establishing best practice value for...