IT Applications Engineer IV, Database - Epic Cogito

As a Lead Business Intelligence Administrator, you will use Epic Application build and analytics experience to build tools that will provide data insight to our business partners. You will leverage your understanding of healthcare related workflows to interact with physicians and clinical partners to provide them with analytical solutions that help advance patient care.Directly interact with Clinical/Market leaders and SMEs to understand their data needs and lead and mentor analysts within the team to meet those needs. Possess strong analytical, technical and troubleshooting skills and work both independently and within a team of analysts.Make informed decisions based on data, train and mentor team members. Use expertise in SQL and various Epic Cogito functionalities (Clarity, Caboodle, Radar, Reporting Workbench, SlicerDicer, Epic Metrics framework, Epic Registries) to provide accurate and timely data to our end users.

• Epic Application Build or experience in analytics / business intelligence within a healthcare system using the Epic Systems electronic health record


• Expert with SQL and Cogito functionality (Clarity, Caboodle, Radar, Reporting Workbench, SlicerDicer, Epic Metrics framework, Epic Registries)


• Understanding Healthcare related workflows and ability to converse in clinical language with physicians and clinical staff.


• Providing direct interaction with Clinical/Market Leaders & Subject Matter Experts


• Experience with BI tools such as Tableau, Crystal Reports, Power BI

In addition to the responsibilities listed below, this position is responsible for supervising technical software aspects for development and production activities for one functional area or application. This includes providing technical expertise on Database/Data Warehousing software program/ application/system; acting as first point of escalation for Database/Data Warehousing technical decisions and problems, and leading other software engineers for efficient program/ application solutions which support business processes and functional requirements; and overseeing all Database/Data Warehousing coding and work quality reviews. Some of the unique challenges this position will face include acting as a SME on Database/Data Warehousing across healthcare / plan applications.

• Completes work assignments and supports business-specific projects by applying expertise in subject area; supporting the development of work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating and assigning resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving complex problems; escalating high priority issues or risks, as appropriate; and recognizing and capitalizing on improvement opportunities.


• Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others and managers; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback.


• As part of the IT Engineering job family, this position is responsible for leveraging DEVOPS, and both Waterfall and Agile practices, to design, develop, and deliver resilient, secure, multi-channel, high-volume, high-transaction, on/off-premise, cloud-based solutions.


• Provides insight into recommendations for technical solutions that meet design and functional needs.


• Translates business requirements and functional specifications into physical program designs, code modules, stable application systems, and software solutions by partnering with Business Analysts and other team members to understand business needs and functional specifications.


• Assists in identification of specific interfaces, methods, parameters, procedures, and functions, as required, to support technical solutions.


• Leads systems incident support and troubleshooting for complex and non-complex issues.


• Supports component integration testing (CIT) and user acceptance testing (UAT) for application initiatives by providing triage, attending test team meetings, keeping the QC up-to-date, performing fixes and unit testing, providing insight to testing teams in order to ensure the appropriate depth of test coverage, and supporting the development of proper documentation.


• Builds and maintains trusting relationships with internal customers and third party vendors to ensure the alignment, buy-in, and support of diverse project stakeholders.


• Reviews and validates technical specifications and documentation.


• Identifies specific interfaces, methods, parameters, procedures, and functions to support technical solutions while incorporating architectural designs.


• Collaborates with architects and/or software consultants to ensure functional specifications are converted into flexible, scalable, and maintainable solution designs.


• Provides implementation and post-implementation triage and support of business software solutions by programming and/or configuring enhancements to new or packaged-based systems and applications.


• Reviews and makes changes to technical specifications and documentation.


• Develops and executes unit testing to identify application errors and ensure software solutions meet functional specifications.


• Writes technical specifications and documentation.


• Ensures new and existing software solutions are developed with insight into industry best practices, strategies, and architectures.


• Builds partnerships with IT teams and vendors to ensure written code adheres to company architectural standards, design patterns, and technical specifications.


• Leads, mentors, and trains other technical resources to develop software applications.


• Develops, configures, or modifies basic to moderately complex integrated business and/or enterprise application solutions within various computing environments by designing and coding component-based applications using programming languages.


• Participates and coaches others in all software development lifecycle phases by applying and sharing an in-depth understanding of company and industry methodologies, policies, standards, and controls.


• Assists with project estimation throughout the PLC.


• Develops and maintains specialist knowledge of database concepts, object and data modeling techniques and design principles, and a detailed knowledge of database architectures, software, and facilities. Analyses data requirements to establish, modify, or maintain object/data models. Evaluates potential solutions, demonstrating, installing, and commissioning selected products.


• Takes responsibility for the accessibility, retrievability, and security of specific subsets of information. Provides advice on the transformation of information from one format/medium to another, where appropriate. Maintains and implements information handling procedures. Enables the availability, integrity, and search ability of information through the application of formal data structures and protection measures. Manipulates specific data from information services to satisfy local or specific information needs.