Republic Services · 4 weeks ago
Sr Data Modeler
United States
Full-time
Remote
Senior Level
$110K/yr - $164K/yr
5+ years expRepublic Services, Inc. is a leader in the environmental services industry, seeking a Sr Data Modeler to contribute to their Enterprise Data organization. The role focuses on full stack software development, shaping future big data and analytics initiatives through designing data models and optimizing data processing.
Information TechnologyRecyclingRenewable EnergySustainabilityWaste Management
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
Designs and develops code and data pipelines to ingest from relational databases (Oracle, SQL Server, DB2, Aurora), file shares, and web services
Streaming ingestion with Kinesis Streams, Kinesis Firehose, Kinesis Analytics and Kafka (MSK)
Build Data Lake on AWS S3 with optimal performance considerations by partitioning and compressing data
Data Engineering and Analytics using AWS Glue, Informatica, EMR, Spark, Athena, Python
Data modeling and building Data Warehouse using Snowflake
Designs and develops code and data pipelines to ingest relational databases, file shares, and web services
Designs JavaScript modules and REST APIs utilizing MarkLogic to support complex searches
Develops MarkLogic integrations with existing enterprise platforms
Participates in requirements definition, system architecture design, and data architecture design
Participates in all aspects of the software life cycle using Agile development methodologies
Qualification
Required
5+ years' experience with data modeling tools like ERWIN, Lucid, sqlDBM
7+ years of experience in Enterprise Information Solution Architecture, Design, and Development required
7+ years of experience with integration architecture such as SOA, Microservices, ETL or other integration technologies
7+ years of experience with working content or knowledge management systems, search engines, relational databases, NoSQL databases, ETL tools, geospatial systems, or semantic technology
5+ years of hands-on experience with a MarkLogic framework, DynamoDB preferred
5+ years of hands-on experience with AWS services (S3, Kinesis, Lambda, Athena, Glue, EMR) required
5+ years of analytics tools like SAS, R, Python, and other advanced statistical software
5+ years of Web development experience with Angular, JavaScript, and Node.js
Experience with JSON or XML data modeling required
Experience with Git/GitHub, branching, and other modern source code management methodologies required
Domain knowledge of NoSQL or relational database required
Understanding of database architecture and performance implications required
Experience integrating Business Intelligence applications like Qlik Sense, Tableau, or Power BI
Experience with Machine Learning and Artificial Intelligence
Ability to multi-task effectively
Ability to work collaboratively as part of an Agile Team
Extensive knowledge and experience with Python, JavaScript and Java
Excellent written and verbal communication skills, sense of ownership, urgency and drive
Bachelor's degree in Computer Science, Computer Information Systems, Engineering, Statistics or closely related field (willing to accept foreign education equivalent) (required)
Experience in AWS services for data and analytics (required)
5 years of experience in Data Ingestion, Data Extraction, and Data Integration (required)
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)
Company
Republic Services
Republic Services provides comprehensive environmental services to support business, home and community.
10001+ employees
H1B Sponsorship
Republic Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (14)
2024 (22)
2023 (14)
2022 (17)
2021 (26)
2020 (18)
Funding
Current Stage
Public CompanyTotal Funding
unknown1998-07-01IPO
Leadership Team
Jon Vander Ark
President and CEO
Brian DelGhiaccio
EVP, Chief Financial Officer
Recent News
2026-01-06
Company data provided by crunchbase