Sr Data Modeler at Republic Services in Phoenix, AZ | Kablio

Role

Description

data pipelines

data warehouse

data lake

sql optimization

marklogic integration

medallion architecture

Designs and develops code and data pipelines to ingest relational databases, file shares, and web services
Align data models with ELT/ETL pipelines and analytics frameworks to create scalable data structures that grow with business demands
Write and optimize advanced SQL queries in Snowflake (or similar platforms) to ensure efficient data processing and warehouse performance
Develops MarkLogic integrations with existing enterprise platforms
Data modeling and building Data Warehouse using Snowflake
Designs and develops code and data pipelines to ingest from relational databases (Oracle, SQL Server, DB2, Aurora), file shares, and web services
Design and implement Medallion Architecture, dimensional models (Star/Snowflake schemas), and metadata-driven modeling approaches for enterprise data warehouses
Designs JavaScript modules and REST APIs utilizing MarkLogic to support complex searches
Participates in all aspects of the software life cycle using Agile development methodologies
Develop canonical and semantic data models with effective SCD handling techniques that align with business requirements and analytical needs
Build Data Lake on AWS S3 with optimal performance considerations by partitioning and compressing data.
Participates in requirements definition, system architecture design, and data architecture design

Requirements

aws

python

erwin

git

angular

bachelor’s

5+ years’ experience with data modeling tools like ERWIN, Lucid, sqlDBM
Experience with Machine Learning and Artificial Intelligence
Experience with Git/GitHub, branching, and other modern source code management methodologies required
Data Engineering and Analytics using AWS Glue, Informatica, EMR, Spark, Athena, Python
Ability to work collaboratively as part of an Agile Team
5+ years of Web development experience with Angular, JavaScript, and Node.js
Experience with JSON or XML data modeling required
5 years of experience in Data Ingestion, Data Extraction, and Data Integration (required).
7+ years of experience with integration architecture such as SOA, Microservices, ETL or other integration technologies
Understanding of database architecture and performance implications required
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 AWS services (S3, Kinesis, Lambda, Athena, Glue, EMR) required
7+ years of experience in Enterprise Information Solution Architecture, Design, and Development required
5+ years of analytics tools like SAS, R, Python, and other advanced statistical software
Excellent written and verbal communication skills, sense of ownership, urgency and drive.
Domain knowledge of NoSQL or relational database required
Experience in AWS services for data and analytics (required).
Experience integrating Business Intelligence applications like Qlik Sense, Tableau, or Power BI
5+ years of hands-on experience with a MarkLogic framework, DynamoDB preferred
Bachelor’s degree in Computer Science, Computer Information Systems, Engineering, Statistics or closely related field (willing to accept foreign education equivalent) (required).
Streaming ingestion with Kinesis Streams, Kinesis Firehose, Kinesis Analytics and Kafka (MSK)
Ability to multi-task effectively
Extensive knowledge and experience with Python, JavaScript and Java

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

1981

Year Founded

Established as a regional waste hauler.

$16 Billion

2024 Revenue

Annual revenue achieved in 2024.

$2+ Billion

2024 Net Income

Net income for the year 2024.

It operates collection, transfer, recycling centers, landfills and energy‑from‑waste facilities across the U.S.
Typical projects include curbside residential pickup, commercial/industrial waste hauling, recycling operations and landfill gas‑to‑energy plants.
Specialisms span residential and commercial collection, industrial waste services, recycling processing, hazardous waste treatment, and renewable energy generation.

Culture + Values

Safe – We protect the livelihoods of our colleagues and communities.
Committed to Serve – We go above and beyond to exceed our customers’ expectations.
Environmentally Responsible – We take action to improve our environment.
Driven – We deliver results in the right way.
Human-centered – We respect the dignity and unique potential of every person.

Environment + Sustainability

35% emissions reduction

Net-zero greenhouse gas target

Aims to reduce absolute Scope 1 and 2 emissions by 35% by 2030, aligned with the Science Based Targets initiative (SBTi).

15% emissions reduction

Early achievement of interim target

Reduced operational greenhouse gas emissions by 15% as of 2023, meeting the 2025 interim target two years early.

40% material recovery increase

Resource recovery goal

Aims to increase the recovery of key materials by 40% by 2030, supporting circularity and resource efficiency.

50% biogas reuse increase

Biogas beneficial reuse target

Committed to increasing biogas sent to beneficial reuse by 50% by 2030, enhancing renewable energy generation.

Open five new renewable natural gas plants; renewable-energy portfolio includes 86 projects
Deploy collision-avoidance cameras on collection trucks (2,200+ units)
Pace electrification: goal for 50% of new refuse vehicle purchases to be EVs by 2028
Initiatives include landfill-gas-to-energy, polymer center for plastics circularity, recycling and organics programs
Employee engagement goal: maintain ≥ 88% by 2030 (supports sustainability culture)

Inclusion & Diversity

50% Ethnically Diverse Workforce

Diverse Workforce Representation

Half of the company's workforce is composed of ethnically diverse individuals, reflecting a commitment to inclusivity.

38% Leadership Roles by Women

Women in Top Leadership

38% of top leadership positions within the company are held by women, showcasing progress toward gender equality.

$75.8M with Diverse Suppliers

Diverse Supplier Spending

The company spent $75.8 million with certified diverse suppliers in 2022, aiming for $150 million by 2025.

82% Employee Satisfaction

Employee Satisfaction Rating

82% of employees rated the company as a great place to work in a 2024 survey, reflecting a supportive workplace culture.

Established MOSAIC Council in 2013 to drive inclusion efforts, including recruiting partnerships, training, leadership development, and business resource group support.
Removed college-degree requirements for many roles to broaden access and inclusivity.
Aims to achieve 50% diversity in leadership roles by 2030.

Articles

Media Room

Customer Support

Reddit: strike information & customer email

Role

Description

data pipelines

data warehouse

data lake

sql optimization

marklogic integration

medallion architecture

Designs and develops code and data pipelines to ingest relational databases, file shares, and web services
Align data models with ELT/ETL pipelines and analytics frameworks to create scalable data structures that grow with business demands
Write and optimize advanced SQL queries in Snowflake (or similar platforms) to ensure efficient data processing and warehouse performance
Develops MarkLogic integrations with existing enterprise platforms
Data modeling and building Data Warehouse using Snowflake
Designs and develops code and data pipelines to ingest from relational databases (Oracle, SQL Server, DB2, Aurora), file shares, and web services
Design and implement Medallion Architecture, dimensional models (Star/Snowflake schemas), and metadata-driven modeling approaches for enterprise data warehouses
Designs JavaScript modules and REST APIs utilizing MarkLogic to support complex searches
Participates in all aspects of the software life cycle using Agile development methodologies
Develop canonical and semantic data models with effective SCD handling techniques that align with business requirements and analytical needs
Build Data Lake on AWS S3 with optimal performance considerations by partitioning and compressing data.
Participates in requirements definition, system architecture design, and data architecture design

Requirements

aws

python

erwin

git

angular

bachelor’s

5+ years’ experience with data modeling tools like ERWIN, Lucid, sqlDBM
Experience with Machine Learning and Artificial Intelligence
Experience with Git/GitHub, branching, and other modern source code management methodologies required
Data Engineering and Analytics using AWS Glue, Informatica, EMR, Spark, Athena, Python
Ability to work collaboratively as part of an Agile Team
5+ years of Web development experience with Angular, JavaScript, and Node.js
Experience with JSON or XML data modeling required
5 years of experience in Data Ingestion, Data Extraction, and Data Integration (required).
7+ years of experience with integration architecture such as SOA, Microservices, ETL or other integration technologies
Understanding of database architecture and performance implications required
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 AWS services (S3, Kinesis, Lambda, Athena, Glue, EMR) required
7+ years of experience in Enterprise Information Solution Architecture, Design, and Development required
5+ years of analytics tools like SAS, R, Python, and other advanced statistical software
Excellent written and verbal communication skills, sense of ownership, urgency and drive.
Domain knowledge of NoSQL or relational database required
Experience in AWS services for data and analytics (required).
Experience integrating Business Intelligence applications like Qlik Sense, Tableau, or Power BI
5+ years of hands-on experience with a MarkLogic framework, DynamoDB preferred
Bachelor’s degree in Computer Science, Computer Information Systems, Engineering, Statistics or closely related field (willing to accept foreign education equivalent) (required).
Streaming ingestion with Kinesis Streams, Kinesis Firehose, Kinesis Analytics and Kafka (MSK)
Ability to multi-task effectively
Extensive knowledge and experience with Python, JavaScript and Java

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

1981

Year Founded

Established as a regional waste hauler.

$16 Billion

2024 Revenue

Annual revenue achieved in 2024.

$2+ Billion

2024 Net Income

Net income for the year 2024.

It operates collection, transfer, recycling centers, landfills and energy‑from‑waste facilities across the U.S.
Typical projects include curbside residential pickup, commercial/industrial waste hauling, recycling operations and landfill gas‑to‑energy plants.
Specialisms span residential and commercial collection, industrial waste services, recycling processing, hazardous waste treatment, and renewable energy generation.

Culture + Values

Safe – We protect the livelihoods of our colleagues and communities.
Committed to Serve – We go above and beyond to exceed our customers’ expectations.
Environmentally Responsible – We take action to improve our environment.
Driven – We deliver results in the right way.
Human-centered – We respect the dignity and unique potential of every person.

Environment + Sustainability

35% emissions reduction

Net-zero greenhouse gas target

Aims to reduce absolute Scope 1 and 2 emissions by 35% by 2030, aligned with the Science Based Targets initiative (SBTi).

15% emissions reduction

Early achievement of interim target

Reduced operational greenhouse gas emissions by 15% as of 2023, meeting the 2025 interim target two years early.

40% material recovery increase

Resource recovery goal

Aims to increase the recovery of key materials by 40% by 2030, supporting circularity and resource efficiency.

50% biogas reuse increase

Biogas beneficial reuse target

Committed to increasing biogas sent to beneficial reuse by 50% by 2030, enhancing renewable energy generation.

Open five new renewable natural gas plants; renewable-energy portfolio includes 86 projects
Deploy collision-avoidance cameras on collection trucks (2,200+ units)
Pace electrification: goal for 50% of new refuse vehicle purchases to be EVs by 2028
Initiatives include landfill-gas-to-energy, polymer center for plastics circularity, recycling and organics programs
Employee engagement goal: maintain ≥ 88% by 2030 (supports sustainability culture)

Inclusion & Diversity

50% Ethnically Diverse Workforce

Diverse Workforce Representation

Half of the company's workforce is composed of ethnically diverse individuals, reflecting a commitment to inclusivity.

38% Leadership Roles by Women

Women in Top Leadership

38% of top leadership positions within the company are held by women, showcasing progress toward gender equality.

$75.8M with Diverse Suppliers

Diverse Supplier Spending

The company spent $75.8 million with certified diverse suppliers in 2022, aiming for $150 million by 2025.

82% Employee Satisfaction

Employee Satisfaction Rating

82% of employees rated the company as a great place to work in a 2024 survey, reflecting a supportive workplace culture.

Established MOSAIC Council in 2013 to drive inclusion efforts, including recruiting partnerships, training, leadership development, and business resource group support.
Removed college-degree requirements for many roles to broaden access and inclusivity.
Aims to achieve 50% diversity in leadership roles by 2030.

Articles

Media Room

Customer Support

Reddit: strike information & customer email