Sr Data Modeler

Overview

Design & implement data models, pipelines & analytics on AWS/Snowflake.

Key Responsibilities

• snowflake
• data warehouse
• medallion architecture
• marklogic
• data lake
• etl pipelines

Tasks

-Data modeling and building Data Warehouse using Snowflake -Design and implement Medallion Architecture, dimensional models (Star/Snowflake schemas), and metadata-driven modeling approaches for enterprise data warehouses -Participates in all aspects of the software life cycle using Agile development methodologies -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 -Designs JavaScript modules and REST APIs utilizing MarkLogic to support complex searches -Build Data Lake on AWS S3 with optimal performance considerations by partitioning and compressing data. -Develop canonical and semantic data models with effective SCD handling techniques that align with business requirements and analytical needs -Participates in requirements definition, system architecture design, and data architecture design -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 -Designs and develops code and data pipelines to ingest relational databases, file shares, and web services

Requirements

• aws services
• python
• github
• machine learning
• agile
• bachelor’s

What You Bring

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

People Also Searched For

Benefits

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

About Republic Services

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

Sector Specialisms