Senior Data Modeler - Enterprise Data Warehouse - Remote
USD 91K-163K Senior-level Full Time
Tasks
- Collaborate with ETL architects and BI developers on scalable analytics solutions
- Create ERDs and data flow diagrams using modeling tools
- Define keys indexes constraints and referential integrity rules
- Design conceptual logical and physical data models
- Design data movement and interface mappings
- Design medallion architecture Bronze Silver Gold with Delta Lake and Parquet patterns
- Develop dimensional and normalized modeling patterns
- Ensure HIPAA PHI PII data protection compliance
- Govern data model standards and evolution
- Maintain data dictionaries business glossaries and lineage documentation
- Migrate legacy Teradata models to cloud platforms
- Oversee data quality and metadata policies
- Translate business requirements into enterprise data models
Perks/Benefits
- 401k contribution
- Career development opportunities
- Comprehensive benefits package
- Incentive and recognition programs
- Remote work within United States
Skills/Tech-stack
ANSI SQL | Azure Data | Azure Data Factory | Azure Data Lake | Azure Data Lake Storage | Azure Purview | Azure Synapse | Azure Synapse Analytics | DCL | DDL | DML | Data Factory | Data Governance | Data Lake Storage | Data Migration | Data Modeling | Data Quality | Data Security | Data Vault | Database Design | Delta Lake | Dimensional Modeling | ERD | HIPAA | Informatica | Kimball | MDM | Medallion Architecture | Metadata Management | Normalized Data | Normalized data modeling | OLAP | OLTP | PII | Parquet | Phi | Power BI | Query Optimization | SQL | Slowly Changing Dimensions | Snowflake | Stored Procedures | Synapse Analytics | Tableau | Teradata
Education
N/A
Roles
Related jobs
-
ITPA11 - Data Warehouse Modeler USD 48K-89KDDL | Data Model | Data Modeling | Data Warehouse | Data WarehousingHybrid work option | Sign-on bonus eligibility | Veteran-friendly employerEntry-level Full TimeLansing R8d ago
-
Advanced Analytics Modeler (Hybrid Work Model) USD 64K-102KData Transformation | Generalized Linear Models | Gradient boosting | Linear Models | Neural Networks401k match with immediate vesting | Caregiver leave | Dependent care FSA | FSA option | Group medical dental vision insuranceEntry-level Full TimeStevens Pt-Strongs, United States R13d ago
-
Senior ML/AI Modeler, Risk Automation Machine Learning USD 228K-343KAWS | Apache Airflow | Artificial Intelligence | Data orchestration | GCPFamily planning | Flexible time off | Medical insurance | Remote work | Retirement savings plansSenior-level Full TimeBay Area, CA, United States of … R13d ago
-
Cloud Data Architect - Data Modeler USD 169K-229KAWS | Amazon Redshift | CI/CD | Change Data Capture | Data Capture401k | Dental insurance | Health insurance | Remote | Vision insuranceSenior-level Full TimeUSA DC Home Office (DCHOME), United … R26d ago
-
Analytic Server Modeler USD 150K-170KAzure | Big Data | C# | C++ | DDL401k | Medical/Dental/Vision insurance | Paid time offEntry-level Full TimeRemote, United States R30d ago
-
Data Management | Data Visualization | Econometrics | Git | Logistic RegressionSenior-level Full TimeBuffalo, NY, United States R1mo ago