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.
Technology Service Analyst managing high severity IT incidents for Deutsche Bank. Ensuring effective management of business impacting incidents with strong communication and process adherence.
Clearing and Settlement Analyst supporting Trade Services processes like securities transfers and reconciliations in Bangalore. Seeking candidates with German language skills and a flexible work approach.
Associate Analyst applying economic approaches to energy and transport transition challenges. Collaborating on studies and expert opinions in a reputable global consulting firm in Germany.
Strategy & Revenue Analyst for papernest analyzing data for business growth. Collaborating with teams in energy, telecommunications, and insurance sectors in Spain.
Portfolio Enablement Analyst leading operational intake and governance processes for technology portfolio. Collaborating with various teams to improve intake workflows and compliance at Kimberly - Clark.
Analyst at Northern Trust producing timely reports and financial statements for hedge fund clients. Mentoring junior employees and ensuring compliance with procedures and controls.
Portfolio Enablement Analyst leading operational intake and readiness for Kimberly - Clark's technology portfolio. Collaborating cross - functionally to ensure smooth workflows and compliance.
Regional Treasury Lead Analyst managing key treasury functions including cash management and trade finance for LATAM at GE HealthCare. Collaborating with business units to optimize growth and risk management strategies.
Functional Analyst translating internal business requirements into detailed designs for a global engineering provider. Collaborating with stakeholders and improving business processes effectively.
Senior Billing Analyst managing monthly cycle of billing at Evertec. Responsible for strategic projects and internal/external customer support in a financial tech environment.