Data Architect
Role: Data Architect
Location: Chicago IL (Downtown)
Term: 18 Month Contract to Hire
Compensation: W2 Negotiable (Cannot work Corp to Corp)
Summary
We are seeking a Data Architect with expertise in data modeling, data profiling, Python scripting, and SQL query development to design and optimize our data architecture. The ideal candidate will play a key role in defining and implementing scalable data solutions that support business intelligence, analytics, and operational data needs.
Key Responsibilities
• Design and implement data models (conceptual, logical, and physical) to support business and analytical needs.
• Perform data profiling and analysis to ensure data quality, consistency, and integrity.
• Develop and optimize SQL queries for data extraction, transformation, and reporting.
• Create Python scripts for data processing, automation, and integration with other data services.
• Collaborate with cross-functional teams, including Data Engineers, Analysts, and Business Stakeholders, to align data architecture with business objectives.
• Define and enforce data governance, security, and compliance best practices.
• Support data migration and integration initiatives across different databases and platforms.
• Work with modern cloud-based data platforms (AWS, Azure, or Google Cloud) to design scalable data solutions.
• Provide technical leadership and mentorship to junior data professionals.
Qualifications
• 8+ years of experience in data architecture, data modeling, and data engineering roles.
• Strong experience in designing relational and non-relational databases (e.g., SQL Server, PostgreSQL, Oracle, MySQL, NoSQL databases).
• Deep understanding of data modeling techniques (e.g., star schema, snowflake schema, normalized forms).
• Proficiency in SQL development, query optimization, and performance tuning.
• Experience with Python for data processing, scripting, and automation.
• Knowledge of ETL/ELT processes and tools such as Apache Airflow, Talend, Informatica, or dbt.
• Familiarity with big data technologies (e.g., Spark, Hadoop) is a plus.
• Strong problem-solving skills and ability to communicate technical concepts effectively to both technical and non-technical stakeholders.
Preferred Qualifications
• Experience in data cataloging, metadata management, and data lineage tracking.
• Familiarity with machine learning pipelines and AI-driven analytics.
• Knowledge of DevOps and Infrastructure as Code (Terraform, Ansible) for data infrastructure management.
• Experience with Kafka or other event-driven architecture for real-time data processing.
Role: Data Architect
Location: Chicago IL (Downtown)
Term: 18 Month Contract to Hire
Compensation: W2 Negotiable (Cannot work Corp to Corp)
Summary
We are seeking a Data Architect with expertise in data modeling, data profiling, Python scripting, and SQL query development to design and optimize our data architecture. The ideal candidate will play a key role in defining and implementing scalable data solutions that support business intelligence, analytics, and operational data needs.
Key Responsibilities
• Design and implement data models (conceptual, logical, and physical) to support business and analytical needs.
• Perform data profiling and analysis to ensure data quality, consistency, and integrity.
• Develop and optimize SQL queries for data extraction, transformation, and reporting.
• Create Python scripts for data processing, automation, and integration with other data services.
• Collaborate with cross-functional teams, including Data Engineers, Analysts, and Business Stakeholders, to align data architecture with business objectives.
• Define and enforce data governance, security, and compliance best practices.
• Support data migration and integration initiatives across different databases and platforms.
• Work with modern cloud-based data platforms (AWS, Azure, or Google Cloud) to design scalable data solutions.
• Provide technical leadership and mentorship to junior data professionals.
Qualifications
• 8+ years of experience in data architecture, data modeling, and data engineering roles.
• Strong experience in designing relational and non-relational databases (e.g., SQL Server, PostgreSQL, Oracle, MySQL, NoSQL databases).
• Deep understanding of data modeling techniques (e.g., star schema, snowflake schema, normalized forms).
• Proficiency in SQL development, query optimization, and performance tuning.
• Experience with Python for data processing, scripting, and automation.
• Knowledge of ETL/ELT processes and tools such as Apache Airflow, Talend, Informatica, or dbt.
• Familiarity with big data technologies (e.g., Spark, Hadoop) is a plus.
• Strong problem-solving skills and ability to communicate technical concepts effectively to both technical and non-technical stakeholders.
Preferred Qualifications
• Experience in data cataloging, metadata management, and data lineage tracking.
• Familiarity with machine learning pipelines and AI-driven analytics.
• Knowledge of DevOps and Infrastructure as Code (Terraform, Ansible) for data infrastructure management.
• Experience with Kafka or other event-driven architecture for real-time data processing.
