Lead Cogito Business Intelligence Developer

2 weeks ago


Austin, United States Central Health Full time
Overview

Residing on the Reporting, Analytics, and Business Intelligence Team, the Lead Cogito BI Developer leads and provides technical expertise in the design, development, testing, documentation, maintenance of Epic reporting and analytic solutions including Caboodle/Clarity databases and Healthy Planet, Radar, SlicerDicer, and Reporting Workbench applications. This position acts as subject matter expert and assists other members of the team in data discovery and mapping, ETL and schema design, and application development. This position will assist in designing Fact and Dimension tables, Healthy Planet registries, develop ETL processes using SSIS, prepare and maintain technical documentation to guide system users and/or Analysts. This position requires a strong
technical background among multiple technical disciplines and an expertise in Healthy Planet and Caboodle development. This role will act as a bridge of communication and expertise between IT and other analyst/application teams within the Enterprise. This position will report to the Associate Director of Business Intelligence.

* This position is grant-dependent and currently secured for one year. Additional grant funding is under review but not currently secure.

Responsibilities

Essential Duties

Primary Accountabilities:
  • Develops complex Healthy Planet patient and contact registries/metrics based on based on stakeholder initiatives and organization strategy.
  • Works with BI developers, analysts, and customers (clinical/operational leaders, data scientists, quality analysts, etc.) to design, create and publish data models, ETL processes, and metadata using the Epic Caboodle Console, as well as third party ETL tools.
  • Performs highly complex data queries and mapping. Leads the development and validates test plans for solutions, applications, and/or operating systems.
  • Acts as subject matter expert for all Epic Cogito/Radar applications (SlicerDicer, SQL Metrics, RW reports, etc.) and communicates barriers/limitations associated with applications to Enterprise and executive partners.
  • Serves as a data warehouse expert, specifically Clarity and Caboodle, consultant within the CommUnityCare.
  • This includes gathering and interpreting business requirements. Is able to formulate and implement data warehouse solutions based on requirements and following IT methodologies, processes and standards.
  • Acts as subject matter expert in SQL querying and configuring of Radar settings for custom SQL metrics.
  • Develops and maintains health care subject matter expertise related to specific products, data elements, business processes, data marts, and BI applications. Ensures strategic alignment of IT solutions with business objectives.
  • Performs troubleshooting of complex/difficult implementation issues; test security of roll-out. Remains vigilant of data architecture standards and best practices to ensure solutions are maintainable and scalable.
  • Supports technical development and documentation of complex BI reports, applications, and database management. Validates development of prototypical systems or system components to demonstrate technical feasibility.
  • Provides complete and consistent documentation of data warehouse content in the Caboodle Console to ensure that users can determine what data is available in the warehouse, how this data is defined, and lineage to Epic Clarity.
  • Participates in the ongoing maintenance of the data warehouse and ETL programs. Creates and modifies the structure of database objects in database using T-SQL DDL.
  • Mentors BI Developers to improve technical skills and provides motivation/guidance to less experienced personnel. Mentors in the deployment of SSIS ETL Jobs, Stored Procedures and Views to production servers.
Knowledge/Skills/Abilities
  • Microsoft SQL Server environment
  • SQL query writing
  • Knowledge and skills working with large data sets, including survey instrument design, data collection processes, data analysis, and writing reports on findings of the research.
  • Knowledge and skills with relational databases, data queries, and data extraction techniques including the ability to import, merge, and export files between applications, perform analyses, and prepare reports
  • Knowledge and skills with Healthy Planet contact and patient registry development, business application, and maintenance.
  • Knowledge and skills with Clarity and Caboodle development.
  • Knowledge and skills developing Epic SlicerDicer Data Models
  • Self-starter able to take ownership of analysis projects from start to finish, with the ability to meet established timelines.
  • Knowledge and skills of databases, stored procedures, and the scheduling of jobs
  • Ability to work with diverse teams, and collaborate with leaders from all areas of organization.
  • Knowledge and skill in technical documentation.
  • Ability and drive to maintain a working knowledge of key indicators, standards, and processes related to EMR systems.
  • Strong organizational skills with a strong attention to detail and accuracy.
  • Excellent verbal and written communication skills.
  • Ability to work independently to complete a project
  • Ability to be flexible and work in a fast-paced environment.
  • Ability to leverage technical knowledge and subject matter expertise to mentor team members.


Qualifications

Minimum Education

Bachelor's Degree Management Information Systems, Finance, Mathematics, Economics, Computer Science, Engineering, Statistics, Public Health, Epidemiology or related quantitative discipline.

Preferred Education

Master's Degree Master' s Degree Management Information Systems, Finance, Mathematics, Economics, Computer Science, Engineering, Statistics, Public Health, Epidemiology or related quantitative discipline.

Minimum Experience

7 years Business Intelligence or Analytics/Reporting experience.
4 years Epic Healthy Planet and/or Clarity/Caboodle Development experience.
4 years SQL Server Experience, including SSIS and T-SQL, coding, performance tuning, and system optimization.
4 years Microsoft SQL Coding (preferably T-SQL) experience.

Required Licenses/Certifications Licenses/Certification
EPIC - EPIC Certification
Cogito/Clarity/Caboodle. Within 6 Months Required

Preferred Licenses/Certifications Licenses/Certification
EPIC - EPIC Certification Healthy Planet. Within 6 Months Preferred
EPIC - EPIC Certification Cogito. Within 4 months Preferred

  • Austin, Texas, United States CommUnityCare Health Centers Full time

    Overview: The Business Intelligence Analyst, Sr. will act as an expert in understanding the organizations data, working with stakeholder groups to create dashboards, visualizations, algorithms, and business tools for use across the organization. This includes aiding various teams in drawing insight from our data by researching, compiling, and analyzing data...

  • Business Intelligence

    1 month ago


    AUSTIN, United States Atechstar Full time

    Job DescriptionLead in the design development testing and maintenance of Business Intelligence applications and provide end-user support for the implementation and usage of business intelligence systems. Apply specific functional working and general industry knowledge. Develop or contribute to solutions for a variety of problems of moderate scope and...

  • Business Intelligence

    1 month ago


    Austin, Texas, United States Atechstar Full time

    Job DescriptionLead in the design development testing and maintenance of Business Intelligence applications and provide end-user support for the implementation and usage of business intelligence systems. Apply specific functional working and general industry knowledge. Develop or contribute to solutions for a variety of problems of moderate scope and...


  • Austin, United States Enovis Full time

    Who We Are ABOUT ENOVIS™ Enovis Corporation (NYSE: ENOV) is an innovation-driven medical technology growth company dedicated to developing clinically differentiated solutions that generate measurably better patient outcomes and transform workflows. Powered by a culture of continuous improvement, global talent and innovation, the Company's extensive range...


  • Austin, United States eTeam Full time

    Skill MicroStrategy / Tableau Dimensional Data modelling, Logical & Physical Data modelling Data Vault 2.0 model for Snowflake Data visualizations / interactive dashboards Qlikview, Qlik Sense, Tableau, Power BI Data & Analytics Detailed JD (Pl share the Detailed Description, 1 liner JD will not work) The primary role for the Business Intelligence Engineer...


  • Austin, Texas, United States NeighborFavor Inc Full time

    We're building a community of Runners (that's what we call Favor delivery drivers), customers, and local businesses.We're looking for a Sr. Business Intelligence Analyst to help Favor grow to become a household name in Texas.As a Sr. Business Intelligence Analyst on Favor's Business Analytics team, you treat data as a product with real return on...


  • Austin, United States Macpower Digital Assets Edge Full time

    Position Overview: The Business Development Representative (BDR) plays a crucial role in driving the growth and success of a company by identifying and generating new business opportunities. As a key member of the sales team, the BDR focuses on prospecting, qualifying leads, and nurturing relationships to ultimately convert them into customers. This role...


  • Austin, United States Certinia Full time

    WHO WE ARE Certinia (formerly FinancialForce) delivers a Services-as-a-Business platform that powers and connects all aspects of services operations, from services estimation and delivery to customer success management and financial planning and accounting. The company's Professional Services Automation (PSA), Customer Success, and ERP solutions delivered on...


  • Austin, United States Macpower Digital Assets Edge Full time

    Position Overview: The Business Development Representative (BDR) plays a crucial role in driving the growth and success of a company by identifying and generating new business opportunities. As a key member of the sales team, the BDR focuses on prospecting, qualifying leads, and nurturing relationships to ultimately convert them into customers. This role...

  • Business Developer

    4 weeks ago


    Austin, United States BrightView Landscapes Full time

    **Description** At BrightView, the best teams are created and maintained here. If you are searching for your next fulfilling career, picture yourself on a best-in-class team where you can grow to be your brightest. Were looking for aBusiness Developer.Can you picture yourself here? **Heres what youd do**: Youd aggressively grow our landscape maintenance...

  • Business Developer

    2 weeks ago


    Austin, United States BrightView Landscape Services Full time

    Description Position at BrightView Landscape Services At BrightView, the best teams are created and maintained here. If you are searching for your next fulfilling career, picture yourself on a best-in-class team where you can grow to be your brightest. We're looking for a Business Developer. Can you picture yourself here? Here's what you'd do: You'd...


  • Austin, United States US United States Army Futures Command Full time

    **Duties**: - Serve as the AFC lead for Threat Mitigation, synchronizing with the Defense Security Enterprise, IC, and non - traditional partners to protect technologies identified in the Critical Technologies Protection List (CPTL). - Oversee the management of AFC CPTL, use the CPTL to prioritize foreign intelligence and counterintelligence (CI) activities...


  • Austin, United States eBay Full time

    At eBay, we're more than a global ecommerce leader — we’re changing the way the world shops and sells. Our platform empowers millions of buyers and sellers in more than 190 markets around the world. We’re committed to pushing boundaries and leaving our mark as we reinvent the future of ecommerce for enthusiasts. Our customers are our compass,...


  • Austin, United States Burnett Specialists Staffing & Recruiting Full time

    Job DescriptionA European electronics manufacturer has opened a new Austin office and is looking to hire several Business Development Executives. They will be responsible for account development and maintenance with the objective of maximizing revenue in line with the Company's long and short-term strategic objectives. Key Responsibilities &...


  • Austin, Texas, United States Sibylline Americas Full time

    Job Description Sibylline Ltd is looking for an outstanding intelligence professional and manager to join us in an embedded role leading a client's Threat Intelligence team. The role will be based in office in Austin, TX and support the client’s security leadership. The Embedded Account Manager will act as the management point of contact between the...


  • Austin, United States Burnett Specialists Staffing & Recruiting Full time

    Job Description A European electronics manufacturer has opened a new Austin office and is looking to hire several Business Development Executives. They will be responsible for account development and maintenance with the objective of maximizing revenue in line with the Company's long and short-term strategic objectives. Key Responsibilities &...


  • Austin, United States Skiltrek Full time

    Business Development Manager - Staffing - 100% Remote Contract, Direct Placement, SOW, MSP Skiltrek is celebrating 20 years as an innovative and rapidly growing staffing company that connects businesses with top-tier professionals. We specialize in providing customized staffing solutions to meet the unique needs of our clients, ranging from startups to...


  • Austin, United States Skiltrek Full time

    Business Development Manager - Staffing - 100% Remote Contract, Direct Placement, SOW, MSP Skiltrek is celebrating 20 years as an innovative and rapidly growing staffing company that connects businesses with top-tier professionals. We specialize in providing customized staffing solutions to meet the unique needs of our clients, ranging from startups to...


  • Austin, United States TalentBridge Full time

    Job Type Full-time Description Let's take a dive into your internal thoughts and see if we can answer your questions for you on this intriguing job opportunity... First of all, who and what is TalentBridge? TalentBridge is a staffing agency that is mastering the approach of being the indisputable beacon of trust and unwavering support for strategic talent...


  • Austin, Texas, United States Sibylline Americas Full time

    Job Description Sibylline is looking for a professional intelligence analyst to join our team in an embedded role within a client's security function. Based in Austin, TX and reporting to the embedded AMR Team Lead, the successful candidate will join a 24/7 team of analysts spread across the USA, UK and Singapore as part of a tight-knit operation providing...