> Markdown version of [/jobs/ext/629847-data-modeler](https://www.wearedevelopers.com/jobs/ext/629847-data-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Modeler

- **Company:** Atlantis IT Consulting Group LLC
- **Location:** Scottsdale, AZ, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Architecture, Data Governance, Extract Transform Load (ETL), Data Transformation, Data Structures, Data Warehousing, SQL Databases, Snowflake, Data Build Tool (dbt), Data Pipelines
- **Published:** June 24, 2026
- **Apply:** https://www.dice.com/job-detail/3659bb8e-0208-4074-ac1f-9228c0bf2ffc

## About the Role

* Minimum 6+ years of professional experience in data modeling and data architecture.
 * Strong hands-on experience with Informatica (PowerCenter/IICS), Snowflake, and DBT.
 * Proven experience building canonical data models that combine data from multiple source systems.
 * Practical knowledge of Medallion architecture concepts (Bronze * Silver * Gold).
 * Excellent proficiency in SQL for data transformation, optimization, and troubleshooting.
 * Domain expertise in waste management or environmental services, including operational, billing, fleet, recycling, disposal, and compliance data.
 * Strong communication and documentation skills, with the ability to work cross-functionally with engineering and business teams.

## Description

Looking for a hands-on Data Modeler with strong technical expertise and waste management domain experience to support a data warehouse modernization initiative. The role focuses on migrating existing Informatica-based models into Snowflake using DBT (Data Build Tool), while designing a unified canonical data model that integrates multiple source systems. You'll architect and maintain a Medallion data structure (Bronze, Silver, Gold layers) that delivers reliable, analytics-ready data for business use., * Rebuild and migrate data models from Informatica to a modern Snowflake/DBT platform.

 * Design and implement canonical data models that unify multiple operational and transactional data sources into a single data warehouse.
 * Develop and maintain a Medallion Architecture (Bronze, Silver, Gold layers) to ensure scalable, high-quality data pipelines.
 * Collaborate with engineering and business stakeholders to translate data requirements into optimized, reusable models.
 * Build and tune ETL/ELT processes for performance and reliability.
 * Ensure strong data governance, documentation, and lineage tracking across models.


## Related Videos

- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Why and when should we consider Stream Processing frameworks in our solutions](https://www.wearedevelopers.com/videos/1085-why-and-when-should-we-consider-stream-processing-frameworks-in-our-solutions)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)