The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
M8y57q5xl50dzv1104k

Data Solution Enterprise Analytics SQL II (Open Work Location)

Job Description

JOB SUMMARY: This position will design, develop, test and implement SQL Server based programs, applications, and systems leveraged by all facets of the organization. The incumbent will utilize their expertise and available tools, which may include but not limited to Visual Basic for Applications (VBA) and/or SQL Server Integration Services (SSIS), to support the execution and maintenance of operational and client initiatives to ensure continual success. JOB ROLES AND RESPONSIBILITIES: 1. Create, optimize and maintain complex T-SQL as part of stored procedures, views, functions, and queries that efficiently analyze health care claims data based on requirements. 2. Collaborate on multiple complex technical projects within the department. Identify and drive implementation of enhancements based on project participation as necessary. 3. Perform complex ad hoc queries against data tables to support development work. 4. Develop and support internal and client facing operational volume and performance reporting. 5. Troubleshoot and resolve issues as they arise. Ensure databases and systems are executing optimally. 6. Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring. 7. Recommend and develop Exact-Transform-Load (ETL) packages required for data integration projects. 8. Successfully deliver solution components (business requirements, design specification, functional specifications, development, testing, and deployment). 9. Collaborate, coordinate, and communicate across disciplines and departments. 10. Ensure compliance with HIPAA regulations and requirements. 11. Demonstrate Company's Core Competencies and values held within. 12. Please note due to the exposure of PHI sensitive data -- this role is considered to be a High Risk Role. 13. The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary. JOB SCOPE: This position works under minimal supervision in a results oriented manner. The incumbent will aid in the establishment of successful, efficient, objective focused solutions when completing job responsibilities. The incumbent may have regular contact with all levels of internal and external sources to complete objectives, while keeping the needs of external and internal customers as a priority when making decisions and taking action.

Job Requirements

JOB REQUIREMENTS (Education, Experience, and Training): * Minimum Bachelor's degree in statistics, mathematics, actuarial science, economics, information technology, computer science, or similar rigorous technical field; Graduate Degree strongly preferred. * Experience with Microsoft SQL Server, T-SQL, Stored Procedures, Triggers, table indexing and data access optimization techniques, 2014 or 2016 preferred * T-SQL programming and the ability to design, write and optimize complex well-performing SQL stored procedures * Experience with Microsoft Office applications including Excel, Access, and VBA macros * Strong communication skills and ability to work independently * Ability to manage multiple projects at the same time * Must be a self-motivated, creative problem-solver who can adapt to new technologies and evolving customer requirements * Willingness to learn new programming languages and adopt new platforms is a plus * Familiarity using Microsoft Team Foundation Server or similar source control management platform * SSIS, SSRS, SSAS experience is a plus * Microsoft SQL Certification is a plus * Required licensures, professional certifications, and/or Board certifications as applicable * Individual in this position must be able to work in a standard office environment which requires sitting and viewing monitor(s) for extended periods of time, operating standard office equipment such as, but not limited to, a keyboard, copier and telephone As an Equal Opportunity Employer, the Company will provide equal consideration to all employees and job candidates without regard to sex, age, race, marital status, sexual orientation, religion, national origin, citizenship status, physical or mental disability, political affiliation, service in the Armed Forces of the United States, or any other characteristic protected by federal, state, or local law.

Job Snapshot

Location US-IL-Naperville
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type Engineering & Aerospace, IT & Technical
Apply

Company Overview

MultiPlan

At MultiPlan, our employees are instrumental to our success and we reward them accordingly. We offer a very competitive compensation and benefits package, an incentive bonus program, service recognition awards and an employee recognition program that honors individuals whose achievements go above and beyond even our high expectations. We invite you to search our listing of current Career Opportunities. One of our top priorities is the career development of our employees. Learn More

Contact Information

US-IL-Naperville
Snapshot
MultiPlan
Company:
US-IL-Naperville
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
Engineering & Aerospace, IT & Technical
Store Type:

Job Description

JOB SUMMARY: This position will design, develop, test and implement SQL Server based programs, applications, and systems leveraged by all facets of the organization. The incumbent will utilize their expertise and available tools, which may include but not limited to Visual Basic for Applications (VBA) and/or SQL Server Integration Services (SSIS), to support the execution and maintenance of operational and client initiatives to ensure continual success. JOB ROLES AND RESPONSIBILITIES: 1. Create, optimize and maintain complex T-SQL as part of stored procedures, views, functions, and queries that efficiently analyze health care claims data based on requirements. 2. Collaborate on multiple complex technical projects within the department. Identify and drive implementation of enhancements based on project participation as necessary. 3. Perform complex ad hoc queries against data tables to support development work. 4. Develop and support internal and client facing operational volume and performance reporting. 5. Troubleshoot and resolve issues as they arise. Ensure databases and systems are executing optimally. 6. Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring. 7. Recommend and develop Exact-Transform-Load (ETL) packages required for data integration projects. 8. Successfully deliver solution components (business requirements, design specification, functional specifications, development, testing, and deployment). 9. Collaborate, coordinate, and communicate across disciplines and departments. 10. Ensure compliance with HIPAA regulations and requirements. 11. Demonstrate Company's Core Competencies and values held within. 12. Please note due to the exposure of PHI sensitive data -- this role is considered to be a High Risk Role. 13. The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary. JOB SCOPE: This position works under minimal supervision in a results oriented manner. The incumbent will aid in the establishment of successful, efficient, objective focused solutions when completing job responsibilities. The incumbent may have regular contact with all levels of internal and external sources to complete objectives, while keeping the needs of external and internal customers as a priority when making decisions and taking action.

Job Requirements

JOB REQUIREMENTS (Education, Experience, and Training): * Minimum Bachelor's degree in statistics, mathematics, actuarial science, economics, information technology, computer science, or similar rigorous technical field; Graduate Degree strongly preferred. * Experience with Microsoft SQL Server, T-SQL, Stored Procedures, Triggers, table indexing and data access optimization techniques, 2014 or 2016 preferred * T-SQL programming and the ability to design, write and optimize complex well-performing SQL stored procedures * Experience with Microsoft Office applications including Excel, Access, and VBA macros * Strong communication skills and ability to work independently * Ability to manage multiple projects at the same time * Must be a self-motivated, creative problem-solver who can adapt to new technologies and evolving customer requirements * Willingness to learn new programming languages and adopt new platforms is a plus * Familiarity using Microsoft Team Foundation Server or similar source control management platform * SSIS, SSRS, SSAS experience is a plus * Microsoft SQL Certification is a plus * Required licensures, professional certifications, and/or Board certifications as applicable * Individual in this position must be able to work in a standard office environment which requires sitting and viewing monitor(s) for extended periods of time, operating standard office equipment such as, but not limited to, a keyboard, copier and telephone As an Equal Opportunity Employer, the Company will provide equal consideration to all employees and job candidates without regard to sex, age, race, marital status, sexual orientation, religion, national origin, citizenship status, physical or mental disability, political affiliation, service in the Armed Forces of the United States, or any other characteristic protected by federal, state, or local law.
Mrt3c768phnp0gk12d2
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Data Solution Enterprise Analytics SQL II (Open Work Location) Apply now