Application Development Advisor

job summary: 100% REMOTE ---------------------------------------------------------------------- location: Kasbeer, Illinois job type: Contract salary: $55 - 69 per hour work hours: 8am to 5pm education: No Degree Required responsibilities: Responsibilities: Application Development team members within the Quality Apps Support team are responsible for the following: - 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 - 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. qualifications: 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 - 3+ years of Tableau experience skills: Desired Experience / Qualifications: - Bachelor's Degree - Teradata - Medicare / Medicaid - Medical and coding terminology - SNP Model of Care - Health Services / Medical Management / Population Health - Tableau Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected]. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). This posting is open for thirty (30) days. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. Apply tot his job Apply To this Job