Research Programmer Analyst Sr

Advocate Aurora Health - Milwaukee, WI

Full-time - Mid Level

Milwaukee, WI

1,001-5,000 employees

Hospitals

About the position

The Research Programmer Analyst Sr role at Advocate Aurora Health involves supporting research through the development and maintenance of data infrastructure. This position focuses on defining functional requirements, developing automated ETL processes, and ensuring data quality for research applications. The analyst will work with various programming languages and tools to deliver analysis-ready datasets while adhering to compliance standards.

Responsibilities

• Assists with defining functional requirements and formulating technical specifications for custom applications and processes that support research.
• Develops, tests, debugs, documents, and maintains automated ETL processes for research data infrastructure.
• Coordinates technical aspects of data mapping and cleaning activities.
• Implements features, develops test cases, fixes defects, and documents applications written in Java or R for research data infrastructure.
• Deploys changes to on-premises and cloud production environments.
• Develops, tests, and debugs complex SQL and R, Python, or SAS code for analysis-ready datasets.
• Documents processes and rationales with code, providing data dictionaries and descriptive statistics as needed.
• Works with senior programmers to develop reusable code methods and functions.
• Ensures datasets are accessible to research investigators while complying with HIPAA and other standards.
• Contributes to documentation, code repositories, and internal packages to improve collaboration and efficiency.

Requirements

• Bachelor's Degree in Computer Science or related field.
• Typically requires 4 years of experience in data management and integration, design and development, program management, and/or report writing.
• Knowledge of data integration, data warehouse design, and management of enterprise data warehouse systems.
• Proficient in SQL and understanding of database-specific procedural languages (e.g., PL/SQL, T-SQL).
• Proficient in statistically oriented programming languages (e.g., R, Python, SAS) or Java.
• Basic understanding of health care data, processes, workflows, and research methodology.

Nice-to-haves

• Experience with ETL tools (e.g., Pentaho Data Integration).
• Strong analytical, logic, and creativity skills.
• Ability to explain technical subjects to non-technical clients.

Benefits

• Health insurance