Data Architect

Data ArchitectIf you're looking to be a part of a collaborative environment where your skills can make an impact, explore our current opportunities in creating a better future for public health.Harris County Public Health (HCPH) includes a network of more than 1,100 public health professionals working together to improve health outcomes for the third most populous county in the United States. HCPH provides a multitude of services such as medical and dental services, community programming, and health education for the approximately 2.3 million people in unincorporated Harris County. Through its core values of innovation, engagement, and health equity, HCPH strives to bring meaningful solutions to public health issues while keeping Harris County healthy and vibrant.This is a grant-funded position.Position Overview: The Data Architect is responsible for designing and building Harris County Public Health data systems. They will provide expert guidance in identifying internal and external data sources, and collaborating with department heads to determine their data storage and organizational needs.Duties and Responsibilities:Design data warehouses, data lakes, and data pipelines for cloud and on-prem environmentsCreates data transformation processes (ETL, SQL stored procedures, etc.) to support complex business systems and operational data flows.Provide input in optimizing application configuration to achieve departmental analytical goals.Communicate project status, risks, milestones, and assigned roles and responsibilities to cross-departmental stakeholders and executive leadership.Provide data governance oversight by creating policies for data quality, security, and privacy compliance.Other duties as assigned include special tasks involved in responding to an emergency event.Harris County is an Equal Opportunity Employer. If you need special services or accommodations, please call View phone number on click.appcast.io or email View email address on click.appcast.io. This position is subject to a criminal history check. Only relevant convictions will be considered and, even when considered, may not automatically disqualify the candidate.RequirementsEducation: Bachelor's degree in computer science, information systems or a related field.Experience: 8 (eight) years of experience in database administration. 5 (five) years of experience with Stored Procedures, advanced query functions like Common Table Expressions, Pivots, etc. and other advanced RDBMS tasks. 5 (five) years of experience with SSIS. 3 (three) years of experience practicing agile principles. 3 (three) years of working with HIPAA protected data.Knowledge, Skills and Abilities:Strong SQL skills and database architecture.In-depth understanding of IT security and how to handle health protected data.Demonstrate strong problem-solving skills to analyze issues, identify root causes, and develop effective solutions to overcome challenges that may arise during the project.Be skilled in managing time efficiently, setting priorities, and meeting project deadlines.Foster a collaborative and inclusive work environment, encouraging teamwork and knowledge sharing among project team members.Core Competencies:Data Analytics and Assessment Skills: Ability to use data to analyze community health needs and support decisions that improve community health outcomes.Communication Skills: This competency focuses on using clear and effective communication to engage audiences, address misinformation, and build trust, supporting informed decisions and stronger public health outcomes.Health Advancement Skills: This competency focuses on applying principles of equity, diversity, and inclusion to public health, addressing systemic barriers, and promoting fair access to resources for healthier communities.Community Partnership Skills: This competency focuses on collaborating with communities to address the systems and policies affecting health, fostering engagement, shared ownership, and sustainable improvements in well-being.Public Health Science Skills: This competency focuses on using public health science and evidence-based approaches to develop and improve policies and programs, ensuring effective delivery of the 10 Essential Public Health Services.NOTE: Qualifying education, experience, knowledge and skills must be documented on your job application. You may attach a resume to the application as supporting documentation but ONLY information stated on the application will be used for consideration. "See Resume" will not be accepted for qualifications.PreferencesExperience in Azure and Snowflake platforms. Experience working with HL7 Data. Experience in business reporting. Experience with PowerBI.General InformationPosition Type, and Typical Hours of Work:Full-Time | Grant-Funded PositionMonday – Friday | 8 am – 5 pmHours may vary based on the business needs of the department or task requirements.May require periodic overnight travel and long hours/overtime during emergencies/disasters.Work Environment:This job operates in a professional office environment.This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.May require travel.Physical Demands:This is primarily a sedentary position.Work Location:Harris County Public Health (1111 Fannin, Houston, 77002)BenefitsNot Applicable