Data programmer Analyst-Excellus

Employment Type:

Shift:

Date:

December, 2020

Department:

Business Analysis Unit

FLSA:

Exempt

Reports To:

Manager of Business Intelligence

Grade:

14

Approved By:

Director of Business Intelligence & DSS

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.

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.

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.

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.

Our Commitment to Diversity and Inclusion
 

Trinity Health is one of the largest not-for-profit, Catholic healthcare systems in the nation. Built on the foundation of our Mission and Core Values, we integrate diversity, equity, and inclusion in all that we do. Our colleagues have different lived experiences, customs, abilities, and talents. Together, we become our best selves. A diverse and inclusive workforce provides the most accessible and equitable care for those we serve. Trinity Health is 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, status as a protected veteran, or any other status protected by law.