IT - Technology Lead | Cloud Integration | Azure Data Factory (ADF)

Job Title: Senior Data modelerWork Location: ChicagoIL60604Vendor Rate: 74.50Contract duration: 6Target Start Date: 05 Sep 2026Does this position require Visa independent candidates only? Yes**hybrid**Need to work from Chicago office weekly 3 days**Job Details:Detailed Job DescriptionKey ResponsibilitiesData Modeling: Create conceptual, logical, and physical data models.Cloud Architecture: Architecture data solutions specifically for cloud platforms.Pipeline Design: Assist in designing ETL/ELT data integration workflows.Optimization: Tune database performance, indexing, and storage costs.Governance: Establish data standards, metadata registries, and security rules.Required Technical SkillsCloud Platforms: AWS (Redshift), Azure (Synapse), or Google Cloud (BigQuery).Data Warehouses: Snowflake, Databricks, or cloud-native relational databases.Modeling Tools: Erwin, ERwin, Hackolade, or DbSchema.Methodologies: Kimball Data Warehousing, Data Vault 2.0, or Inmon.Languages: Advanced SQL and scripting languages like Python.Minimum years of experience8-10 yearsCertifications Needed :NoTop 3 responsibilities you would expect the Subcon to shoulder and executeData Modeling Architecture Architect cloudnative Snowflake data warehouses, implementing starsnowflake schemas and optimizing dimensional models.Strong knowledge in data ingestion no ETL and data warehousing conceptsHands on experience in Python preferredInterview Process (Is face to face required?)NoAny additional information you would like to share about the project specs/ nature of work

Project Code: Data Platform Development POD