Overview
On Site
USD 84.04 - 84.04 per hour
Contract - W2
Skills
Data Extraction
ELT
Data Quality
Flat File
SFTP
Reporting
Meta-data Management
Real-time
Dropbox
FTP
Collaboration
Data Validation
Regulatory Compliance
Privacy
Data Architecture
Data Migration
Databricks
Informatica
Extract
Transform
Load
Data Modeling
Snow Flake Schema
Dimensional Modeling
Dynamics
Customer Engagement
Data Structure
Legacy Systems
Migration
Microsoft Dynamics AX
Microsoft
Unity
Data Governance
Continuous Integration
Continuous Delivery
Workflow
Microsoft Azure
DevOps
Life Insurance
Screening
Writing
Career Counseling
Recruiting
Law
Testing
Job Details
Data Architect - Contract - Chicago, IL - $ 84.04- $ 84.04/hr.
The final salary or hourly wage, as applicable, paid to each candidate/applicant for this position is ultimately dependent on a variety of factors, including, but not limited to, the candidate's/applicant's qualifications, skills, and level of experience as well as the geographical location of the position.
Applicants must be legally authorized to work in the United States. Sponsorship not available.
Our client is seeking a Data Architect in Chicago, IL.
Role Description
Data Migration Strategy & Execution
Define and lead the end-to-end data migration strategy from legacy systems (e.g., AX 2009) to Dynamics 365 CE & F&O.
Design and implement data extraction, transformation, and loading (ETL/ELT) pipelines using Azure Data Factory and Informatica.
Ensure data quality, consistency, and completeness across all migrated datasets.
Data Modeling & Architecture
Design and implement enterprise data models aligned with the Databricks Medallion architecture:
Bronze Layer: Raw ingestion from APIs, flat files, and FTP/SFTP sources
Silver Layer: Cleaned and structured data
Gold Layer: Curated, business-ready data for consumption and reporting
Define data lineage, metadata, and governance standards using Unity Catalog and Azure Purview.
Integration & Real-Time Enablement
Support real-time and batch data ingestion from diverse sources including:
Shelter LOB systems, PetProPortal, SFCC, Vetco, Dropbox, and FTP endpoints
Azure Event Hub, Logic Apps, and Function Apps
Enable data synchronization with Dynamics 365 and downstream systems via APIs and Dataverse.
Collaboration & Governance
Collaborate with enterprise architects, data engineers, and business analysts to align data models with business needs.
Establish data validation, reconciliation, and exception handling frameworks.
Participate in data governance forums and ensure compliance with security and privacy standards.
Skills & Requirements
10+ years of experience in data architecture, data migration, and enterprise data modeling.
Azure Data Factory, Databricks, Delta Lake
Informatica ETL, Event Hub, Logic Apps
Data modeling tools and techniques (e.g., star/snowflake schemas, dimensional modeling)
Experience with Dynamics 365 CE & F&O data structures and legacy system migrations (e.g., AX 2009).
Familiarity with Medallion architecture and modern data lakehouse patterns.
Preferred Qualifications:
Microsoft Certified: Azure Data Engineer Associate or equivalent
Experience with Unity Catalog, Azure Purview, and data governance frameworks
Familiarity with CI/CD pipelines for data workflows using Azure DevOps
Benefits/Other Compensation
This position is a contract/temporary role where Hays offers you the opportunity to enroll in full medical benefits, dental benefits, vision benefits, 401K and Life Insurance ($20,000 benefit).
Why Hays?
You will be working with a professional recruiter who has intimate knowledge of the industry and market trends. Your Hays recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and drivers. You will also get support on resume writing, interview tips, and career planning, so when there's a position you really want, you're fully prepared to get it.
Nervous about an upcoming interview? Unsure how to write a new resume?
Visit the Hays Career Advice section to learn top tips to help you stand out from the crowd when job hunting.
Hays is committed to building a thriving culture of diversity that embraces people with different backgrounds, perspectives, and experiences. We believe that the more inclusive we are, the better we serve our candidates, clients, and employees. We are an equal employment opportunity employer, and we comply with all applicable laws prohibiting discrimination based on race, color, creed, sex (including pregnancy, sexual orientation, or gender identity), age, national origin or ancestry, physical or mental disability, veteran status, marital status, genetic information, HIV-positive status, as well as any other characteristic protected by federal, state, or local law. One of Hays' guiding principles is 'do the right thing'.
We also believe that actions speak louder than words.
In that regard, we train our staff on ensuring inclusivity throughout the entire recruitment process and counsel our clients on these principles. If you have any questions about Hays or any of our processes, please contact us.
In accordance with applicable federal, state, and local law protecting qualified individuals with known disabilities, Hays will attempt to reasonably accommodate those individuals unless doing so would create an undue hardship on the company. Any qualified applicant or consultant with a disability who requires an accommodation in order to perform the essential functions of the job should call or text .
Drug testing may be required; please contact a recruiter for more information.
#LI-DNI
The final salary or hourly wage, as applicable, paid to each candidate/applicant for this position is ultimately dependent on a variety of factors, including, but not limited to, the candidate's/applicant's qualifications, skills, and level of experience as well as the geographical location of the position.
Applicants must be legally authorized to work in the United States. Sponsorship not available.
Our client is seeking a Data Architect in Chicago, IL.
Role Description
Data Migration Strategy & Execution
Define and lead the end-to-end data migration strategy from legacy systems (e.g., AX 2009) to Dynamics 365 CE & F&O.
Design and implement data extraction, transformation, and loading (ETL/ELT) pipelines using Azure Data Factory and Informatica.
Ensure data quality, consistency, and completeness across all migrated datasets.
Data Modeling & Architecture
Design and implement enterprise data models aligned with the Databricks Medallion architecture:
Bronze Layer: Raw ingestion from APIs, flat files, and FTP/SFTP sources
Silver Layer: Cleaned and structured data
Gold Layer: Curated, business-ready data for consumption and reporting
Define data lineage, metadata, and governance standards using Unity Catalog and Azure Purview.
Integration & Real-Time Enablement
Support real-time and batch data ingestion from diverse sources including:
Shelter LOB systems, PetProPortal, SFCC, Vetco, Dropbox, and FTP endpoints
Azure Event Hub, Logic Apps, and Function Apps
Enable data synchronization with Dynamics 365 and downstream systems via APIs and Dataverse.
Collaboration & Governance
Collaborate with enterprise architects, data engineers, and business analysts to align data models with business needs.
Establish data validation, reconciliation, and exception handling frameworks.
Participate in data governance forums and ensure compliance with security and privacy standards.
Skills & Requirements
10+ years of experience in data architecture, data migration, and enterprise data modeling.
Azure Data Factory, Databricks, Delta Lake
Informatica ETL, Event Hub, Logic Apps
Data modeling tools and techniques (e.g., star/snowflake schemas, dimensional modeling)
Experience with Dynamics 365 CE & F&O data structures and legacy system migrations (e.g., AX 2009).
Familiarity with Medallion architecture and modern data lakehouse patterns.
Preferred Qualifications:
Microsoft Certified: Azure Data Engineer Associate or equivalent
Experience with Unity Catalog, Azure Purview, and data governance frameworks
Familiarity with CI/CD pipelines for data workflows using Azure DevOps
Benefits/Other Compensation
This position is a contract/temporary role where Hays offers you the opportunity to enroll in full medical benefits, dental benefits, vision benefits, 401K and Life Insurance ($20,000 benefit).
Why Hays?
You will be working with a professional recruiter who has intimate knowledge of the industry and market trends. Your Hays recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and drivers. You will also get support on resume writing, interview tips, and career planning, so when there's a position you really want, you're fully prepared to get it.
Nervous about an upcoming interview? Unsure how to write a new resume?
Visit the Hays Career Advice section to learn top tips to help you stand out from the crowd when job hunting.
Hays is committed to building a thriving culture of diversity that embraces people with different backgrounds, perspectives, and experiences. We believe that the more inclusive we are, the better we serve our candidates, clients, and employees. We are an equal employment opportunity employer, and we comply with all applicable laws prohibiting discrimination based on race, color, creed, sex (including pregnancy, sexual orientation, or gender identity), age, national origin or ancestry, physical or mental disability, veteran status, marital status, genetic information, HIV-positive status, as well as any other characteristic protected by federal, state, or local law. One of Hays' guiding principles is 'do the right thing'.
We also believe that actions speak louder than words.
In that regard, we train our staff on ensuring inclusivity throughout the entire recruitment process and counsel our clients on these principles. If you have any questions about Hays or any of our processes, please contact us.
In accordance with applicable federal, state, and local law protecting qualified individuals with known disabilities, Hays will attempt to reasonably accommodate those individuals unless doing so would create an undue hardship on the company. Any qualified applicant or consultant with a disability who requires an accommodation in order to perform the essential functions of the job should call or text .
Drug testing may be required; please contact a recruiter for more information.
#LI-DNI
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.