Snowflake Architect

Ready to embark on a journey where your growth is intertwined with our commitment to making a positive impact? Join the Delphi family - where Growth Meets Values.

At Delphi Consulting Pvt. Ltd., we foster a thriving environment with a hybrid work model that lets you prioritize what matters most. Interviews and onboarding are conducted virtually, reflecting our digital-first mindset. We specialize in Data, Advanced Analytics, AI, Infrastructure, Cloud Security, and Application Modernization, delivering impactful solutions that drive smarter, efficient futures for our clients.

About the Role:

We are seeking an experienced Enterprise Data Architect to manage and oversee all activities that define client business data assets in alignment with the Client's Data & Analytics Strategy. The role requires discovering and analyzing data and analytics requirements, and applying logical and analytical thinking to deliver innovative database solutions that drive business outcomes.

What you'll do:

• Influence and shape the client's Data & Analytics Strategy to align with long-term business goals.
• Lead data architecture and solution design, ensuring scalability, security, and performance.
• Apply deep expertise in data warehouse design, including dimensional modeling, data vault, star schema, and snowflake schema.
• Design and implement data integration solutions using Informatica Intelligent Cloud Services (IICS) and Informatica with Snowflake for seamless data movement and transformation.
• Adjust and refine designs on the fly, providing clear justifications for decisions.
• Create data models using Visio, Erwin, or similar tools.
• Develop mapping documents and collaborate with ETL and testing teams for seamless implementation.
• Interact with enterprise architects, business stakeholders, and cross-functional teams to gather, validate requirements, and secure sign-offs.
• Drive multiple initiatives/projects from inception to completion, ensuring quality and timeliness.
• Enhance organizational decision-making by surfacing data priorities and maximizing value derived from analytics.
• Conduct business data modeling and enable enterprise data management practices.
• Ensure security, integrity, and performance of data assets, with a focus on improving Data Hub performance.

What you'll bring:

• A degree in Computer Science, Information Systems, or a related field.
• 8+ years of IT experience, with at least 3 years focused on information systems design or data architecture.
• Proven experience in designing and implementing information solutions and database structures (transactional modeling, dimensional modeling, data vault, star schema).
• Strong expertise in IICS (Informatica Intelligent Cloud Services) and hands-on experience implementing Informatica with Snowflake for enterprise-scale solutions.
• Strong leadership and people management skills, with experience working across cultures, coaching teams, and driving high performance.
• Hands-on experience in implementing data and analytics management programs is preferred.
• Ability to analyze project/program/portfolio needs and determine required resources while overcoming cross-functional challenges.
• Excellent communication, problem-solving, and stakeholder management skills.

What We Offer:

At Delphi, we are dedicated to creating an environment where you can thrive, both professionally and personally. Our competitive compensation package, performance-based incentives, and health benefits are designed to ensure you're well-supported. We believe in your continuous growth and offer company-sponsored certifications, training programs, and skill-building opportunities to help you succeed. We foster a culture of inclusivity and support, with remote work options and a fully supported work-from-home setup to ensure your comfort and productivity. Our positive and inclusive culture includes team activities, wellness and mental health programs to ensure you feel supported.