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.
Senior Database Analyst ensuring performance and security of databases at Inmetrics. Collaborating in a dynamic environment focused on results and decision - making.
Analista de Trading Execution Sr managing trading operations with a focus on client needs at Ipiranga. Involves communication with internal departments and relevant documentation compliance.
Analyst facilitating the digital integration of planning and execution with Localiza's strategic areas. Focusing on data - driven insights and improvements in S&OP processes.
Analista de Remuneração e Benefícios II at M. Dias Branco managing compensation policies and benefit programs to enhance employee satisfaction and competitiveness.
Analyzing and documenting operational processes related to client activities in the public administration sector. Proposing solutions aligned with legal regulations and operational flows.
Process Improvement Analyst leading Lean Six Sigma projects in operational excellence at Minsait. Focus on improving internal processes and managing efficiency in a hybrid work model.
Execute administrative activities related to partner accreditation at Órigo Energia while ensuring the accuracy of partner data and documentation. Collaborate with sales executives and internal teams for compliance and efficiency.
Analista de Sistema Operacional Junior responsible for configuring and managing systems and storage in a fintech. Working with innovative solutions in the financial infrastructure sector.
Analyst supporting strategic governance and corporate communication initiatives at Quanta Previdência. Engaging in planning, reporting, and consolidating strategic information and events.