Job Description – Solution Architect / Tech Lead (Data & Analytics)
Position: Solution Architect / Tech Lead – Data & Analytics
Experience: 8+ Years
Location: Remote
Employment Type: Contract
Role Overview
We are seeking an experienced and highly skilled Solution Architect / Tech Lead – Data & Analytics to lead the design, development, and implementation of enterprise-scale data platforms and modern analytics solutions. The ideal candidate will possess strong expertise in cloud-based data lake and data warehouse architectures, big data technologies, ETL frameworks, and modern data engineering practices.
This role requires deep technical proficiency in AWS cloud services, Snowflake/Databricks ecosystems, data modeling, and scalable analytics platform design. The candidate will collaborate closely with business stakeholders, engineering teams, and cross-functional units to deliver high-performance and future-ready data solutions.
Key Responsibilities
- Define, drive, and align strategic initiatives related to enterprise Data & Analytics Architecture.
- Design and develop scalable Data Lakes and Data Warehouses capable of handling structured and unstructured data.
- Build and manage robust ETL/ELT pipelines to integrate data from multiple enterprise systems into centralized data platforms.
- Develop reusable and scalable solution architectures for ingesting data from ERP systems such as SAP and other enterprise applications.
- Architect near real-time and batch-based data processing solutions.
- Design and optimize modern data platforms using technologies such as Databricks, Snowflake, Redshift, HANA, Teradata, Exasol, or equivalent.
- Create scalable and efficient data warehouse solutions for analytics and reporting.
- Design and evaluate enterprise data models including:
- Star Schema
- Snowflake Schema
- Flattened Data Models
- Define data access patterns supporting both OLTP and OLAP workloads.
- Troubleshoot, triage, debug, and resolve technical issues related to Data Lakes and Data Warehouses.
- Enable secure and governed data sharing using modern data warehousing practices and tools.
- Collaborate with business stakeholders and technical teams across all phases of the Software Development Life Cycle (SDLC).
- Participate in major architectural and technical decision-making processes.
- Lead proof-of-concepts (POCs) and hands-on prototyping of emerging technologies and innovative solutions.
- Mentor development teams and provide technical leadership on best practices and architecture standards.
Required Skills & Qualifications
Mandatory Skills
- 8+ years of experience working on AWS Cloud with expertise in building enterprise-grade Data Lakes and Data Warehousing Architectures.
- 5+ years of experience designing and developing Data Warehouses using:
- Snowflake
- Amazon Redshift
- SAP HANA
- Teradata
- Exasol
- or equivalent technologies.
- 3+ years of hands-on experience with AWS Data Services such as:
- Amazon S3
- AWS Glue
- Lake Formation
- EMR
- Kinesis
- RDS
- DMS
- 3+ years of strong experience in Data Modeling.
- 3+ years of experience working with Apache Spark or equivalent big data technologies.
- 3+ years of experience building and managing Delta Lakes using technologies like Databricks.
- Strong understanding of ETL/ELT frameworks and modern data engineering practices.
- Experience designing scalable and high-performance data architectures.
- Strong analytical, debugging, and problem-solving skills.
- Excellent communication and stakeholder management abilities.
Preferred Qualifications
- Experience with real-time streaming and event-driven architectures.
- Knowledge of CI/CD pipelines and DevOps practices for data platforms.
- Familiarity with data governance, security, and compliance frameworks.
- AWS or Snowflake certifications will be an added advantage.
- Exposure to Agile/Scrum methodologies.
