Location: METROHEALTH SOUTH CAMPUS

Biweekly Hours: 80.00

Shift: M-F, 8-5PM

The MetroHealth System is redefining health care by going beyond medical treatment to improve the foundations of community health and well-being: affordable housing, a cleaner environment, economic opportunity and access to fresh food, convenient transportation, legal help and other services. The system strives to become as good at preventing disease as it is at treating it. Founded in 1837, Cuyahoga County’s safety-net health system operates four hospitals, four emergency departments and more than 20 health centers.

Summary: 

Summary:
Under the direction of the Department Manager, the Business Intelligence (BI) Developer I contributes to efforts within the Department of Operations Research & Analytics (DORA) to advance the organization’s use of data and information. Works in tandem with DORA’S BI Analysts, and BI Advisors to accurately and efficiently create sustainable business value by transforming raw data into actionable information for the end user. In conjunction with partners in Information Services, aids in the deployment and maintenance of one or more of the following areas: effective data structures (i.e. star schema facts and dimensions, cubes, views), ETL processes, BI infrastructure (i.e. SQL Server, Hadoop, Spark), data visualization (i.e. Tableau), and/or analytic tools. May have duties that include data manipulation, transformation, and automation using appropriate programming languages such as SQL, C#, Python, and R. Upholds the mission, vision, values, and customer service standards of the MetroHealth System.

Responsibilities:

Responsibilities:
1. Aids the DORA team in rapid-cycle iterations to test and deploy analytic content that is driven by the strategic and tactical needs of internal business users.

2. Assists in the design and execution of strategic initiatives that help the MetroHealth System move toward maturity on the analytics continuum.

3. Aids in the creation and deployment of extraction, transformation and load (ETL) procedures that reliably integrate diverse and isolated data systems into a central, enterprise data warehouse.

4. Supports the implementation of enterprise BI tools and actively participates in the growth of an analytic ecosystem within the MetroHealth System.

5. Monitors the performance of automated administrative tasks required for the optimal function of critical data structures, including quality assurance, data base tuning, etc., and takes the appropriate action(s) to correct any deviations from service level expectations.

6. Maintains an up-to-date personal knowledge-base and a relevant analytic skill set aligned with DORA’s key priorities, including identifying areas for personal development and creating concrete learning plans to address any gaps.

Qualifications:

Other information:
Required:
Bachelor’s degree in Computer Science, Finance, Operations Research or related field or 1+ years of progressive development/analytical experience in lieu of degree.
Experience or training in programming with SQL.
Experience or training in one of the following languages: C#, Python, or R.
Experience or training with the Microsoft BI stack (i.e. Visual Studio/SSDT/SSIS) including recent versions of SQL Server.
Knowledge of applying ETL best practices.
Knowledge of SQL Server performance tuning techniques.
Knowledge of Git and/or Azure DevOps.
Knowledge of designing data warehouse structures.

Preferred:
Experience with Tableau.
1+ years of experience with an Electronic Medical Record (EMR) system, i.e. Epic, Cerner.
1+ years of experience with one of the following: Kronos, Infor/Lawson, EPSi
Knowledge of the Agile development/management methodology.
Knowledge of machine learning, data mining, and predictive analytics.
Knowledge of project management.
Knowledge of Big Data technologies (i.e. Hadoop, Spark, Hive, Pig, Sqoop, Flume, Oozie).
Knowledge of Cloud (i.e. Azure, AWS).
Knowledge of Web Services (i.e. SOAP, Rest, WSDL).
Knowledge of Continuous Integration/Continuous Delivery.
Experience with Tableau.
Knowledge of statistics, simulation and data modeling.

Physical Requirements:
May sit, stand, stoop, bend, and ambulate intermittently during the day.
May need to sit or stand for extended periods.
See in the normal visual range with or without correction.
Hear in the normal audio range with or without correction.
Ability to communicate in face-to-face, phone, email, and other communications.
Ability to read job related documents.
Ability to use computer.