Data Architect at American Heart Association

Job description

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

Requirements

Must-haves

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.
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.
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.
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.
Bachelor's Degree or equivalent work experience.
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.

Nice-to-haves

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.
Here are some of the preferred skills we are looking for:

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

agilepythonsqlaws

Platform: icims
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

Pto

Paid Time Off

Wellness

Professional Development