Data programmer Analyst-Excellus Local Hybrid

Trinity Health; United States; Remote; USD 80,000 - 100,000; Full time

Job summary

A leading health organization is seeking a Data Programmer Analyst (I) to enhance data processing and analysis efforts. The position involves working with large datasets, automating processes, and collaborating with various teams to support analytic initiatives using programming tools like SQL and Python. Ideal candidates will have a strong background in data analysis and relational database management, looking to contribute to impactful healthcare solutions.

Qualifications

• 3-4 years of programming experience with SQL, SAS, Python, or R.
• Familiarity with data warehousing and relational databases.
• Ability to manage multiple data sources.

Responsibilities

• Support data processing and analysis, including data quality monitoring.
• Write queries for data manipulation and reporting.
• Collaborate with stakeholders to gather requirements.

Skills

SQL

Python

R

Data Analysis

Education

Bachelor's degree in Health Science, Computer Science or related field

Job description

Employment Type: Full timeShift: Description:

Date:

December, 2020

Department:

Business Analysis Unit

FLSA:

Exempt

Reports To:

Manager of Business Intelligence

Grade:

14

Approved By:

Director of Business Intelligence & DSS

POSITION PURPOSE

The Data Programmer Analyst (I) serves as a technical resource to support data processing and analysis tasks such as monitoring data quality, developing documentation, applying statistical methods and creating data visualizations for analytic teams across the organization. The responsibilities for this role include automating routine processes, identification and validation of appropriate data elements, and contribution to the design or architecture of data systems. In addition, this role works with multiple, large, complex data sources to collaboratively aid in the transformation of data to knowledge. This role builds out solutions to support analytic initiatives using SSIS, SQL, R, Python or other applicable tools to meet the specific needs of the organization.

ESSENTIAL FUNCTIONS

Knows, understands, incorporates and demonstrates the Trinity Health Mission, Vision, and Values in behaviors, practices and decisions.

Under the guidance of Senior Analysts, such as Data Scientists (Level II and Senior), Programmer Analysts (Level II and Senior) and Healthcare Data Analysts (Level II and Senior), participates in the creation of working datasets by sourcing high-volume, high-dimensionality data from one or more databases to support analysis, evaluation and recurring production-level datasets.

Supports collaboration with data warehouse teams in navigating data tables, architecture, and incorporation of external data sources in support of utility of data. Documents reporting and data warehouse processes to ensure system reliability and accuracy of warehouse data and queries.

Writes simple to moderately complex queries (SQL, R, Python, etc.) for data manipulation, sorting, summarizing and reporting.

Supports the review, analysis, and programming modification, as directed, including coding, testing, debugging, validity checks and documenting programs.

Collaborates with stakeholders and colleagues, such as Health Informatics and Trinity Information Services, to determine requirements and supports the translation to technical design in alignment with clinical workflows, interpretations, and analytic plans.

Develops knowledge of project specific data and participates in the design and implementation of systems of code with analytics colleagues.

Participates in the code review to identify inefficiencies in system processes and coding practices and streamlines processes.

Supports the completeness and accuracy of data within project context and interpretation of data.

Develops trusted relationships through efficient, high-quality products and effective communication regarding expectations and timelines.

Other duties as needed and assigned

Maintains a working knowledge of applicable Federal, State, and local laws and regulations, Trinity Health’s Organizational Integrity Program, Standards of Conduct, as well as other policies and procedures in order to ensure adherence in a manner that reflects honest, ethical, and professional behavior.

MINIMUM QUALIFICATIONS

Must possess general knowledge of relational databases, data warehousing, and data architecture as normally obtained through completion of a Bachelor's degree in Health Science, Computer Science or a related technical field with three to four (3-4) years of progressively responsible programming experience (including but not limited to SQL, SAS, Python, or R), and working with multiple, moderately complex data sources and large volumes of data; or an equivalent combination of education and experience will be considered.

Trinity Epic COG400 completion required or obtained within three (3) months of hire.

Ability to learn and understand front-end source systems and clinical workflows for effective validation of data.

Basic skills in modular programming to support recurring production-level datasets.

Ability to write code that is clearly readable and efficient and can be explained to a variety of audiences.

Familiarity with statistical concepts and fluency in analytic approaches for health care outcomes.

Must be well organized and possess the ability to work with minimal supervision, which includes setting one’s own priorities and actively seeking direction in case of conflict.

Must be able to make decisions based on logical thinking and ethical principles.

Excellent interpersonal skills to foster collaborative partnerships using a team approach to span traditional boundaries within a health care setting.

Must be comfortable operating in a collaborative, shared leadership environment.

Must possess a personal presence that is characterized by a sense of honesty, integrity, and caring with the ability to inspire and motivate others to promote the philosophy, mission, vision, goals, and values of Trinity Health.

PHYSICAL AND MENTAL REQUIREMENTS AND WORKING CONDITIONS

Must be able to set and organize own work priorities and adapt to them as they change frequently. Must be able to work concurrently on a variety of tasks/projects in an environment that may be stressful with individuals having diverse personalities and work styles.

Must possess the ability to comply with Trinity Health policies and procedures.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of duties so assigned.

Pay Range based on experience and location $34.10-51.10

Our Commitment

Rooted in our Mission and Core Values, we honor the dignity of every person and recognize the unique perspectives, experiences, and talents each colleague brings. By finding common ground and embracing our differences, we grow stronger together and deliver more compassionate, person-centered care. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other status protected by federal, state, or local law.