Data Architect

Experience: 7+ Years

Location: Noida

Key Responsibilities:

Data Architecture Design:

• Design, develop, and maintain the enterprise data architecture, including data models, database schemas, and data flow diagrams.
• Develop a data strategy and roadmap that aligns with the business objectives and ensures the scalability of data systems.
• Architect both transactional (OLTP) and analytical (OLAP) databases, ensuring optimal performance and data consistency.

Data Integration & Management:

• Oversee the integration of disparate data sources into a unified data platform, leveraging ETL/ELT processes and data integration tools.
• Design and implement data warehousing solutions, data lakes, and/or data marts that enable efficient storage and retrieval of large datasets.
• Ensure proper data governance, including the definition of data ownership, security, and privacy controls in accordance with compliance standards (GDPR, HIPAA, etc.).

Collaboration with Stakeholders:

• Work closely with business stakeholders, including analysts, developers, and executives, to understand data requirements and ensure that the architecture supports analytics and reporting needs.
• Collaborate with DevOps and engineering teams to optimize database performance and support large-scale data processing pipelines.

Technology Leadership:

• Guide the selection of data technologies, including databases (SQL/NoSQL), data processing frameworks (Hadoop, Spark), cloud platforms (Azure is a must), and analytics tools.
• Stay updated on emerging data management technologies, trends, and best practices, and assess their potential application within the organization.

Data Quality & Security:

• Define data quality standards and implement processes to ensure the accuracy, completeness, and consistency of data across all systems.
• Establish protocols for data security, encryption, and backup/recovery to protect data assets and ensure business continuity.

Mentorship & Leadership:

• Lead and mentor data engineers, data modelers, and other technical staff in best practices for data architecture and management.
• Provide strategic guidance on data-related projects and initiatives, ensuring that all efforts are aligned with the enterprise data strategy.

Required Skills & Experience:

Extensive Data Architecture Expertise:

• Over 7 years of experience in data architecture, data modeling, and database management.
• Proficiency in designing and implementing relational (SQL) and non-relational (NoSQL) database solutions.
• Strong experience with data integration tools (Azure Tools are a must + any other third party tools), ETL/ELT processes, and data pipelines.

Advanced Knowledge of Data Platforms:

• Expertise in Azure cloud data platform is a must. Other platforms such as AWS (Redshift, S3), Azure (Data Lake, Synapse), and/or Google Cloud Platform (BigQuery, Dataproc) is a bonus.
• Experience with big data technologies (Hadoop, Spark) and distributed systems for large-scale data processing.
• Hands-on experience with data warehousing solutions and BI tools (e.g., Power BI, Tableau, Looker).

Data Governance & Compliance:

• Strong understanding of data governance principles, data lineage, and data stewardship.
• Knowledge of industry standards and compliance requirements (e.g., GDPR, HIPAA, SOX) and the ability to architect solutions that meet these standards.

Technical Leadership:

• Proven ability to lead data-driven projects, manage stakeholders, and drive data strategies across the enterprise.
• Strong programming skills in languages such as Python, SQL, R, or Scala.

Certification:

• Azure Certified Solution Architect, Data Engineer, Data Scientist certifications are mandatory.

Pre-Sales Responsibilities:

• Stakeholder Engagement: Work with product stakeholders to analyze functional and non-functional requirements, ensuring alignment with business objectives.
• Solution Development: Develop end-to-end solutions involving multiple products, ensuring security and performance benchmarks are established, achieved, and maintained.
• Proof of Concepts (POCs): Develop POCs to demonstrate the feasibility and benefits of proposed solutions.
• Client Communication: Communicate system requirements and solution architecture to clients and stakeholders, providing technical assistance and guidance throughout the pre-sales process.
• Technical Presentations: Prepare and deliver technical presentations to prospective clients, demonstrating how proposed solutions meet their needs and requirements.

Additional Responsibilities:

• Stakeholder Collaboration: Engage with stakeholders to understand their requirements and translate them into effective technical solutions.
• Technology Leadership: Provide technical leadership and guidance to development teams, ensuring the use of best practices and innovative solutions.
• Integration Management: Oversee the integration of solutions with existing systems and third-party applications, ensuring seamless interoperability and data flow.
• Performance Optimization: Ensure solutions are optimized for performance, scalability, and security, addressing any technical challenges that arise.
• Quality Assurance: Establish and enforce quality assurance standards, conducting regular reviews and testing to ensure robustness and reliability.
• Documentation: Maintain comprehensive documentation of the architecture, design decisions, and technical specifications.
• Mentoring: Mentor fellow developers and team leads, fostering a collaborative and growth-oriented environment.

Qualifications:

• Education: Bachelor's or master's degree in computer science, Information Technology, or a related field.
• Experience: Minimum of 7 years of experience in data architecture, with a focus on developing scalable and high-performance solutions.
• Technical Expertise: Proficient in architectural frameworks, cloud computing, database management, and web technologies.
• Analytical Thinking: Strong problem-solving skills, with the ability to analyze complex requirements and design scalable solutions.
• Leadership Skills: Demonstrated ability to lead and mentor technical teams, with excellent project management skills.
• Communication: Excellent verbal and written communication skills, with the ability to convey technical concepts to both technical and non-technical stakeholders.