Data Warehouse Architect & Front End Developer en OhioGuidestone
OhioGuidestone · Berea, Estados Unidos De América · Onsite
- Senior
- Oficina en Berea
Your Story. Our Mission. A Perfect Match.
OhioGuidestone is the state’s leader in community behavioral health care, serving around 26,000 Ohioans each year. We focus on the needs of the whole person by providing telehealth and in-person prevention services, as well as mental health and substance use treatment. As we help people navigate the most difficult times in their lives—with compassion and respect—we ultimately empower them to take steps towards a healthier future.
Location: Berea, OH
Will we sponsor for this role? - No.
Will we consider anyone not located in the Greater Cleveland area: No.
Essential Functions:
Demonstrate the values and guiding principles of OhioGuidestone, performing with the highest standards of excellence, integrity and ethics.
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.
Improve user experience and interaction on internal platforms.
Monitor and analyze business intelligence data and make recommendations for data warehouse growth and integration.
Stay updated with industry trends and best practices in reporting tools and data warehousing.
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.
Education & Experience:
Bachelor's or Master’s in Computer Science, Information Systems, or related field.
5+ years of experience in data warehouse design and management, preferably in healthcare, with demonstrated knowledge and expertise in enterprise architecture implementations.
Qualifications:
Mission driven; strong desire to make an impact
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.
Excellent communication and collaboration skills, with the ability to work effectively with stakeholders at all levels.
Flexible; able to work days, evenings, and/or weekends, as required to meet the needs of the organization.
Benefits include:
Competitive medical benefits including a zero-premium monthly option for employee or employee + children!
Free CEU trainings
10 paid holidays 2 can be used as floating holidays
Flexible work schedules to support work/life balance
Flexible work opportunities to support varying career paths, job roles, intern to hire, and locations
401(k) with employer match option
Employment Assistance Program (EAP)
Mileage reimbursement
Free licensure supervision
Recognition and rewards
Possess a valid Ohio Driver’s License with a safe driving record and valid insurance.
Successfully complete pre-employment screenings, including drug tests, background checks, and any other required assessments, such as a physical examination and TB test.
