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
-
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 … R5d ago
-
Analytic Server Modeler USD 150K-170KAzure | Big Data | C# | C++ | DDL401k | Medical/Dental/Vision insurance | Paid time offEntry-level Full TimeRemote, United States R8d ago
-
Associate Quantitative Modeler & Developer - Remote USD 117K-195KAWS | Azure | C# | C++ | Cloud platform401k matching | Company community matching | Flex days | Flexible work schedule | Hybrid telecommutingMid-level Full TimeUnited States R27d ago
-
Data Management | Data Visualization | Econometrics | Git | Logistic RegressionSenior-level Full TimeBuffalo, NY, United States R28d ago
-
Advanced Analytics Modeler (Hybrid Work Model) USD 78K-140KGeneralized Linear Models | Gradient boosting | Linear Models | Neural Networks | Python401k match | Employee assistance program | Health and wellness benefits | Home-office equipment provided | Hybrid work scheduleMid-level Full TimeStevens Pt-Strongs, United States R1mo ago
-
Senior Data Architect USD 172K-203KAWS S3 | Amazon Kinesis | Apache Airflow | Apache Kafka | Apache SparkDental insurance | Employee discounts | Health insurance | Mental health resources | Paid HolidaysSenior-level Full TimeHybrid - San Francisco, California R1mo ago