Data Architect

Hybrid in Chicago, IL, US • Posted 19 hours ago • Updated 19 hours ago
Contract W2
2 Years
No Travel Required
Hybrid
$80 - $90/hr
Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

  • Data Modeling
  • Data Validation
  • Data Warehouse

Summary

Key Responsibilities
  1. Strategic Architecture & Future-Proofing
    1. Cloud-Agnostic Vision: Design and execute a 3-to-5-year enterprise data warehouse modernization roadmap that prioritizes extreme data portability, decoupling storage from compute using open table formats (e.g., Apache Iceberg).
    2. Multi-Cloud Readiness: Evaluate alternative ecosystems and ensure current AWS implementations are built with vendor-neutral patterns, avoiding proprietary lock-in.
    3. AI & Semantic Preparation: Establish strict semantic conventions, data hygiene standards, and metadata graphs today to ensure the underlying data warehouse is optimized for future conversational AI agents and modern BI tools.
 
  1. Engineering Governance & Quality Automation
    1. Scale Through Guardrails: Stop technical debt at the source by designing reusable framework templates and abstracted wrappers that enforce coding best practices across an offshore development team
    2. Automated DataOps Gates: Implement automated CI/CD quality gates (e.g., automated SQL linting, schema drift detection, and data validation frameworks) to catch low-quality code before it reaches human review.
    3. Operational Excellence: Redefine the onshore team''s workflows, shifting senior engineers from manual code-reviewers to platform product owners.
    4. Code modernization: Assist in setting policies and training for the team to move from working exclusively in SQL to also including Spark jobs. Help us figure out the proper handoff mechanisms and frameworks for evaluating SQL developed solutions to Spark jobs.
 
  1. Ingestion & Pipeline Optimization
    1. High-Frequency Ingestion: Own the architectural pattern for high-frequency source replication, ensuring optimal performance without violating API limits or driving unnecessary cloud compute costs.
    2. Modern Orchestration & Storage: Guide the transition from rigid, scheduled jobs to event-driven processing using AWS Glue, EMR Serverless, and optimized presentation layers in Redshift.
 
  1. Mentorship & Leadership
    1. Talent Elevation: Act as a dedicated mentor to the 3 intermediate and 3 senior onshore engineers, pushing them to think in terms of holistic system design and enterprise scalability.
    2. Soft Skills Coaching: Help senior staff develop critical soft skills, including "influence without authority," cross-functional stakeholder communication, and effective offshore vendor governance.
 
Required Qualifications
  • 8+ years of deep experience in enterprise data engineering, data architecture, or data platform roles, with at least 2+ years operating at a Staff, Principal, or Lead Architect level within a Fortune 500 scale environment.
  • Expertise in Cloud-Agnostic Design: Proven track record of building data lakehouses centered around open table formats (e.g., Apache Iceberg, Delta Lake) to ensure cross-cloud compatibility.
  • Advanced AWS Data Ecosystem Experience: Hands-on architectural experience with AWS Glue, EMR Serverless, S3 data lakes, and Amazon Redshift.
  • Governance at Scale: Demonstrated success implementing automated testing, CI/CD pipelines, and DataOps frameworks (e.g., dbt, Great Expectations, SQLFluff) to govern large delivery teams.
  • Complex Ingestion Mastery: Experience managing high-frequency CDC data ingestion from massive enterprise ERP systems (specifically Oracle Fusion Cloud or equivalent) using modern tools like Fivetran.
  • Expert Coding Skills: Mastery of Python and complex SQL, with a deep understanding of query optimization, data modeling (Kimball, Data Vault 2.0), and technical debt remediation.
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.
  • Dice Id: 91134724
  • Position Id: 8987979
  • Posted 19 hours ago
Contact the job poster
KM

Kevin Mangan

Recruiter @ Next Gen IT Inc
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Chicago, Illinois

Today

Easy Apply

Contract

Depends on Experience

Hybrid in Chicago, Illinois

19d ago

Easy Apply

Contract

70 - 80

Hybrid in Chicago, Illinois

Yesterday

Easy Apply

Contract

Depends on Experience

Chicago, Illinois

Today

Contract

USD 120,000.00 - 150,000.00 per year

Search all similar jobs