Data Architect at Motifworks- An Accionlabs · Pune · 10 - 18 years · ₹15L - ₹45L / yr · Profitable · Posted 28 Jul 2023

6+ years’ experience in Azure architecture, Azure Data Services, design and development. Significant experience as DW architect on several initiatives. • Rich Data/Dimensional modeling expertise • Expert knowledge of Azure tools and services centered around data and analytics (Azure Synapse, Data Lake, Data Factory etc.) • Experience designing and building complete ETL processes moving and transforming data from ODS, Staging and Data Warehousing, cloud and hybrid. Education and Experience: • Bachelor’s Degree in computer science or related field required. • 10 or more years’ experience managing and designing systems in an enterprise infrastructure environment required.

About Motifworks- An Accionlabs
About
Similar jobs (10)
Solution Architect – AZURE Data Engineering
Job Overview
We are looking for an experienced Solution Architect – Data Engineering with strong expertise in designing data solutions and hands-on experience with Azure, Synapse, PySpark, Data Warehousing, and Data Lakes. The ideal candidate should have strong architectural and data engineering knowledge.
Key Responsibilities
- Design and implement scalable data architecture and solutions.
- Develop and manage Data Warehouse and Data Lake architectures.
- Design data platforms using Medallion Architecture.
- Lead Data Engineering and ETL activities.
- Work with Azure Synapse Analytics for data processing and analytics.
- Develop data solutions using PySpark / Apache Spark.
- Define and implement data validation and data quality processes.
- Collaborate with business, data, and technology teams to deliver effective data solutions.
Required Skills
- Strong experience in Solution Architecture / Data Architecture.
- Strong knowledge of Data Warehouse and Data Lake architecture.
- Good understanding of Medallion Architecture.
- Strong experience in Data Engineering and ETL.
- Hands-on experience with Microsoft Azure and Azure Synapse Analytics.
- Strong knowledge of PySpark / Apache Spark.
- Experience with Data Validation and Data Quality.
- Good communication and stakeholder management skills.
Experience
8+ Years
Job Description
We are looking for an experienced Azure Synapse Data Engineer with strong hands-on expertise in Azure data engineering, data warehousing, ETL/ELT, and SQL performance optimization.
Key Responsibilities
- Design, develop, and optimize solutions using Azure Synapse Analytics.
- Build and maintain data integration pipelines using Azure Data Factory (ADF) and Synapse Pipelines.
- Design and implement scalable Azure Data Lake Storage Gen2 (ADLS Gen2) architectures.
- Develop robust and high-performance ETL/ELT frameworks for enterprise data platforms.
- Monitor and troubleshoot large-scale data ingestion, transformation, and processing workloads.
- Identify and resolve performance bottlenecks across data movement and transformation processes.
- Ensure data quality, availability, reliability, and consistency across analytics platforms.
- Perform advanced SQL query analysis and optimization.
- Analyze execution plans and optimize complex analytical workloads.
- Configure and tune Synapse Dedicated SQL Pools.
- Design efficient partitioning strategies for large datasets.
- Optimize indexing, statistics, and workload distribution to improve query performance.
Mandatory Skills
- Azure Synapse Analytics
- Azure Data Factory (ADF)
- Synapse Pipelines
- ADLS Gen2
- ETL/ELT
- Strong SQL
- Synapse Dedicated SQL Pool
- SQL query/execution plan optimization
- Partitioning, indexing, and statistics
- Azure data warehouse / data lake architecture
- Performance tuning and troubleshooting
Ideal Candidate
A strong Azure Data Engineer with hands-on experience in Synapse + ADF + ADLS Gen2 + Advanced SQL + Dedicated SQL Pool performance tuning.
Position: Technical Architect – Data Engineering
Job Summary:
- We are looking for an experienced Technical Architect to lead the design and implementation of modern cloud-based data platforms.
- The ideal candidate should have strong expertise in Azure and/or AWS, Databricks, Snowflake, modern data architecture, and large-scale data engineering.
- The candidate will work closely with business stakeholders, architects, and engineering teams to deliver scalable, secure, and high-performance data solutions.
Key Responsibilities
• Design enterprise-scale data lakehouse and data warehouse architectures.
• Define data ingestion, transformation, and serving architecture.
• Lead architecture discussions and technical governance.
• Design scalable ETL/ELT frameworks using Databricks and Snowflake.
• Define best practices for security, performance, CI/CD, and DevOps.
• Guide engineering teams on implementation.
• Collaborate with business, product, and data governance teams.
Must Have Skills :
• Azure or AWS
• Databricks
• Snowflake
• Data Lakehouse Architecture
• PySpark
• SQL
• Data Modelling
• ETL/ELT Architecture
• Performance Optimization
• CI/CD
• Terraform or Infrastructure as Code (preferred)
Preferred
• Insurance domain
• dbt
• Unity Catalog
• Delta Lake
• Iceberg
• Azure Data Factory / AWS Glue
Technical Lead
Job Description
Role Overview
We are seeking a highly skilled Data Engineering Lead with minimum of 5 years of hands-on experience in Azure data engineering, data warehousing, and automation-driven integration. The ideal candidate should be a proven technical lead, capable of driving end-to-end
project delivery and working closely with customer teams. This is a Work from Office / Customer Site role.
Roles and Responsibilities
• Lead the design, development, and delivery of data engineering and automation projects.
• Architect and implement ETL/ELT pipelines using Azure Data Factory.
• Design and manage enterprise data warehouses including dimensional modeling and
schema optimization.
• Manage Azure components including Storage Accounts, Data Lakes, Azure SQL, and Synapse.
• Drive automation initiatives across data ingestion and transformation workflows.
• Collaborate with business and technical stakeholders to translate requirements into scalable solutions.
• Mentor team members and enforce engineering best practices.
• Serve as the technical anchor responsible for ensuring high-quality, on-time delivery.
Skills and Qualification
• Strong hands-on experience with Azure Data Factory, Azure Storage, Azure SQL/Synapse.
• Deep understanding of data warehousing concepts: star/snowflake schemas, fact/dimension modeling.
• Experience with automation-led data engineering solutions.
• Strong troubleshooting, optimization, and analytical skills.
• Excellent communication and stakeholder management abilities.
• Proven experience as a Technical Lead leading teams and delivery.
Must Have
• Min of 5 years of relevant data engineering experience.
• Strong Azure Data Engineering and Data Warehousing expertise.
• Proven Technical Lead experience.
• Ability to work from office and customer site.
• Strong ownership mindset with a focus on quality and delivery excellence.
Location: Bangalore Experience: 5 to 7 years Employment type: Full-time, permanent Work Hours: General Shift (10.00 AM to 7.00 PM) website: www.amazech.com Qualifications: Minimum B.E./B.Tech, or higher in Computer Science, Information Technology, Data Engineering, or a related field, with a good academic background. Key Responsibilities: • Design, develop, and maintain end-to-end data pipelines. • Build and optimize ETL/ELT processes for large-scale data processing. • Implement Azure-based data solutions ensuring scalability and performance. • Collaborate with stakeholders to understand business data requirements. • Perform performance tuning and optimization across data platforms. • Support production environments, conduct root cause analysis, and resolve data-related issues. • Maintain comprehensive technical documentation and structured knowledge transfer documents. • Work effectively within Agile/Scrum frameworks and contribute to sprint planning and delivery. • Ensure secure and compliant data handling using Azure best practices. Required Skills & Experience • End-to-end ETL/ELT pipeline development, integration, and performance optimization • Azure Synapse, Azure Logic Apps, Azure SQL, and Azure Databricks, with a strong focus on performance tuning • Microsoft Azure services, including Storage Accounts, Key Vault, and Cognitive Services • Advanced proficiency in Python development and modern productivity tools such as GitHub Copilot and Cursor • Strong documentation discipline, including technical design documentation, and structured knowledge transfer documents • Experience operating within Agile/Scrum frameworks, including production support, root cause analysis, and effective stakeholder collaboration
Job Description:
Experience: 10+ Years
Job Summary
We are looking for an experienced Azure Fabric Data Architect to lead the design and implementation of an enterprise data platform on Microsoft Fabric. The role involves architecting scalable data solutions, defining data governance, and enabling AI-driven analytics for a global financial services client.
Key Responsibilities
- Design end-to-end data architecture using Microsoft Fabric.
- Build enterprise Lakehouse, Data Warehouse, and OneLake solutions.
- Define data ingestion, ETL/ELT, governance, security, and performance strategies.
- Lead architecture for AI-powered analytics, AI Agents, and enterprise chatbots using Azure AI services.
- Work with business stakeholders to translate requirements into technical solutions.
- Mentor engineering teams and provide technical leadership.
Required Skills
- Microsoft Fabric (Data Factory, Lakehouse, Data Warehouse, OneLake)
- Azure Data Engineering
- Power BI
- Azure AI Services / Azure OpenAI
- Data Architecture & Data Modeling
- SQL, Python
- Azure DevOps, CI/CD
- Strong stakeholder management and solution design experience
Preferred: Experience in Capital Markets or Financial Services and Microsoft Azure/Fabric certifications.
NOTE: One technical round is mandatory to be taken F2F from office.
About the Role
We are looking for an experienced Power BI Architect to lead enterprise-wide BI initiatives. This role will be responsible for designing, implementing, and governing scalable Power BI solutions across the organization. The ideal candidate will play a key role in establishing best practices, driving adoption, and owning the overall BI architecture within the Center of Excellence (CoE).
Key Responsibilities
- Lead end-to-end implementation of Power BI solutions across the enterprise
- Design scalable, secure, and high-performance BI architecture
- Act as the Power BI Architect, providing technical leadership and direction
- Own and drive BI governance, standards, and best practices within the CoE
- Collaborate with business and technology teams to translate requirements into robust BI solutions
- Define data modeling strategies, reporting frameworks, and dashboard standards
- Ensure data accuracy, consistency, and performance optimization across reports
- Support and guide development teams in Power BI implementation
- Enable enterprise-wide adoption of Power BI through training, documentation, and mentorship
- Work closely with IT/technology teams to integrate Power BI with data platforms and enterprise systems
Required Skills & Qualifications
- 10+ years of experience in BI/Data Analytics, with strong focus on Power BI
- Proven experience in enterprise-wide Power BI implementation
- Strong expertise in:
- Power BI (Desktop, Service, Gateway, Dataflows)
- Data Modeling (Star Schema, Snowflake Schema)
- DAX, Power Query (M language)
- Experience in designing and implementing BI architecture at scale
- Strong understanding of data warehousing concepts and ETL processes
- Experience working within a Center of Excellence (CoE) model
- Excellent stakeholder management and communication skills
Preferred Skills
- Experience with Azure (Azure Synapse, Data Factory, Data Lake)
- Knowledge of DevOps practices for Power BI (CI/CD pipelines)
- Exposure to governance tools and security frameworks
- Certification in Power BI / Microsoft Data Platform
Job Summary
The Technical Lead will be responsible for overseeing and leading projects related to Azure Data Factory (ADF), Azure Databricks, SQL, Oracle PL/SQL, and Python. The role involves designing, developing, and implementing data solutions while ensuring they meet the business requirements and align with best practices. (1.) Key Responsibilities
1. Lead and manage end-to-end data engineering projects using azure data factory, azure databricks, sql, oracle pl/sql, and python.
2. Collaborate with stakeholders to gather and understand requirements for data pipelines and analytics solutions.
3. Design and develop etl processes, data models, and data integration solutions.
4. Provide technical guidance and mentorship to the team members.
5. Ensure data quality, data governance, and data security standards are maintained throughout the project lifecycle.
6. Troubleshoot and optimize data pipelines and processes for performance and efficiency.
7. Stay updated on the latest trends and technologies in data engineering and contribute to continuous improvement efforts.
Skill Requirements
1. Proficiency in azure data factory (adf) and azure databricks for building and managing data pipelines.
2. Strong experience with sql and oracle pl/sql for data querying and manipulation.
3. Advanced programming skills in python for scripting and data processing tasks.
4. Knowledge of data modeling, data warehousing concepts, and database design principles.
5. Ability to work in a collaborative team environment and communicate effectively with stakeholders.
6. Strong analytical and problem-solving skills with attention to detail.
7. Experience in data visualization tools and techniques is a plus.
Certifications: Relevant certifications in Azure Data Factory, Azure Databricks, SQL, Oracle PL/SQL, or Python are advantageous.
Skill (Primary)
Data Fabric-Azure-Azure Data Factory (ADF)
Data Architect – Databricks & AWS
- Strong experience in Data Architecture, Data Engineering, Databricks, Apache Spark/PySpark, Python, and Advanced SQL.
- Design and implement scalable ETL/ELT pipelines, data platforms, and Lakehouse architectures using Medallion Architecture.
- Experience with Databricks, Databricks Workflows, Unity Catalog OR Databricks Jobs
- Strong knowledge of Delta Lake, Databricks Workflows, Delta Live Tables (DLT), and dimensional data modeling.
- Hands-on experience with AWS services such as S3, Glue, IAM, Lambda, and CloudWatch.
- Experience with Apache Airflow, Data Warehouse concepts, Git/CI-CD, performance optimization, and data quality.
- Good to have exposure to Kafka/Structured Streaming, Unity Catalog, and modern data governance.
Data Engineer
Experience - 5+ years
6-7 LPA
Remote
Duration: 1 month contract (We can take as a tentative, It can be extended)
Scope: Subscriber Activation, Churn, FTE and future reporting requirements, with BigQuery as the centralized data warehouse and Power BI as the proposed reporting layer.
Key Skills:
Strong hands-on experience with GCP & BigQuery
Data warehouse architecture, design and implementation
Data ingestion/integration across multiple source systems
ETL/ELT and data pipeline development
Data modelling for reporting and analytics
Experience integrating BigQuery with Power BI or similar reporting tools













