Sr. Data Modeler
Core
Designing and implementing enterprise data models, warehouses, and pipelines to support big data and analytics initiatives for the waste management and environmental services industry.
Role type
Senior Data Engineer / Data Modeler
Builds
Enterprise data warehouses, data lakes, ELT/ETL pipelines, and semantic data models
Domain
Waste management / Environmental services / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Data modeling (Star/Snowflake, dimensional), SQL optimization, AWS services (S3, Kinesis, Glue, EMR, Athena), Python, JSON/XML modeling, Git, NoSQL/Relational databases, AI-assisted development practices
Preferred skills
Machine Learning and Artificial Intelligence experience, experience with SOA/Microservices integration architectures, experience with content/knowledge management systems, experience with SAS/R statistical software
Technologies
Snowflake, AWS (S3, Kinesis, Lambda, Glue, EMR, Athena), Python, SQL, Oracle, SQL Server, DB2, Aurora, Kafka (MSK), Informatica, Spark, sqlDBM, ERWIN, Lucid
Responsibilities
Design and implement Medallion Architecture and dimensional models; Develop canonical and semantic data models with SCD handling; Write and optimize advanced SQL queries; Align data models with ELT/ETL pipelines; Design and develop code and data pipelines for ingestion from various sources; Participate in requirements definition and system architecture design
Seniority
Senior, hands-on IC
