Data Architect

AceStack LLC

Pittsburgh, PA

Role : Data Architect

Location :Pittsburgh, PA or Strongsville, OH

FTE

Job Description

Must Have Technical/Functional Skills:

12-15 years of experience in data architecture, data modeling, or related roles.
Strong expertise in data modeling techniques (conceptual, logical, physical).
Proven experience creating logical data flow diagrams and data lineage documentation.
Hands-on proficiency with SQL and relational databases (e.g., Oracle, SQL Server, PostgreSQL, MySQL).
Solid understanding of dimensional modeling, normalization, and denormalization.
Experience working closely with business, analytics, and engineering teams.
Strong analytical, problem-solving, and communication skills

Roles & Responsibilities:

Design and maintain conceptual, logical, and physical data models to support business and analytical needs.
Develop logical data flow diagrams representing data movement across source systems, integrations, and consumption layers.
Partner with business stakeholders, data engineers, and application teams to translate requirements into scalable data architectures.
Define and enforce data standards, naming conventions, and modeling best practices.
Perform hands-on work with SQL and database platforms to validate models, optimize queries, and ensure data accuracy.
Review and optimize existing data models for performance, scalability, and maintainability.
Support data integration, ETL/ELT, and reporting initiatives with clear architectural guidance.
Ensure data quality, consistency, and integrity across systems.
Provide architectural input for cloud, on prem, or hybrid data platforms.
Mentor junior architects and data modelers as needed.

Apply

Vacancy posted 18 hours ago

Similar jobs that could be interesting for youBased on the Data Architect in Pittsburgh, PA vacancy

Data Architect
Title: Data ArchitectReports To: Director - Data EngineeringLocation: Pittsburgh, PA or New York, NY American Eagle is a youth culture... ....Get to Know the Role: We are seeking an experienced Data Architect to lead the design and implementation of our enterprise data architecture...
Suggested
Full time
Part time
Summer work
Casual work
Local area
Immediate start
American Eagle Outfitters
Pittsburgh, PA
18 hours ago
Data Architect
...Data Architect Location:Pittsburgh PA Fulltime Must Have Technical/Functional Skills: Database design, data modeling, data warehousing, SQL, ETL processes, cloud technologies, data mining. Programming languages like Python...
Suggested
Full time
SARIAN Co
Pittsburgh, PA
3 days ago
BI/Data Architect
...BI/Data ArchitectLocation: Strongsville, OH / Pittsburgh, PAJob OverviewWe are looking for an experienced BI/Data Architect to design and implement scalable data architecture, business intelligence solutions, and enterprise data platforms. The ideal candidate should have...
Suggested
AceStack LLC
Pittsburgh, PA
1 day ago
Enterprise Data Architect
...Enterprise Data Architect Location: Remote (Must be available during EST hours) Duration: Contract Work Authorization: GC, USC 10+ years of Enterprise Data Architecture experience with data modeling, ETL, Azure Data Factory, Data Lake, BI/Data Warehouse...
Suggested
Contract work
Remote work
3B Staffing LLC
Pittsburgh, PA
3 days ago
Senior Data Architect
...Position Title: Senior Data Architect Position Location: PA - Pittsburgh, Duration – 1 Year Industry background: Banking, Regulatory reporting, CCAR Roles and Responsibilities: 8-10 years total experience with at least 5-6 years of specific experience in...
Suggested
Temporary work
Local area
Flexible hours
Shift work
System One
Pittsburgh, PA
a month ago
Applied AI Health Data Architect-Senior Manager
$124k - $280k
...LevelSenior ManagerJob Description & SummaryAt PwC, our people in data and analytics engineering focus on leveraging advanced... ..., FHIR R4, and interoperability standards- Proven track record architecting data solutions for healthcare programs- Navigating HIPAA compliance...
Full time
H1b
PwC
Pittsburgh, PA
18 hours ago
Snowflake Finance Data & AI Architect Manager
...Recruiting for this role ends on 09/30/2026Work you'll doAs a Finance Data & AI Manager specializing in Microsoft Azure and Fabric, you’ll... ...for planning, close, profitability, treasury, and reporting• Architect production ML and generative and agentic AI with Fabric Data...
Local area
Visa sponsorship
Deloitte
Pittsburgh, PA
2 days ago
Data Solution Architect
...Data Engineering Position Responsibilities: Data Engineering, Data Modeling, Data Warehousing, Master Data Management, Reference Data Management, Data Lineage, Data Governance and Meta Data Management experience required Experience in defining Data & Analytics...
E-Solutions
Pittsburgh, PA
3 days ago
Director, AI & Data Solution Architect
$155k - $410k
...ApplicableSpecialismData, Analytics & AIManagement LevelDirectorJob Description & SummaryThe OpportunityAs a Director, AI & Data Solution Architect you will lead the design of AI and data solutions that help clients modernize platforms, shape architecture choices, and...
Full time
H1b
PwC
Pittsburgh, PA
1 day ago
Application Data Architect - Data Streaming
...Role Overview We are seeking a senior Application Data Architect to lead the design and implementation of complex, event-driven data ecosystems within a retail banking environment. In this role, you will act as a foundational architect, defining how data flows across...
Local area
Techstra Solutions
Pittsburgh, PA
29 days ago
Cloud Data Architect
...Data Ideology At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business... ...For more information about Data Ideology, visit . Cloud Data Architect We are always looking to connect with top talent! We are...
Work at office
Remote work
Work from home
Monday to Friday
Data Ideology, LLC
Pittsburgh, PA
3 days ago
Data Analyst + Kafka
...Cleveland, OH / Pittsburgh, PA (Day 1 Onsite)Note - Pls submit only visa independent candidatesEmployment Type - FTEJob Description:Data Analyst + KafkaWe are seeking a highly skilled Big Data Analyst to join our data-driven team. The ideal candidate will be responsible...
SRI Tech
Pittsburgh, PA
18 hours ago
Sr. Data Governance Analyst
...Fishers, OH0523 Independence Bus Office, OH0713 NW Bancshares HQ, PA0258 Bellevue, PA0738 Processing CenterJob DescriptionA Senior Data Governance Analyst is a key member of the Data Governance Program at Northwest Bank and will lead the development, deployment, and maintenance...
Full time
Work experience placement
Casual work
Work at office
Shift work
Northwest Bank
Pittsburgh, PA
18 hours ago
Data Analyst + Python
...Cleveland, OH / Pittsburgh, PA (Day 1 Onsite)Note - Pls submit only visa independent candidatesEmployment Type - FTEJob Description:Data Analysis & Insights: Conducted in-depth analysis of large datasets to identify trends, patterns, and actionable insights, driving data...
SRI Tech
Pittsburgh, PA
18 hours ago
Data Warehousing Systems Analyst
...We are seeking a Data Warehousing Systems Analyst II to support enterprise data warehouse solutions, data analysis, system integrations, and business applications. The role will work closely with technical and business stakeholders to gather requirements, troubleshoot...
Contract work
Techvilla Solutions
Pittsburgh, PA
a month ago
Senior Buildings Science Architect/Engineer
$128.6k - $192.9k
Stantec’s Buildings team is on a mission to become the world’s leading integrated design practice. Our architects, engineers, interior designers, consultants, sustainability specialists, and technologists are passionate about the power of design. Our collaborative culture...
Full time
Contract work
Temporary work
Part time
For contractors
Casual work
Local area
Flexible hours
Stantec
Pittsburgh, PA
18 hours ago
Lead Adobe Commerce Architect
$134.5k - $265.1k
...drive sustained growth through customer and commercial strategy, data and analytics, Generative AI, digital products, marketing, commerce, sales, and service. As a Lead Business Transformation Architect specializing in Adobe Commerce, you will help clients define scalable...
Local area
Visa sponsorship
Deloitte
Pittsburgh, PA
2 days ago
BCG Platinion | Lead AI Tech Architect - AI Platforms
$190k
...competitive advantage and business superior performance through data, technology and digital. BCG Platinion sits within the TDA... ...leading-edge tech platforms, at scale.What You'll DoLead AI Tech Architects - AI Platforms at BCG Platinion are:Collaborative. They are interdisciplinary...
Work at office
Local area
The Boston Consulting Group
Pittsburgh, PA
1 day ago
BCG Platinion | Senior AI Tech Architect, Public Sector Industry Leader (Defense & Security, Civil Sector)
$150k
...the intersection of people and technology. As a Senior AI Tech Architect, you will collaborate on interdisciplinary teams of designers,... ...Architecture and Solution DesignDesigning solution, application, and data architecture.Developing feasibility studies, technical concepts...
Contract work
Work at office
Local area
The Boston Consulting Group
Pittsburgh, PA
4 days ago
Lead Architect with Anthropic Experience
$141.2k - $278.3k
Position Summary Lead Architect with Agentic AI Experience, AI & Engineering/Engineering as a ServiceAgentic AI is moving from experimentation... ...operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These solutions...
Work at office
Local area
Visa sponsorship
Flexible hours
Shift work
Deloitte
Pittsburgh, PA
1 day ago
Machine Learning Systems Engineer
$144k - $192k
...be doing:Performance Profiling & Optimization: Utilize profiling tools (e.g., Nsight, PyTorch Profiler) to identify bottlenecks in data loading, gradient computation, and communication. Implement optimizations like kernel fusion, sharding, and tiling to improve step time...
Work at office
Remote work
Motional
Pittsburgh, PA
3 days ago
Database Engineer
...develop, and maintain robust database solutions to support business applications and analytics. This role involves creating efficient data models, writing optimized queries, and ensuring data integrity and security across systems. Key Responsibilities: Design and...
Contract work
Yantran LLC
Homestead, PA
1 day ago
Machine Learning Engineer III
...passion and skills to helping achieve our purpose, you’ll be part of a team that understands that there’s a human life behind every data point. Your skills, curiosity, and compassion—will help fuel our innovation and achieve the TeleTracking promise of revolutionizing...
Visa sponsorship
Work visa
TeleTracking Technologies
Pittsburgh, PA
1 day ago
Senior Machine Learning Engineer
...development and production-grade software engineering: you will build and optimize generative models, implement robust Python code and data pipelines, collaborate with cross-functional teams (research scientists, software engineers, product owners), and help drive ML best...
CyberCoders
Pittsburgh, PA
10 hours ago
Dayforce Data Integration Management - Senior Consultant, Functional Transformation
$116.2k - $229.1k
Position Summary Dayforce Integration Data Management - Senior ConsultantOur Human Capital practice is at the forefront of transforming the nature of work. As converging forces reshape industries, our team uniquely addresses the complexities of work, workforce,...
Local area
Visa sponsorship
Deloitte
Pittsburgh, PA
2 days ago
Oracle Database Engineer
Mid to Senior Linux EngineerFacilitate device usability from Triage through System Recovery, Storage Recovery, and Application RecoveryWorking in a crisis recovery environmentRequires flexibility, resourcefulness, and some long days while maintaining a positive demeanorMust...
NTT DATA
Pittsburgh, PA
3 days ago
Clinical Data AMS Sr. Consultant
$120.2k - $140k
...Are you an experienced, passionate pioneer in technology who wants to work in a collaborative environment? As an experienced Clinical Data AMS Senior Consultant you will have the ability to share new ideas and collaborate on projects as a consultant without the extensive...
Permanent employment
Local area
Remote work
Visa sponsorship
Deloitte
Pittsburgh, PA
1 day ago
Vice President, Database Engineer
$83k - $195k
...necessary improvementsCollaborate with software development teams to integrate database solutions seamlessly into applications, ensuring data integrity and securityLead initiatives to enhance database automation and streamline processes, supporting BNY's commitment to...
Temporary work
Worldwide
Flexible hours
The Bank of New York Mellon
Pittsburgh, PA
1 day ago
Cyber Data Privacy Specialist - Senior Consultant
$105.4k - $207.8k
...support the design and implementation of privacy technology solutions that help organizations address regulatory requirements, strengthen data governance, and enable trusted business outcomes. You will contribute across configuration, integration, testing, and deployment...
Local area
Deloitte
Pittsburgh, PA
1 day ago
Oracle Global Data Warehouse Senior Analyst - Hybrid
...Job Description Genesis10 is currently seeking an Oracle Global Data Warehouse Senior Analyst - Hybrid position with a Global... ...improvements for continuous optimization Collaborate with IT Business Architect to define and maintain application roadmaps Maintain ITIL...
Hourly pay
Permanent employment
Contract work
Genesis10
Pittsburgh, PA
6 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Architect. Be the first to apply!