Data Architect

American Heart Association; Dallas (TX); Remote; USD 126,000 - 146,000; Full time

Benefits offered by this job

Medical, dental, vision

Retirement plan with employer match

Paid time off and holidays

Tuition assistance

Heart U training and development

Job summary

The American Heart Association is seeking a Data Architect at the National Center in Dallas, TX, with the option for home-based work. This full-time, grant-funded role will focus on data architecture, ETL design, and data governance within the Precision Medicine Platform.

With 8+ years in data mapping and ETL for EHR data and images, you will lead integration architecture, data virtualization, and modeling efforts, mentoring ETL staff and guiding researchers with centralized data resources.

Qualifications

• Bachelor's degree or equivalent work experience.
• 8+ years in Data Mapping and ETL with clinical EHR data/images.
• Experience with ODS/Star schema data modeling.
• Integration architecture with EHRs/images.
• Experience with Data Virtualization tools.
• Knowledge of SDLC/agile methodologies.
• Strong communication and documentation skills.
• Fluent in relational DB concepts and flat file processing.

Responsibilities

• Designs integration architectures and data models for EHR data and imaging.
• Sets standards for performance, compliance and data delivery to researchers.
• Maintains data architecture quality and documents improvements.
• Evaluates new data sources and supports data governance and self-service analytics.
• Mentors ETL staff and provides technical training across teams.
• Collaborates with Data Science leadership to align priorities.

Skills

Data mapping

ETL design

Data modeling

Integration architecture

Data virtualization

Agile

SQL

Python

Education

Bachelor's degree

10+ years data experience

Tools

AWS Glue

SSIS

Informatica

Snowflake

Databricks

S3

Tableau/SSRS

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 Architect based at our National Center in Dallas, TX. This role 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 LinkedIn, Instagram, Facebook, X, and at heart.jobs.

Responsibilities

• Designs integration architectures, defines clinical data mappings from electronic health record data including imaging, 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 American Heart Association Precision Medicine Platform.

• Ensures accuracy and integrity of service-oriented architecture through analysis, coding, writing clear documentation and problem resolution. Reviews issues and enhancements documented in the incident management and project management system for consideration of business needs.

• Maintains in-depth current knowledge of standards, guidelines, and industry trends for Data Warehouse Architecture as it relates to reporting and operations. Attends and interacts with user groups and researches new software vendors in the market. 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.

• Participates in the planning for retirement of systems programs, and migration of systems infrastructure by providing current state and future state architectural diagrams.

• Works closely with Chief of Data Science and business groups within American Heart Association to ensure prioritization of corporate and department objectives within the portfolio management system.

• Provides guidance on Data Governance as it applies to enterprise data architecture choices.

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

• Provides mentoring to Extract/Transform/Load (ETL) team members with technical expertise, complex systems, and/or programming knowledge. Provides on-the-job training for new or less experienced ETL team members.

• Provides technical training to external team members to encourage cross-department connections including the development and maintenance of standard operating procedures.

• Provides a methodology for the ongoing assessment of database performance and the identification of problem areas by holding regularly scheduled reviews of code and monitoring software.

• Develops business cases, impacts evaluation and ROI for department to get buy-in from senior management.

• 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 eight (8) years of experience (ten years of experience preferred) of Data Mapping and Extract/Transform/Load (ETL) design and development experience with clinical electronic health record data and images.

• Minimum of eight (8) years of experience with:

• Data modeling with an emphasis on ODS and Star schema models.

• Integration architecture design and implementation with electronic health records and images.

• 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: Apache Spark, Databricks, Snowflake, Hadoop, Cloudera, SQL Server, Oracle, Alteryx, Denodo.

• Business Intelligence Technology: SSRS, Power BI, Tableau, MicroStrategy.

Compensation & Benefits

The expected pay range will be $126,000 - $146,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.

EOE/Protected Veterans/Persons with Disabilities

Join our Talent Community!

Join our Talent Community to receive updates on new opportunities and future events.

Software Powered by ICIMS

Default: Location : Location US-TX-Dallas

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