Senior Data Architect

We are seeking 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.

• 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.

• 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.

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

• 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).

You will be part of a dynamic and innovative team focused on driving business transformation through data. You will work on diverse and challenging projects across industries and have the opportunity to leverage cutting-edge BI tools and technologies to create impactful solutions.

You will also have continuous learning and professional development through training, certifications, and industry exposure. And you will enjoy competitive compensation, benefits, and a positive work culture that values growth and collaboration.

Here at 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.