Business Intelligence Developer

Where compassion meets innovation and technology and our employees are family. Thank you for your interest in joining our team! Please review the job information below. GENERAL PURPOSE OF JOB The Business Intelligence Developer (BID) develop effective ways for stakeholders to view, use, and understand large complex sets of data. Designs, develops, and enhances reports, dashboards, and visualizations for internal and/or external customers. The objectives at this level are complex report writing, query generation, data validation, data visualization and end user education. Incumbents report to the Data and Analytics Manager and will be assigned a focus area within the Driscoll Health Plan. ESSENTIAL DUTIES AND RESPONSIBILITIES - Positions in this class may perform any or all of the below listed duties. These should be interpreted as examples of the work, and are not necessarily all-inclusive. Follows the Driscoll Way with communication, end user engagement, and customer service at all times. Follows all guidelines for PHI and data management. Develops complex SQL queries and has a strong understanding of data models within their assigned focus area. Advanced skills in data visualization tools, maintains data visualization tools, ability to generate proper visualizations/Metrics for end user needs. Tools include SSMS (SQL Server), PowerBI, PowerQuery, SAS Software, and Epic (Clarity / Caboodle). Engagement with end users: ownership of reporting initiatives, working with business to understand report needs, build report specifications and designing reporting solutions. Minimal errors in report/query development by performing basic query tuning, proper data validation steps, reviewing or analyzing data prior to sending to requesters. Works well in team environment and assists colleagues with peer review and guidance on report development, or query generation. Can build complex reports in SSRS, paginated reports or other DHS software tools. T his position has the opportunity to advance into a Lead Business Intelligence Developer / Architect or Lead Healthcare Data Analyst. Performs other related work as required. BEHAVIORAL EXPECTATIONS Customer Service – Enthusiastically interacts with all customers. Assumes personal responsibility for meeting customer needs. Consistently demonstrates a commitment to customer satisfaction. Interpersonal Skills - Sensitive to the needs, ideas, and feelings of others. Develops and maintains rapport with others. Listens well. Facilitates a group process. Adaptability/flexibility – Demonstrates the ability to change behaviors and plans to meet rapidly changing/ competing job demands (new or unusual situations). Receives change as a challenge. Revises plans to meet changing circumstances. Maintains composure, effectiveness, and flexibility under pressure. Communication – Clearly and effectively communicates ideas and requests to others. Persuades or influences others through spoken or written communication. Initiative – Starts and completes tasks with minimum of prompting. Willing to make recommendations and assume additional responsibilities. Team Player – Fully participates in maintaining a positive team environment that is conducive to customer satisfaction. Builds trust among co-workers, focusing on accomplishing hospital and departmental mission and goals. Organized and efficient – Organizes work and uses time efficiently. Takes the initiative to find additional work during slow or downtimes. Recommends innovative ways of doing work more efficiently and effectively. Core Values –Practices Driscoll Children’s Health System core values. EDUCATION AND/OR EXPERIENCE - Any combination of education and experience that would likely provide the required knowledge, skills, and abilities is qualifying. Bachelor's Degree in the fields such as Computer Science, Finance, Statistics, Data Mining and Analytics, Clinical Analytics, or Health Care Administration with Bachelor’s degree or equivalent experience preferred. 2 - 3 years of reporting and analytics experience or preferred degree with at least 2 years of business experience (nursing, epidemiology, health plan, etc.) KNOWLEDGE SKILLS AND ABILITIES Knowledge of: The job requires the ability to design reports using industry standard tools to mine data from the hospitals financial, operational and clinical enterprise systems. The information produced is for enhancing business/clinical processes. The successful candidate should have working experience with relational database querying tools and critical thinking skills to determine the appropriate course of action to meet reporting needs. The successful candidate must possess the ability to work in a team setting as well as independently and possess excellent analytical skills. Communication skills need to be above average to assess customer needs, assist others with report writing, and explain reports to customer audience. Preferred candidates must be well versed in financial and clinical reporting. Preferred candidate will have healthcare industry or related experience, prior experience working with an Electronic Medical Record (EMR)system, knowledge of Clarity or Caboodle data structure for financial and clinical applications, experience with report performance tuning and optimization, experience with SQL query writing and comfortable in making data manipulations and calculations directly in the SQL script. Specific Focus Area Requirements Clinical: Graduate from an accredited college/university preferred Clinical setting with experience preferred Prior experience with information systems with clinical information system experience preferred. Provide leadership in the development of hospital initiatives or programs related to data collection, retrieval, analysis and interpretation to assist in optimizing patient outcomes and/or effectiveness and efficiency. Must be able to extract internally generated data from current clinical modules within the electronic medical record. In addition to the internal data, will need to work with external data sources such as the PHIS database to provide external benchmarking comparisons and identify thorough clinical data. Exhibits the ability to produce reports for internal clinical data and external data as necessary. Serves as an expert on clinical data production/interpretation. Collaborate with colleagues and provide insight on data generation and interpret results and help facilitate recommendations/solutions. Facilitate standardization of definitions to help provide consistent measurements of data throughout the facility. Assess other clinical databases for attributes, data validation and necessity. Health Plan: Understand operations and goals of a health plan. Stay current in the quality and performance measures based on industry standards or government initiatives (DSRIP, HEDIS measures, etc). Integrate data from different sources specific to the health plan, to provide a full picture of organizational performance. Utilize and understand public health data sources. Utilize Qlik or equivalent software. Financial/Operational: Ability to work with market analysis systems, preferred. Participate in budget process developing forecasts for facility and departmental volume, as well as FTE requirements. Familiarity with and an awareness of the laws and regulations that apply to an accounting and/or quality function are required to ensure compliance. Integrate data from different sources, such as Lawson, KRONOS, Epic, etc. to provide a full picture of organizational performance. Develop capital analysis, including pro formas and developing methods of tracking ROI. Must be able to extract internally generated data from current modules within the electronic medical record. In addition to the internal data, will need to work with external data sources, such as the PACT database to provide external benchmarking comparisons and identify areas of opportunity. Stay current in the quality and performance measures based on industry standards or government initiatives (DSRIP, THCIC, CHA, etc.). Until all children are well. Driscoll Children’s Hospital and its specialty centers, urgent care centers, and after-hours facility serve a vast area covering 31 South Texas counties. The hospital is a 191-bed tertiary care center offering 32 medical and 13 surgical specialties. Combined with our non-profit, community-based Health Plan, Driscoll Health System is an exceptional workplace for anyone with a big heart and a drive for success. Smiles, hugs and a soothing touch are as much a part of Driscoll’s approach to treating children as is its advanced medical treatments and technologies. The core values at Driscoll Heath System are: Compassion, Advocacy, Respect, Excellence, and Stewardship. These values are exemplified through every position - from treating the most critical patients hands-on, to maintaining a clean environment, to keeping the organization running from behind the scenes. We invite you to learn about Driscoll’s rich history and explore the laidback lifestyle South Texas has to offer.