OhioGuidestone is looking to solve the problem of providing scalable and secure data warehouse solutions for clinical and administrative data to support healthcare analytics and improve patient outcomes.
Requirements
- Strong SQL and experience with platforms like Microsoft Fabric (preferred), Snowflake, Redshift, or BigQuery
- Proficient in front-end development (React, Angular) and/or BI tools (Power BI, Tableau, etc.).
- Familiar with healthcare data standards (e.g., HL7, FHIR, ICD, CPT) and regulatory compliance (HIPAA).
- Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
- Experience with data warehouse design and management, preferably in healthcare, with demonstrated knowledge and expertise in enterprise architecture implementations.
- Bachelor's or Master’s in Computer Science, Information Systems, or related field.
- 5+ years of experience in data warehouse design and management
Responsibilities
- Design and maintain scalable data warehouse solutions (e.g., star/snowflake schemas) for clinical and administrative data.
- Develop and manage secure, efficient ETL/ELT pipelines using appropriate tools (i.e. Airflow, dbt, or Informatica).
- Optimize data models for performance, quality, and regulatory compliance (e.g., HIPAA).
- Build front-end dashboards and reporting tools using Power BI (preferred), React or Tableau to support healthcare analytics.
- Collaborate with analysts, clinicians, and IT to translate business needs into data solutions.
- Ensure data integrity, security, and high availability in a healthcare-compliant environment.
- Monitor and analyze business intelligence data and make recommendations for data warehouse growth and integration.
Other
- Demonstrate the values and guiding principles of OhioGuidestone, performing with the highest standards of excellence, integrity and ethics.
- Present the Agency in the most positive light with all internal and external contacts.
- Demonstrate positive leadership, promote a team-based work environment and a culture of belonging.
- Exhibit positivity, flexibility and a willingness to take on new responsibilities as requested or required.
- Possess a valid Ohio Driver’s License with a safe driving record and valid insurance.
