Sr Data Modeler

Core responsibilities:

• Design and implement Medallion Architecture, dimensional models (Star/Snowflake schemas), and metadata-driven modeling approaches for enterprise data warehouses
• Develop canonical and semantic data models with effective SCD handling techniques that align with business requirements and analytical needs
• Write and optimize advanced SQL queries in Snowflake (or similar platforms) to ensure efficient data processing and warehouse performance
• Align data models with ELT/ETL pipelines and analytics frameworks to create scalable data structures that grow with business demands

This role supports Republic Services' vision to partner with customers to create a more sustainable world by advancing circularity and supporting decarbonization through data-driven initiatives that optimize recycling, waste management, and environmental solutions.

Required skills and qualifications:

• 5+ years' experience with data modeling tools like ERWIN, Lucid, sqlDBM
• 7+ years of experience in Enterprise Information Solution Architecture, Design, and Development
• 7+ years of experience with integration architecture such as SOA, Microservices, ETL or other integration technologies
• 5+ years of hands-on experience with AWS services (S3, Kinesis, Lambda, Athena, Glue, EMR) required
• Bachelor's degree in Computer Science, Computer Information Systems, Engineering, Statistics or closely related field

Rewarding Compensation and Benefits:

• Comprehensive medical benefits coverage, dental plans and vision coverage
• Health care and dependent care spending accounts
• Short- and long-term disability
• Life insurance and accidental death & dismemberment insurance
• Employee and Family Assistance Program (EAP)
• Employee discount programs
• Retirement plan with a generous company match
• Employee Stock Purchase Plan (ESPP)
• Paid Time Off (PTO)

Republic Services, Inc. is a leader in the environmental services industry providing customers with recycling, waste, special waste, hazardous waste and field services. The company is committed to advancing circularity and supporting decarbonization to create a more sustainable world.