Senior Business Intelligence Developer-Information Technology

The Senior Business Intelligence Developer (BID) functions collaboratively as a leader with the primary responsibility of ensuring the effective design, implementation and support of reports, dashboards and related data extracts from the enterprise EHR system and other sources including, but not limited to, clinical inpatient, clinical ambulatory, revenue cycle/financial and patient access data. This position works directly with key administrative medical and operational stakeholders to answer questions, set expectations, plan, and implement products and services to meet organizational reporting and data analysis needs. This individual will have expertise in the use of institutional and third-party Business Intelligence (BI) tools and related system data models. This role requires an advanced knowledge and understanding of data patterns and operational workflows. The proper individuals possess experience in all stages of Business Intelligence project work such as requirements gathering, logical and physical design, documentation, testing and deployment.

Specific Duties and Responsibilities

Essential Functions:

Leads the design, development, implementation and support of advanced reports, dashboards, data extracts using any BI application, such as Epic Cogito Tools, Tableau, and Microsoft development tools (SSIS, SSMS).
Proficiently works with MS SQL Server, including the development of T-SQL scripts and stored procedures.
Fluency with RDBMS concepts such hierarchical, relational and multidimensional database modeling concepts. In-depth understanding of database management systems, online analytical processing (OLAP), and ETL (Extract, transform, load) framework.
Implement data ingestion routines both real time and automated/batched using best practices in data modeling, ETL processes using SSIS or similar tools.
Responsible for monitoring and ensuring the completion of scheduled ETL processes; troubleshoots and resolves issues as needed to ensure timely and accurate delivery of data updates and/or reports.
Manages the development, modification, analysis of various data models in depth; proactively define data structures additions (views, distribution methods, intermediate tables, multidimensional cubes) that would improve performance or add value.
Serves as an expert resource in the development, distribution, and support for reports and or dashboards in a timely manner, prioritizing multiple requests and maintaining a support relationship with all users.
Mentor, provide guidance and training to other BIDS’s, as well as assist and lead projects related to data reporting and other BI/Analytics initiatives.
Manages and monitors scheduled execution of routine processes and reports, diagnosing and fixing any reportrelated issues while maintaining excellent open communication internally and externally.
Excellent attention to detail, patience, and a positive, customer centric attitude. Develops and maintains positive relationships with all customers, key stakeholders and departmental colleagues.
Clear demonstrations of critical thinking, technical, analytical, organizational, and problem-solving skills.
Ability to identify the appropriate technological solutions for various reporting needs.
Demonstrated ability to develop proficiency with unfamiliar toolsets.
Works within established guidelines, standards and methodologies for creating BI solutions and documentation.
Leads in the creation and maintenance of data dictionaries to improve organizational data integrity and facilitate user access to data.
Serves as lead technical resource to other BID’s and user community in the areas of analytics design, development, and administration.
Performance tuning and analysis including identifying and troubleshooting poorly performing queries and providing performance improvement recommendations.
Serves as an administrator of the various BI tools used by the organization (i.e. Tableau Server) involving the design, configuration and development of the data infrastructure, data source creation, security (user access), change control and overall support.
Conducts validation testing of all data exchanged, migrated, archived, imported, to and from the enterprise EHR system and related applications.
Maintains knowledge of industry standards, as well as, federal, state and local healthcare regulatory requirements, including but not limited to, HIPAA and IRB policies and procedures, to ensure all deliverables meet those standards.
Provides support for any District audits.
Works closely with manager to identify opportunities for change, present ideas and recommendations for capitalizing on these opportunities.
Utilizes change management processes and techniques in an appropriate manner.
Adheres to all District Policies and Procedures.
Provides adequate back up for personnel technical requirements, including on-call first level support across the IT customer base, as needed.
Provides support for the Help Desk functions, and IT On-Call duties, as needed.
Travels to remote locations on-request appropriately to provide IT support.
Position Qualifications

Education:

Bachelor’s Degree in Business Administration, Information Systems, Computer Science, or similar discipline required. Master’s degree in Business Administration, Information Systems, Computer Science, or similar discipline preferred. Minimum of three to five years’ experience in healthcare information systems may be considered in lieu of degree.

Experience:

Minimum of five (5) years of proven business analysis experience with work in a data analytics/data warehouse role and with business process re-engineering and architecture required. Proficient MS SQL experience (T-SQL scripts, stored procedures, ETL, etc.) and Microsoft BI Suite (SSRS, SSIS, SSAS) required. Experience leading the development of reports/dashboards with any BI application, such as Epic Cogito, Tableau, etc. required. Ability to take large data sets and summarize down to actionable levels, turning analysis into answers. Experience with healthcare industry data required. Experience with healthcare EHR systems, ideally Epic is highly recommended.

Certification:

Epic certification desirable. Ability to become Epic certified within 6 months of training required.