Data Architect

Harris County • Houston, TX

6d • Onsite

About The Position

If 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. About Harris County 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. Our Values: HCPH embraces a foundation of progressive work anchored by the department's cornerstone values guiding our work to improve community's health and well-being. Transparency - We share information openly and honestly so that staff, partners, and the community understand our actions and the reasons behind them. Integrity - Our actions reflect strong ethical principles, ensuring we remain trustworthy, accountable, and consistent with our mission. Respect - We foster a supportive environment by valuing diverse perspectives, listening intentionally, and treating people with dignity in every interaction. Impact - We focus our efforts on activities that improve health, reduce disparities, and create meaningful, measurable outcomes for the communities we serve. Collaboration - We actively partner across teams, disciplines, organizations, and communities to align our efforts toward common goals. 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.

Requirements

• Bachelor's degree in computer science, information systems or a related field.
• 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.
• 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.

Nice To Haves

• Experience in Azure and Snowflake platforms.
• Experience working with HL7 Data.
• Experience in business reporting.
• Experience with PowerBI.

Responsibilities

• Design data warehouses, data lakes, and data pipelines for cloud and on-prem environments
• Creates 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level