American Heart Association Business Intelligence Solutions Architect in Dallas, Texas

Business Intelligence Solutions Architect

Job Locations US-TX-Dallas Posted Date 3 months ago (3 months ago) Requisition ID 2018-2533 Job Family Group Business Operations


Are you ready to join an organization where you can make an extraordinary impact every day?

Imagine all Americans enjoying ideal cardiovascular health free of heart disease and stroke. At the American Heart Association and American Stroke Association, we get to work toward that goal every day. Is it easy? No. Is it worthwhile? Absolutely.

This is satisfying and challenging work that makes a real difference in people's lives. We are where you can achieve professional growth with personal fulfillment. We are where you can connect people to making a lifesaving impact. We are where you can partner with individuals, schools, lawmakers, healthcare providers and others to ensure everyone has access to healthier lifestyle choices and proper healthcare. The American Heart Association is where you can make an extraordinary impact.

The American Heart Association has an excellent opportunity for an Business Intelligence Solutions Architect in our Business Technology department located at our National Center office located in Dallas, TX .


Responsible for developing, selecting and executing integrated technology solutions for support and analysis of business intelligence across AHA. Responsible for collaborating with stakeholders and team members to define, design and deliver actionable insights from master data sources in an Agile environment.


Essential Job duties

Designs integration architectures, defines data mappings, 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 Data Warehouse and Master Data Management systems.

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.

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 Business Intelligence Manager to ensure prioritization of corporate and department objectives within the portfolio management system.

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

​Minimum Qualifications

Bachelor's Degree in Computer Science, Information Technology or related extensive work experience

Ten (10 ) years of experience with data mapping and Extract/Transform/Load (ETL) design and development

Eight (8) years of experience with data modeling with an emphasis on ODS and Star schema models

Five (5) years of experieince implementing integration architecture design

Experience with Data Virtualization tools

Preferred Qualifications

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

ETL Technology: SSIS, DataStage, Informatica

Time series analysis, clustering, decision trees and neural networks

Database/Data Virtualization Technology: SQL Server, Oracle, Alteryx, Denodo, Hadoop, Cloudera

Experience with Cloud offerings

Click on “Apply for this job online” to submit your online application or “Log back in!” if you are a returning applicant. Only those candidates deemed most qualified by the hiring manager will be contacted to interview.

At American Heart Association | American Stroke Association, diversity, inclusion, and equal opportunity applies to both our workforce and the communities we serve as it relates to heart health and stroke prevention.

This position not a match with your skills? Click here to see other opportunities with the American Heart Association

Be sure to follow us on Twitter to see what it is like to work for the American Heart Association and why so many people enjoy #TheAHALife EOE Minorities/Females/Protected Veterans/Persons with Disabilities


Apply for this job online Apply Share Email this job to a friend Refer

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.

Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started. Application FAQs Software Powered by iCIMS