Sr. Data Extraction Analyst

Job Description

This position involves providing guidance and technical oversight to the team as well as hands‑on work to design, develop and maintain ETL objects and scripts using advanced Transact‑SQL scripting.

• 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, , 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 relationships 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, develop and modify functions, programs, routines, and stored procedures to extract, transform, and load data.
• Lead coordination of actions among developers, production control, DBA, infrastructure team and project vendor to implement the ETL scripts and objects.
• Validate ETL by developing and executing test plans and scenarios including data design and data quality.
• Demonstrate support for the mission, values and goals of the organization through behaviors consistent with the Connecticut Children’s Medical Center STANDARDS.

• Education:
  
  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 & 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 Qlik View and others.
• Experience in , SSIS, ASP.NET and Tivoli scheduler.

• Education:
  
  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.

• N/A

• General computer software (Excel, MS Word, E‑mail).
• Data visualization software/architecture Qlik View, 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.

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…