Role: Data Architect - Snowflake
Exp: 12 - 16 Years
Location: Hyderabad/Pune
Mode of Work: Work from Office
About the job
We are seeking a skilled Snowflake Data Architect with expertise in PySpark to join our team and contribute to building scalable, efficient, and governed data solutions. The ideal candidate will have hands-on experience in designing and optimizing Snowflake data warehouses, leveraging PySpark for complex ETL/ELT processes. Proficiency in advanced Snowflake features, such as streams, tasks, materialized views, and SQL, is essential. A solid understanding of data governance principles, metadata management, and cloud platforms like AWS or Azure will be highly beneficial.
Know your team
At Value Momentum's Technology Solution Center, we are a team of passionate engineers who thrive on tackling complex business challenges with innovative solutions while transforming the P&C insurance value chain. We achieve this through a strong engineering foundation and continuously refining our processes, methodologies, tools, agile delivery teams, and core engineering archetypes. Our core expertise lies in 4 key areas: Platform, App & Infra Engineering, Data & BI Engineering, Core Engineering, Advance Analytics.
Join a team that invests in your growth. Our Infinity Program empowers you to build your career with role-specific skill development, leveraging immersive learning platforms. You'll have the opportunity to showcase your talents by contributing to impactful projects.
Responsibilities
- Lead efforts to ensure data capabilities are operating efficiently, accurately, and with high quality.
- Collaborate with programs & projects to understand data dependencies, anticipate risks, and identify opportunities. Guide data project decisions based on the direction of data domain roadmap.
- Contribute data domain expertise to feasibility, complexity assessments of potential future initiatives including data domain analysis.
- Develops an integrated view of data capabilities and processes, using a repeatable approach, cohesive framework, and available industry best practices and techniques.
- Provides consulting and makes recommendations to tackle data transformation initiatives, help mature existing data capabilities, or enable new data capabilities.
- Facilitate the process of defining and publishing data standards, best practices, data capabilities, and data roadmap, synchronized with the overall enterprise future state architecture.
- Collaborate in creation of conceptual and logical architecture and models following the enterprise guidance to describe a particular domain of data and use these models to inform the physical design of data-related projects.
- Co-develop data life cycle governance framework including standards, patterns, and controls.
Deliverables
- Domain Analysis Specification & Findings
- Clearly define the data domain and its confines
- Leverage an organizationally accepted and standardized framework (like CMMI) to evaluate and grade maturity within the defined data domain.
- Identify opportunities for investment along with specified benefits for investment, including the data capability roadmap.
- Document Data Governance Capabilities (co-create)
- Data and attribute definitions and master dataset definitions within the data domain.
- Documentation of domain definition governance processes and platform.
- Documented capabilities and coverage for data lineage within the data domain.
- Diagrams overall data landscape within a data domain, including current and future state data flows.
- Data mapping document (initiate/support)
- Assist in the creation and delivery of Conceptual & Logical Data Model by providing business level understanding of relationships to other domains and business transactions across the enterprise.
Qualifications
- Minimum eight years of relevant experience as a data architect building large-scale data solutions.
- Experience in Migration of existing On-Prem Data warehouses to Snowflake.
- Experience in architecting and large data modernization, data migration, data warehousing – experience with cloud-based data platforms (like Snowflake)
- Experience with defining and operationalizing data strategy, data governance, data lineage and quality standards.
- Experience designing highly scalable ETL processes with complex data transformations, data formats including error handling and monitoring .
- Extensive knowledge of data engineering, data integration and data management concepts (i.e. APIs, ETL, MDM, CRUD, Pub/Sub, etc.)
- Experience with data Modeling.
- Experience with structured and hierarchical datasets (i.e. JSON, XML, etc.)
- Engineering experience with large scale system integration and analytics projects.
About Value Momentum
Value Momentum is a leading solutions provider for the global property & casualty insurance industry, supported by deep domain and technology capabilities. We offer a comprehensive suite of advisory, development, implementation, and maintenance services across the entire P&C insurance value chain. This includes Underwriting, Claims, Distribution, and more, empowering insurers to stay ahead with sustained growth, high performance, and enhanced stakeholder value. Trusted by over 75 insurers, Value Momentum is one of the largest standalone insurance-focused solutions providers in the US insurance industry.
Our culture – Our fuel
At Value Momentum, we believe in making employees win by nurturing them from within, collaborating and looking out for each other.
- People first - Empower employees to succeed.
- Nurture leaders - Nurture from within.
- Enjoy wins – Recognize and celebrate wins.
- Collaboration – Foster a culture of collaboration and people-centricity.
- Diversity – Committed to diversity, equity, and inclusion.
- Fun – Create a fun and engaging work environment.
- Warm welcome – Provide a personalized onboarding experience.
Company Benefits
- Compensation - Competitive compensation package comparable to the best in the industry.
- Career Growth - Career development, comprehensive training & certification programs, and fast track growth for high potential associates.
- Benefits: Comprehensive health benefits and life insurance.
****
