[Hiring] Data Architect @American Heart Association

Role Description

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.

Responsibilities include:

• 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.
• Maintains in-depth current knowledge of standards, guidelines, and industry trends for Data Warehouse Architecture as it relates to reporting and operations.
• Fosters use of self-service analytics, data governance and visual discovery while guiding changes and limited reliance on manual data processes.
• 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.
• Provides mentoring to Extract/Transform/Load (ETL) team members with technical expertise, complex systems, and/or programming knowledge.
• 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.
• 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.
• Preferred skills include:
  • 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.

Benefits

• The expected pay range will be $126,000 - $146,000. Pay is commensurate with experience; geographic differentials to the pay range may apply.
• 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.
• Professional Development: You can join one of our many Employee Resource Groups (ERG) or be a mentor/mentee in our professional mentoring program.
• Work-Life Harmonization: The Association offers Paid Time Off (PTO) at a minimum of 16 days per year for new employees, increasing based on seniority level.
• Tuition Assistance: We support the career development of all employees with financial assistance for further education related to current duties or potential future positions.