Hybrid Senior Data Extraction Analyst

at Connecticut Children's

• Job title: Senior Data Extraction Analyst
• Job type: Full Time
• Experience level: Senior
• Salary: Not specified
• Degree requirement: High School Diploma
• Tech skills: ASP.NET, ETL, MS SQL Server, SQL, SSIS, .NET
• Location requirements: Hybrid, Hartford, United States

About the role

• Sr. Data Extraction Analyst designing and maintaining ETL processes for Connecticut Children's, focusing on data integration and technical oversight. Requires advanced SQL skills and leadership experience.

Responsibilities

• Assist with planning, management and implementation of solution projects to meet company goals.
• Liaise with external/internal resources for ongoing support and development.
• Responsible for design and implementation of the ETL data integration process which is accomplished through the use of Dynamic T-SQL, VB.net, ASP.NET, SSIS.****Ensure all work and changes performed are within data warehouse standards and guidelines
• Mentor and train less experienced developers.
• Perform data object analysis by defining, analyzing, and validating data objects and relationship through the use of advanced T-SQL scripting.
• Design, develop and maintain ETL data integration process with the Business Intelligence and IT team.
• Implement data objects and integrating data shared across multiple source and target systems. Establish interfaces, developing and modifying functions, programs, routines, and stored procedures to extract, transform, and loads data
• Leading 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.

Requirements

• Education: High School Diploma, GED, or a higher level of education that would require the completion of high school, is required.
• Experience:
• 8-10 years prior related technical and business experience required. Microsoft SQL Server, Business Intelligence Analytics, Requirements Analysis and Design, Windows Server Operating Systems, Data Conversion, Data Modeling with relational and dimensional.
• At least 15 years work experience with minimum 10 years of design and development experience in data warehouse, SQL Server. Proficiency in the following technical concepts necessary.
• Advanced T-SQL scripting including dynamic and complex stored procedures experience.
• Self-managing and ability to lead project solution end-to-end.
• Data Visualization experience using QlikView and others.
• Experience in VB.Net, SSIS, ASP.NET and Tivoli scheduler.
• Education: College degree in Business, MIS, or related discipline preferred.
• Experience:
• Prior related experience in coordinating systems related projects preferred.
• Experience with Code On time tool set a plus.

Benefits

• N/A