Logo for American Heart Association

Data Warehouse Developer

Role overview

Qualifications

  • Bachelor's Degree or equivalent work experience
  • Minimum of three (3) years of Data Mapping and Extract/Transform/Load (ETL) design and development experience with clinical electronic health record data
  • Experience with data modeling and Integration of architecture design and implementation with electronic health records
  • Experience with Data Virtualization tools

Responsibilities

  • Designs integration architectures, defines clinical data mappings, develops data models, and consults with the infrastructure team
  • Works as a part of a dynamic team to support the data pipeline, database management, and creation of new tools
  • Champions data quality, integrity, and reliability throughout the department by designing data flow models
  • Helps with the assessment of database performance and the identification of problem areas

About the company

American Heart Association logo

American Heart Association

Health, Sport, Wellness & Fitness

For 100 years, the American Heart Association has worked to build longer, healthier lives. And there’s no letting up in the next 100 years. Our future is about improving yours. The American Heart Association is the nation’s oldest and largest voluntary organization dedicated to fighting heart disease and stroke. We are committed to advancing health and hope for everyone, everywhere. We are advocates of good health and promoters of positive behaviors, nutritious eating habits and healthy lifestyles. We also fund cutting-edge research and professional education programs. We promise to have an extraordinary impact on your life by empowering you and your loved ones to save lives, live healthier and enjoy more peace of mind about cardiovascular health. Join our communities: Facebook: http://facebook.com/AmericanHeart Twitter: http://twitter.com/American_Heart YouTube: http://www.youtube.com/American_Heart Pinterest: http://pinterest.com/americanheart Instagram: http://instagram.com/american_heart Blog: http://blog.heart.org Heart News: http://twitter.com/heartnews ASA Facebook: http://facebook.com/AmericanStroke ASA Twitter: http://twitter.com/American_Stroke Science News Facebook: https://www.facebook.com/ahasciencenews Science News Twitter: https://www.facebook.com/AHACPR CPR Facebook: https://www.facebook.com/AHACPR CPR Twitter: http://twitter.com/heartCPR Go Red For Women Facebook: https://www.facebook.com/goredforwomen Go Red For Women Twitter: http://twitter.com/goredforwomen Advocacy Facebook: https://www.facebook.com/yourethecure Advocacy Twitter: http://twitter.com/AmHeartAdvocacy

Company details

Company typeLarge
IndustryHealth, Sport, Wellness & Fitness
Company size1001 - 5000

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Overview:

Since our founding in 1924, we've cut cardiovascular disease deaths in half, but there is still so much more to do. To overcome today’s biggest health challenges and accelerate this progress, we need passionate individuals like you. Join our movement, be part of the progress, and help ensure a healthier future for all. You matter, and so does the impact you can make with us.

 

The American Heart Association has an excellent opportunity for a Data Warehouse Developer! This position can be home-based.

 

This is a full-time, benefits-eligible, grant-funded opportunity. Current funding will expire 12/31/2030 with the possibility of extension.

 

The Association offers many resources to help you maintain work-life harmonization through your changing needs and life situations. To help you be successful, you will have access to Heart U, our award-winning corporate university, as well as additional training and support, locally.

 

#TheAHALife is more than a company culture; it is our way of life. It embodies our commitment to work-life harmonization and is guided by our core values where our employees can thrive both personally and professionally. Discover why you will Be Seen. Be Heard. Be Valued at the American Heart Association by following us on LinkedInInstagramFacebookX, and at heart.jobs.

Responsibilities:
  • Designs integration architectures, defines clinical data mappings from electronic health record data, develops data models, and consults with the infrastructure team on server and data storage services.
  • Formulates and recommends standards for achieving maximum performance, compliance and efficiency of the database and delivery to researchers in the AHA Precision Medicine Platform.  
  • Works as a part of a dynamic team of biomedical researchers, database designers, data scientists, statisticians, software developers, quality research and health IT team members, and clinical data experts to support the data pipeline, database management, and creation of new tools. Understands their data requirements and builds systems that streamline data workflow and support advanced analytics.
  • Supports team in the delivery of external grants by providing data science expertise.
  • Works with external team members to encourage cross-department connections including the development and maintenance of standard operating procedures.
  • Ensures accuracy and integrity of service-oriented architecture through analysis, coding, writing clear documentation and problem resolution.
  • Maintains in-depth current knowledge of standards, guidelines, and industry trends for Data Warehouse Architecture as it relates to reporting and operations. Evaluates new data sources for adherence to the organization's quality standards and ease of integration.
  • Fosters use of self-service analytics, data governance and visual discovery while guiding changes and limited reliance on manual data processes. Builds proof of concept and tangible results by sharing testing data.
  • Champions data quality, integrity, and reliability throughout the department by designing data flow models and promoting development best practices with best of breed automation tools, working cross-functionally to ensure that data is made available timely and securely.
  • Helps with the assessment of database performance and the identification of problem areas by holding regularly scheduled reviews of code and monitoring software.
  • Performs other duties as required or assigned which are reasonably within the scope and responsibility of the job level and family.
Qualifications:
  • Bachelor's Degree or equivalent work experience.
  • Minimum of three (3) years of Data Mapping and Extract/Transform/Load (ETL) design and development experience with clinical electronic health record data.
  • Experience with data modeling and Integration of architecture design and implementation with electronic health records.
  • Experience with Data Virtualization tools
  • Comprehensive knowledge in software development lifecycles/methodologies, i.e. agile.
  • Strong presentation and collaboration skills and can communicate all aspects of the job requirements, including the creation of formal documentation.
  • Fluent in relational database concepts and flat file processing concepts.
  • Strong problem solving, time management and organizational skills.

Here are some of the preferred skills we are looking for: 

  • Experience with Electronic health records and image mapping
  • Experience with Python, R, SQL 
  • Experience with Cloud offerings.
  • Experience with Amazon Web Services: S3, Glue, SageMaker, Lake Formation, Lambda, Athena, RedShift, EMR, etc.
  • ETL Technology: AWS Glue, SSIS, DataStage, Informatica.
  • Time series analysis, clustering, decision trees, and neural networks.
  • Database/Data Virtualization Technology: Snowflake, Apache Spark, Databricks, Hadoop, Cloudera, SQL Server, Oracle, Alteryx, Denodo.
  • Business Intelligence Technology: SSRS, Power BI, Tableau, MicroStrategy
Compensation & Benefits:

The expected pay range will be $95,000 - $115,000. Pay is commensurate with experience; geographic differentials to the pay range may apply. The American Heart Association reserves the right to pay more or less than the posted range. The American Heart Association invests in its people. Here are the main components of our total rewards package. Visit Rewards & Benefits to see more details.

 

  • Compensation – Our goal is to ensure you have a competitive base salary.  That’s why we regularly review the market value of jobs and make adjustments, as needed.

  • Performance and Recognition – You are rewarded for achieving success through annual salary planning and incentive programs; eligibility for an incentive program is based on the type of position. 

  • Benefits – We offer a wide array of benefits including medical, dental, vision, disability, and life insurance, along with a robust retirement program that includes an employer match and automatic contribution.  As a mark of our commitment to employee well-being, we also offer an employee assistance program, employee wellness program and telemedicine, and medical consultation.

  • Professional Development – You can join one of our many Employee Resource Groups (ERG) or be a mentor/mentee in our professional mentoring program.  Heart U is the Association’s national online university, with more than 100,000 resources designed to meet your needs and busy schedule.

  • Work-Life Harmonization – The Association offers Paid Time Off (PTO) at a minimum of 16 days per year for new employees.  The number of days will increase based on seniority level.  You will also have a total of 12 paid holidays off each year, which includes several days off at the end of the year.

  • Tuition Assistance - We support the career development of all employees.  This program provides financial assistance to employees who wish to further their education and career in relation to their current duties and responsibilities, or for potential future positions in the organization.
 :

The American Heart Association’s 2028 Goal: Building on over 100 years of trusted leadership in cardiovascular and brain health, by 2028 the Association will drive breakthroughs and implement proven solutions in science, policy, and care for healthier people and communities. The greatest discoveries in health must reach everyone where they are.


At American Heart Association | American Stroke Association, our mission is to be a relentless force for a world of longer, healthier lives, regardless of race, ethnicity, gender, gender identity, religion, age, language, sexual orientation, national origin and physical or cognitive abilities.

This position not a match with your skills? 
Click here to see other opportunities.

In accordance with local and state laws where applicable, qualified applicants with arrest or conviction records will be considered for employment.

 

EOE/Protected Veterans/Persons with Disabilities

 

 

: #AHAIND3, #LI-Remote

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Data Analyst Related jobs

Other jobs at American Heart Association

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.