Perform ETL operations on healthcare data from multiple sources. To succeed in this role, the candidate should be analytical and excellent communicator. Experience in the healthcare industry is a plus. Experience integrating data from disparate sources in MS SQL Environment. You will be responsible towards working with different stakeholders to accomplish business and operation goals.
Key duties & responsibilities
- Data processing (ETL) using MSSQL 2012/2014 R2 SSIS with stored procedures, views, and other various database objects; import and export processing; data conversions; business process workflows and metrics reporting.
- Providing client support services and enhancements.
- Controlling daily ticket resolution/prioritization as client and user volume increases.
- Prioritizing issues based on client expectations, volume of current tickets, and visibility of issues across the enterprise.
- Analyzing the overall enterprise environment to find gaps and can think outside-of-the-box in order to design and create functionality which will prove to be of value.
- Provide SQL training to other technicians.
- Drive ticket resolution momentum and provide feedback to US Leadership where staff improvements can be made in order to better overall productivity of the technicians.
- Manage MSSQL Server 2012/2014 R2 database objects (stored procedures, views, synonyms, tables and overall schema), reporting, and administration.
Skills and Knowledge
- Bachelor s degree in computer science or equivalent.
- 4-7 years of experience writing T-SQL code in order to triage issues, analyse data, and optimize database objects.
- 2-5 years of experience of troubleshooting using MSSQL 2012 R2/2014 SSIS.
- 2-3 years of experience relating to ETL flat file/real-time message data loading.
- Strong with MSSQL 2012 R2/2014 Administration.
Key competency profile
- Identify new opportunities by anticipating change and planning accordingly
- Feels comfortable working in a changing environment
- Communicates accurately at clients level of understanding, checking to make sure all information is correct.
- Be accountable for customer service of highest quality
- Help people improve by learning from successes and failures
- Finds flexible and rapid solutions to meet the client s needs.
- Takes controlled risks, seeking support from team members when unsure.
- Motivate each other to perform at our highest level
- Prioritizes work and sets realistic deadlines to ensure that important tasks are achieved on or ahead of time, with quality results.
- Shares own expertise with team members, while remaining open to others ideas.
- Identify area of process improvement and automation
- Help team members with your expertise to archive common goal.
- Proactively identifying problems and solutions.
- Takes full responsibility for meeting the client s level of satisfaction.
- Checks back with client to ensure the correct information has been provided.
- Continuously searches for new ideas and better ways of doing things.
- Takes steps to learn about own department, its vision, its values and its strategic objectives.
- Encourages others to look for solutions rather than presenting problems
