Architectural Visualization Internship Jobs in Allen, TX

Job Summary:
UST HealthProof is a mission-driven company that transforms lives through technology. They are seeking an Associate Data Engineer to learn and contribute to the HR Analytics data engineering vertical, focusing on data ingestion, modeling, and visualization using tools like Snowflake and Power BI.
Responsibilities:
• Execute assigned components of solution designs handed off by Senior and Data Engineers, delivering production-grade code under senior engineer guidance.
• Land source data into the team's unified ingestion framework using the patterns specified in the design.
• Implement assigned data models and transformation logic in Snowflake (including Iceberg tables) and Databricks (Delta Lake, Unity Catalog) per the design.
• Apply medallion (bronze, silver, gold) architecture and the team's engineering standards to all work, including naming conventions, documentation, and code review practices.
• Build assigned components of the semantic layer in Microsoft Fabric (Fabric IQ, OneLake) per the design specifications.
• Build assigned Power BI visualizations and reports following the design specifications and the team's BI standards.
• Implement unit tests, data quality checks, and reconciliation for assigned work.
Qualifications:
Required:
• Graduation Year: 2024, 2025 or 2026
• GPA: 3.5
• Experience: 1+ years
• Bachelor's degree in Computer Science, Software Engineering, Information Management, or equivalent experience in field plus 1+ years of related work experience, OR equivalent demonstrated experience through internships, bootcamps, or self-directed project work.
• Must be located in the United States.
• 1+ years of hands-on data engineering or software engineering experience, including internships and academic project work that demonstrate production-quality engineering habits.
• Working proficiency in SQL and Python.
• Exposure to Spark (PySpark or Spark SQL) for distributed data transformation, or strong willingness and demonstrated ability to learn it quickly.
• Exposure to cloud data platforms Databricks, Snowflake, or comparable with a willingness to develop hands-on depth.
• Familiarity with at least one BI tool (Power BI preferred, Tableau or similar acceptable).
• Understanding of fundamental data engineering concepts data modeling, ETL/ELT, data quality, source-to-target mapping.
• Familiarity with Git, code review practices, and basic CI/CD concepts.
• Good communication skills able to ask clarifying questions, communicate progress clearly, and learn from feedback.
• Strong problem-solving instincts, curiosity, and the discipline to deliver well-defined work to a high standard.
• Eagerness to learn the full vertical from ingestion through visualization, and to take on broader ownership over time.
Preferred:
• Hands-on coursework, internship, or project experience with Databricks (Delta Lake) or Snowflake at any scale.
• Hands-on coursework, internship, or project experience with Microsoft Fabric, OneLake, or Power BI.
• Exposure to Iceberg tables or other modern open table formats.
• Exposure to HR data domains talent acquisition, workforce analytics, compensation, learning, performance, or people analytics.
• Familiarity with Workday, ServiceNow HR, or comparable HR systems of record.
• Exposure to streaming technologies (Kafka, Azure Event Hub, Delta Live Tables, or Spark Structured Streaming).
• Exposure to AI/ML pipelines or building data products that support ML workloads.
• Azure certifications (Azure Fundamentals, Data Engineer Associate) or working toward them.
• Familiarity with data privacy concepts (GDPR, CCPA) and HR data handling considerations.
Company:
UST HealthProof offers risk adjustment, quality programs, and healthcare payer technology services. It is a sub-organization of UST. Founded in 1999, the company is headquartered in Aliso Viejo, USA, with a team of 501-1000 employees. The company is currently Late Stage.