Data Architect Job at Probal DasGupta, Villa Park, IL

L0NMZmp5Szd2STkzWXRhUkZVd2c0NHNJRmc9PQ==
  • Probal DasGupta
  • Villa Park, IL

Job Description

Job Title: Data Architect

No. of Positions: 1

Projected Start Date: 08-05-2025

Projected End Date: 02-20-2026

Position Type: Contract

Location: Villa Park, IL (Hybrid – Onsite Monday & Tuesday at 1 Renaissance Plaza, Oak Brook Terrace, IL)

Mandatory Skills:

  • 8+ years in relational & dimensional data modeling (Kimball methodology)
  • 5+ years of experience with Power BI reporting and dataset development
  • 5+ years in Enterprise Data Warehouse (EDW) architecture and ETL
  • 2+ years working with Azure Synapse Pipelines
  • Strong T-SQL, SSIS, and DAX skills
  • Experience building Tabular models in Power BI Premium/SSAS
  • Azure Data Factory, Azure Data Lake architecture.

Highly Desired Skills:

  • Experience with data governance frameworks like DAMA-DMBOK
  • Familiarity with Azure Purview, Collibra (metadata management & data cataloging)
  • Knowledge of Databricks
  • Understanding of regulatory compliance (HIPAA, GDPR).

Key Responsibilities:

Data Architecture & Engineering

  • Design scalable enterprise-wide data architectures
  • Transform normalized data into dimensional models (Facts & Dimensions).
  • Architect/manage the Enterprise Data Warehouse (EDW), ensure parent-child & data lineage relationships.
  • Develop data pipelines using Azure Data Factory & Synapse Pipelines.
  • Design Tabular models for Power BI Premium and SSAS.
  • Leverage SSIS for data extraction and transformation.
  • Write optimized T-SQL and DAX for modeling and reporting.

Business Intelligence & Analytics

  • Build Power BI reports and dashboards
  • Integrate external data sources into the EDW
  • Translate business needs into technical models and BI solutions

Governance & Standards

  • Implement data governance and metadata management tools
  • Define and enforce data quality rules and architectural standards
  • Design secure, compliant data access infrastructures

Leadership & Collaboration

  • Lead full SDLC efforts: requirement gathering to implementation
  • Mentor junior engineers and analysts
  • Collaborate cross-functionally across business and technical teams

Required Qualifications

  • Bachelor's in Computer Science, Information Systems, or related
  • 8+ years in data architecture/modeling
  • 5+ years in Power BI and EDW
  • 2+ years in Azure Synapse Pipelines
  • Strong hands-on skills in T-SQL, SSIS, DAX
  • Strong documentation and communication skills

Job Tags

Contract work,

Similar Jobs

Planet Group

Python Developer Job at Planet Group

 ...Target Pay Rate: 80-100/hr **salary will be commensurate with experienceAbout the Role: We are seeking a talented Python Developer with experience in clinical data standards (SDTM/CDISC) and a passion for AI/ML-driven automation. In this role, you will design and... 

MedMatch

Physician Assistant Job at MedMatch

 ...Our client, a large family practice , is hiring multiple Physician Assistants to join their organization at one of several locations....  ...experience in a family practice setting. Experience with telemedicine is a plus Performance Skills - Strong clinical assessment... 

Chick-fil-A

Miembro del equipo de limpieza - Turno de noche Job at Chick-fil-A

 ...Principales responsabilidades de un limpiador: Mantener los edificios en condiciones limpias Realice toda la limpieza de alta resistencia Realizar actividades de mantenimiento...  ...e insecticidas Requisitos del trabajo de limpiador/conserje: Debe tener un diploma... 

Cornerstone School

School Secretary Job at Cornerstone School

 ...Cornerstone Mandarin Immersion Program is looking for good fit profession to joining our growing community. The School Secretary plays a vital role in the smooth operation of the school, providing administrative support to the principal, staff, students, and parents... 

Mystic Valley Regional Charter School

7-12th Grade History Teacher Job at Mystic Valley Regional Charter School

 ...who are committed to continuous improvement and student success. Teachers work closely with their grade-level teams to deliver high-...  ...raising student achievement Enthusiasm and content mastery in History (or applicable academic subject) Self-motivation, professionalism...