Designs and oversees organizational data architecture and conceptual, logical, and physical data models. Translates business requirements into scalable data solutions, develops data flows and modeling standards, maintains metadata and documentation, evaluates databases for discrepancies, and identifies model reuse opportunities. Partners with application development teams and provides executive guidance on high-impact data initiatives aligned with organizational goals.
The Data Architect will provide technical expertise in analysis, design, development, rollout and maintenance of enterprise data models and solutions
Provides technical expertise in needs identification, data modelling, data movement and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective.
Essential Duties
- Understand and translate business needs into data models and data architecture supporting long-term solutions.
- Work with the Application Development team to implement data strategies, build data flows and development of data models.
- Create and maintain conceptual, logical, and physical data models using best practices to ensure high data quality and reduced redundancy, along with corresponding metadata.
- Optimise and update logical and physical data models to support new and existing projects.
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
- Organized and rigorous with versioning of documentation and models to ensure consistent delivery and understanding between the client and development team.
- Recommend opportunities for reuse of data models in new environments.
- Perform reverse engineering of physical data models from databases and SQL scripts.
Evaluate data models and physical databases for variances and discrepancies.
ResponsibilitiesOversee organizational data modelling. Lead highimpact initiatives. Ensure alignment with organizational goals. Provide executive guidance. QualificationsBachelor's or Master's degree in Computer Science, Data Science, or a related field. 8-12 years of experience in data modelling or data analysis.Similar Jobs
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Lead enterprise data architecture across warehouses, data lakes, downstream applications, and AI workloads. Design data models, Medallion Architecture, ELT standards, semantic layers, APIs, access controls, and reusable datasets. Partner with business and BI teams to drive adoption, conduct architecture reviews, establish platform standards, and mentor data and analytics engineers. The role requires deep Snowflake, dbt, data modeling, pipeline, and semantic-layer expertise, with experience in AI data patterns and cloud infrastructure preferred.
Top Skills:
AWSAzureDatabricksDbtDelta LakeGCPGraphQLLlmsPower BIRagRestSnowflakeSnowflake Unity CatalogTableau
Information Technology
Designs and delivers Snowflake data architectures on AWS, including dbt-based data engineering and AI-enabled solutions. Leads RAG, vector search, embedding, semantic search, and analytics initiatives from proof of concept through production. Directs project teams, oversees solution quality and budgets, supports proposals and business cases, and serves as a trusted technical advisor to clients. Requires strong data engineering, governance, documentation, communication, and stakeholder-management skills, with travel as needed.
Top Skills:
AWSDbtEmbedding PipelinesGenerative AiPrompt OrchestrationRetrieval-Augmented GenerationSemantic SearchSnowflakeSQLVector Search
Information Technology
Designs and delivers Microsoft Fabric, Azure AI, Power BI, and generative AI architectures for enterprise clients. Leads solution design, prototyping, implementation readiness, governance, quality assurance, and client enablement across complex engagements. Develops AI solution patterns including RAG, vector search, embeddings, semantic search, and prompt orchestration. Leads project and client teams, supports business cases and proposals, reviews technical deliverables, manages risks, and serves as a trusted technical advisor.
Top Skills:
AzureAzure AiAzure Ai SearchAzure OpenaiCi/CdCopilotEltEmbeddingsGenerative AiMicrosoft FabricOnelakePower BIPrompt EngineeringPysparkPythonRbacRetrieval-Augmented GenerationSemantic SearchSparkSQLVector Search
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
