Data ArchitectModeler
Share
Job Location:
Pittsburgh, PA - USA
Monthly Salary:
Not Disclosed
Posted on:
2 days ago
Vacancies:
1 Vacancy
Job Summary
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 assetdata. We offer a collaborative environment where innovation is encouraged and professional growth is a priority.
Required Experience:
Manager
About Company
Get the value out of your data with Infinitive, the leaders in data analytics and cloud development.
