Research Programmer Analyst

Department:

80036 Research - Office of Research Analytics and Systems Computing

Status:

Full time

Benefits Eligible:

Yes

Hours Per Week:

40

Schedule Details/Additional Information:

-Remote

Major Responsibilities:

• Develops, tests, and debugs complex SQL and moderately complex R, Python, or SAS code to deliver reproduceable and scalable analysis-ready datasets. Documents processes and rationales with code. Provides data dictionaries and descriptive statistics with datasets as appropriate.
• · Assists with defining functional requirements, assists with formulating technical specifications, and researches and evaluates alternatives for moderately complex custom applications and processes that support research.
• · Develops, tests, debugs, documents, and maintains automated routine extract, transform, and load (ETL) processes that comprise data infrastructure for research. May coordinate the technical aspect of and regularly participates in data mapping and cleaning activities. Makes recommendations and improves data quality within research data infrastructure.
• · Works with senior programmers to develop stub methods and functions with appropriate documentation for code that that can be generalized and repurposed within internal libraries and packages. Develops more detailed technical specifications.
• · Ensures datasets are accessible and provided to research investigators and stakeholders in a manner consistent with Health Insurance Portability and Accountability Act (HIPAA), Institutional Review Board (IRB), legal agreements, policies and procedures, and other appropriate standards.
• · Increases collaboration, efficiency, and standardization within the department by contributing and improving documentation, code repositories, and internal packages. Regularly reviews pull requests. Engages with larger analytics community.

Licenses & Certifications:

Epic Clinical Data Model certification issued by Epic (COG240). needs to be obtained within 6 months, and
Epic Caboodle Data Model certification issued by Epic. needs to be obtained within 6 months, and
Epic Clarity Data Model certification issued by Epic (CLR110). needs to be obtained within 6 months.

Educational Requirment:

Bachelor's Degree in Computer Science or related field.

Experience Required:

Typically requires 4 years of experience in data management and integration, design and development, program management, and/or report writing.

Preferred remote locations in IL, WI, NC, GA

Fully Remote Role from these states: AL, AK, AR, AZ, DE, FL, GA, IA, ID, IL, IN, LA, KS, KY, ME, MI, MO, MS, MT, NC, ND, NE, NH, NM, NV, OH, OK, PA, SC, SD, TN, TX, UT, VA, WI, WV, WY.
Due to complex requirements, remote work is NOT permitted for short or long periods in: CA, CO, CT, HI, MA, MD, MN, NJ, NY, OR, RI, VT, WA and working Internationally (this includes working while on vacation).

No relocation, No Sponsorship/transfer for any visa for this position.

Knowledge, Skills & Abilities:

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 and workflows, and research methodology with strong analytical, logic and creativity skills.

· Knowledge of data integration, data warehouse design and management of enterprise data warehouse systems.

· Exposure to building and maintaining ETL processes through ETL tools.

· Knowledge of Health Insurance Portability and Accountability Act (HIPAA) patient confidentiality and privacy regulations.

· Ability to explain technical subjects to non-technical clients.

· Ability to work independently, or as part of a team and balance multiple priorities

Physical Requirements and Working Conditions:

• Position may require travel which may result in exposure to road and weather hazards.
• Exposed to normal office environment.
• Operates all equipment necessary to perform the job.

This job description indicates the general nature and level of work expected of the incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the incumbent. Incumbent may be required to perform other related duties.

Pay Range

$34.90 - $52.35

Our Commitment to You:

Advocate Health offers a comprehensive suite of Total Rewards: benefits and well-being programs, competitive compensation, generous retirement offerings, programs that invest in your career development and so much more – so you can live fully at and away from work, including:

Compensation

• Base compensation listed within the listed pay range based on factors such as qualifications, skills, relevant experience, and/or training
• Premium pay such as shift, on call, and more based on a teammate's job
• Incentive pay for select positions
• Opportunity for annual increases based on performance

Benefits and more

• Paid Time Off programs
• Health and welfare benefits such as medical, dental, vision, life, and Short- and Long-Term Disability
• Flexible Spending Accounts for eligible health care and dependent care expenses
• Family benefits such as adoption assistance and paid parental leave
• Defined contribution retirement plans with employer match and other financial wellness programs
• Educational Assistance Program

About Advocate Health 

Advocate Health is the third-largest nonprofit, integrated health system in the United States, created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names Advocate Health Care in Illinois; Atrium Health in the Carolinas, Georgia and Alabama; and Aurora Health Care in Wisconsin, Advocate Health is a national leader in clinical innovation, health outcomes, consumer experience and value-based care. Headquartered in Charlotte, North Carolina, Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies, with Wake Forest University School of Medicine serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology, neurosciences, oncology, pediatrics and rehabilitation, as well as organ transplants, burn treatments and specialized musculoskeletal programs. Advocate Health employs 155,000 teammates across 69 hospitals and over 1,000 care locations, and offers one of the nation’s largest graduate medical education programs with over 2,000 residents and fellows across more than 200 programs. Committed to providing equitable care for all, Advocate Health provides more than $6 billion in annual community benefits.