Impact Advisors - Chicago, IL
posted 29 days ago
Impact Advisors, LLC, a leading healthcare consulting firm, is seeking a skilled and experienced Business Intelligence (BI) Developer with Epic and Healthcare experience to join our dynamic team. As a BI Developer, you will play a vital role in designing, developing, and maintaining business intelligence solutions that drive data analysis and reporting capabilities for our healthcare clients, particularly in the Epic environment. Your expertise in Epic and healthcare data will contribute to improving operational efficiency and decision-making within healthcare organizations. In this role, you will work closely with clients to understand their data management and integration requirements within the healthcare industry. You will be responsible for creating information from data and will be skilled at organizing the presentation of quantitative information to facilitate understanding and illuminate decision-making. You will need intermediate to advanced/expert experience and knowledge in developing complex SQL scripts as a SQL programmer. A strong hands-on working knowledge of analytical and BI tools such as MS SQL Server, SAP, Tableau, and Power BI is essential, with knowledge of statistical packages being a plus. You will also have experience documenting and analyzing clinical workflows and processes, along with a foundational understanding of relational and dimensional data models. The ability to produce data flow diagrams that show data lineage and experience with data sourcing, data mapping, and managing metadata is crucial. You will be expected to translate business requirements into data and information deliverables using relevant business intelligence tools. Certification in one or more of the following Epic Systems modules: Clarity, Caboodle, Cogito, Reporting Workbench is required. As part of your responsibilities, you will gather requirements and design customized reports, dashboards, and analytics solutions using the Epic Cogito platform. You will configure and optimize the Epic Cogito platform to meet client-specific reporting needs, including data extraction, transformation, and visualization. Additionally, you will perform testing, troubleshooting, and performance tuning to ensure accurate and efficient reporting, and provide training and support to end-users on utilizing the Epic Cogito reporting tools effectively. In terms of the Epic Caboodle platform, you will design, develop, and implement data models, data mappings, and ETL processes for effective data integration and aggregation. You will configure and maintain the Epic Caboodle data warehouse, ensuring data quality, integrity, and security. Identifying and resolving data-related issues, performance bottlenecks, and optimization opportunities will also be part of your role, along with supporting data governance initiatives, including data profiling, cleansing, and stewardship activities. You will provide training and support to end-users on accessing and utilizing data from the Epic Caboodle data warehouse effectively.