Data Warehouse Developer

Role Description

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.

Responsibilities include:

• Designing integration architectures, defining clinical data mappings from electronic health record data, developing data models, and consulting with the infrastructure team on server and data storage services.
• Formulating and recommending standards for achieving maximum performance, compliance, and efficiency of the database and delivery to researchers in the AHA Precision Medicine Platform.
• Working as 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.
• Supporting the team in the delivery of external grants by providing data science expertise.
• Encouraging cross-department connections including the development and maintenance of standard operating procedures.
• Ensuring accuracy and integrity of service-oriented architecture through analysis, coding, writing clear documentation, and problem resolution.
• Maintaining in-depth current knowledge of standards, guidelines, and industry trends for Data Warehouse Architecture as it relates to reporting and operations.
• Evaluating new data sources for adherence to the organization's quality standards and ease of integration.
• Fostering use of self-service analytics, data governance, and visual discovery while guiding changes and limited reliance on manual data processes.
• Building proof of concept and tangible results by sharing testing data.
• Championing data quality, integrity, and reliability throughout the department by designing data flow models and promoting development best practices.
• Helping with the assessment of database performance and the identification of problem areas by holding regularly scheduled reviews of code and monitoring software.
• Performing 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.

Requirements

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

Benefits

• The expected pay range will be $95,000 - $115,000. Pay is commensurate with experience; geographic differentials to the pay range may apply.
• 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.
• Tuition Assistance: We support the career development of all employees.