Data Architect

$65.75 - $84.50/hr

Other

Posted 26 days ago


Job description

Data Architect
Chicago, IL – hybrid WFH: 3 days onsite in the loop, 2 days work from home
Summary
We're looking for a Data Architect with a background in Azure, Databricks, Snowflake and Python, which is our primary tech stack for designing, building, and optimizing data pipelines. This role is foundational for our organization to deliver best in class AI models, Machine Learning, Analytics and BI – where we have an industry leading real estate data platform, to power critical business decisions in our space.
What you'll be doing
  • Design, develop, and maintain robust data pipelines using Databricks to process and transform large-scale datasets.
  • Write efficient, reusable, and scalable SQL and/or Python code for data ingestion, transformation, and integration.
  • Optimize data workflows for performance, reliability, and cost-efficiency in cloud environments.
  • Collaborate with data scientists, analysts, and stakeholders to understand data requirements and deliver solutions.
  • Implement data governance, security, and compliance best practices within data pipelines.
  • Monitor and troubleshoot data pipeline issues, ensuring high availability and data integrity.
  • Leverage Databricks for advanced analytics, machine learning workflows, and real-time data processing.
  • Integrate data from various sources (APIs, databases, blob, SFTP, streams) into Datalake for centralized storage and querying.
  • Mentor junior data engineers and contribute to team knowledge sharing.
  • Stay updated on emerging data technologies and recommend improvements to existing systems.
  • Performance Tuning and Optimization of all Data Ingestion and Data Integration processes, including the Data Platform and databases

Skills we're seeking
  • 7+ years of experience with Data Architecture / Data Engineering
    • Must have strong experience designing, building and optimizing data pipelines
  • 2+ years of Data Architect experience specifically
  • Must have strong experience with Azure
  • Must have strong experience with Databricks
  • Must have strong experience with Snowflake
  • Must have advanced proficiency with SQL
  • Must have data modeling experience
    • Understanding of data schema modeling (dimensions, measures, slowly changing dimensions)
    • Inmon vs Kimball (Star-Schema vs 3NF)
  • Must have excellent communication skills

Nice to haves (in this order)
  • Strong Python experience, or other programming experience (Python highly preferred) for data processing, scripting, and automation
  • Bachelor's or Master's Degree in Computer Science or related IT or Data field
  • Experience with Azure Durable Functions
  • Experience with Spark
  • Experience with Azure Durable Functions
  • Experience with DuckDB
  • Experience with Parquet, Delta Lake, and/or Iceberg formats
  • Experience with ELT and/or Bronze, Silver, Gold transformation layers
  • Experience with data governance

1872 Consulting logo

About 1872 Consulting

Sourced by ZipRecruiter

1872 Consulting, based in Chicago, IL, USA, operates within the IT consulting industry. Armed with a diverse team of experts, the company offers specialized IT consulting services, focusing on modernizing business technologies and driving innovative business strategies. Established in 1872, the company has a rich history marked by its commitment to bridging the gap between businesses and technology. Its mission is to empower organizations to surpass their business goals by providing state-of-the-art IT solutions and service. The company prides itself on its core values of integrity, excellence, and innovation, instilling these principles in every project they undertake.

Industry

It services

Company size

11 - 50 Employees

Headquarters location

Chicago, IL, US

Year founded

2014



Frequently asked questions

Q: What skills or qualities help someone succeed as a Data Architect?

A: To succeed as a Data Architect, key technical skills include proficiency in data modeling, database design, and data warehousing, as well as expertise in data management tools such as ETL (Extract, Transform, Load) software and data governance platforms. Additionally, strong analytical and problem-solving skills, along with the ability to communicate complex technical concepts to non-technical stakeholders, are essential soft skills for this role. By combining these technical and soft skills, Data Architects can effectively design and implement data systems that support business growth and drive informed decision-making.

Q: What is the career path for a Data Architect?

A: A Data Architect's typical career progression involves starting as a Junior Data Architect or Data Analyst, where they develop foundational skills in data modeling, database design, and data warehousing. As they gain experience, they move into mid-level roles such as Senior Data Architect or Data Governance Lead, where they oversee data strategy, architecture, and compliance. Ultimately, senior Data Architects can transition into leadership positions like Chief Data Officer or Director of Data Engineering, where they drive organizational data vision and strategy.\n\nKey opportunities for skill development and professional growth in this role include learning cloud-based data platforms, advanced data modeling techniques, and data governance frameworks, as well as staying up-to-date with emerging technologies like artificial intelligence and machine learning. \n\nLong-term career prospects for Data Architects may include transitioning into leadership roles, pursuing specialized roles like Data Scientist or Business Analyst, or exploring adjacent fields like IT Consulting or Business Intelligence.



1872 Consulting job posting for a Data Architect in Chicago, IL with a salary of $66 to $85 Hourly with a map of Chicago location.