DATA MODELER

Title: Data Modeler Location: Scottsdale, AZ / Remote with travel to Scottsdale once in a month Job Type: Contract – 12 Months

Key Responsibilities: 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.

Must Haves: 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.

Nice to Have: Familiarity with cloud platforms (AWS, Azure, GCP). Experience with data governance and data quality frameworks. Knowledge of Git, CI/CD pipelines, or Airflow for orchestration and automation. Understanding of performance tuning and Snowflake optimization best practices. Exposure to BI tools (Power BI) and curated data delivery from Gold layers.

-- Thanks & Regards, Pallavi Reddy| Technical Recruiter Thoughtwave Software and Solutions Desk: 630-228-9745 , EXTN:167 Email: pallavib@thoughtwavesoft.com