Probal DasGupta
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
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