Data Architect

In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.

As a leading Modernization Engineering company, we aim to deliver modernization-driven hypergrowth for our clients based on the deep differentiation we have created in Modernization Engineering, powered by our Lightening suite and 16-step Platformation™ playbook. In addition, we bring agility and systems thinking to accelerate time to market for our clients.

Headquartered in Bengaluru, India, Sonata has a strong global presence, including key regions in the US, UK, Europe, APAC, and ANZ. We are a trusted partner of world-leading companies in BFSI (Banking, Financial Services, and Insurance), HLS (Healthcare and Lifesciences), TMT (Telecom, Media, and Technology), Retail & CPG, and Manufacturing space. Our bouquet of Modernization Engineering Services cuts across Cloud, Data, Dynamics, Contact Centers, and around newer technologies like Generative AI, MS Fabric, and other modernization platforms.

We are seeking an experienced Data Architect with strong expertise in Azure Data Factory (ADF) and SQL Server to design, build, and optimize scalable data solutions. The ideal candidate will be responsible for defining data architecture standards, designing end-to-end data integration pipelines, and ensuring high performance, security, and reliability of enterprise data platforms.

• Design and implement enterprise-level data architectures using Azure and SQL Server technologies.
• Develop, manage, and optimize data integration pipelines using Azure Data Factory.
• Architect ETL/ELT workflows to ingest data from multiple sources (on-premises and cloud).
• Design and maintain SQL Server databases, including schemas, tables, indexes, and stored procedures.
• Ensure data quality, data governance, and data security best practices are followed.
• Optimize SQL queries and data pipelines for performance, scalability, and cost efficiency.
• Collaborate with business stakeholders, data engineers, and analytics teams to translate business requirements into technical solutions.
• Define data modeling standards (logical, physical, and dimensional models).
• Implement error handling, monitoring, and logging in Azure Data Factory pipelines.
• Support data migration initiatives from on-prem systems to Azure.
• Provide technical leadership, architecture reviews, and mentoring to development teams.
• Document architecture designs, data flows, and technical standards.

• Strong experience as a Data Architect or Senior Data Engineer.
• Hands-on expertise with Azure Data Factory (pipelines, triggers, linked services, datasets).
• Deep knowledge of SQL Server (T-SQL, performance tuning, indexing, partitioning).
• Experience with data modeling (OLTP and OLAP, star/snowflake schemas).
• Solid understanding of ETL/ELT concepts and data warehousing principles.
• Experience integrating data from REST APIs, flat files, relational databases, and cloud sources.
• Familiarity with Azure SQL Database / SQL Managed Instance.
• Knowledge of security concepts such as encryption, RBAC, and data access controls.
• Experience with CI/CD for data pipelines is a plus.
• Strong analytical, problem-solving, and communication skills.

At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.

• Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law.