BI Architect - Epic Revenue - Clinical Data Model - Cogito Project Manager at 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 Business Intelligence (BI) Architect is a high-level business intelligence professional that is a key part of the Data and Analytics Team and will be generally responsible for the design, development, and implementation of data modeling and construction of the BI and analytics solutions, including business process analysis, database design, core data architecture, and report design/development. The BI architect develops specific data structures or implementations for a set of end users within a business. This role will work on tasks like linking legacy or enterprise software to BI applications and creating or handling metadata that helps programs use data more efficiently and accurately. The BI architect will have extensive interaction with operational team members and leadership, and will be tasked with analysis of business data and analytics requirements, and the transformation of those requirements into analytics solutions. Working with customers and Management to determine priorities as well mentoring of other team members on BI concepts and strategies is also an integral role of the position

• Licensure or other certifications: Epic Revenue or Clinical Data Model or Cogito Project Manager Certificate

• Educational Requirements: Bachelors degree

• Minimum Experience: Seven (7) years as a various BI and other analytic reporting software applications with strong preference for EPIC, SQL, and Crystal Report Writing. Providing production level support and/or development in business intelligence (BI)/enterprise data warehouse (EDW) environments

• Other: If no certification, must be obtained within 6 months of date of hire; In lieu of Bachelor's Degree, eleven (11) 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:

• Preferred Educational Requirements:

• Preferred Experience: Database development and management tasks such as creating indexes, functions, stored procedures, creating databases, file groups, users, configuring permissions and assigning roles to users. Working knowledge of data warehouse concepts, enterprise data management, modeling techniques and ability to create solutions, participate in strategy discussions and review them with customer as well as project stakeholders

• Strong 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; initiative in enhancing system productivity, functionality, and performance

• Advanced 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

• Excellent communication (written, verbal and presentation) and people-facing skills, Proven ability to maintain positive peer, customer relationships, interacting positively and productively with teams across organizational lines. Demonstrates skills in leadership, critical thinking, and consensus and relationship building

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

• Ability to think logically and analyze and enhance work flow efficiencies and problem solve system issues

• Must be able to function in dynamic environment subject to changes in schedules and priorities, working on multiple projects/ issues concurrently. Responsibilities may require evening and weekend work in response to needs of the systems supported

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

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

• Possess a solid understanding of data warehousing concepts, including relational and multidimensional modeling

• Experience in designing, building, testing, executing and performance tuning of ETL and reporting applications, including automation of ETL jobs for recurring imports; fluent in Microsoft SQL

• Experience in designing and developing database objects, tables, stored procedures, views, and triggers

• 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.

• 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. Provide after-hours on-call support on a scheduled basis. Responsible for ensuring service level agreement adherence.

• Works with staff to adhere to department/organization policies and procedures, compliance and regulatory agency requirements.

• Works with leaders in IT as well as operations to identify data from other source systems to form richer data sets, including the capture of derived data to address gaps in source system repositories.

• Promotes and 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 application analyst, development of the report and validation of the report by the operational stakeholder to ensure quality, timeliness and accountability.

• In partnership with the Technical Training team, facilitates the development and implementation of a self-service reporting program across the organization that utilizes tools like Epic's Slicer Dicer program and Qlik Sense, which include a formal training and support plan to help users across the organization utilize these tools.

• Assists with all upgrade, update or enhancement efforts associated with the business intelligence tools.

• In partnership with the Manager of Business Intelligence and Analytics, serves as a mentor and advisor to the  BI technical resources and other analysts and provides general project management skills to produce BI views that address customer’s needs.

• Builds and maintains SQL scripts, indexes and complex queries for data analysis and extraction.

• Troubleshoots problems regarding the databases, applications, and development tools.

• Assists with the development and implementation of new data sources into the data warehouse or determine ways to be able to utilize data in other systems to support data and analytics for the organization.

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

• Responsible for data collection/extraction 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 business intelligence or information technology (IT) reports, dashboards, or other outputs.

• In collaboration with other team members and leadership, supports the evaluation, adoption and implementation of new methods, tools and technologies in order to meet current gaps in the organization-wide data and analytics infrastructure.

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

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

• Provides solution design, perform reviews and participate strategic discussions.

• Provides application analysis and data modeling design to collect data or to extract data from various disparate systems.

• Monitors incident management queue. Efficiently troubleshoot, resolve, report and close active issues.

• Works on additional assignments as delegated by management.

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

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

• Vision: Moderate, Frequently 31-65%

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

• Standing/Walking: Frequently 31-65%

• Pushing/Pulling: Occasionally 0-30%

• Intensity of Work: Occasionally 0-30%

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

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.