Business Intelligence Developer II - Enterprise Analytics

Location: MetroHealth Old Brooklyn 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.


With general guidance from the Department Manager, the Business Intelligence (BI) Developer II 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 personnel and development teams 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, collaborates on the creation, deployment, and maintenance of effective data structures, ETL processes, BI infrastructure, data visualization, and analytic tools. Performs duties for data manipulation, transformation, and automation via programming using appropriate languages such as SQL, C#, Python, and R. Upholds the mission, vision, values, and customer service standards of the MetroHealth System.


Required: Bachelor's degree in Computer Science, Finance, Operations Research or related field and a minimum of 4 years of progressive development/analytical experience. In lieu of degree, up to 7 years of progressive development/analytical experience. Advanced knowledge of programming with SQL. Experience in one of the following languages: C#, Python, or R. Proficient with the Microsoft BI stack (i.e. Visual Studio, SSDT, SSIS) including recent versions of SQL Server. Experience in designing data warehouse structures, to include the "Kimball" methodology. Experience applying ETL best practices. Experience in SQL Server performance tuning techniques. Experience with Git and/or Azure DevOps. Working knowledge of data visualization approaches (i.e Tableau, Power BI, Qlik). Ability to interact effectively with a wide range of cultural, ethnic, racial, and socioeconomic backgrounds. Preferred: 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. Experience with project management. Knowledge of Big Data technologies (i.e. Hadoop, Spark, Hive, Pig, Sqoop, Flume, Oozie). Knowledge of Cloud (i.e. Azure, AWS). Experience with Web Services (i.e. SOAP, Rest, WSDL). Knowledge of Continuous Integration/Continuous Delivery. 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.