Data Architect

Job Overview:We are seeking an experienced Data Architect with over 10 years of expertise in SQL development and database architecture. The ideal candidate should have strong experience in ETL processes, data modeling, and performance optimization, particularly in handling large-scale data transactions (5 to 10 million records). Proficiency in AWS Redshift is essential.Role & responsibilities: Design, develop, test, deploy and troubleshoot SQL scripts, Stored Procedures that implement complex ETL processes.Must have experience in Query Optimization.Must be able to understand complex business logic, fine tune long-running queriesMust be expert at reverse engineering and extracting business requirements and rules from the code.Scheduling and monitoring the ETL jobs using SSIS.Build and review functional and business specifications Expert understanding of PostgreSQL, Stored Procedures, Views, and Functions.Provide the estimates for the ETL workDatabase/Data Warehouse performance tuning, monitoring and troubleshooting expertise.Expertise in query construction, including writing and optimizing complex SQL queries that contain sub queries, joins, and derived tablesTroubleshooting and fixing the codeUnit testing the code and documentation of resultsMust be expert at providing non-functional requirements.Help creating test data and provide support to QA process.Work with gate keeper on promoting the data stage jobs from QA to Production.Build, patch and data fix in production environment.Ensure very high availability to scale of 99.999%.Establish coding practices, best practices, and SoPs. Participate in code reviews and enforce relevant process. Strong analytical and thinking capabilities, good communication skills to conduct requirement gathering sessions/interview customersAbility to perform independent research to understand the product requirements and customer needsCommunicates effectively with the project teams and other stakeholders. Translate technical details to non-technical audience.Expert at creating architectural artifacts for Data Warehouse.Team, effort management.Ability to set expectations for the client and the team. Ensure all deliverables are delivered in time at highest quality. Technical Skills: ETL-SSISSQL Stored Procedure, Functions, Triggers etcQuery OptimizationServer monitoringETL:-AWS-GlueDBMS:-AWS Aurora MySQL, AWS Redshift, PostgreSQLCloud Services:-AWS cloud services, including EC2, RDS, S3, and IAM.Data Skills:- SQL Performance tuning.Coding:- knowledge of programming language like C#, Python or Java. To oversee dev resources.Team and people management.Agile scrum practicesGreat learning attitudeEagerness to take ownershipA global mindsetExcellent communication skills.Why QualiZeal?Award-Winning Workplace: Certified as a Great Place to Work® and recognized by ET NOW as the Best Organization for Women in 2025.Proven Engagement: Industry-recognized client and employee Net Promoter Scores (NPS).Growth-Focused Culture: Equal-opportunity employer with a strong emphasis on leadership development, training, and continuous learning.Flexible & Supportive Environment: We value empathy, recognize contributions, and support work-life balance.Transparent Leadership: Open-book management with a collaborative, inclusive approach.Rapid Growth: 850+ professionals strong and on track to reach 3000+ employees — an exciting time to join.About QualiZeal:QualiZeal is North America's fastest-growing independent digital quality engineering services company. With a diverse portfolio of digital transformation services encompassing Quality Engineering, Digital Engineering, Advisory and Transformation, and Emerging Technology Testing, QualiZeal empowers organizations of all sizes globally to achieve quality excellence and sustainable market leadership. Trusted by 70+ global enterprises and with a headcount of 850+ elite software quality engineers, QualiZeal is pioneering AI-enabled Quality Engineering innovation. QualiZeal has consistently maintained an outstanding client Net Promoter Score (NPS) of over 75, reflecting its unwavering commitment to client satisfaction and service excellence.