Data Warehouse Developer

Summary

The American Heart Association is dedicated to improving cardiovascular health and is seeking a Data Warehouse Developer to join their team. This role involves designing integration architectures, developing data models, and collaborating with a dynamic team to support data management and advanced analytics.

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 American Heart Association 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

Skills

• 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
• Ability to travel up to 10% local and overnight stay
• 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

Qualifications

Must Haves

• 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
• Ability to travel up to 10% local and overnight stay

Nice to Haves

• 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

• Full-time, benefits-eligible
• 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.
• 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.
• We also offer an employee assistance program, employee wellness program and telemedicine, and medical consultation.
• Eligibility for an incentive program is based on the type of position.
• 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.
• 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.