Developer-GME Research Data - Northeast Georgia Health System, Inc

Job Category:

Work Shift/Schedule:

Northeast Georgia Health System is rooted in a foundation of improving the health of our communities.

About the Role:

Job Summary

The GME Research Data Developer is an integral part of the GME Research Team and is responsible for the design, development, and project management of business intelligence solutions, including reports, dashboards, and other data views, to meet the needs of GME stakeholders for various data sources. This role will have extensive interaction with GME research team members, GME stakeholders and GME leadership and will be tasked with analysis of GME data and analytics requirements, and the transformation of those requirements into analytics solutions. A key element of this role includes serving as the IRB defined “honest-broker” for research-related databases to ensure the ethical and appropriate use of access to institutional data. The Developer with be responsible for developing complex reports and dashboard in EPIC and other Business Intelligence systems 80-90% of the time. Strong project management skills: ability to formulate action plans and timelines and to execute those plans; ability to manage multiple initiatives simultaneously. Strong analytical skills to develop, interpret, adapt, known methods, system procedures or operating concepts to new situations. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of complex tasks. A wide degree of creativity and latitude is expected. Demonstrated ability to achieve results through team efforts, willingness to challenge established practices draw relevant conclusions. Leads and coaches team members to achieve goals, objectives and personal growth. 

• Licensure or other certifications: Qlik Sense Business Analyst Certification required should be obtained within two (2) years of being hired, and 
  Clarity and Caboodle Data model certified required should be obtained within one (1) year of being hired. OR Epic Cogito fundamentals and Cogito Tools Administration certification/accreditation required within one (1) year of being hired.

• Educational Requirements: Bachelors Degree

• Minimum Experience: A minimum of eight (8)+ years of experience as a developer with various BI and other analytic reporting software applications (PowerBI, Tableau and Qlik). Prior experience providing production level support and/or development in business intelligence (BI)/enterprise data warehouse (EDW) environments. Working knowledge of data warehouse concepts, enterprise data management, modeling techniques and ability to create solutions. Experience in participating in strategy discussions and review them with customer as well as project stakeholders. Experience in database development and management tasks such as creating indexes, functions, stored procedures, creating databases, file groups, users, configuring permissions and assigning roles to users. 

• Other: Bachelors Degree Required in Computer Science, Math, or related field. In lieu of Bachelor's Degree related experience in the field, twelve (12) years progressively responsible, professional job specific work experience and an equivalent combination of education and training that provides the required knowledge, skills and abilities, combined with demonstrated professional growth and achievement.

• Preferred Licensure or other certifications: Python certification

• Preferred Educational Requirements:

• Preferred Experience:

• Other: Knowledge of Epic Clarity and Caboodle data models

• Excellent analytical and interpersonal skills; demonstrated ability to work with management and customers; proven ability to work independently or as a team member; strong problem solving and troubleshooting skills; ability to translate complex information into simpler terms and concepts

• Proven ability to maintain positive peer, customer relationships, interacting positively and productively with teams across organizational lines. Demonstrates skills in critical thinking, and consensus and relationship building.

• Service-oriented; able to communicate technical solutions to non-technical customers

• Must be able to function in dynamic environment subject to changes in schedules and priorities, working on multiple projects/ issues concurrently

• Comfortable presenting to senior management, physicians and all levels of staff

• Understanding of the full reporting delivery life cycle, from requirements definition to report development and testing required as well as understanding of data management best practices and proper use of data management technologies

• Understands healthcare, hospital and ambulatory terminology, business practices, and industry trends and ideas for data analysis, including regulatory regulations such as HIPAA, DNV and MIPS

• Knowledge of clinical documentation and orders databases, research database requirements, data conversion models, workflows, master files, category lists, synonyms and preference lists

• Experience in analytics specification gathering, reviews, solution design, estimation and general planning for project execution, monitoring and control

• Hands-on with ability to design, re-design (schemas, data models, entity relationships etc.), and probe and guide developers

• Experience in understanding end user workflows and determining the most appropriate analytics solutions that supports the operational workflows that will provide end users with the data that is needed in the manner that is needed in order to solve the end user's business problems

• Experience in developing data report solutions to complex, multi-source data streams

• Ability to learn rapidly and to apply formal training to new software environments

• UpToDate knowledge of external databases and platforms such as Qualtrics and RedCap

• Experience in creating and maintaining reports that summarize data to be used by management

• Develop and maintains knowledge of scholarly activity pathways in GME and associated institutional requirements.

• Maintains a service-oriented approach with customers, providing follow up and responding to issues/ concerns in a timely manner. Answer staff and client questions in person, via email and via phone. Responsible for ensuring service level agreement adherence.

• Serves as the research team’s IRB defined “honest-broker” for GME research-related databases to ensure the validation of data, ethical de identification of participant data and monitor appropriate use of access to institutional data. Use of deidentification processes that are compliant with federal requirements.

• Develop and maintain a key terms definition list consistent across GME databases and reporting (for example, define “Length of Stay”). Work in collaboration with IT to validate and crosswalk data.

• Works closely with end-users to identify and explain data and reporting discrepancies.

• Utilizes the report request and development process, including the development of an understanding of a report request, assessment of the appropriate tool to be used to provide the data, creation of a report specification in partnership with the operational stakeholder and business intelligence application analyst, development of the report and validation of the report by the operational stakeholder to ensure quality, timeliness and accountability.

• UpToDate knowledge of external databases and platforms such as Qualtrics and RedCap.

• Creates standard or custom reports, dashboards, views, etc. summarizing clinical, financial, or operational data for review by executives, managers, physicians and other stakeholders using the Epic Cogito BI tools, Business Objects, Crystal, and Qlik Sense, including GME specific data sources from Qualtrics, RedCap and NVivo platforms.

• Works with other analysts to integrate data from other source systems to form richer data sets, including the capture of derived data to address gaps in source system repositories.

• Partners with operational stakeholders to understand current reporting, analytics and data needs/requests and help determine the best approach to meeting those needs.

• Responsible for data development, cleaning, collection/extraction using SQL scripts, indexes and complex queries and developing methods for database design and validation reports.

• Prepares and maintains key documents and technical specifications for new and existing solutions.

• Documents specifications for dashboards, or other outputs.

• Partners with the Epic application teams to ensure that roles/security templates or end users in Epic have the appropriate access to reports and dashboards.

• Conducts or coordinates tests to ensure that intelligence is consistent with defined needs.

• Collaborates with BI on all upgrade, update or enhancement efforts associated with the business intelligence tools.

• Independently implements and maintains multidimensional data marts ensuring availability and reliability.

• Work on additional assignments as delegated by management.

• Weight Lifted: Up to 20 lbs, Occasionally 0-30% of time

• Weight Carried: Up to 20 lbs, Occasionally 0-30% of time

• Vision: Moderate, Frequently 31-65% of time

• Kneeling/Stooping/Bending: Occasionally 0-30%

• Standing/Walking: Frequently 31-65%

• Pushing/Pulling: Frequently 31-65%

• Intensity of Work: Occasionally 0-30%

• Job Requires: Reading, Writing, Reasoning, Talking, Keyboarding

Working at NGHS means being part of something special: a team invested in you as a person, an employee, and in helping you reach your goals. 

NGHS: Opportunities start here.

Northeast Georgia Health System is an Equal Opportunity Employer and will not tolerate discrimination in employment on the basis of race, color, age, sex, sexual orientation, gender identity or expression, religion, disability, ethnicity, national origin, marital status, protected veteran status, genetic information, or any other legally protected classification or status.