• Phone: +1-425-502-5094
  • info@deevita.com

Data Warehouse Architect – Azure Synapse & Power BI

Job Location: OMR, Chennai.

About Deevita:

DeeVita is looking for an expert level Data Warehouse Architect with specialization in Azure Synapse, Analysis Services and Power BI to be part of a global team that is building product for Financial industry on Microsoft Azure platform. The person will be leading efforts to build enterprise scale Analytics systems. The position requires someone with deep knowledge & experience in Data Architecture, Data Warehouse Concepts, and enterprise scale Reporting and analytical systems. Must have experience in various data related roles including but not limited to data systems architecting, design and development, implementing large scale enterprise applications and analytical solutions and leading team of junior developers to deliver solutions. Preferred experience in Financial /Banking domain.


  • Understand client requirements holistically both current and prospective, participate in discussions and drive discussions that brings clarity and details that can have positive influence on overall quality.
  • Design holistic system, sub systems and develop system design document that outlines implementation scope for entire team; review & get sign off from all stakeholders and set expectations.
  • Engage with Customers and stakeholders in all phases of project life cycle – requirements gathering, solution design reviews, development, testing, UAT, delivery and support.
  • Deliver innovation in design and solutions leveraging latest best practices Date warehouse, Data Analytics and Azure Cloud platform.
  • Evangelize across the team to adopt best practices, and continuously keep updated oneself on latest technologies.
  • Ensure the design proposal makes balanced tradeoff across schedule, cost, technology, security, and compliance requirements.
  • Roll off sleeves to get hands on with development efforts at any level, assisting developers and/or developing oneself to keep project going.
  • Mentor team of engineers from database developers, analytical experts and data integration/visualization engineers providing technical & non-technical guidance to help them grow their skills, deliver quality implementations for successful completion of projects.
  • Sets best practices for data systems development and diligently enforces them across the projects through combination of process, education, training, and sufficient review processes.
  • Ensure quality of team members consistently meets/exceeds set standards and expectations.
  • Occasional travel to client and partner locations

Required Qualifications:

  • 12-15 years of relevant experience in architecting, design, and development of data warehouse systems (SQL Server based on Cloud/on premise and Analytics) at enterprise scale.
  • At least 5+ years of experience in building end to end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.
  • At least 2+ years’ experience in Data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database.
  • At least 1+ years’ experience in building data warehouse/analytical systems using Azure Synapse product, Power BI Architecture and Report delivery
  • Masters/Bachelor's degree in computer science/engineering or related fields
  • Must have at least 5+ years of experience in technical leadership role in driving design, architecture of large-scale transactional system and analytics systems involving Service Oriented /3-tier architecture.
  • Must be hands on, deeply technical and exposure to latest features within data platform development, able to do both coding and guide group of junior/mid-level database engineers.
  • Must have at least 3+ experience in managing technical team and leading them to deliver large scale solutions.
  • Must have excellent communication skills (English) to interface with US clients directly and verify in proficient in all types of communication modes – Listening, Reading, Writing and Speaking
  • Must have strong experience in Performance Tuning / Optimization Initiatives using DB Profiler tools
  • Combination of working in a startup for few years and in large company/product for few years.
  • Financial domain experience in dealing with industry specific data and exposure to relevant regulatory and compliance requirements.
  • Ability to act independently to resolve issues, excellent communication (English) and interpersonal skills, strong critical & analytic thinking.
  • Ability to manage team a through the entire development life cycle and to manage time effectively.

Preferred Qualifications:

  • Experience with FIS (Financial Information Services) APIs
  • Experience with Bonds, Securities trading, and related systems
  • Experience with NoSQL technologies such as MongoDB
  • Experience in Data Visualization tools like Power BI
  • Experience in building reporting systems on the cloud, data ingestion, data platform development using open-source technologies and extend data access to 3rd parties outside the organization.