← Back to jobs

Avance Consulting Logo
Data Model/Data Architect

Avance Consulting

 

Chicago,United States

Posted On: 1 day ago
Experience: 5+ years
Availability: Onsite
Openings: 2
Category: Data Modeler/Data Architect
Tenure: Contract - Corp-to-Corp
Related Jobs

No related jobs found

Description

You will design and implement data structures, warehousing solutions, and ETL processes to support business requirements.

This role is on-site.

Responsibilities

  • Design relational and dimensional data models aligned with business needs.
  • Implement data warehouse concepts using real-world scenarios.
  • Manage ETL processes, including loading fact tables and handling Slowly Changing Dimensions (SCDs).
  • Execute complex data analysis and write advanced SQL queries.

Required Skills

  • 8+ years of experience in Data Modeling, including Relational and Dimensional models.
  • 8+ years of experience in Data Warehouse implementation and concepts.
  • 7+ years of experience with ETL processes and history management via SCDs.
  • 7+ years of experience in strong SQL writing and data analysis.
  • 5+ years of experience with Azure Medallion Architecture.
  • 5+ years of experience using data modeling tools, specifically Erwin.
  • Any Graduate degree.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs