: Dedicated & Serverless SQL pools, MPP architecture, Star-Schema Data Modeling (SCD Type 1/2) Data Integration & Pipelines: ETL..., HIPAA/PHI/PII security, Role-Based Access Control (RBAC) Qualifications Master's degree in Data Science, Computer Science...
controls, and automated deployment. Security/governance - Experience implementing least-privilege access and working... with catalog, lineage, classification, and row-level security requirements. SQL - Advanced SQL development and query optimization...
advanced DAX calculations measures and KPIs Implement dimensional models using star and snowflake schemas Optimize datasets... Governance Security Quality Implement RowLevel Security RLS data governance and lineage tracking Ensure compliance...
-Star experienceThe ability to accurately and efficiently count money and make changeProficiency in basic mathematical... with supervisors, teammates, and Guests, both verbally and in writingThe ability to comply with all safety and security policies...
understanding of: Data Warehousing concepts Dimensional Modeling (Star/Snowflake Schema) Data Lakes and Lakehouse Architectures... such as Docker and Kubernetes. Knowledge of data security, compliance, and cloud governance best practices. Key Responsibilities...
governance and security controls (e.g., Unity Catalog permissions, role-based access, row- and column-level security, data... in ADLS Gen2 using OPENROWSET, external tables, and views Required 4 Years Building star-schema facts, dimensions, stored...
(star, snowflake, data vault). Provide guidance on: SCD (Type 1/2) strategies Partitioning, clustering... adoption of engineering excellence practices including reusable frameworks and templates. SECURITY & GOVERNANCE Lead...
, dimensional modeling, and canonical models for key domains. Governance, Quality, and Security Define and enforce data governance...), ensuring trusted datasets and consistent KPIs. Ensure compliance with security and regulatory requirements (PII/PHI/PCI/SOX...
, Synapse, and Azure Data Factory pipelines including scheduling and failure recovery. Apply data governance and security.... Building star-schema facts, dimensions, stored procedures, and views including Slowly Changing Dimensions (Type 1 and 2...
Applies data governance and security controls (e.g., Unity Catalog permissions, role-based access, row- and column-level... security, data masking) to protect sensitive health data (PHI/PII) in accordance with HIPAA and agency policy Assists...