Sr. Data Extraction Analyst @ Connecticut Children's Medical Center - Hartford, CT

Job Overview

6 days ago

Sr. Data Extraction Analyst

Connecticut Children's Medical Center - Hartford, CT

SUMMARY

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

ROLE 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.

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
  • High analytical skill and experience to support transitioning data architecture in a legacy and service oriented environment.
  • Nascent or fully developed leadership/mentoring skills

ABILITY TO:
  • 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

Clinical environment with normal noise level.


Physical Requirements:

Amount of Time

(Choose which ones do apply)


< 25% day


Occasional

25-50% day


Frequent

50-75% day


Constant

> 75% day


Stand


Walk


Sit


Manual Dexterity/Repetitive use of hands, wrists, arms, elbows


Forward reach w/hands and/or arms


Climb or balance


Stoop, kneel, crouch


Overhead/above shoulder reaching



Choose Applicable Lifting Demands


LIFT


Floor-Waist


Waist-Shoulder


Above Shoulder


< 15 lbs.


Choose an item.


Choose an item.


Choose an item.


15 - 25 lbs.


Choose an item.


Choose an item.


Choose an item.


25 - 40 lbs.


Occasionally


Occasionally


Choose an item.


50 lbs.


Occasionally


Occasionally


Choose an item.


Requirements:
High School Diploma, GED, or a higher level of education that would require the completion of high school, is required
College degree in Business, MIS, or related discipline preferred
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
Prior related experience in coordinating systems related projects preferred.
Proficiency in the following technical concepts necessary

At least 15 years work experience with minimum 10 years of design and development experience in data warehouse, SQL Server.
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.
Experience with Code On time tool set a plus.

Similar Jobs

Packaging Associate

Holistic Industries

Monson, MA

Prepare plant material for extraction (packing material socks) and accurately documenting related data. Maintain accurate documentation of all related data in…

Senior Sourcing Analyst - WORK FROM HOME

CVS Health

Woonsocket, RI

Experience with foundational data handling tools, data mining tools and Business Intelligence platforms. Support data selection, extraction, and cleansing for…

AdvAnalytic Consulting

CVS Health

Woonsocket, RI

Strong knowledge of advanced analytics tools and languages to analyze large data sets from multiple data sources. 2+ years of people management experience.

DATA ANALYST I

State of Rhode Island

Providence, RI

To acquire data from primary or secondary data sources and maintain databases/data systems. To assure the integrity of project data, including data extraction,…

Asset Management, Business Analyst / Project Manager, Associate

JPMorgan Chase Bank, N.A.

New York, NY

Provide support by coordinating data extraction from various databases and data interpretation. Demonstrable awareness of data governance and data strategy…

Insights Analyst

Parrot Analytics

New York, NY

Technical skills including data management, data extraction, cleaning, transformation and visualization using tools such as SQL, R, Python, and Dashboards …

Asset Management, Project Manager / Business Analyst, Associate

JPMorgan Chase Bank, N.A.

New York, NY

Provide support by coordinating data extraction from various databases and data interpretation. Demonstrable awareness of data governance and data strategy…

Senior Insights Analyst

Parrot Analytics

New York, NY

Strong analytical skills, including familiarity with common data science approaches and structured thinking to identify starting points and apply methodical…

Clinical Technologist - Next Gen Sequencing II/III (Night)

SEMA4

Stamford, CT

Familiarity with and advanced understanding of NGS and other molecular data analysis and interpretation techniques using LIMS, Excel, and other data management…

Licensed Esthetician

Lustre Skin Bar

New York, NY

Documents treatments and machine data in customers' files. \* Candidate shall be able to perform basic employment duties; skin consults, facials, extractions,…

Bioanalytical Scientist - Genomics

Eurofins Central Laboratory

Cambridge, MA

Assist in analyzing experimental data, summarizing results, and preparing technical reports to be transferred to CROs. 401(k) with company match.

CLINICAL DATA ANALYST

Montefiore Medical Center

Bronx, NY

1-3 experience in data analysis, data mining, or analytics in healthcare related fields. The Clinical Data Anlayst is responsible for collection, extraction,…

Research Assistant

The Rockefeller University

New York, NY

Must have excellent organizational skills, including laboratory record keeping, data management, and prioritizing work to carry out complex experiments with…

Marketing Analyst

Customer Portfolios

Boston, MA

Partner with data team to source new data, resolve system issues that impede data extraction, and design structures which will best support analytical efforts.

Assurance Services Experienced Staff - Analytics Delivery Specialist - East - MULTIPLE CITIES

EY

Boston, MA

Acting as a subject matter expert in advising clients to gain greater insight into their data and the value that data analytics can bring to an organization.

Sr. SAS Programmer

eClinical Solutions, LLC

Mansfield, MA

Create submission-ready standard data presentations and data sets using standard coding and following standard industry processes including SDLC.

Senior Business Analyst, R&D – Limited Partners Vertical

Dynamo Software

Watertown, MA

Examples include investment data analytics, qualitative data extraction, and flexible data integrations. Reporting to the VP, LP Product this position requires…

SAS Programmer

eClinical Solutions, LLC

Mansfield, MA

Create submission-ready standard data presentations and data sets using standard coding and following standard industry processes including SDLC.

Assurance Services Senior - Analytics Delivery Specialist - East - MULTIPLE CITIES

EY

Boston, MA

Acting as a subject matter expert in advising clients to gain greater insight into their data and the value that data analytics can bring to an organization.

Barista

Hotel RL Brooklyn

Brooklyn, NY

Purpose for the Position: The Barista will be responsible for providing exceptional customer service while maintaining the highest standards of coffee…

Senior Data Analyst

Wiley

Hoboken, NJ

Skilled in multiple data domain areas, including data warehousing, business intelligence (BI), data governance, data integration, data classification, data…

Director, Central Analytics

ViacomCBS Networks International

New York, NY

Experience using SQL for data extraction, feature development etc. Experience with data modeling and querying data warehouses at scale.

Sr. Consultant Data Engineering

Avanade

Philadelphia, PA

Design, develop, adapt and maintain data warehouse architecture and relational databases that support data mining. Help to develop business intelligence tools.

Data Scientist

ViacomCBS Networks International

New York, NY

3+ years using SQL for data extraction, feature development etc. 1+ year with data modeling and querying data warehouses at scale.

Ad