Data Architect/Modeler

About Infinitive

Infinitive is a data and AI consultancy that enables its clients to modernize and operationalize their data to create lasting and substantial value. We bring deep industry and technology expertise to drive and sustain adoption of new capabilities. We match our people and personalities to our clients' culture while bringing the right mix of talent and skills to enable measurable value.

Infinitive has been named Best Small Firms to Work For by Consulting Magazine 8 times, most recently in 2025. Infinitive has also been named a Washington Post Top Workplace, Washington Business Journal Best Places to Work, and Virginia Business Best Places to Work.

Position Summary

We are seeking a highly skilled Data Architect to design, implement, and optimize our enterprise data landscape. You will serve as the blueprint designer for our data systems, ensuring that our infrastructure is scalable, secure, and aligned with business objectives. The ideal candidate bridges the gap between high-level business requirements and technical execution, possessing deep expertise in both cloud engineering and sophisticated data modeling.

Key Responsibilities

• Architectural Design : Lead the design and implementation of end-to-end data architecture, from ingestion and storage to transformation and consumption layers.

• Data Modeling : Develop and maintain conceptual, logical, and physical data models (Star Schema, Snowflake Schema, Data Vault) to support diverse analytics and reporting needs.

• Cloud Strategy : Design scalable, secure, and high-performance data solutions within the AWS ecosystem.

• Platform Integration : Oversee the architectural synergy between Databricks (for processing and Lakehouse capabilities) and Snowflake (for cloud data warehousing).

• Engineering Oversight : Collaborate with Data Engineers to build robust ETL/ELT pipelines, ensuring best practices in CI/CD, data quality, and governance.

• Strategy & Governance : Establish data standards, selection of tools, and best practices for metadata management and data security.

Required Qualifications

• Cloud Expertise : Proven experience architecting data solutions on AWS (S3, Glue, Athena, Lambda, Redshift, etc.).

• Data Modeling : Extensive experience in multi-dimensional modeling and designing complex schemas for large-scale data environments.

• Platform Proficiency : Hands-on experience and architectural knowledge of Databricks (Spark, Delta Lake) and Snowflake.

• Data Engineering : Strong background in SQL, Python, or Scala, with the ability to vet and guide complex data pipeline development.

• Communication : Ability to translate complex technical concepts into actionable insights for executive stakeholders and non-technical teams.

Preferred Qualifications

• Relevant certifications (e.g., AWS Certified Data Engineer, Snowflake SnowPro Core, or Databricks Certified Data Engineer Professional).

• Experience with Infrastructure as Code (Terraform, CloudFormation).

• Familiarity with data orchestration tools (Airflow, Dagster) and dbt (data build tool).

• Knowledge of data privacy regulations (GDPR, CCPA) and security frameworks.

Why Join Us?

At Infinitive, you will work on high-impact projects that transform how our clients leverage their most valuable asset—data. We offer a collaborative environment where innovation is encouraged, and professional growth is a priority.