Create a Job Alert.

Enter your email below to save this search and receive job recommendations for similar positions.
Thank you. We'll send jobs matching these to
You already suscribed to this job alert.
0 suggestions are available, use up and down arrow to navigate them
What job do you want?

Sr. Data Extraction Analyst job in Hartford at Connecticut Children's Medical Center

Create Job Alert.

Get similar jobs sent to your email

List of Jobs

Apply to this job.
Think you're the perfect candidate?
Apply on company site
Sr. Data Extraction Analyst at Connecticut Children's Medical Center

Sr. Data Extraction Analyst

Connecticut Children's Medical Center Hartford, CT Full Time
Apply on company site


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.


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



Knowledge of Transact SQL is required.

Data visualization software/architecture QlikView, etc.)

Relational Database concept knowledge (SQL Server preferred)

General knowledge of object oriented tools desirable

General computer software (Excel, MS Word, E-mail)


Epic Hospital Billing and Professional Billing application and data model experience a plus


Charge Reconciliation

Point of Service Collections

Understanding of basic accounting concepts, including General Ledger, Journal Entries



Strong interpersonal, organizational and presentation skills, as well as an ability to communicate effectively within a team, across disciplines, and with patients and families.

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

Microsoft Word, Excel, and PowerPoint skills


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


25-50% day


50-75% day


> 75% day




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




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.



Choose an item.

50 lbs.



Choose an item.

College degree in Computer Science, Business, MIS, or related discipline preferred

High School Diploma, GED, or a higher level of education that would require the completion of high school, is required

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 Tableau, Qlik and others.

Experience SSIS, ASP.NET and Tivoli scheduler.


Experience with Epic Hospital Billing and Professional Billing application and Epic Clarity and/or Caboodle data models

Facility or Professional Denials

Charge Reconciliation


Point of Service Collections

Understanding of basic accounting concepts, including general ledger, and journal entry.

Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled

Recommended Skills

  • Accounting
  • Analytical
  • Architecture
  • Asp.Net Core
  • Billing
  • Business Intelligence
Apply to this job.
Think you're the perfect candidate?
Apply on company site

Help us improve CareerBuilder by providing feedback about this job:

Job ID: 5000764992506

CareerBuilder TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.