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

Job title

Senior Data Extraction Analyst

Job type

Experience level

Senior

Salary

Not specified

Degree requirement

High School Diploma

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job