T-SQL Developer
Remote
C2h role
• 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
Required Experience / Qualifications:
• 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
• Excellent written and verbal communication skills
• 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
Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status