Snowflake Data Architect

Data Ideology, LLC; Pittsburgh (Allegheny County); Remote; USD 140,000 - 175,000; Full time

Benefits offered by this job

Remote work from home

Job summary

Data Ideology, LLC is seeking a Snowflake Data Architect to design and enable modern cloud data platforms and semantic data models that support analytics, BI, and data science initiatives.

You will lead architecture, ELT/ETL pipelines, and modernization efforts, while ensuring security, governance, and cost management across Snowflake implementations and integrations with enterprise systems.

Qualifications

• 8+ years of experience in data architecture, data engineering, or data modeling.
• Strong SQL skills and ability to design enterprise data platforms.
• Experience leading architecture and data transformations in Snowflake environments.
• Experience guiding large-scale data migrations to Snowflake.
• Ability to collaborate with business and technical stakeholders to drive data initiatives.

Responsibilities

• Lead the architecture and technical direction of enterprise Snowflake data platforms.
• Design and implement Snowflake data models and ELT/ETL pipelines.
• Lead data warehouse modernization and migrations to Snowflake.
• Establish and optimize Snowflake security, governance, performance, and cost management.
• Partner with stakeholders to integrate Snowflake with enterprise systems and cloud platforms.

Skills

SQL proficiency

Technical leadership

Communication

Tools

Snowflake

Snowpark

Cortex

Purview

Collibra

Alation

Job description

Snowflake Data Architect

At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients. Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results. Our team consists of highly motivated individuals passionate about learning, understanding, collaborating, and intellectually curious. For more information about Data Ideology, visit www.dataideology.com.

We are always looking to connect with top talent! We are seeking a skilled and collaborative Snowflake Data Architect to help drive ongoing data modernization efforts. This role is responsible for designing and enabling modern cloud data platforms, integrating enterprise systems, and building semantic data models that support critical business functions across the organization. If you're passionate about cloud architecture, scalable data solutions, and helping organizations transform their data ecosystems, we'd love to connect with you.

Key Responsibilities

• Lead the architecture and technical direction of enterprise Snowflake data platforms, designing scalable solutions for analytics, reporting, business intelligence, and data science.
• Design and implement Snowflake data models and ELT/ETL pipelines, including dimensional, semantic, and enterprise data models supporting financial, operational, ERP, and other business data.
• Lead data warehouse modernization and migrations to Snowflake, including source-to-target mapping, transformation, reconciliation, testing, performance optimization, and production cutover.
• Establish and optimize Snowflake security, governance, performance, and cost management, including RBAC, masking policies, row access policies, workload management, query optimization, and data quality.
• Partner with business and technical stakeholders to integrate Snowflake with enterprise systems and cloud platforms, evaluate Snowflake capabilities such as Snowpark and Cortex, and provide technical leadership and mentorship across data initiatives.

Qualifications

• 8+ years of experience in data architecture, data engineering, or data modeling, with 5+ years of hands-on Snowflake experience designing and implementing enterprise data platforms.
• Deep expertise in Snowflake architecture, data modeling, ELT/ETL, performance optimization, security, governance, and cost management, with strong SQL skills.
• Demonstrated experience designing scalable Snowflake solutions, including enterprise data warehouses, semantic models, high-volume data environments, and batch or near-real-time data pipelines.
• Proven experience leading large-scale data migrations and modernization initiatives to Snowflake, from discovery and architecture through development, testing, reconciliation, and production cutover.
• Strong ability to lead technical direction and collaborate with business and technical stakeholders, translating complex data architecture concepts into scalable Snowflake solutions while balancing strategic vision with hands‑on execution.

Preferred Qualifications

• Deep experience with data governance, metadata management, MDM, and data quality frameworks.
• Familiarity with data catalog tools (e.g., Purview, Collibra, Alation).
• Track record supporting enterprise data modernization, migration, or cloud transformation initiatives.
• Remote work from home.
• Hours of work and days are generally Monday through Friday. Specific business hours will depend on client needs.

Physical Demands:

• Must be able to remain in a stationary position 50% of the time.
• The person in this position must occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc.
• Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and printer.
• The person in this position frequently communicates with clients and coworkers. Must be able to exchange accurate information in these situations.