Senior Data Architect

We are looking for a highly skilled Senior Data Architect with 10+ years of hands-on experience in various data-centric roles such as DBA, SQL Developer, Data Engineer, BI Developer, and Data Analyst.

The ideal candidate must have at least 5 years of experience as a Data Architect, designing and implementing enterprise-scale data solutions across on-premise and cloud platforms (Microsoft, AWS, Azure).

This role requires deep technical expertise, strategic thinking, and a strong ability to work across multiple teams to build scalable, high-performing, and cost-efficient data architectures.

Key Responsibilities :

• Data Architecture & Strategy :
• Design, develop, and optimize scalable, high-availability data architectures across on-premise (SQL Server, SSIS, SSRS, SSAS) and cloud platforms (Azure, AWS, Databricks, Snowflake, BigQuery, Synapse Analytics).
• Define data governance, security, and compliance strategies in line with industry best practices.
• Establish data integration strategies between legacy systems and modern cloud environments.
• Provide roadmaps for data modernization and cloud migration initiatives.
• Architect and implement ETL / ELT pipelines using Azure Data Factory, AWS Glue, SSIS, or similar technologies.
• Enable real-time data streaming using Kafka, Event Hubs, or Kinesis.
• Ensure seamless data integration across various structured, semi-structured, and unstructured data sources.
• Define best practices for data storage, performance tuning, indexing, and partitioning.
• Data Modeling & Warehousing :
• Design enterprise data models (OLTP & OLAP) for high-performance analytics.
• Architect data lakes, data warehouses, and data marts on Azure Synapse, Snowflake, AWS Redshift, Databricks, or similar platforms.
• Optimize dimensional modeling, star / snowflake schemas, and data partitioning strategies.
• Build and manage data platforms preferably on Azure (Synapse, Databricks, Data Factory, Data Lake), AWS (Redshift, Glue, S3, Athena), or GCP (BigQuery, Dataflow).
• Implement serverless data solutions (AWS Lambda, Azure Functions) for cost-effective processing.
• Security, Compliance & Governance :
• Ensure data security through encryption, RBAC, and data masking techniques.
• Ensure compliance with GDPR, HIPAA, SOC2, and other regulatory requirements.
• Provide technical leadership and mentorship to Data Engineers, Analysts, and Developers.
• Collaborate with cross-functional teams including DevOps, ML Engineers, and Product Owners to define data strategies.
• Work closely with business stakeholders to ensure alignment between data initiatives and business goals.

Job Requirements

Core Expertise :

• Experience : 10+ years in Data-related roles | 5+ years as a Data Architect
• Strong experience with SQL Server, PostgreSQL, MySQL, NoSQL (CosmosDB, MongoDB, Cassandra).
• Proficiency in ETL / ELT pipelines using SSIS, ADF, dbt, Glue.
• Strong programming skills in Python, SQL, Scala (nice to have), PowerShell.
• Hands-on experience in data security, data lineage, data governance frameworks.
• Excellent understanding of data modeling, indexing, partitioning, and query optimization.
• Education : Master's in Computer Science, Data Science, Information Systems, or a related field.

Certifications (any relevant Cloud and Data related certifications) :

• Microsoft Certified : Azure Solutions Architect Expert.
• AWS Certified Data Analytics - Specialty.
• Snowflake Data Cloud Certification.
• Google Professional Data Engineer.

Nice to Have :

• Experience with Graph databases (Neo4j, CosmosDB Graph, Amazon Neptune).
• Exposure to machine learning pipelines (Azure ML, AWS Sagemaker, Databricks MLflow).
• Knowledge of Infrastructure as Code (Terraform, Bicep, CloudFormation).
• Familiarity with CI / CD in data environments (Azure DevOps, GitHub Actions, Jenkins, Airflow).

Why Join Us?

• Collaborate with a dynamic and innovative team focused on driving business transformation through data.
• Work on diverse and challenging projects across industries.
• Opportunity to leverage cutting-edge BI tools and technologies to create impactful solutions.
• Continuous learning and professional development through training, certifications, and industry exposure.
• Competitive compensation, benefits, and a positive work culture that values growth and collaboration.

Diversity & Inclusion

Here at the Stefanini Group, we value plurality and equity, regardless of race, sexual orientation, disability, age, ancestry, religion, gender, and nationality. We understand and encourage the importance of being you!