Assoc Data Extraction Analyst
2 months ago
This position involves Contribution to the team as a hands on developer working to design, and maintain ETL objects and scripts using advanced Transact SQL scripting.
Responsibilities
Responsible for following design and implementation guidelines for 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
Perform data object analysis by defining, analyzing, and validating data objects and relationship through the use of advanced T-SQL scripting with guidance.
Design, develop and maintain ETL data integration process with guidance from 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
Participant in the 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.
Qualifications
Education Required:
Education Preferred: College degree in Business, MIS, or related discipline preferred
Experience Required: 1-2 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
Prior related experience in coordinating systems related projects preferred.
Proficiency in the following technical concepts necessary
At least 2 years work experience with minimum 1 year of design and development experience in data warehouse, SQL Server.
Experience Preferred:
T-SQL scripting with dynamic and complex stored procedures experience a plus.
Ability to take direction and feedback in a growth oriented environment.
Data Visualization experience using QlikView and others.
Experience with Code On time tool set a plus.
SKILLS AND ABILITIES REQUIRED
KNOWLEDGE OF:
General computer software (Excel, MS Word, E-mail)
Data visualization software/architecture QlikView, etc.)
Relational Database concept knowledge (SQL Server preferred)
General knowledge of object oriented tools desirable
Knowledge of Transact SQL is required.
SKILLS:
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
Analytical skill and experience to support transitioning data architecture in a legacy and service oriented environment.
ABILITY TO:
Work towards functioning 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
Ability to take direction and feedback in a growth oriented environment.
Non Clinical environment with normal noise level.
About Us
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 offers personalized medical care in more than 30 pediatric specialties across Connecticut and in two other states. Our transformational growth establishes us as a destination for specialized medicine and enables us to reach more children in locations that are closer to home. Our breakthrough research, superior education and training, innovative community partnerships, and commitment to diversity, equity and inclusion provide a welcoming and inspiring environment for our patients, families and team members.
At Connecticut Children's, treating children isn't just our job - it's our passion. As a leading children's health system experiencing steady growth, we're excited to expand our team with exceptional team members who share our vision of transforming children's health and well-being as one team.
We have other current jobs related to this field that you can find below
-
Data Analyst
1 month ago
Hartford, United States Catholic Charities Full timeJob DescriptionJob DescriptionPOSITION SUMMARYReporting to the Data Manager, works with project teams on extracting, reporting and interpreting data from various software data bases and information sources. Creates charts, graphs and analysis narratives to facilitate data driven decisions and planning. Responsible for creating and producing reports, ad hoc...
-
Data Analyst
2 months ago
Hartford, United States Catholic Charities Full timeJob DescriptionJob DescriptionPOSITION SUMMARYReporting to the Data Manager, works with project teams on extracting, reporting and interpreting data from various software data bases and information sources. Creates charts, graphs and analysis narratives to facilitate data driven decisions and planning. Responsible for creating and producing reports, ad hoc...
-
Data Analyst
1 month ago
Hartford, United States Catholic Charities Full timeJob DescriptionJob DescriptionPOSITION SUMMARY Reporting to the Data Manager, works with project teams on extracting, reporting and interpreting data from various software data bases and information sources. Creates charts, graphs and analysis narratives to facilitate data driven decisions and planning. Responsible for creating and producing reports, ad hoc...
-
Data Analyst
2 months ago
Hartford, United States Catholic Charities Full timeJob DescriptionJob DescriptionPOSITION SUMMARY Reporting to the Data Manager, works with project teams on extracting, reporting and interpreting data from various software data bases and information sources. Creates charts, graphs and analysis narratives to facilitate data driven decisions and planning. Responsible for creating and producing reports, ad hoc...
-
Senior Quality Data Informatics Analyst
2 weeks ago
Hartford, United States Hartford Healthcare Full timeWork where every moment matters. Every day, almost 30,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut’s most comprehensive healthcare network. The Hartford HealthCare Cancer Institute focuses on offering our cancer patients an...
-
Data Analyst
5 hours ago
Hartford, United States CapB InfoteK Full timeCapB is a global leader on IT Solutions and Managed Services. Our R&D is focused on providing cutting edge products and solutions across Digital Transformations from Cloud, AI/ML, IOT, Blockchain to MDM/PIM, Supply chain, ERP, CRM, HRMS and Integration solutions. For our growing needs we need consultants who can work with us on salaried or contract basis. We...
-
Administrative Data Entry Analyst
4 weeks ago
Hartford, United States TEKsystems Full timeAdministrative Data Entry Analyst We are currently seeking a talented and driven individual to join our team as an Entry-Level Administrative Data Analyst. This is an excellent opportunity for employees to gain valuable experience in data analysis and administration. Job Description: The Administrative Data Entry Analyst will be responsible for assisting...
-
Data Analyst
15 hours ago
Hartford, United States Aya Healthcare Full timeAya Healthcare has an exciting 13-week contract opportunity located in Hartford, CT!Job Details:JOB TITLE: Data Analyst CONTRACT DURATION: 13 weeksSHIFT: M-F 7:30-4pmLOCATION: Hartford, CTPAY:$18.50-21.75 an hourONBOARDING TIME: Expect 3-5 weeks from offer acceptance to start date.APPLICATION REQUIREMENTS Documentation of Covid vaccination or...
-
Data Analyst
6 days ago
Hartford, United States Aya Healthcare Full timeAya Healthcare has an exciting 13-week W2 contract opportunity located in Hartford, CT!Job Details: W2JOB TITLE: Data AnalystCONTRACT DURATION: 13 weeksSHIFT: M-F 7:30-4pmLOCATION: Hartford, CTPAY:$18.50-21.75 an hourONBOARDING TIME: Expect 3-5 weeks from offer acceptance to start date.APPLICATION REQUIREMENTS · Documentation of Covid vaccination or...
-
Data Analyst
1 week ago
Hartford, United States Aya Healthcare Full timeAya Healthcare has an exciting 13-week contract opportunity located in Hartford, CT!Job Details:JOB TITLE: Data Analyst CONTRACT DURATION: 13 weeksSHIFT: M-F 7:30-4pmLOCATION: Hartford, CTPAY:$18.50-21.75 an hourONBOARDING TIME: Expect 3-5 weeks from offer acceptance to start date.APPLICATION REQUIREMENTS · Documentation of Covid vaccination or...
-
Data Analyst
1 week ago
Hartford, United States Aya Healthcare Full timeAya Healthcare has an exciting 13-week contract opportunity located in Hartford, CT!Job Details:JOB TITLE: Data Analyst CONTRACT DURATION: 13 weeksSHIFT: M-F 7:30-4pmLOCATION: Hartford, CTPAY:$18.50-21.75 an hourONBOARDING TIME: Expect 3-5 weeks from offer acceptance to start date.APPLICATION REQUIREMENTS · Documentation of Covid vaccination or...
-
Data Analyst
4 days ago
Hartford, United States Aya Healthcare Full timeAya Healthcare has an exciting 13-week W2 contract opportunity located in Hartford, CT!Job Details: W2JOB TITLE: Data AnalystCONTRACT DURATION: 13 weeksSHIFT: M-F 7:30-4pmLOCATION: Hartford, CTPAY:$18.50-21.75 an hourONBOARDING TIME: Expect 3-5 weeks from offer acceptance to start date.APPLICATION REQUIREMENTS · Documentation of Covid vaccination or...
-
Senior Business Development Analyst
2 weeks ago
Hartford, United States HSB Full timeThe Senior Business Development Analyst will be responsible for supporting the data, reporting and analytical needs across the entire Specialty Re Department. The role will involve analyzing and synthesizing financial data from multiple sources (S&P IQ...), producing high quality insights that demonstrate a full narrative and ultimately communicating to key...
-
Senior Business Development Analyst
7 days ago
Hartford, Connecticut, United States Munich Re Full timeSenior Business Development Analyst (Actuary) Company HSB Location Hartford , United StatesThe Senior Business Development Analyst will be responsible for supporting the data, reporting and analytical needs across the entire Specialty Re Department. The role will involve analyzing and synthesizing financial data from multiple sources (S&P IQ...),...
-
Senior Business Development Analyst
7 days ago
Hartford, Connecticut, United States Munich Re Full timeThe Senior Business Development Analyst will be responsible for supporting the data, reporting and analytical needs across the entire Specialty Re Department. The role will involve analyzing and synthesizing financial data from multiple sources (S&P IQ...), producing high quality insights that demonstrate a full narrative and ultimately communicating to key...
-
Senior Business Development Analyst
7 days ago
Hartford, United States Munich Re Full timeSenior Business Development Analyst (Actuary) Company HSB Location Hartford , United StatesThe Senior Business Development Analyst will be responsible for supporting the data, reporting and analytical needs across the entire Specialty Re Department. The role will involve analyzing and synthesizing financial data from multiple sources (S&P IQ...),...
-
Senior Business Development Analyst
7 days ago
Hartford, United States Munich Re Full timeThe Senior Business Development Analyst will be responsible for supporting the data, reporting and analytical needs across the entire Specialty Re Department. The role will involve analyzing and synthesizing financial data from multiple sources (S&P IQ...), producing high quality insights that demonstrate a full narrative and ultimately communicating to key...
-
Lead Data Analyst
9 hours ago
Hartford, United States LTIMindtree Full timeAbout Us:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise...
-
Data Engineer with Talend
14 hours ago
Hartford, United States CapB InfoteK Full timeCapB is a global leader on IT Solutions and Managed Services. Our R&D is focused on providing cutting edge products and solutions across Digital Transformations from Cloud, AI/ML, IOT, Blockchain to MDM/PIM, Supply chain, ERP, CRM, HRMS and Integration solutions. For our growing needs we need consultants who can work with us on salaried or contract basis. We...
-
Lead Data Analyst
1 week ago
Hartford, United States LTIMindtree Full timeAbout Us:LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise...
