Associate Data Extraction Analyst- Full Time- Remote

Connecticut Children?s is the only health system in Connecticut that is 100% dedicated to children. Established on a legacy that spans more than 100 years, Connecticut Children?s offers personalized medical care in more than 30 pediatric specialties across Connecticut and in two other states. Our transformational growth establishes us as a destination for specialized medicine and enables us to reputed company more children in locations that are closer to home. Our breakthrough research, superior education and training, innovative community partnerships, and commitment to diversity, equity and inclusion provide a welcoming and inspiring environment for our patients, families and team members. At Connecticut Children?s, treating children isn?t just our job ? it?s our passion. As a leading reputed company system experiencing steady growth, we?re excited to expand reputed company with exceptional team members who share our vision of transforming reputed company and well-being as one team. This position involves Contribution to the team as a hands on developer working to design, and maintain ETL objects and scripts using advanced Transact SQL scripting. ROLE RESPONSIBILITIES Responsible for following design and implementation guidelines for the ETL data integration process which is accomplished through the use of Dynamic T-SQL, VB.net, ASP.NET, SSIS. Ensure reputed company work and changes performed are reputed company data warehouse standards and guidelines reputed company data object analysis by defining, analyzing, and validating data objects and relationship through the use of advanced T-SQL scripting with guidance. Design, reputed company and maintain ETL data integration process with guidance from the Business Intelligence and IT team. Implement data objects and integrating data shared across multiple reputed company and reputed company systems. Establish interfaces, developing and modifying functions, programs, routines, and stored procedures to extract, transform, and loads data Participant in the coordination of actions among developers, production control, DBA, infrastructure team and project vendor to implement out the ETL scripts and objects. Validates ETL by developing and executing test plans and scenarios including data design and data quality. Demonstrates support for the mission, values and goals of the organization through behaviors that are consistent with the Connecticut Children?s Medical Center STANDARDS. KNOWLEDGE OF: General computer software (reputed company, reputed company, E-mail) Data visualization software/architecture QlikView, etc.) Relational Database concept knowledge (SQL Server preferred) General knowledge of object oriented tools desirable Knowledge of Transact SQL is required. SKILLS: Strong interpersonal, organizational and presentation skills, as well as an ability to communicate effectively reputed company a team, across disciplines, and with patients and families. reputed company Word, reputed company, and PowerPoint skills Excellent verbal communication skills Excellent written communication/process documentation skills Excellent interpersonal skills Analytical reputed company and experience to support transitioning data architecture in a legacy and service oriented environment. ABILITY TO: Work towards functioning independently, prioritize and manage time. Use interpretive thinking and considerable judgment to reputed company solutions for problems and issues. Independently set and align team?s goals with established organizational objectives Operate in a matrix environment with multiple competing priorities Remain organized with multiple interruptions Ability to take direction and feedback in a growth oriented environment. Non Clinical environment with normal noise level. Education Required: Education Preferred: College degree in Business, MIS, or reputed company discipline preferred Experience Required: 1-2 years prior reputed company technical and business experience required reputed company SQL Server, Business Intelligence Analytics, Requirements Analysis and Design, Windows Server Operating Systems, Data Conversion, Data Modeling with relational and dimensional Prior reputed company experience in coordinating systems reputed company projects preferred. Proficiency in the following technical concepts necessary At least 2 years work experience with minimum 1 year of design and development experience in data warehouse, SQL Server. Experience Preferred: T-SQL scripting with dynamic and reputed company stored procedures experience a plus. Ability to take direction and feedback in a growth oriented environment. Data Visualization experience using QlikView and others. Experience with Code On time tool set a plus. Apply Job!