SQL Developer (Remote)

Our History: From our start in 2009, Conexess has established itself in 3 markets, employing nearly 200+ individuals nation-wide. Operating in over 15 states, our client base ranges from Fortune 500/1000 companies to mid-small range companies. For the majority of the mid-small range companies, we are exclusively used due to our outstanding staffing track record. Who We Are: Conexess is a full-service staffing firm offering contract, contract-to hire, and direct placements. We have a wide range of recruiting capabilities extending from help desk technicians to CIOs. We are also capable of offering project-based work. Conexess Group is aiding a large healthcare client in their search for a SQL Developer in a remote capacity. Thisis 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