Republic Services
Sr Data Modeler
Join to apply for the
Sr Data Modeler
role at
Republic Services .
Position Summary The Data Modeler III is a hands‑on technical role focused on full stack software development within the Enterprise Data organization. The role will play a crucial part in shaping future big data and analytics initiatives.
Principal 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.
Design and develop code and data pipelines to ingest from relational databases (Oracle, SQL Server, DB2, Aurora), file shares, and web services.
Implement 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.
Design JavaScript modules and REST APIs utilizing MarkLogic to support complex searches.
Participate in requirements definition, system architecture design, and data architecture design.
Participate in all aspects of the software life cycle using Agile development methodologies.
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.
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.
Minimum Qualitifications
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.
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).
EEO Statement Republic Services is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, protected veteran status, relationship or association with a protected veteran (spouses or other family members), genetic information, or any other characteristic protected by applicable law.
About The Company Republic Services, Inc. (NYSE: RSG) is a leader in the environmental services industry. We provide customers with the most complete set of products and services, including recycling, waste, special waste, hazardous waste and field services. Our industry‑leading commitments to advance circularity and support decarbonization help deliver on our vision to partner with customers to create a more sustainable world.
In 2023, Republic’s total company revenue was $14.9 billion, and adjusted EBITDA was $4.4 billion. We serve 13 million customers and operate more than 1,000 locations, including collection and transfer stations, recycling and polymer centers, treatment facilities, and landfills.
Job Meta
Seniority level: Not Applicable
Employment type: Full‑time
Job function: Information Technology
#J-18808-Ljbffr
Sr Data Modeler
role at
Republic Services .
Position Summary The Data Modeler III is a hands‑on technical role focused on full stack software development within the Enterprise Data organization. The role will play a crucial part in shaping future big data and analytics initiatives.
Principal 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.
Design and develop code and data pipelines to ingest from relational databases (Oracle, SQL Server, DB2, Aurora), file shares, and web services.
Implement 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.
Design JavaScript modules and REST APIs utilizing MarkLogic to support complex searches.
Participate in requirements definition, system architecture design, and data architecture design.
Participate in all aspects of the software life cycle using Agile development methodologies.
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.
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.
Minimum Qualitifications
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.
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).
EEO Statement Republic Services is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, protected veteran status, relationship or association with a protected veteran (spouses or other family members), genetic information, or any other characteristic protected by applicable law.
About The Company Republic Services, Inc. (NYSE: RSG) is a leader in the environmental services industry. We provide customers with the most complete set of products and services, including recycling, waste, special waste, hazardous waste and field services. Our industry‑leading commitments to advance circularity and support decarbonization help deliver on our vision to partner with customers to create a more sustainable world.
In 2023, Republic’s total company revenue was $14.9 billion, and adjusted EBITDA was $4.4 billion. We serve 13 million customers and operate more than 1,000 locations, including collection and transfer stations, recycling and polymer centers, treatment facilities, and landfills.
Job Meta
Seniority level: Not Applicable
Employment type: Full‑time
Job function: Information Technology
#J-18808-Ljbffr