Data programmer Analyst-Excellus

Sjhsyr; City of Syracuse (NY); On-site; USD 55,000 - 85,000; Full time

Job summary

An established industry player is seeking a Data Programmer Analyst (I) to join their dynamic team in Syracuse. This role is pivotal in supporting data processing and analysis tasks, ensuring data quality, and contributing to the design of data systems. The ideal candidate will have a strong background in SQL, Python, and R, and will work collaboratively with various teams to transform data into actionable insights. This is an exciting opportunity to be part of a mission-driven organization that values diversity and inclusion, making a significant impact in healthcare analytics.

Qualifications

• 3-4 years of programming experience with SQL, Python, or R.
• General knowledge of relational databases and data warehousing.
• Ability to write readable and efficient code.

Responsibilities

• Support data processing and analysis tasks for analytic teams.
• Automate routine processes and validate data elements.
• Collaborate with stakeholders to determine requirements.

Skills

SQL

Python

R

Data Analysis

Data Visualization

Education

Bachelor's degree in Health Science

Bachelor's degree in Computer Science

Related technical field

Tools

SSIS

SAS

Job description

Employment Type:

Full time

Shift:

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.

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.