AWS Redshift Data 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 an
AWS Redshift Data Architect
, you will be a part of an Agile team responsible for designing, implementing, and optimizing the enterprise data warehouse solution on AWS Redshift as part of the Teradata to AWS migration program. This role will lead the architecture and design of Redshift clusters, data modeling, performance tuning, and integration with ETL, BI, and ML components.

Responsibilities: -

• Lead the design and architecture of AWS Redshift clusters, including sizing, workload management, and security.
• Define and implement data modeling strategies aligned with business and analytical requirements.
• Collaborate with ETL, BI, and ML teams to ensure seamless integration with DataStage, Alteryx, Tableau, and SageMaker.
• Oversee schema migration from Teradata using AWS SCT and DMS tools.
• Drive performance tuning of Redshift queries, workloads, and resource management.
• Implement security best practices, including IAM roles, encryption, and access control.
• Support data validation and reconciliation efforts.
• Provide technical leadership and guidance to data engineers and developers.
• Participate in code reviews, design sessions, and architecture governance forums.
• Collaborate with stakeholders to define and implement data governance, lineage, and metadata strategies.

Experience: -

• 10+ years

Location: -

• This role is remote-friendly. Candidates must reside in or be authorized to work in the United States.

Educational Qualifications: -

• Engineering Degree – BE/ME/BTech/MTech/BSc/MSc.
• Technical certification in multiple technologies is desirable.

Skills: -

Mandatory skills

• 12–15 years of experience in data architecture, with at least 5 years on AWS Redshift.
• Strong expertise in Redshift internals, Spectrum, RA3 nodes, and concurrency scaling.
• Proficient in SQL performance tuning, workload management.
• Experience with AWS services: S3, DataZone, IAM, CloudWatch, CloudTrail.
• Familiarity with ETL tools (DataStage, Alteryx) and BI tools (Tableau).
• Hands-on experience with schema conversion tools (SCT) and data migration strategies.
• Knowledge of data governance, cataloging, and metadata management.
• Excellent communication and stakeholder management skills

Good to have skills: -

• AWS Certified Data Analytics – Specialty or Solutions Architect certification.
• Experience in healthcare data platforms and HIPAA-compliant architectures.
• Exposure to AI/ML pipelines and integration with SageMaker.

Salary:

The estimated salary range for this position is $135,000 to $150,000 annually. Final compensation will be based on experience, skills, and location. We offer a comprehensive benefits package including medical, dental, and vision insurance, paid time off, parental leave, and other benefits.

CitiusTech is an Equal Opportunity Employer.
We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

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, visit