Kablio AI
AI Turbo Recruiter
Want to hear how I work? Hit play.Kablio AI applies for you. You just show up to the interviewKablio AI helps you secure roles in construction, clean energy, facilities management, engineering, architecture, sustainability, environment and other physical world sectors.
Get hired, get rewarded!
Land a job through Kablio and earn a 5% salary bonus.
Exclusive benefits
5%Bonus
Data Architecture and Engineering Director
Core Spaces
Design, implement, and optimize data pipelines and warehouse using various tools like Databricks, Azure Data Factory, Delta Lake, and Power BI for data transformation, modeling, and integration from multiple platforms to ensure data integrity, performance, and accessibility.
20d ago
$175,000 - $200,000
Expert & Leadership (13+ years)
Full Time
Chicago, IL
Hybrid
Company Size
300 Employees
Service Specialisms
Construction services
Project Management
Consulting
Engineering
Architecture
Property Development
Design
Technical Services
Sector Specialisms
Student Housing
Build-to-Rent Residential
Role
What you would be doing
data warehousing
etl pipelines
automation design
data security
semantic models
governance
- Provide documentation, knowledge transfer, and training to analysts and report developers.
- Build and manage enterprise data warehouses and lakehouse environments.
- Support schema evolution, metadata management, and automation of workflows.
- Mentoring peers and elevating organizational data maturity.
- Driving multifamily housing or real estate data solutions.
- Design, implement, and optimize ETL/ELT pipelines using Databricks, Azure Data Factory, Delta Lake, and other tools.
- Partnering cross-functionally with Finance, Operations, and Technology teams.
- Designing scalable automation for reporting, reconciliation, and forecasting needs.
- Work with semi-structured data (CSV, JSON, Parquet, XML) and ensure lineage, quality, and integrity.
- Enable reporting and analytics through semantic layers and Power BI models.
- Define and enforce data modeling and architecture standards across platforms and projects.
- Continuously identify opportunities for advanced analytics and efficiency improvements.
- Act as a subject matter expert (SME) for data engineering best practices.
- Transform raw data into structured tables, star schemas, and reporting models.
- Enhance and monitor existing data models, pipelines, and performance SLAs.
- Manage and monitor data security and access in alignment with enterprise policies.
- Support validation, reconciliation, and migration for integrations and rollouts.
- Partner with stakeholders to translate business requirements into data models and platform capabilities.
- Collaborate with business users and engineers to support operational and strategic projects.
- Ingest, cleanse, and transform data from multiple SaaS and operational systems.
- Document data models, pipelines, transformation logic, and integrations.
- Govern functional and non-functional requirements to ensure scalability, performance, and security.
What you bring
sql, python
databricks
power bi
bachelor’s
7 years
data pipelines
- Must be able to complete all physical requirements of this role with or without a reasonable accommodation
- Ability to work with multiple formats (CSV, JSON, Parquet, XML) and API-based data ingestion.
- Familiarity with real estate/multifamily housing data domains (preferred).
- Strong SQL and Python (PySpark) proficiency.
- Strong analytical, problem-solving, and communication skills.
- 7+ years of progressive experience in data engineering, data architecture, or analytics modeling.
- Hands-on experience with Databricks, Azure Data Factory, Delta Lake, and Power BI.
- Comfort working independently and collaboratively in a fast-paced, “in-the-weeds” environment.
- Deep understanding of data transformation, pipelines, and schema design (star, snowflake, dimensional modeling, CDC/SCD2).
- Bachelor’s degree in Information Systems, Computer Science, Engineering, or related field (or equivalent experience).
- Experience building/managing data warehouses and lakehouse environments.
- Wellness allowance and perks, including a yearly subscription to a meditation app
- Monthly phone reimbursement
- Company retirement options including 401(k) + matching & Roth account option
- Monthly workshop weeks; fewer meetings & more collaboration
- Robust health plan options that begin within at least 30 days of your employment
- Paid Parental Leave that begins after 90 days
- Incentives designed to reward your achievements
- Competitive pay that values your contributions
- Paid 15 holidays, including your birthday, to disconnect and celebrate
- Paid volunteer time off to give back to your community
- Hybrid or remote work options may vary by role to support work-life balance
- Paid flexible PTO to disconnect or celebrate life milestones
- Employee Assistance Program (EAP) for access to confidential support services
Information not given or found
Interview process
Information not given or found
Visa SponsorshipInformation not given or found
Security clearance- credit and criminal background checks may be conducted as permitted by law
Company
Overview
- Founded with a vision to redefine urban living, focusing on transforming spaces that blend modern design with functionality.
- Operates with a strong presence in major metropolitan areas, specializing in developing both residential and commercial properties.
- Prides itself on being an innovator in the mixed-use real estate sector, creating spaces that foster community engagement.
- Known for a forward-thinking approach, balancing aesthetic appeal with sustainability and user-centric designs.
- Typical projects include luxury apartment complexes, student housing, and commercial retail spaces, all designed with cutting-edge amenities.
- Expanding rapidly through strategic partnerships and market insights, becoming a key player in urban real estate development.
- Integrates smart technology and sustainable practices, ensuring a lasting impact on the neighborhoods they develop.
- We are innovative, driven, and passionate.
- We foster an environment of collaboration and transparency.
- We value diversity of thought and perspective.
- We challenge the status quo and push boundaries.
- We are committed to excellence and continuously improving.
2035
Net-Zero Carbon Target
Aims to achieve net-zero carbon emissions by a specific year, demonstrating a strong commitment to climate action.
- Focus on energy efficiency and the use of sustainable materials in all projects.
- Integrate green building certifications like LEED into their design and construction process.
- Prioritize reducing waste and optimizing resource use across their operations.
- Dedicated to fostering a diverse and inclusive workplace.
- Tracks and reports gender representation at all levels, aiming for greater gender parity.
- Has a mentorship program to support underrepresented groups within the organization.
Kablio AIIf you're someone who helps build and power the world (or dreams to), Kablio AI is your pocket-sized recruiter that gets you hired.
Copyright © 2025 Kablio