Role overview

Qualifications

7+ years of advanced T-SQL (complex JOINs, subqueries, stored procedures, indexes, temp tables and CTEs, query optimization is a MUST)
5+ years of functional testing and regression/negative testing
3+ years of Intermediate to advanced SSRS (hands on dev experience with drilldowns, drillthroughs, dynamic groupings, document maps, single dataset for multiple controls)
5+ years of intermediate to advance SSIS

Responsibilities

Researches and evaluates alternative solutions and recommends the most efficient and cost-effective application programming solution
Develops, documents, and follows standard coding practices
Comprehensively tests, including negative/regression testing, to prevent re-work
Provides comprehensive consultation to business units and IT management and staff at the highest technical level on all phases of data integration processes and data management

Key facts

Remote from: Illinois (USA)
Full time
Senior (5-10 years)
English

Hard skills

SQL (Programming Language) SQL (Programming Language) SQL Server Integration Services (SSIS) Debugging Database Queries Stored Procedure Teradata BI Data Integration Data Management Medicare Medicaid Medical Management

Other skills

Teamwork
Logical Reasoning
Detail Oriented
Quick Learning
Multitasking
Problem Solving

About the company

Conexess Group

Information Technology & Services

Conexess Group is a staffing and consulting solutions provider that combines the technology you need with relationships you can trust. We understand that one size never fits all, which is why we work with our clients to develop specialized solutions that fit their organizations, coupled with responsive service that ensures we get the job done right. By getting to know our clients on a deeply personal level, we unlock the potential of our elite technical knowledge and talent network, granting access to game-changing consultants and concierge-level service. And our 80 years of combined experience enables us to attract only the best specialized talent, whom we always treat with the utmost respect and professionalism. In fact, many of our consultants have come to view Conexess as a career counselor, providing constant updates on the latest opportunities. Our culture and values reflect our innovative approach toward attracting and retaining the most talented experts and producing consistent results for our Fortune 500 and mid-cap clients. Known for our technological leadership and entrepreneurial passion, our firm has been delivering value to our clients by providing solutions to their most complex challenges. Whether you’re in need of specialized talent or a boost to your career, we look forward to working with you. Specialties: IT Staff Augmentation | ERP Consulting Solutions | Accounting & Finance Recruitment

Company details

Company typeSME

IndustryInformation Technology & Services

Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Conexess Group is aiding a large healthcare client in their search for a SQL Developer in a remote capacity. This is a long-term opportunity with a competitive compensation package.

Responsibilities:
• Researches and evaluates alternative solutions and recommends the most efficient and cost-effective application programming solution.
• Develops, documents, and follows standard coding practices.
• Comprehensively tests, including negative/regression testing, to prevent re-work.
• Provides comprehensive consultation to business units and IT management and staff at the highest technical level on all phases of data integration processes and data management.
• Design, Develop and enhance new and existing backend application components and ETL processes including creation and modifying of stored procedures, SQL Job, SSIS packages, API's.
• Work with data from multiple sources including relational databases like SQL Server, Teradata, and flat files.
• Analyze and enhance SQL queries to improve performance, ensuring that queries/stored procedures are efficient, scalable, and align with best practices.
• Validate data consistency, accuracy, and completeness within SQL code/Stored procedures and troubleshoot issues related to data integrity across sources.
• Strong debugging skills and able to identify and fix the issues/bugs identified in the Code/Stored Procedures.
• Creation of necessary technical documentation based on implementation details.
• Conduct development work required in a comprehensive manner consistent with our best practices and standards
• Coordinate with systems analyst and other developers on technical delivery
• Proactively learn ways to improve systems, reducing costs and maximizing opportunities

Requirements:

7+ years of advanced T-SQL (complex JOINs, subqueries, stored procedures, indexes, temp tables and CTEs, query optimization is a MUST). MS SQL is a must. TD SQL is desired but not required.
5+ years of functional testing and regression/negative testing
3+ years of Intermediate to advanced SSRS (hands on dev experience with drilldowns, drillthroughs, dynamic groupings, document maps, single dataset for multiple controls etc etc)
5+ years of intermediate to advance SSIS
Logical, detail-oriented team player who learns quickly and has the ability to handle multiple, competing priorities in a fast paced environment

Desired Experience / Qualifications:

Bachelor’s Degree
Teradata
Medicare / Medicaid
Medical and coding terminology
SNP Model of Care
Health Services / Medical Management / Population Health

#LI-Remote
#LI-DO1