Data Warehouse Developer

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 LinkedIn, Instagram, Facebook, X, 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