Technical Architect- Job Code: JOHO-JHND-LJML-FJ

Job Description

Snowflake Solution Architect

Who we are: -

At CitiusTech, we constantly strive to solve the industry's greatest challenges with technology, creativity, and agility. With over 8,500 healthcare technology professionals worldwide, CitiusTech powers healthcare digital innovation, business transformation, and industry-wide convergence for over 140 organizations through next-generation technologies, solutions, and products. We aim to accelerate the transition to a human-first, sustainable, and digital healthcare ecosystem with the world's leading Healthcare and life sciences organizations and our partners.

Here is an opportunity for you to make a difference and collaborate with global leaders to shape the future of healthcare and positively impact human lives.

Our vision: -

To inspire new possibilities for the health ecosystem with technology and human ingenuity.

What is in it for you

As a Snowflake Solution Architect, you will play a crucial role in designing, building, and maintaining scalable data pipelines and infrastructure. You will work with a variety of technologies, including Scala, Python, Spark, AWS services, and SQL, to support our data processing and analytics needs.

Responsibilities: -

• Collaborate with stakeholders to finalize the scope of enhancements and development projects, gathering detailed requirements. Apply expertise in ETL/ELT processes and tools to design and implement data pipelines that fulfil business requirements.
• Provide expertise as a technical resource to solve complex business issues that translate into data integration and database systems designs.
• Migrate and modernize existing legacy ETL jobs for Snowflake, ensuring data integrity and optimal performance.
• Analyse existing ETL jobs and identify opportunities for creating reusable patterns and components to expedite future development.
• Develop and implement a configuration-driven Data Ingestion framework that enables efficient onboarding of new source tables.
• Collaborate with cross-functional teams, including business analysts and solution architects, to align data engineering initiatives with business goals.
• Drive continuous improvement initiatives, enhancing data engineering processes, tools, and frameworks.
• Ensure compliance with data quality, security, and privacy standards across all data engineering activities.
• Participate in code reviews, providing constructive feedback and ensuring high-quality, maintainable code.
• Prepare and present technical documentation, including data flow diagrams, ETL specifications, and architectural designs.

Experience: -

• Should have strong experience on Snowflake and must have executed development and migration projects involving snowflake.
• Should have strong working experience with ETL tools (Matillion/ DBT/Fivetron/ADF preferred).
• Experience in SQL writing - flatten tables and JSON (good to have) and able to write complex queries
• Strong understanding of SQL queries. Good coding experience on Python. Deploying into Snowflake datawarehousing, pipelines
• Experience with large databases
• Working knowledge of AWS (S3, KMS, etc..) or Azure/GCP
• Design, develop, and thoroughly test new ETL/ELT code, ensuring accuracy, reliability, and adherence to best practices
• Cloud certifications (AWS, etc.) and relevant technical certifications are advantageous.
• 10 - 18 Years

Location: -

Any location in India.

Educational Qualifications: -

• Engineering Degree BE / ME / BTech / M Tech / B.Sc. / M.Sc.

Technical certification in multiple technologies is desirable.

Skills: -

Mandatory Technical skills

• Snowflake
• Python/Spark/JavaScript
• AWS/Azure/GCP
• SQL

Good to have skills:

• CI/CD (DevOps)
• Terraform/Airflow

Life at CitiusTech

We focus on building highly motivated engineering teams and thought leaders with an entrepreneurial mindset, centered on our core values of Passion, Respect, Openness, Unity, and Depth (PROUD) of knowledge. Our success lies in creating a fun, transparent, non-hierarchical, diverse work culture that focuses on continuous learning and work-life balance.

Rated by our employees as the Great Place to Work for according to the Great Place to Work survey. We offer you a comprehensive set of benefits to ensure that you have a long and rewarding career with us.

Our EVP

Be You Be Awesome is our EVP and it reflects our continuing efforts to create CitiusTech as a great place to work where our employees can thrive, both personally and professionally. It encompasses the unique benefits and opportunities we offer to support your growth, well-being, and success throughout your journey with us and beyond. Together with our clients, we are solving some of the greatest healthcare challenges and positively impacting human lives. Welcome to the world of Faster Growth, Higher Learning, and Stronger Impact.

Join CitiusTech. Be You. Be Awesome.

To learn more about CitiusTech, visitwww.citiustech.com and follow us on

Happy Applying!