Data Architect

Prophecy Technologies

$120K — $150K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years as a Data Architect
  • At least 2 successful enterprise-level Snowflake implementations
  • Expertise in Snowflake architecture, including virtual warehouses and snowpipe
  • Proficient in data modeling methodologies such as Inmon, Kimball, and Data Vault 2.0
  • Strong understanding of cloud security governance and best practices
  • Experience with dbt for data transformation and reverse-engineering legacy systems
  • Hands-on experience building medallion architecture and working with LLM and prompt engineering.

Responsibilities

  • Lead the design of future state Snowflake architecture
  • Evaluate and optimize current SAP HANA modeling patterns
  • Define target data models and cloud data warehousing standards
  • Establish storage/compute topology for optimal performance
  • Implement data governance frameworks for the Snowflake environment
  • Ensure scalability, security, and cost-effectiveness of data solutions
  • Collaborate with cross-functional teams to integrate solutions into the enterprise data strategy.

Benefits

  • Flexible work environment with remote options
  • Opportunities for professional development and training
  • Comprehensive health and wellness plans
  • Work in a cutting-edge technology stack
  • Contribute to impactful data-driven decisions within the organization
Full Job Description
Role: Acts as the blueprint designer for the future state, leading the evaluation of current SAP HANA modeling patterns (like Calculation Views, Stored procedures etc) to map them into an optimized Snowflake architecture. They are responsible for defining the target data models, cloud data warehousing standards, storage/compute topology, and data governance frameworks that ensure the new Snowflake environment is scalable, secure, and cost-effective. Experience: 8+ years as a Data Architect, including at least 2 successful enterprise-level Snowflake implementations. Skills: Snowflake architecture (virtual warehouses, snowpipe, clustering keys), data modeling (Inmon, Kimball, Data Vault 2.0), cloud security governance, dbt for data transformation and legacy system reverse-engineering. Hands on exp in building medallion architecture, LLM and prompt engineering.

Similar Jobs

More Jobs at Prophecy Technologies

More Information Technology Jobs

Find similar Data Architect jobs: