Solution Architect – Snowflake
Job Description
Who we are
CitiusTech - Shaping Healthcare Possibilities.
CitiusTech is a global IT services, consulting, and business solutions enterprise 100% focused on the healthcare and life sciences industry. We enable 140+ enterprises to build a human-first ecosystem that is efficient, effective, and equitable with deep domain expertise and next-gen technology.With over 8,500 healthcare technology professionals worldwide, CitiusTech powers healthcare digital innovation, business transformation, and industry-wide convergence through next-generation technologies, solutions, and products.
Our Purpose
We are shaping healthcare possibilities to make our clients businesses successful, which is not just a statement but our purpose, driving us to explore what's next in healthcare.
Our goal is clear: to make healthcare better for all more efficient, effective, and equitable. We are investing in people, technology, innovation, and partnerships to create meaningful change. We see technology not just as a tool but as a catalyst that amplifies human ingenuity to solve complex healthcare challenges.
100% healthcare focus | Trusted by 140+ healthcare and life sciences enterprises | 40% of Fortune 500 healthcare enterprises are our clients | #1 Rated as a leader by top analyst firms
Our vision
To inspire new possibilities for the health ecosystem with technology and human ingenuity.
What is in it for you
As a Solution Architect Snowflake, 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, gather 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, ensure data integrity and optimal performance.
- Analyze 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, enhance data engineering processes, tools, and frameworks.
- Ensure compliance with data quality, security, and privacy standards across all data engineering activities.
- Participate in code reviews, provide constructive feedback, and ensure high-quality, maintainable code.
- Prepare and present technical documentation, including data flow diagrams, ETL specifications, and architectural designs.
Experience:
- 8 - 10 Years
Location:
- Pune
- Chennai
Educational Qualifications:
- Engineering Degree BE/ME/BTech/MTech/BSc/MSc.
- Cloud certifications (AWS, etc.) and relevant technical certification in multiple technologies is desirable.
Skills:
Mandatory Technical Skills:-- Should have strong experience in Snowflake and must have executed development and migration projects involving Snowflake
- Should have strong working experience in ETL tools (Matillion/ DBT/Fivetron/ADF preferably)
- Experience in SQL writing including flatten tables and experience in JSON will be good to have, and able to write complex queries.
- Strong understanding of SQL queries, good coding experience on Python, deploying into Snowflake data warehousing, pipelines
- Experience in large databases
- Working knowledge of AWS (S3, KMS, and more) or Azure/GCP
- Design, develop, and thoroughly test new ETL/ELT code, ensure accuracy, reliability, and adherence to best practices
- Snowflake
- Python/Spark/JavaScript
- AWS/Azure/GCP
- SQL
- CI/CD (DevOps)
- Terraform/Airflow
Our commitment
To combine the best of IT services, consulting, products, accelerators, and frameworks with a client-first mindset and next-gen tech understanding. Together, we're humanizing healthcare to make a positive impact on human lives.
What drives us
At CitiusTech, we believe in making a tangible difference in healthcare. We constantly explore new ways to transform the industry, from AI-driven solutions to advanced data analytics and cloud computing. Our collaborative culture, combined with a relentless drive for excellence, positions us as innovators reshaping the healthcare landscape, one solution at a time.
Life@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, nonhierarchical, 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 comprehensive benefits to ensure you have a long and rewarding career with us.
Our EVP
Be You Be Awesome is our EVP. It reflects our continuing efforts to create CitiusTech as a great workplace where our employees can thrive, personally and professionally. It encompasses the unique benefits and opportunities we offer to support your growth, wellbeing, 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.
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.
To learn more about CitiusTech, visit https://www.citiustech.com/careers and follow us on
Happy applying!