SQL Developer (SSIS)

Job PurposeThe Database Developer will analyze, develop SSIS projects, custom reports and work closely with the team on any SQL issues. Manage new implementations, resolve any integration issues timely manner.

Duties and ResponsibilitiesDevelop Complex ETL and Analytics Programs using SQL, Store Procedures and various query tools.Develop, maintain and support SQL Server Integration Services (SSIS) packages related to the extraction, transformation and loading (ETL) process using Microsoft SQL Server 2012 or laterMaintain HIPAA transactions specifically 835 and 837 transaction sets, create the ad hoc reports to query the transaction sets.Responsible for data profiling as well as SQL and database tuning / optimizationAnalyze the client requirements and design technical solutions based on those requirements.Perform day to day troubleshooting of issues related to QA and Production.Design ETL audit control and scheduling processes.Develop testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issuesGuide the developers in the team to implement the client requirement and review the software developed by the team members.Provide technical leadership by making recommendations for application development to enhance the existing solution or resolve production issuesWork within a fast paced, objective oriented environmentManage and version the SSIS projects using Visual Studio Foundation Server.Participate in Client meetings, lead technical review meetings with team and/or client as requiredResponsible for providing accurate and timely communication of the status of assignment, job responsibilities, and the resolution of problems to the appropriate parties following established policies and proceduresAssist with capacity planning and resource expansion through data aggregation and analysisConsistently demonstrate understanding of security standards in daily development, administration, and/or solutions where applicable and as set for in the Information Security and HIPAA policiesStay abreast of new and emerging security threats and mitigation approaches for your respective area and perform periodic security reviews of your assigned areasWork to ensure regulatory compliance (HIPAA, etc.) in all aspects of data utilization and information accessEnsure all proposed changes follow the Change Management policy and procedure for production changesUse, protect and disclose patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards

QualificationsFour-year degree in Computer Science/Information Technology requiredMinimum eight years working as a SQL Database engineerMinimum of five years SSIS experienceThorough understanding of database structures, theories, principles, & practicesAbility to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraintsProject Management Experience requiredExtensive knowledge of MS SQL Server 2012 or laterExtensive knowledge with SSRS\SSIS\TSqlExperience with C# and\or VB.NET.Technical knowledge of MS SQL Server internals with emphasis on query performanceKnowledge and know-how to troubleshoot potential issues; experience with best practices around database operationsStrong oral and written communication skills with the ability to communicate technical and non-technical concepts to peers, customers, and managementMust be capable of routinely making effective and timely decisions in alignment with departmental direction, and based on sound business knowledge and industry best practicesAbility to work independently with minimal supervisionAbility to multi-task with several complex and demanding projects

Working ConditionsPhysical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear.Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress.Work Environment: The noise level in the work environment is usually minimal.

Med-Metrix will not discriminate against any employee or applicant for employment because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, veteran status, other non-merit based factors, or any other characteristic protected by federal, state or local law.