Senior Data Modeler

🕒 May 28

🌵 Arizona – Remote

🌵 Arizona – Remote

⏰ Full Time

🟠 Senior

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Republic Services

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1998

Environmental Solutions • Waste Management • Sustainability

Republic Services is a leading provider of comprehensive environmental solutions, specializing in recycling, waste management, and sustainability services. The company partners with both residential and business customers to create cleaner, safer, and healthier communities while driving environmental sustainability through innovative practices and technologies. Their services include solid waste and hazardous waste treatment, dumpster rental, and emergency response, all aimed at helping clients achieve their sustainability goals.

📋 Description

• 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. • Participates in all aspects of the software life cycle using Agile development methodologies.

🎯 Requirements

• 5+ years’ experience with data modeling tools like sqlDBM, ERWIN, Lucid • 7+ years of experience in Enterprise Information Solution Architecture, Design, and development required. • 7+ years of experience with integration architectures 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. • Experience adopting and championing AI-assisted development practices within a team. • 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. • 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 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.

🏖️ 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)