Hi ,
Greetings from Nitor infotech!
Data Architect
This role involves collaborating with cross-functional teamsengineering, analytics, product, and business stakeholdersto create scalable, reliable, and high-performing data solutions that support advanced analytics, BI reporting, and operational workflows.
Key Responsibilities
1. Data Architecture & Design
- Design and implement scalable, secure, and high-performance
data architectures
on Azure. - Develop
data models, data flows, and metadata layers
supporting analytics and operational requirements. - Architect solutions using
Delta Lake, Parquet, Lakehouse patterns, Data Mesh, or Data Fabric
(depending on needs).
2. Data Engineering & Pipelines
- Build and optimize
ETL/ELT pipelines
using Azure Databricks, Azure Data Factory, and Azure Synapse. - Manage ingestion of structured and unstructured data into
Azure Data Lake Storage (ADLS)
in Parquet
format. - Ensure data quality, lineage, governance, and documentation.
3. SQL & Storage Optimization
- Write and optimize complex
SQL queries
for analytics and operational workloads. - Optimize storage layers, partitioning, indexing, caching, and query performance.
4. Azure Cloud Ecosystem
- Leverage Azure services such as:
- Azure Data Lake (ADLS)
- Azure Databricks
- Azure Data Factory (ADF)
- Azure Synapse Analytics
- Azure SQL Database / Managed Instance
- Azure Purview (Governance)
- Azure DevOps (CI/CD for data)
5. Business Intelligence & Analytics
- Partner with BI teams to design semantic layers for
Power BI
dashboards. - Ensure efficient datasets, DAX best practices, dataflows, and governance for Power BI consumers.
6. Collaboration & Leadership
- Work closely with Product, Engineering, and Analytics teams to understand data requirements.
- Lead data solution design reviews, enforce best practices, and guide engineering teams.
- Support data governance, security, compliance, and data lifecycle management initiatives.
Required Skills & Experience
Technical Skills
Strong SQL
expertise (queries, optimization, stored procedures).- Hands-on experience with
Azure Databricks
(PySpark, Delta Lake). - Experience working with
Parquet
and columnar data formats. - Solid understanding of
data modeling
techniques (OLTP, OLAP, star schema, data vault). - Strong expertise in
Power BI
(datasets, DAX, performance tuning). - Strong command over
Azure data services
. - Experience with
CI/CD
using Azure DevOps for data pipelines.
Azure Cloud Ecosystem
- Leverage Azure services such as:
- Azure Data Lake (ADLS)
- Azure Databricks
- Azure Data Factory (ADF)
- Azure Synapse Analytics
- Azure SQL Database / Managed Instance
- Azure Purview (Governance)
- Azure DevOps (CI/CD for data)
Wish you all the best!
Thanks & Regards,
VIGNESH
6379146150