As a Data Architect at R Systems, you'll play a pivotal role in shaping the future of our data infrastructure. From developing robust database solutions to analyzing structural requirements for new software, your expertise will be instrumental in driving our digital transformation journey. You'll spearhead database migrations, design conceptual data models, and optimize system performance to ensure seamless functionality. Collaboration with our Data Science department will be key, as you'll work hand-in-hand to anticipate future needs and requirements, ensuring our data ecosystem remains agile and future-proof.
Major Duties and Responsibilities
- Develop innovative database solutions to efficiently store and retrieve company information.
- Install and configure information systems, guaranteeing optimal functionality and performance.
- Analyze structural requirements for new software and applications, providing expert insights and recommendations.
- Execute seamless data migrations from legacy systems to modern, scalable solutions.
- Design comprehensive conceptual and logical data models, supported by detailed flowcharts.
- Continuously optimize database systems to enhance performance and reliability.
- Define and implement robust security and backup procedures to safeguard critical data assets.
- Collaborate closely with the Data Science department to anticipate future needs and requirements.
- Provide essential operational support for Management Information Systems (MIS), ensuring smooth day-to-day functioning.
Required Qualifications
Skills/Abilities and Knowledge
- Proficiency in data warehousing, and ETL processes, with a minimum of 2 years experience in end-to-end implementation of Snowflake cloud data warehouse migrations.
- Expertise in advanced Snowflake concepts, including resource monitors, Role-based access control (RBAC), virtual warehouse sizing, and query performance tuning.
- In-depth understanding of Snowflake features such as Micro-partitions, Warehouse, Clone, and Stages (external, internal).
- Extensive experience in ingesting data into Snowflake from various sources, including S3, Sharepoint, and APIs.
- Strong command of AWS and Azure platforms, with demonstrated experience in cloud migration projects.
- Proven proficiency in ETL using SnowSQL and writing complex stored procedures.
- Hands-on experience in scheduling ingestion pipelines using tools such as Tasks, Snowpipe, and Airflow.
- Solid skills in SQL, PLSQL, and Unix shell scripting, coupled with the ability to troubleshoot technical issues effectively.
- Excellent communication skills, both verbal and written, with fluency in English.
- Outstanding analytical abilities and a problem-solving mindset.
- Experience with visualization tools like Tableau is advantageous.
- Familiarity or working knowledge of Big Data technologies such as Hadoop/Hive is a plus.
Qualifications
- Stand out by highlighting skills pertinent to the job posting.
- Minimum 2+ years of experience with Snowflake.
- Minimum 3+ years of experience with AWS Cloud Migration.
- Proficiency in English, both native and bilingual.
Company Overview
R Systems is a dynamic digital product engineering firm located in Noida, committed to crafting cutting-edge solutions for a diverse range of clients across industries. Our mission revolves around empowering businesses to transcend digital obstacles, prioritize customer satisfaction, and achieve optimal operational efficiency while maximizing revenue potential. Through relentless innovation and the strategic utilization of leading-edge technologies such as cloud computing, automation, AI, ML, analytics, and mixed reality, we deliver transformative business solutions that drive tangible impact.