Data Architect/Modeler

Infinitive Inc • Pittsburgh, PA

5d

About The Position

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.

Requirements

• 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.

Nice To Haves

• 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.

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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 11-50 employees