Job Description
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.
* Data Engineering & Integration:
* 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.
* Cloud & Big Data Technologies:
* 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.
* Implement data governance frameworks (Collibra, Alation, Microsoft Purview).
* Ensure compliance with GDPR, HIPAA, SOC2, and other regulatory requirements.
* Leadership & Collaboration:
* 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).
* Deep expertise in Azure Data Platform (Fabric, Synapse, Data Factory, Databricks, ADLS, Purview ).
* 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.
* Microsoft Certified: Azure Data Engineer Associate.
* AWS Certified Data Analytics - Specialty.
* Databricks Certified Data Engineer Associate/Professional.
* Snowflake Data Cloud Certification.
* Google Professional Data Engineer.
* TOGAF 9 Certification (Enterprise Architecture).
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.
The preceding job description had been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties and responsibilities required of employees assigned to this job.
What we offer:
You will find here not only a challenging and interesting workplace, but also a rewarding work experience, with competitive compensation and benefit packages:
* Soft skills and technical training for current and emerging products and technologies;
* Career development: opportunity to grow within the team;
* Meal card;
* Flexible working hours and work from home, aligned with project needs;
* Friendly team who is eager to meet you.
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!
What's next?
It's best to apply today, because job postings can be taken down and we wouldn't want you to miss this opportunity.
The recruitment process starts with an HR discussion, followed by a technical test and a final talk with the hiring manager.
About Us
We are a Brazilian company with over 35 years of experience in delivering IT services worldwide, ranging from IT outsourcing to application development or IT staffing. We have a direct presence in 41 countries, through our 70 offices located throughout the world. We have managed to become the preferred partner of many small-to-midsize local and regional companies as well. Most of our clients come from industries such as financial services, manufacturing, telecommunications, chemical, services, technology, the public sector, and utilities.
Stefanini has career opportunities locally and around the world for professionals interested in a vibrant, passionate, team-oriented workplace. If you are a customer-centric person with a "get it done" attitude, come over for coffee and a talk on your future career with us!
Learn more about us at www.stefanini.com and join us on LinkedIn, Facebook, and Instagram where we regularly post insights from our colleagues.