Sr Data Modeler

Sr Data Modeler

Join to apply for the Sr Data Modeler role at Republic Services
.

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.

• 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 Mark Logic 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.

• 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, No
  
  SQL databases, ETL tools, geospatial systems, or semantic technology.
• 5+ years of hands‑on experience with a Mark Logic framework, Dynamo
  
  DB 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/Git Hub, branching, and other modern source‑code‑management methodologies required.
• Domain knowledge of No
  
  SQL 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.

• 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).

Republic Services is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual…