Jobs via Dice
Data Architect with Kimball
Jobs via Dice - Oakbrook Terrace, Illinois, United States
Work at Jobs via Dice
Overview
- View job
Overview
2 days ago Be among the first 25 applicants
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Voto Consulting LLC, is seeking the following. Apply via Dice today!
Job Title: Data Architect with Kimball
Location: Oak Brook Terrace, Illinois (Hybrid)
Duration: 6-12 Months
Visa: No H1b
Must Have 8+ years of experience in building relational and dimensional data models using Kimball methodology.
Job Summary:
The Senior Data Architect is responsible for designing, building, and overseeing the
deployment and operation of enterprise data architecture and business intelligence
solutions. This role defines the end use of data systems and creates blueprints for
developing, testing, and maintaining data platforms. The architect ensures the seamless
integration of structured and unstructured data from internal and external sources,
enabling advanced analytics, reporting, and decision-making capabilities.
This position plays a critical role in establishing data governance frameworks, metadata
management practices, and architectural standards that ensure data quality, security, and
compliance across the organization.
Key Responsibilities
Design and implement scalable data architectures that support enterprise-wide analytics and reporting needs. Lead the transformation of transactional (normalized) data into dimensional models (facts and dimensions) using Kimball methodology. Architect and manage the Enterprise Data Warehouse (EDW), including parent-child relationships and data lineage. Develop and maintain data pipelines using Azure Data Factory and Synapse pipelines to move data from Data Lake to Synapse. Design and implement Tabular models within Power BI Premium datasets and SSAS environments. Utilize SSIS for data extraction and transformation processes. Write efficient and optimized T-SQL and DAX code for data modeling and reporting. Business Intelligence & Analytics Lead the design and development of Power BI reports and dashboards to support business decision-making. Analyze external data sources and integrate them into the EDW. Collaborate with business stakeholders to translate requirements into technical specifications and data models. Ensure BI solutions align with business goals and deliver measurable value. Governance & Standards Define, select, and implement data governance and metadata management tools and best practices. Establish and enforce design standards, data quality rules, and assurance processes to ensure compatibility and operability of data flows and storage. Design and implement a security infrastructure that supports internal and external access while maintaining compliance with data privacy regulations. Review internal and external business and product requirements and recommend system upgrades or changes to meet evolving data needs. Leadership & Collaboration Lead the full system development life cycle from requirements gathering to implementation and support. Work independently and collaboratively across cross-functional teams. Mentor junior data engineers and analysts on best practices in data architecture and governance.
Required Qualifications
Bachelor s degree in Computer Science, Information Systems, or a related field. 8+ years of experience in building relational and dimensional data models using Kimball methodology. 5+ years of experience in Power BI reporting and dataset development. 5+ years of experience working with Enterprise Data Warehouses and writing ETL processes. 2+ years of experience with Azure Synapse pipelines. Strong proficiency in Microsoft SQL Server T-SQL, SSIS, and DAX. Experience designing and implementing Tabular models in Power BI Premium. Familiarity with Azure development platform and Data Lake architecture. Knowledge of Databricks is a plus. Excellent written and verbal communication skills. Strong documentation and multi-tasking abilities. Proven ability to gather requirements and estimate work effort.
Preferred Skills
Experience with data governance frameworks such as DAMA-DMBOK. Familiarity with data cataloging and metadata management tools (e.g., Azure Purview, Collibra). Understanding of regulatory compliance requirements (e.g., HIPAA, GDPR) as they relate to data architecture.
Thanks & Regards.
Aviral Sapra
Voto Conulting LLC Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Software Development Referrals increase your chances of interviewing at Jobs via Dice by 2x Sign in to set job alerts for “Data Architect” roles.
Solutions Architect, Retail, Google Cloud
Chicago, IL $147,000.00-$216,000.00 1 week ago Oakbrook Terrace, IL $127,000.00-$174,500.00 1 week ago Chicago, IL $150,000.00-$200,000.00 2 days ago Chicago, IL $170,000.00-$180,000.00 1 week ago Chicago, IL $150,000.00-$220,000.00 3 days ago Chicago, IL $125,825.00-$221,275.00 1 week ago Chicago, IL $218,000.00-$306,000.00 2 weeks ago Chicago, IL $155,000.00-$165,000.00 1 week ago Chicago, IL $150,000.00-$180,000.00 2 weeks ago Chicago, IL $137,275.00-$178,670.00 1 day ago Solutions Architect Digital Transformation
Chicago, IL $137,275.00-$178,670.00 1 week ago Data Solutions Architect | Splunk (Remote)
Chicago, IL $160,000.00-$190,000.00 2 weeks ago Chicago, IL $137,400.00-$240,400.00 2 weeks ago Enterprise Data Architect (Hybrid role 8 days in office per month)
Chicago, IL $114,500.00-$194,700.00 1 week ago Delivery Solutions Architect - Healthcare & Life Sciences
Chicago, IL $165,000.00-$180,000.00 3 days ago Greater Chicago Area $169,000.00-$206,000.00 1 week ago Senior Architect - 3rd Party Cloud Cybersecurity (Remote)
Chicago, IL $109,820.00-$149,600.00 1 week ago Chicago, IL $150,000.00-$180,000.00 2 weeks ago Senior Architect - 3rd Party Cloud Cybersecurity (Remote)
Chicago, IL $109,820.00-$149,600.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Job Title: Data Architect with Kimball
Location: Oak Brook Terrace, Illinois (Hybrid)
Duration: 6-12 Months
Visa: No H1b
Must Have 8+ years of experience in building relational and dimensional data models using Kimball methodology.
Job Summary:
The Senior Data Architect is responsible for designing, building, and overseeing the
deployment and operation of enterprise data architecture and business intelligence
solutions. This role defines the end use of data systems and creates blueprints for
developing, testing, and maintaining data platforms. The architect ensures the seamless
integration of structured and unstructured data from internal and external sources,
enabling advanced analytics, reporting, and decision-making capabilities.
This position plays a critical role in establishing data governance frameworks, metadata
management practices, and architectural standards that ensure data quality, security, and
compliance across the organization.
Key Responsibilities
Design and implement scalable data architectures that support enterprise-wide analytics and reporting needs. Lead the transformation of transactional (normalized) data into dimensional models (facts and dimensions) using Kimball methodology. Architect and manage the Enterprise Data Warehouse (EDW), including parent-child relationships and data lineage. Develop and maintain data pipelines using Azure Data Factory and Synapse pipelines to move data from Data Lake to Synapse. Design and implement Tabular models within Power BI Premium datasets and SSAS environments. Utilize SSIS for data extraction and transformation processes. Write efficient and optimized T-SQL and DAX code for data modeling and reporting. Business Intelligence & Analytics Lead the design and development of Power BI reports and dashboards to support business decision-making. Analyze external data sources and integrate them into the EDW. Collaborate with business stakeholders to translate requirements into technical specifications and data models. Ensure BI solutions align with business goals and deliver measurable value. Governance & Standards Define, select, and implement data governance and metadata management tools and best practices. Establish and enforce design standards, data quality rules, and assurance processes to ensure compatibility and operability of data flows and storage. Design and implement a security infrastructure that supports internal and external access while maintaining compliance with data privacy regulations. Review internal and external business and product requirements and recommend system upgrades or changes to meet evolving data needs. Leadership & Collaboration Lead the full system development life cycle from requirements gathering to implementation and support. Work independently and collaboratively across cross-functional teams. Mentor junior data engineers and analysts on best practices in data architecture and governance.
Required Qualifications
Bachelor s degree in Computer Science, Information Systems, or a related field. 8+ years of experience in building relational and dimensional data models using Kimball methodology. 5+ years of experience in Power BI reporting and dataset development. 5+ years of experience working with Enterprise Data Warehouses and writing ETL processes. 2+ years of experience with Azure Synapse pipelines. Strong proficiency in Microsoft SQL Server T-SQL, SSIS, and DAX. Experience designing and implementing Tabular models in Power BI Premium. Familiarity with Azure development platform and Data Lake architecture. Knowledge of Databricks is a plus. Excellent written and verbal communication skills. Strong documentation and multi-tasking abilities. Proven ability to gather requirements and estimate work effort.
Preferred Skills
Experience with data governance frameworks such as DAMA-DMBOK. Familiarity with data cataloging and metadata management tools (e.g., Azure Purview, Collibra). Understanding of regulatory compliance requirements (e.g., HIPAA, GDPR) as they relate to data architecture.
Thanks & Regards.
Aviral Sapra
Voto Conulting LLC Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Software Development Referrals increase your chances of interviewing at Jobs via Dice by 2x Sign in to set job alerts for “Data Architect” roles.
Solutions Architect, Retail, Google Cloud
Chicago, IL $147,000.00-$216,000.00 1 week ago Oakbrook Terrace, IL $127,000.00-$174,500.00 1 week ago Chicago, IL $150,000.00-$200,000.00 2 days ago Chicago, IL $170,000.00-$180,000.00 1 week ago Chicago, IL $150,000.00-$220,000.00 3 days ago Chicago, IL $125,825.00-$221,275.00 1 week ago Chicago, IL $218,000.00-$306,000.00 2 weeks ago Chicago, IL $155,000.00-$165,000.00 1 week ago Chicago, IL $150,000.00-$180,000.00 2 weeks ago Chicago, IL $137,275.00-$178,670.00 1 day ago Solutions Architect Digital Transformation
Chicago, IL $137,275.00-$178,670.00 1 week ago Data Solutions Architect | Splunk (Remote)
Chicago, IL $160,000.00-$190,000.00 2 weeks ago Chicago, IL $137,400.00-$240,400.00 2 weeks ago Enterprise Data Architect (Hybrid role 8 days in office per month)
Chicago, IL $114,500.00-$194,700.00 1 week ago Delivery Solutions Architect - Healthcare & Life Sciences
Chicago, IL $165,000.00-$180,000.00 3 days ago Greater Chicago Area $169,000.00-$206,000.00 1 week ago Senior Architect - 3rd Party Cloud Cybersecurity (Remote)
Chicago, IL $109,820.00-$149,600.00 1 week ago Chicago, IL $150,000.00-$180,000.00 2 weeks ago Senior Architect - 3rd Party Cloud Cybersecurity (Remote)
Chicago, IL $109,820.00-$149,600.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr