Business Intelligence Developer

Job Title: Business Intelligence Developer

Location: Secaucus NJ/ Clifton NJ/ Marlboro NJ/ Chicago IL - Onsite

Duration: Full time

Job Description              

Business Intelligence Developer certified in Epic Cogito, will play a pivotal role in providing analytics insights and developing data solutions to support clinical and business operations. Collaborating closely with various stakeholders, your responsibilities span from gathering requirements and performing qualitative and quantitative analyses to designing, developing, and maintaining complex reports and databases.

This Epic subject matter expert will build data solutions by leveraging the Epic databases (Chronicle, Clarity, Caboodle) and the Cogito suite of tools.

Duties and Responsibilities:

• Configuring and testing Epic-released and Foundation System content for all applications, including: Reporting Workbench, SlicerDicer, Radar, Cogito SQL
• Creating content to display Epic data from Chronicles, Clarity, and Caboodle
• Writing SQL and configuring Radar settings for custom SQL metrics
• Modifying existing reports
• Distributing analytics content to data consumers
• Reviewing peer reports for validity
• Working with subject matter experts to understand the needs of data consumers
• Maintaining the Analytics Catalog and associated metadata records
• Testing analytics build in a specified testing environment and volume testing in live environments
• Reviewing upgrade documentation related to Cogito features and determining how to implement the changes
• Responsible for building and maintaining: Cubes-Extracts, SlicerDicer custom filters, Third-party BI tools, Epic data in Caboodle
• Identify business and technical impacts of user requirements
• Assume responsibility for the quality and delivery of technology business solutions
• Create ad hoc queries, data sources and reports to support the business
• Utilize Cogito suite of tools to deliver data solutions
• Provide productions support and respond to questions related to BI development tool set and Cogito suite
• Mentor and provide guidance, direction, and support to other developers

Qualifications:

• 4+ years of recent healthcare or IT experience
• 3+ years of experience with BI reporting tools
• 3+ years of experience with SQL, writing complex, highly optimized, queries across large volumes of data, database design, data warehouse design, query performance tuning, and writing stored procedures
• Knowledge of BI reporting best practices
• Applied experience working through the complete report development lifecycle for medium to large scale projects
• Training in the fundamentals of report design for the third-party reporting tool
• Strong experience with end users to gain an understanding of user workflows and how to present the data users need in a meaningful way
• Certified in Cogito Fundamentals (this is required to complete data model certification)
• Certified in Cogito Tools Administration
• Complete the Caboodle-Clarity Development class
• Badges for Radar SQL Metrics, SlicerDicer Custom Build, and Cogito SQL

Competencies:

• Strong communication skills
• Critical thinking and an analytical mind
• User-focused design and data visualization skills
• Proficiency with SQL and relational database concepts
• Proficiency and demonstrated experience with analytics tools
• Familiarity with Epic applications and database structure, through training that occurs early in the implementation
• Ability to gain an in-depth understanding of the data model through data model classes geared toward content areas
• Ability to understand data structures that could benefit the entire data environment
• For financial reporting: Prior experience working with an AR system is preferred
• For clinical reporting: Prior experience working with an EMR system is preferred