HealthPoint · 15 hours ago
Data Warehouse Lead
HealthPoint is a Federally Qualified Health Center providing primary care, dental, and behavioral health services across nine rural Texas counties. They are seeking a Data Warehouse Lead to design the data architecture and oversee the development of their first enterprise data warehouse, ensuring long-term reliability and quality of data integrations.
Health CareHealth DiagnosticsMedicalNon Profit
Responsibilities
Design the enterprise data warehouse architecture using SQL Server
Build dimensional models (star/snowflake schemas) for clinical, financial, and operational data
Create data marts optimized for Power BI reporting
Establish data standards, documentation, and governance practices
Define requirements and specifications for integrations from eClinicalWorks, Azara DRVS, Sage Intacct, Pioneer RX, Ring Central and others
Provide technical direction to contract data engineers building integrations
Review contractor deliverables for quality and alignment with your architecture
Maintain and optimize ETL pipelines after contractor handoff
Manage database performance, security, and HIPAA compliance
Implement monitoring and data quality processes
Partner with our Power BI Developer to deliver analytics-ready datasets
Qualification
Required
4+ years in data warehousing, ETL development, or data engineering
Strong SQL Server skills (T-SQL, stored procedures, performance tuning)
Experience with dimensional modeling (star/snowflake schemas)
Experience with ETL tools (Azure Data Factory, SSIS, dbt, or equivalent)
Solid communication skills—you'll direct contractors and work with non-technical stakeholders
Preferred
Healthcare industry experience (EHR systems, claims data, quality measures)
Experience working with or coordinating contractors/vendors
Familiarity with HIPAA compliance for data handling
Experience with cloud data warehouse platforms
Benefits
Health, dental, vision
Retirement with employer match
Generous PTO
Professional development
Company
HealthPoint
HealthPoint is a nonprofit organization that renders an array of healthcare, dental & pharmacy services as well as offers health education.
H1B Sponsorship
HealthPoint has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase