OH - Business Intelligence Developer III, SQL, C#, Python, Clarity FULLY REMOTE - $105/hour (Rate offers accepted)

Job DescriptionJob Description:Job SummaryOperating with considerable autonomy, the Business Intelligence (BI) Developer III leads efforts within the Department of Operations Research & Analytics (DORA) to advance the organizations use of data and information. Works in tandem with DORAS 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, leads the creation, deployment, and maintenance of effective data structures (i.e. star schema facts and dimensions, cubes, views), ETL processes, BI infrastructure (SQL Server, Hadoop, Spark), data visualization (i.e. Tableau), and/or analytical tools. Serves as the core resource 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.ResponsibilitiesContributes to patient safety by supporting the System-wide programs and policies addressing a safe environment for patients and the reporting of safety concerns to the appropriate individuals.1. Leads rapid-cycle iterations to create, test, improve, and deploy analytic content that is driven by the strategic and tactical needs of internal business users.2. Evaluates the current state of DORA and MetroHealths analytic capabilities, including aligning current resource deployment with strategic priorities, identifying critical success factors, and creating plans to address gaps.3. Designs and executes strategic initiatives that help the MetroHealth System move toward maturity on the analytics continuum.4. Creates extraction, transformation and load (ETL) procedures that reliably integrate diverse and isolated data systems into a central, enterprise data warehouse.5. Guides the strategic acquisition and implementation of appropriate BI tools to create a thriving analytic ecosystem across the MetroHealth System that supports timely and accurate reporting, self-service analytics and data visualization.6. Develops procedures to efficiently automate administrative tasks required for the optimal function of critical data structures, including quality assurance, data base tuning, etc.7. Performs other functionally related duties as assigned.QualificationsRequired:Bachelors degree in Computer Science, Finance, Operations Research or related field 5 years of progressive development/analytical experience.In lieu of degree, 8 years of progressive development/analytical experience.Expert knowledge of programming with SQL.Proficient in one of the following languages: C#, Python, or R.Expertise with the Microsoft BI stack (i.e. Visual Studio/SSDT/SSIS) including recent versions of SQL Server.Expertise in applying ETL best practices.Expertise with SQL Server performance tuning techniques.Proficient with Git and/or Azure DevOps.Expert in designing data warehouse structures.Preferred:3 years of experience with an Electronic Medical Record (EMR) system, i.e. Epic, Cerner.3 years of experience with one of the following: Kronos, Infor/Lawson, EPSiKnowledge of the Agile development/management methodology.Knowledge of machine learning, data mining, and predictive analytics.Experience with project management.Experience with Big Data technologies (i.e. Hadoop, Spark, Hive, Pig, Sqoop, Flume, Oozie).Experience with Cloud (i.e. Azure, AWS).Experience with Web Services (i.e. SOAP, Rest, WSDL).Experience with 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.Position Urgency:NormalShifts:8:00a-4:30pState License Details:Not NeededMinimum Years of Experience:12Minimum Guaranteed Hours:38Specialty Type:Information TechnologySub Specialty:ETL Developer, Developer/Other, Business IntelligenceBilingual:NoEMR Used:No ListingHoliday Coverage Required:No