Data Warehouse Developer
American Heart Association4 months ago
Dallas, TX, USAMid Level
Base Salary
$95k - $115k/yr
Responsibilities
- Design integration architectures and define clinical data mappings from electronic health record data.
- Develop data models, data pipelines, ETL solutions, and systems that streamline data workflows and support advanced analytics.
- Consult with infrastructure teams on server and data storage services and formulate database performance, compliance, and efficiency standards.
- Support biomedical researchers, data scientists, statisticians, software developers, quality research teams, health IT teams, and clinical data experts.
- Evaluate new data sources for quality and integration readiness and promote data governance, data integrity, reliability, and secure availability.
- Enable self-service analytics and visual discovery while reducing reliance on manual data processes.
- Create documentation, standard operating procedures, proof-of-concept solutions, and testing data.
- Assess database performance, review code, monitor software, and identify problem areas.
- Provide data science expertise in support of external grants and collaborate with external team members.
- Maintain current knowledge of data warehouse architecture standards, guidelines, and industry trends.
Requirements
- Bachelor’s degree or equivalent work experience.
- At least three years of data mapping and ETL design and development experience with clinical electronic health record data.
- Experience with data modeling and integration architecture design and implementation for electronic health records.
- Experience with data virtualization tools.
- Knowledge of software development lifecycles and methodologies.
- Strong presentation, collaboration, communication, documentation, problem-solving, time-management, and organizational skills.
- Fluency in relational database concepts and flat-file processing concepts.
- Ability to travel up to 10% locally and with overnight stays.
- Preferred experience with electronic health records and image mapping; Python, R, and SQL; cloud offerings; AWS services; ETL technologies; data virtualization and database platforms; business intelligence tools; and time-series analysis, clustering, decision trees, and neural networks.
Benefits
- Home-based work arrangement.
- Full-time, benefits-eligible, grant-funded position; current funding expires December 31, 2030, with possible extension.
- Medical, dental, vision, disability, and life insurance.
- Retirement program with employer match and automatic contribution.
- Employee assistance, wellness, telemedicine, and medical consultation programs.
- Professional development through Heart U, employee resource groups, and mentoring programs.
- At least 16 days of paid time off for new employees, increasing with seniority, plus 12 paid holidays including year-end holidays.
- Tuition assistance for education and career development.
Tech Stack
Amazon RedshiftApache HadoopApache SparkAWSDatabricksInformaticaMicrosoft SQL ServerPythonRSnowflakeSQL
Categories
Data Engineering
About American Heart Association
The American Heart Association is a U.S. nonprofit that advances cardiovascular health through research funding, clinical guidelines, education, and advocacy. It provides CPR and first aid training and certification for healthcare providers and workplaces, publishes scientific journals, and convenes conferences. Revenue comes from donations and grants along with training, publications, and events. Founded in 1924 and headquartered in Dallas, it runs national programs such as Go Red for Women and Heart Walk.