Position Summary / Career Interest:

As part of the centralized Analytics and Business Intelligence department, an EDW Developer works to fulfill analytical requests generated by all departments within the health system. Content developed by this role, leveraging internal enterprise data-warehouse, should be designed to improve patient care, enhance patient engagement, advance operational efficiency, and improve the health system's financial position. This role adds value to the health system by developing data models, enhancing application functions, advancing the skills of their teams, and providing better service and products for their customers. Successful candidates should have SQL experience to transform data from multiple sources, strong critical thinking and communication skills with an analytical mindset, and experience visualizing insights to tell a story and achieve actionable results. Attention to detail is an important characteristic for candidates interested in this position. Candidates should be comfortable operating in a dynamic environment with ability to balance multiple priorities and competing deadlines.


Responsibilities and Essential Job Functions

• Create, analyze, modify, configure, and distribute content using information technologies to support clinical and operational processes and organizational initiatives in the non-EMR environment.
• Perform all steps of product development stages when designing new data models (requirements collection, research, development, testing, deployment, monitoring, and configuration) that meet health system development standards based on assigned domains. Translate analytical business requirements within request and design solutions that meet the needs of the customers.
• Write clean, maintainable, and well-documented code with focus on reliability embedded in development standards to support data processes.
• Learn workflows, data collection methods, and reporting solutions to present advantages/disadvantages of analytical options available to the customer.
• Provide customer facing Power BI portal support by addressing security concerns/questions, producing updated content, performing configurations, supporting upgrades, monitoring performance to ensure successful completion, and mitigating incidents if they occur.
• Responsible for integrity of the outputs including validation of the data in analytical solutions, systems, and data domains.
• Monitor the performance of existing analytical solutions and taking corrective action to optimize or improve their performance for assigned domains and associated data models.
• Detect data discrepancies and data quality issues and work with other content development members and subject matter experts to ensure data consistency and integrity within systems, data models, and applications.
• Identify new data sources necessary to achieve desired clinical and/or business outcomes and engage with content development support teams to integrate data into a consistent and usable format in the non-EMR environment.
• Engage with Application Analysts and Clinical Informatics Analysts during design and build stages to align content development with operational workflows and validate requirements that define success as part of the implementation in the non-EMR environment.
• Engage with Data Analytics Engineers to profile existing data models and develop recommendations for improvement that foster scalability and sustainability.
• Proactively identify opportunity to improve an existing content development process, communicating these opportunities to internal teams as well as customers where relevant.
• Work closely with analytics and business intelligence managers to identify, recommend, develop/modify and support data and business intelligence strategies resulting from system changes, upgrades, implementations, etc.
• Discover opportunities for an organization to improve its systems and processes through the use of data analytics.
• Review tasks critically and ensure they are appropriately prioritized and sized for incremental delivery.
• Contribute and maintain content in the business intelligence solution catalog and associated metadata records.
• Must be able to perform the professional, clinical and or technical competencies of the assigned unit or department.
• These statements are intended to describe the essential functions of the job and are not intended to be an exhaustive list of all responsibilities. Skills and duties may vary dependent upon your department or unit. Other duties may be assigned as required.

Required Education and Experience

• Bachelors Degree or 4 years related experience/education
• 2 or more years of experience developing applications with one or more business intelligence tools such as Power BI, Qlik, SAP Business Objects, Tableau, etc.

Preferred Education and Experience

• 3 or more years 3 years’ SQL experience in a relational database or an equivalent combination of education and experience

Required Licensure and Certification

• Epic certification in 1 data model. within 1 Year

Preferred Licensure and Certification

• Project Management Professional (PMP) - Project Management Institute (PMI)

Knowledge Requirements

• Experience with database management technologies preferred
• Experience in database building, maintenance, and reporting preferred
• Experience in hospital or healthcare environment preferred
• Experience with one or more of the following data domains: Activity Based Costing, Hospital Industry Data Institute, Press Ganey, Vizient, Workday, etc. preferred

We are an equal employment opportunity employer without regard to a person’s race, color, religion, sex (including pregnancy, gender identity and sexual orientation), national origin, ancestry, age (40 or older), disability, veteran status or genetic information.