Connecticut Children's · 2 days ago
Sr. Data Extraction Analyst- Full Time
Connecticut, United States
Full-time
Onsite
Senior Level, Lead/Staff
8+ years expConnecticut Children’s is the only health system in Connecticut that is 100% dedicated to children. The Sr. Data Extraction Analyst will provide guidance and technical oversight to the team while designing, developing, and maintaining ETL objects and scripts using advanced Transact SQL scripting.
Health CareHospitalMedical
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
Qualification
Required
High School Diploma, GED, or a higher level of education that would require the completion of high school, is required
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
General computer software (Excel, MS Word, 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
Strong interpersonal, organizational and presentation skills, as well as an ability to communicate effectively within a team, across disciplines, and with patients and families
Microsoft Word, Excel, and PowerPoint skills
Excellent verbal communication skills
Excellent written communication/process documentation skills
Excellent interpersonal skills
High analytical skill and experience to support transitioning data architecture in a legacy and service oriented environment
Nascent or fully developed leadership/mentoring skills
Help mentor and guide others on the team
Function independently, prioritize and manage time
Use interpretive thinking and considerable judgment to develop 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
Preferred
College degree in Business, MIS, or related discipline preferred
Prior related experience in coordinating systems related projects preferred
Experience with Code On time tool set a plus
Company
Connecticut Children's
Connecticut Children’s is a leading pediatric academic medical center consistently ranked by our peers as among the best children’s hospitals in the nation.
1001-5000 employees
H1B Sponsorship
Connecticut Children's has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2023 (2)
2022 (5)
2020 (3)
Funding
Current Stage
Late StageTotal Funding
$0.25M2014-04-07Grant· $0.25M
Leadership Team
Jim Shmerling
President and CEO
Bob Duncan
Executive Vice President and Chief Operating Officer
Recent News
Hartford Business Journal
2025-12-30
Hartford Business Journal
2025-10-31
Company data provided by crunchbase