Lead Cogito Business Intelligence Developer (EPIC Developer) (REMOTE)
Central Health
- Austin, TX
- $110,000-118,000 per year
- Permanent
- Full-time
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.
- We base candidate salary on years of experience; the range for this position is between $110k-118k.
- This position is grant-dependent and currently secured for one year. Additional grant funding is under review but not currently secure.
- Develops complex Healthy Planet patient and contact registries/metrics based on based on stakeholder initiatives
as well as third party ETL tools. * Performs highly complex data queries and mapping. Leads the development and validates test plans forsolutions, 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
- Develops and maintains health care subject matter expertise related to specific products, data elements,
objectives. * Performs troubleshooting of complex/difficult implementation issues; test security of roll-out. Remains vigilant ofdata architecture standards and best practices to ensure solutions are maintainable and scalable. * Supports technical development and documentation of complex BI reports, applications, and databasemanagement. 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 ensurethat 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 thestructure of database objects in database using T-SQL DDL. * Mentors BI Developers to improve technical skills and provides motivation/guidance to less experiencedpersonnel. 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
prepare reports * Knowledge and skills with Healthy Planet contact and patient registry development, businessapplication, 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
- 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
- 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.
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 RequiredPreferred Licenses/Certifications Licenses/Certification
EPIC - EPIC Certification Healthy Planet. Within 6 Months Preferred
EPIC - EPIC Certification Cogito. Within 4 months Preferred