Job Description

Architect, Principal

Department: Development

Employment Type: Full Time

Location: Hyderabad

A Typical Day in the Life Includes:

• Oversee the design, development, and deployment of the data warehouse and BI infrastructure, including the ETL (Extract, Transform, Load) processes, data modeling, and reporting tools.
• Collaborate with cross-functional teams, including business analysts, data engineers, and IT professionals, to understand business requirements and translate them into technical solutions.
• Develop and maintain a robust data governance framework, ensuring data quality, security, and compliance with relevant regulations.
• Optimize the performance and scalability of the BI and DW systems, implementing best practices and leveraging the latest technologies.

• Mentor and lead a team of BI/DW specialists, fostering a culture of continuous learning and innovation.
• Stay up-to-date with industry trends and emerging technologies, and recommend strategic initiatives to enhance the company's data and analytics capabilities.
• Design, develop, and maintain a robust, scalable, and efficient data warehouse architecture to support the organization's business intelligence and reporting needs.
• Collaborate with business stakeholders to understand their data and reporting requirements, and translate them into technical solutions.
• Oversee the implementation and integration of data extraction, transformation, and loading (ETL) processes to ensure data accuracy, completeness, and timeliness.
• Develop and optimize complex SQL queries, stored procedures, and other database objects to support advanced data analysis and reporting.
• Implement and maintain data quality and data governance processes to ensure the reliability and integrity of the data warehouse.
• Provide technical leadership and mentorship to the data warehouse team, guiding and supporting their professional development.
• Continuously monitor and optimize the performance of the data warehouse infrastructure, addressing any bottlenecks or issues that may arise.
• Collaborate with the IT team to ensure the data warehouse is integrated with other systems and applications, and that it aligns with the organization's overall technology strategy.
• Stay up-to-date with industry trends and advancements in data warehouse technologies, and recommend and implement appropriate solutions to enhance the organization's business intelligence capabilities.

Basic Qualifications:

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• Extensive experience (10+ years) in BI/DW architecture, design, and implementation, preferably in a team lead role.
• Proficient in data modeling, ETL processes, and the use of BI tools (e.g., Tableau, Power BI, Qlik).
• Strong knowledge of database technologies (e.g., SQL Server, Oracle, PostgreSQL) and cloud-based data platforms (e.g., Azure, AWS, GCP).
• Excellent problem-solving, analytical, and communication skills, with the ability to translate technical concepts into business-friendly language.
• Experience in project management and leading cross-functional teams.
• Familiarity with Agile methodologies and DevOps practices.