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.
IT Service Desk Analyst providing front - line technical support to DLA Piper's colleagues. Handling incoming requests, maintaining records, and troubleshooting IT issues.
SAP PM System Analyst developing and maintaining Plant Maintenance functions and technologies at Boehringer Ingelheim. Collaborating with international teams on asset maintenance initiatives.
Analista Contábil responsible for accounting reconciliation and financial support in Allianz, a leading insurance company in Brazil. Collaborating with teams for accurate financial reporting and compliance.
Grassroots Analyst conducting investment research for Allianz Global Investors in Hong Kong. Collaborating with portfolio managers to manage research studies and communicate insights.
Join Allianz Global Investors as Analyst/Senior Analyst in Hong Kong. Responsible for investment recommendations and quantitative forecasts within China Equity team.
Portfolio Manager/Senior Analyst leading equity research and portfolio management for Taiwan listed equities at AllianzGI Taiwan. Focus on portfolio construction, risk management, and client mandate execution.
Analyst PTP role at UPL managing invoice processing and vendor inquiries for financial operations. Requires SAP experience and accounting knowledge in a global organization based in Pune.
Analyst role responsible for managing operational processes and coordinating events at YPF. Collaborate with various stakeholders to ensure quality standards and report generation.
Senior Implementation Analyst serving as the liaison between Operations and IT at GXO. Define business requirements and coordinate communication for logistics system implementation.
Senior Analyst Logistics managing stock levels of materials and coordinating logistics activities. Focused on recycling processes and timely delivery of raw materials.